Ecgc Form No 203 Download In Excel [new] -

To obtain ECGC forms, including potential versions of ECGC Form No 203 , users are encouraged to visit the official ECGC Limited Website . While many ECGC documents are primarily available in PDF format

Section B: Buyer-wise Declaration (Crucial Columns)

| Column Name | What to Enter | Excel Formula Tip | | :--- | :--- | :--- | | Buyer Code | Unique code assigned by ECGC | Use Data Validation (List) | | Invoice No. & Date | Commercial invoice reference | =TEXT(Date, "DD-MMM-YYYY") | | Invoice Currency | USD, EUR, GBP, etc. | Dropdown list | | Invoice Value | Gross invoice amount | =SUM(range) | | Realization Date | Expected date of payment from buyer | Conditional Formatting if overdue | | Credit Period | (e.g. 90 days, 180 days) | This determines premium slab | | Premium Rate | As per ECGC risk matrix (e.g., 0.45%) | VLOOKUP from rate table | | Premium Amount | Invoice Value × Premium Rate | =[@InvoiceValue]*[@[Premium Rate]] | Ecgc Form No 203 Download In Excel

If you are creating an Excel template for internal tracking, include these standard columns: Shipment Date : Date the goods were dispatched. Invoice Number & Value : Total value in INR (or foreign currency as specified). Destination Country : The country of the buyer. Buyer Details : Name and address of the foreign buyer. Terms of Payment : (e.g., DA/DP, LC, Open Account). Premium Rate & Amount To obtain ECGC forms, including potential versions of

1. Printing the form.
2. Signing and Stamping.
3. Submitting it physically to the ECGC Regional Office along with the invoice copy and bill of lading (if the shipment has already occurred).
4. Alternatively, check the ECGC Online Portal. ECGC has been digitizing specific services; if you have a login ID, you may be able to upload the data directly without submitting a physical Excel sheet.

Explain the differences between various ECGC policy types (e.g., SCR vs. Small Exporter). export credit guarantee corporation of india limited Printing the form