Upload one or both Dynamics exports below. Rows from both files are merged into a single SmartInvoice CSV (same column layout as api-convertor).
E invoice May 2026 (self billed).xlsx)
| Source (xlsx) | SmartInvoice CSV |
|---|---|
| Vendor Name (column C) | supplierName |
| Voucher | docNo |
| Date | createdAt, dueAt |
| Description | description |
| Currency | currency |
| Exchange Rate | exchangeRate |
| Credit (transaction currency) | totalInclTax, totalPayableAmount, unitCost, subtotalWithTax, total |
| Source (xlsx) | SmartInvoice CSV |
|---|---|
| Vendor Name (column H on vendor row) | supplierName |
| Voucher (column F) | docNo |
| Date (column B) | createdAt |
| Due date (column K) | dueAt |
| Description (column I) | description |
| Currency (column S) | currency |
| Exchange Rate (column T) | exchangeRate |
| Credit balance in transaction currency (column AA) | totalInclTax, totalPayableAmount, unitCost, subtotalWithTax, total |
Defaults: type self-billed invoice, status open, exchangeCurrency MYR,
classification 022, taxType 06, taxRate/tax 0, subtotal = total,
supplier TIN/address fields, supplierCountry from currency (3-letter, e.g. GBP → GBR).