Mehul · Export consultancy
Export compliance automation
Customs and DGFT PDFs go in. Ready-to-file government Excel sheets come out, checked cell by cell.
3 hours4 minutesper licence
The problem
Export consultants help manufacturers close out their import licences with the government. For every licence, someone opens a stack of PDFs (the licence itself, every Bill of Entry for what was imported, every Shipping Bill for what was exported, the bank’s realisation certificates) and types hundreds of numbers into prescribed Excel formats.
It took hours per licence. It needed experienced staff. And a single wrong digit meant a rejected filing and weeks of back and forth.
What I built
A private web app with three doors: upload a licence, upload import documents, or upload export documents. It reads each PDF, works out what kind of document it is, and files it under the right licence automatically, even when one Bill of Entry covers several licences.
From everything saved so far, it writes the government sheets in the consultancy’s exact format: the ANF 4F certificate, the import and export annexures and the consumption statement. Download one file or all of them in a single workbook.
Why it can be trusted
Every output is tested cell by cell against sheets the consultancy filed by hand. When a number doesn’t add up (an over-import, a missing exchange rate, a document that belongs to a different licence), the tool stops and says exactly what’s wrong. It never fills a gap with a guess.
“We now file all our licences in minutes. It catches mistakes we used to find only after filing.”
Have a similar problem?