How to use Export sales invoices to Xero / MYOB / QBO
Filter a payroll cycle's invoices, export, paste into the accounting system.
Set up CoA external codes (once). Open Ledger → Chart of Accounts and set External code on each revenue + AR + GST row to match the accountant's system. This is shared with Journal export — set once, used by both.
Open Ledger → Invoices. The list shows every invoice with status filters defaulting to Draft + Issued.
Filter to the cycle. Open the filters panel; set Week ending to any date in the cycle (Sunday or whatever day is configured). The list narrows to that week's invoices.📷Screenshot: Invoices list filtered to a Week ending invoice-export_filter_week.png
Tick the header. Select all visible. Drafts are filtered out of the export automatically — only ISSUED invoices flow.
The file downloads. Filename is <format>_invoices_<timestamp>.csv. Open in a text editor to spot-check before importing into the accounting system; the column shape matches the published Xero / MYOB / QBO template exactly.📷Screenshot: Xero Customer Invoices CSV — sample output invoice-export_xero_csv.png
Import into the accounting system. Xero: Business → Invoices → Import. MYOB: File → Import → Sales. QBO: Settings → Import data → Invoices. Each imports as drafts that the accountant approves after review. Maximum file size varies (Xero 500 invoices, QBO 1000 rows / 100 invoices); split large batches if you hit the limit.
Check the audit log.invoice_exports records every export with the week-ending date stamped on virtual batches. Query by week_ending to see what you've already handed to the accountant.📷Screenshot: invoice_exports audit log — what was exported when invoice-export_audit_log.png
📷Screenshot: Invoice export — how to use invoice-export_2.png