Dubai Trade E-Mirsal II Invoice Converter
Convert Excel supplier invoices into 100% compliant Dubai Customs TXT & XML declaration files with instant HS code validation
Invoice & Declaration Header
📋 Copy & Paste Multi-Line Table Directly from Excel / Google Sheets
Click here and press Ctrl+V (or Cmd+V) to instantly ingest 10 to 500+ invoice lines.
2 Invoice Line Items 2 Lines
| # | Item Description * | HS Code (8/12-digit) * | Origin | Qty | UOM | Unit Price | Total Price | Net Wt (kg) | Gross Wt (kg) | Pkg | Act |
|---|
What is Dubai Trade E-Mirsal II Flat File?
e-Mirsal II is Dubai Customs' electronic clearance and trade declaration platform. When clearing multi-line commercial shipments (containing dozens or hundreds of items), manually entering each line item in Dubai Trade takes hours and frequently triggers declaration rejections due to typos or UOM mismatches.
A Flat File (.txt) is a standardized tab-delimited text file containing 3 core record layers:
- 🔹 Header Record (`H`): Declares sender ID, declaration type (`IMP`/`EXP`/`FZI`), total lines, and total invoice valuation.
- 🔹 Invoice Record (`INV`): Declares commercial invoice number, date, currency, exchange rate, and incoterms (`CIF`/`FOB`).
- 🔹 Item Records (`ITM`): Line-by-line breakdown containing the 8/12-digit UAE HS Code, country of origin, quantity, UOM, unit price, total price, and package details.
- 🔹 Vehicle Records (`VEH`): Automotive declaration containing VIN/chassis number, engine number, model year, and body type.
How to Avoid Dubai Customs Declaration Rejections
Dubai Customs automatically validates declarations upon upload. The most common rejection triggers include:
| Common Mistake | Consequence | Our Auto-Fix |
|---|---|---|
| UOM Mismatch | Rejection (e.g. declaring liquids in PCS) | Auto-suggests approved UOM (`LTR`, `KGM`, `NUM`) |
| Invalid HS Code | Customs inspection / delay | Validates against 13,000+ live UAE codes |
| Math Discrepancy | Valuation query / fine | Auto-calculates `Qty × Unit Price = Total` |
| Missing Permits | Cargo held at port | Flags MOIAT, MOCCAE & TDRA requirements |
Frequently Asked Questions
.txt file. All invoice lines, HS codes, and weights will populate automatically.