The Challenge
A jewellery export company was manually preparing all export documents for every shipment — Customs/DGFT uploads, DHL courier files, GSP Certificate of Origin documents and Value Addition sheets. Each shipment required 2–3 hours of repetitive data entry across multiple formats. Any error in FOB values, CIF calculations or GSP columns could cause customs delays or rejection of preferential duty benefits.
What We Built
A custom Windows desktop application (.exe) — the user uploads their invoice Excel file, fills a few shipment details (vessel, currency, exchange rate) and clicks Generate. The system automatically produces all 6 required output files in one go.
sp
Output FilePurpose
CHA UploadCustoms / DGFT structured Excel — 3 sheets (Main, Invoice, Product Details)
DHL UploadDHL courier CSV — shipment details formatted for DHL system
Product ItemsGSP / COO — product-wise FOB values for Certificate of Origin
Raw Material ItemsGSP / COO — raw material CIF values for preferential duty documentation
GSP / COO InvoiceOriginal invoice + GSP / COO-specific columns: IMP, LOC, CIF, FOB values
GSP / COO VA SheetValue Addition sheet — BX to CD columns with auto-linked formulas
✨ GSP / COO Smart Feature
Optional VA file upload — system automatically detects jewellery type (Diamond / LGD / Plain / Combination) from product marks and applies the correct GSP / COO formula structure across all linked columns.
Windows Desktop App (.exe)
Excel Automation
Customs / DGFT
DHL Integration
GSP / COO
Jewellery Export
FOB / CIF Calculation
Value Addition Sheet