The form requires precise information to ensure the amendment is processed smoothly. Key areas include:
Option A — Create from the structured fields above (recommended, quick):
The agreed deadline by which the buyer must pay. Step-by-Step Guide to Filling Form 203 in Excel Ecgc Form No 203 Download In Excel
Look for "Form 203" or use the search bar to find "Application for Amendment/Modification in Policy." Download: Select the Excel (.xlsx) version.
Switch to the tab (if your template has one). List each unpaid invoice against the overseas buyer, along with the due date. Use Excel’s =TODAY() function to automatically calculate days overdue: =IF( (TODAY()-Due_Date) > 90, “Overdue”, “Current” ) The form requires precise information to ensure the
Reporting monthly or periodic export shipments executed under your specific ECGC policy.
: Specification of whether the transaction is DP, DA, or LC (Letter of Credit). FORM 203 - Commercial Tax Switch to the tab (if your template has one)
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 streamline the monthly/quarterly declaration process, consider these best practices:
Once you have successfully completed the , here is how to populate it correctly. The standard Excel sheet typically contains the following columns:
+---------------------------------------------------------------------------------+ | ECGC FORM NO. 203 - EXCEL TEMPLATE | +---------------------------------------------------------------------------------+ | Invoice No | Date | Buyer Name | Destination | Payment Terms | Currency | Value | +------------+------+------------+-------------+---------------+----------+-------+ | INV-1024 |05/12 | Global Ltd | Germany | LC 60 Days | EUR | 45,000| | INV-1025 |14/12 | Apex Corp | USA | DA 90 Days | USD | 82,000| +------------+------+------------+-------------+---------------+----------+-------+ | GRAND TOTAL (INR): | ₹1,06,45,000 | +---------------------------------------------------------------------------------+