迪拜贸易 E-Mirsal II 发票转换工具
将供应商商业发票 Excel 一键转换为 100% 符合迪拜海关要求的 TXT 和 XML 报关申报文件,并进行海关编码实时核验
发票与报关单表头信息
📋 从 Excel / 飞书表格 / Google 表格直接复制粘贴
点击此处并按 Ctrl+V (或 Cmd+V),即可瞬间批量导入 10 至 500+ 行发票品名数据。
2 发票商品明细行 2 行品目
| 序号 | 商品英文描述 * | 海关编码 (8/12位) * | 原产国 | 数量 | 单位 | 单价 | 总价 | 净重 (kg) | 毛重 (kg) | 件数/包装 | 操作 |
|---|
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 |
常见问题解答
.txt file. All invoice lines, HS codes, and weights will populate automatically.