What the shipping bill extractor does
The shipping bill extractor reads the shipping bill PDF that ICEGATE generates and returns every field on it, from the shipping bill number, date and port code to each invoice and each item line, as a CSV or as JSON, free and with no sign-up. It is shipping bill data extraction without the retyping: drop the PDF, the fields come back.
Open the CSV in Excel. The download is a comma-separated file, and Excel and Google Sheets open it directly. The filing fields come as one CSV and the item lines as another.
What a shipping bill is, and why its fields matter later
A shipping bill is the export declaration filed with Indian customs before goods leave the country. Customs generates it on ICEGATE, and the document that comes back is the reference every later step points at: the bank quotes it when the export is logged in EDPMS, the incentive claim quotes it, and the eBRC quotes it when the payment for that consignment is finally realised.
That is why reading it correctly is worth a page of its own. A shipping bill number typed with a digit wrong, or a FOB value read off the wrong column, does not fail loudly. It fails months later, in a claim that does not reconcile or a certificate that will not map to the remittance it belongs to.
The fields this tool reads, and what each one means
These eleven are the ones a realisation filing asks for, which is why they come out first. Everything else the bill carries is below them, block by block, exactly as the document prints it.
Seven digits, as printed on the billThe number customs assigned when the bill was filed. It identifies the export everywhere afterwards, including on the eBRC.
Day, month and yearThe date the bill was filed, in the day, month and year form a date field expects. The realisation clock runs from here.
Six-character customs location codeThe customs location the bill was filed at, as the six-character code every later filing quotes.
The first invoice on the billThe first invoice on the bill. A bill covering several invoices lists them all in the invoice table below.
Three-letter currency codeThe currency the invoice was raised in, which is the currency the payment will arrive in.
In the bill's currencyThe free on board value of the consignment. This is the figure a realisation is measured against.
In the bill's currencyFreight deducted from the realised value.
In the bill's currencyInsurance deducted from the realised value.
In the bill's currencyDiscount deducted from the realised value.
In the bill's currencyAgency commission deducted from the realised value.
In the bill's currencyEverything else the bill deducts before the realisable value.
The four parts of a shipping bill
An ICEGATE shipping bill is printed in four parts, and knowing which part carries what is most of the skill in reading one. The shipping bill format guide goes through every field on each part and where it is used again; the short version is below.
Part I, the summary
The first page, and the one most questions are answered from. It opens with a header carrying the shipping bill number and date, the port code, the IEC and its branch, the GSTIN, and the counts of invoices, items and containers the rest of the document should contain. Under it sit the lettered blocks: status and routing, the exporter and consignee declaration with the AD code and bank account, the value summary, the export promotion amounts, manifest details, the invoice summary, the equipment table, challans, the annexure and the process log with the LEO date.
Part II, the invoices
One record per invoice: its number and date, the purchase order and letter of credit references, the buyer, the exchange rate and currency, the invoice value with its own freight, insurance, discount and commission, and the line items priced in the invoice currency.
Part III, the items
Every item on the bill as its own row, with the HS code, the description, quantity and unit, the rate, the value in foreign currency, the FOB value in rupees, and the scheme columns for drawback, IGST and RoDTEP.
Part IV, the schemes
The scheme paperwork: drawback and RoSCTL claims, advance authorisation or DFIA licences, jobbing, the single window declaration and its constituents, supporting documents, third party details, manufacturer details, RoDTEP and re-export.
Why the tool checks the bill against itself
A shipping bill states its own totals more than once. The header declares how many invoices, items and containers follow. The value summary in Part I should reconcile with the item values in Part III. Each invoice line should multiply out to its own stated value. So the document can be tested against itself, and that is what the verdict strip reports.
Two severities. An error means a figure this tool would not act on without a person looking: the FOB total not matching the sum of the items, the header declaring more invoices than the document contains, a missing or unparseable shipping bill number, or a file that turns out to hold several bills stapled together. A warning means something worth a glance rather than a stop: a container count that differs because an air consignment lists no containers, or a line where quantity times rate lands a rupee away from the printed value.
A clean bill and a bill with warnings are both perfectly normal. What the check buys you is knowing which one you have, before the figure travels into a claim.
From the shipping bill to the eBRC
An eBRC is the Electronic Bank Realisation Certificate that records an export payment arriving and being realised in India. Since the DGFT revamped the system it is self-certified: your bank reports the inward remittance, and you certify which export it paid for. Certifying that means naming the shipping bill, its date, the port code, the invoice and the value, which is precisely the set at the top of this page.
The tool stops at reading. Filing is the next step, and the eBRC exporter app is where it happens: connect a DGFT account once, and inward remittances arrive on their own to be mapped against bills like this one. It is free at any volume, with no certificate limit and no paid tier for exporters. If you are putting bills through software rather than by hand, the same reader is available over the eBRC API.
Two related pieces of reference are worth a look while you are here: the Indian port code lookup, for the code in the header of the bill you just read, and how shipping bills actually close in EDPMS, which is the process this document is eventually judged by.
If the document itself is the unfamiliar part rather than the filing, what a shipping bill is walks its fields and its types, and the difference between a shipping bill and a bill of entry settles the one that gets mixed up most. Getting your own copies out of the portal in the first place needs an ICEGATE registration and login, and when the portal refuses a bill rather than returning it, the error codes are listed with what each one means.