FlecBase Docs

Export sales invoices to Xero / MYOB / QBO

Export ISSUED sales invoices to your accounting system. Sister to Journal export — same four targets, but emitting each system's native sales-invoice CSV shape (different from the journal-entry shape).

Four formats. Xero (Customer Invoices) repeats *ContactName + *InvoiceNumber on every line and groups multi-line invoices by those keys. MYOB AccountRight (Service Sales) repeats Co./Last Name + Invoice No. per line, with Tax Code = GST or FRE and Tax Amount filled even when zero. QuickBooks Online (Invoices, AU) repeats invoice-level fields per line, splits ItemAmount + ItemTaxAmount. Generic dumps every line-level field plus the invoice headers denormalised — for hand-rolled integrations.

Each line's revenue account maps via InvoiceLine.revenue_account_idchart_of_accounts.external_code when set, else the canonical code. Set external_code on every CoA row once and every future export lands on the accountant's codes.

Tax codes follow the target system's convention: GST on Income / GST when the line's tax_rate > 0; otherwise the no-tax code (BAS Excluded / FRE). Unlike the journal export, the invoice CSV expects the accounting system to compute GST on import from the rate code — DO NOT also include a manual GST line; our invoice subtotal is the net.

Every export logged to invoice_exports. When the operator filtered to a week-ending window before exporting, the audit row also stamps the week_ending date — see Week-ending batches.

Invoice export lifecycle — Issue → Filter → Export → Accounting
Invoice export lifecycle — Issue → Filter → Export → Accounting invoice-export_lifecycle.png
📷Screenshot: Invoice export — overview invoice-export_1.png

How to use Export sales invoices to Xero / MYOB / QBO →