InvoiceNETSIMPLIFYING DIGITAL BUSINESS Help Center
Open portal

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):

  1. Open the invoice in QBO.
  2. Note all fields from the mapping table above.
  3. Enter them in InvoiceNET › + Create Invoice.
  4. For credit notes, use the Create credit note flow — link to the original invoice number.

Bulk (CSV upload):

  1. Export invoices from QBO: Reports › Transaction List by Customer or use the QBO API ().
  2. Map columns using the InvoiceNET Field mapping checker (Reference menu).
  3. 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

  1. Company TRN, legal name, address and emirate are complete in Company Settings.
  2. Custom fields for Buyer TRN and Peppol ID are set up and filled for all UAE customers.
  3. Tax rates cover S, Z, E, O and AE — no mixing of Z and E.
  4. Unit of measure mapping table is documented and applied in your export process.
  5. At least one test invoice (standard) and one credit note submitted and accepted by InvoiceNET.
  6. 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.