QuickBooks Online: mapping your data to UAE e-invoices
Where UAE e-invoice fields — TRN, Peppol ID, tax category, unit codes — live in QuickBooks Online, and how to export them for the InvoiceNET portal or API.
QuickBooks Online (QBO) does not natively generate PINT AE-compliant XML. Your workflow is: post the invoice in QBO → export the data (CSV or API) → submit to InvoiceNET via the portal, bulk upload or REST API. This guide shows where each mandatory e-invoice field lives in QBO.
Where each e-invoice field comes from
| E-invoice field | Where it lives in QBO | What to check |
|---|---|---|
| IBT-031 Seller TRN | Settings › Company settings › Tax registration | 15 digits, starts 1, ends 03 |
| IBT-034 Seller Peppol ID | Not stored in QBO — add to your InvoiceNET setup | + 10-digit TIN |
| IBT-027 Seller name | Settings › Company settings › Company name | Legal trading name |
| IBT-035–IBT-037 Seller address | Settings › Company settings › Address | Street, City, Emirate, AE |
| IBT-039 Seller emirate | State/Province field in company address | Use two-letter emirate code (DU, AZ, SH…) |
| IBT-048 Buyer TRN | Customers › customer › Tax registration number (custom field) | 15 digits for VAT-registered buyers |
| IBT-049 Buyer Peppol ID | Custom field on customer record | Buyer TIN or a ID |
| IBT-050–IBT-055 Buyer address | Customer Billing Address › Street, City, Province, Country | Province = emirate |
| IBT-001 Invoice number | Invoice Invoice no. | Must be unique; note prefix if used |
| IBT-002 Invoice date | Invoice Invoice date | |
| IBT-009 Due date | Invoice Due date | Required per FTA rules |
| IBT-154 Item description | Product/Service Description | Not blank for each line |
| IBT-153 Item name | Product/Service Name | Short name |
| IBT-130 Unit code | Product/Service Unit of measure | Must map to UN/ECE Rec 20 (see below) |
| IBT-151 Tax category | Tax rate applied to the line | One code per line (S / Z / E / O / AE) |
| IBT-084 IBAN | Settings › Payments › Bank accounts | Needed if payment means is bank transfer |
Custom fields you must add
QBO does not have built-in fields for Buyer TRN, Buyer Peppol ID or UAE-specific codes. Add them under Settings › Custom fields (available on QBO Advanced; on Essentials/Plus use the Notes field and parse it on export):
- Buyer TRN — text, 15 chars
- Buyer Peppol ID — text (e.g. )
- Transaction type flags — text, 8 chars (e.g. for a standard invoice)
- Licence number / Authority (if required for your buyers)
Tax category mapping
In QBO, go to Taxes › Tax rates and ensure you have a rate for each category:
| PINT AE category | QBO tax rate name (suggested) | Rate | Note |
|---|---|---|---|
| S | UAE VAT 5% | 5% | Standard rated supplies |
| Z | UAE Zero-rated | 0% | Separate from Exempt |
| E | UAE Exempt | 0% | Store exemption reason in line description |
| O | UAE Out-of-scope | 0% | Non-UAE supplies, outside-scope |
| AE | UAE Reverse charge | 5% | Buyer accounts for VAT; store goods type |
Do not mix Z and E — PINT AE rejects an invoice where both appear without separate tax breakdown lines.
Unit of measure mapping
QBO allows free-text units. Map your QBO unit names to UN/ECE Recommendation 20 codes before submission:
| QBO unit | Rec 20 code | Description |
|---|---|---|
| ea / each / unit / pc | H87 | Piece |
| hr / hour / hrs | HUR | Hour |
| kg | KGM | Kilogram |
| t / ton | TNE | Metric ton |
| l / litre | LTR | Litre |
| m | MTR | Metre |
| sqm / m² | MTK | Square metre |
| day | DAY | Day |
Build this mapping in your export script or in the InvoiceNET field mapping checker (Reference › Field mapping checker).
Exporting data from QBO
Manual (portal submission):
- Open the invoice in QBO.
- Note all fields from the mapping table above.
- Enter them in InvoiceNET › + Create Invoice.
- For credit notes, use the Create credit note flow — link to the original invoice number.
Bulk (CSV upload):
- Export invoices from QBO: Reports › Transaction List by Customer or use the QBO API ().
- Map columns using the InvoiceNET Field mapping checker (Reference menu).
- Upload the mapped CSV via the portal bulk upload.
Automated (REST API): Connect QBO webhooks or a scheduled pull to send invoice data to the InvoiceNET API. Use with the JSON payload; see the API guide for the field list.
Special scenarios
- Credit notes (refund receipts): In QBO, use Refund Receipt or Credit Memo. In InvoiceNET, submit as a Credit Note and reference the original invoice number (IBT-025). See Credit notes.
- Exports: Set the customer country to non-AE; transaction type flag position 8 = . Tax category = Z. See Exports.
- Reverse charge: Tax category AE; include buyer TRN, goods type code and GTIN (barcode) on each line. See Reverse charge.
- Foreign currency invoices: QBO records the exchange rate; export both the invoice currency amount and the AED equivalent for the XML. See Foreign currency.
Before go-live
- Company TRN, legal name, address and emirate are complete in Company Settings.
- Custom fields for Buyer TRN and Peppol ID are set up and filled for all UAE customers.
- Tax rates cover S, Z, E, O and AE — no mixing of Z and E.
- Unit of measure mapping table is documented and applied in your export process.
- At least one test invoice (standard) and one credit note submitted and accepted by InvoiceNET.
- Reverse-charge lines include GTIN and goods type.
QuickBooks Online does not generate PINT AE XML natively; all XML generation happens inside InvoiceNET after you supply the field values above.