How to export journal entries from QuickBooks (and back into it)
There are two questions hiding behind "export journal entries from QuickBooks", and they point in opposite directions: getting the journal out of QuickBooks to hand to someone, or building an entries file QuickBooks will accept. This covers both.
Getting the journal out of QuickBooks Online
QuickBooks Online has no "export journal entries" button. The route is a report: Reports, then the Journal report. Set the period to All Dates if you want the full history, then use the export icon next to the gear and pick Export to Excel.
Here is the part that catches people out: QuickBooks Online exports to Excel, not CSV. If whoever receives it expects a CSV — which an accounting firm or an import tool usually does — open the workbook and save it as CSV. There is no official shortcut.
If the file opens empty or truncated, that is Excel's protected view: click Enable Editing and the full report appears.
What the Journal report actually contains
The Journal report lists every transaction broken into debit and credit lines, including ones that are not manual entries at all: invoices, payments, expenses. It is not a list of your Journal Entries alone.
If you only want hand-keyed entries, filter the report by transaction type Journal Entry before exporting. Otherwise you hand over the whole ledger, which is rarely what was meant.
The other direction: importing a journal into QuickBooks
This is the more common need in practice: entries were posted or generated somewhere else, and you want them into QuickBooks Online without re-keying them one by one.
QuickBooks accepts an entries CSV with a precise column set. The whole difficulty is honouring that format — it forgives neither a different date separator nor a zero where it expects an empty cell.
The columns it expects
Journal No., Journal Date, Memo, Account Name, Debits, Credits, Description, Name, Currency.
Three rules break most imports. First, the lines of one entry share the same Journal No. and must balance to the cent. Second, dates are MM/DD/YYYY. Third, the unused cell — debit or credit depending on the side — stays strictly empty: a zero is not an empty cell as far as QuickBooks is concerned.
One last point, and it is the one discovered latest: QuickBooks identifies an account by its NAME, not its number. Account Name must match the organisation's chart exactly. A chart calling its payables account "Accounts Payable (A/P)" will reject "2010". The Name column carries the party, and QuickBooks requires it on any line touching A/P or A/R.
| Account | Label | Debit | Credit |
|---|---|---|---|
| Office Supplies | JE-1001 · 09/07/2026 · ACME | 1,000.00 | — |
| Prepaid Sales Tax | JE-1001 · 09/07/2026 · ACME | 80.00 | — |
| Accounts Payable (A/P) | JE-1001 · 09/07/2026 · ACME | — | 1,080.00 |
And on Xero, if that is your case
Xero works differently and the trap is worth knowing. Its manual journal CSV has no debit and credit columns: the sign of the amount carries the meaning, positive for a debit, negative for a credit. Dates are ISO YYYY-MM-DD.
A line with an empty Narration and Date continues the previous journal — that is how the lines of one entry are grouped. The file is capped at 300 lines, and a manual journal cannot touch Xero's system Accounts Receivable or Accounts Payable accounts; the organisation needs ordinary equivalents in its chart.
Where Comptyx fits
Comptyx does not read QuickBooks: it produces the file QuickBooks imports. You drop in your purchase and sales invoices, the AI extracts the fields, an accounting engine codes the accounts on the file's chart and checks the entry balances, and the export comes out directly as Journal Entry CSV — one Journal No. per entry, MM/DD/YYYY dates, empty cells on the right side, QuickBooks account names rather than numbers.
The Xero manual journal format is produced with the same care: signed amounts, ISO dates, TaxRate set to No Tax so Xero does not recompute a tax already carried on an explicit line.
Said plainly: these are file exports, not an API connection to QuickBooks Online, and a real import into a production QBO account has not yet been validated end to end on our side.
How do I export journal entries from QuickBooks Online?
Through the Journal report: Reports, Journal report, set the period to All Dates, then the export icon and Export to Excel. QuickBooks Online does not export straight to CSV; save the Excel workbook as CSV if that is what the recipient needs.
Can QuickBooks export journal entries directly to CSV?
No. Transaction exports go through Excel. CSV is obtained by re-saving the file from Excel, which remains the standard workaround.
Which columns are needed to import a journal into QuickBooks?
Journal No., Journal Date, Memo, Account Name, Debits, Credits, Description, Name and Currency. Lines of one entry share the Journal No., dates are MM/DD/YYYY, and the unused cell stays empty rather than zero.
Why is my QuickBooks import rejected?
The three usual causes: an entry that does not balance, an account name that does not match the organisation's chart exactly, or a zero where QuickBooks expects an empty cell. A missing Name column on an A/P or A/R line produces the same rejection.
Does Comptyx connect to QuickBooks over an API?
No. Comptyx generates the entries file in the expected format and you import it into QuickBooks Online yourself. There is no OAuth connection and no continuous sync.