How to Export Transactions from QuickBooks Online to CSV

Getting data out of QuickBooks Online is easier than getting it in, but the path you take decides which columns you end up with. Here are the four that matter, from the quickest to the most complete.

1. Export one account's register

The fastest route for a single bank or credit card account.

1. Go to Transactions, then Chart of accounts.
2. Find the account and choose View register.
3. Set the date filter to the period you want.
4. Use the export icon above the register — it downloads an Excel file.

You get date, type, payee, memo, amount and running balance for that account. It is the closest thing to a bank statement QuickBooks will hand you, and it is the right export for reconciling against a real statement.

2. Export a report

More control, more columns, and the option of a proper CSV.

1. Open Reports and run the report you need — Transaction List by Date is the most statement-like, and Profit and Loss Detail is the most useful for review.
2. Set the date range and, under the gear or customise panel, add the columns you want.
3. Use the export icon in the report header and choose Export to Excel or Export to CSV.

Reports are the only export where you choose the columns, which makes them the right choice when someone has asked for a specific layout.

3. Export search results

For "every transaction mentioning this vendor" questions.

1. Use the magnifier, then Advanced search.
2. Filter by type, date, amount or contains-text.
3. Export the result set from the icon above the list.

4. Export the whole company

For an accountant handover or a migration.

1. Go to the gear menu, then Export data (available on most plans; some editions put it under Tools).
2. Choose reports and lists, set the date range and request the export.
3. QuickBooks builds a set of Excel workbooks and notifies you when they are ready.

This is the complete picture — lists, balances and transactions — but it arrives as workbooks, not as a single tidy CSV, so expect to do some assembling.

Formatting the result

Whichever route you take, the export is built for humans rather than for machines. Expect a title row or two above the real header, merged cells in Excel exports, and blank rows between sections. If the file is destined for another system, delete everything above the header row and remove the total rows at the bottom before you hand it over.

Amounts export as plain numbers, so negative values may appear as -45.00 or as (45.00) depending on your locale settings — worth checking before someone else parses the file.

What you cannot export

QuickBooks Online will not export a bank feed back out as a .qbo file. Web Connect is an import format; there is no matching download. If a system you are migrating to wants a .qbo, the practical route is to export a CSV from QuickBooks and convert that.

A note on attachments and audit trail

Receipts attached to transactions do not travel with a CSV export. Neither does the audit log. Both can be downloaded separately — attachments in bulk from the attachments list, the audit log from the gear menu under Audit log — and both are worth grabbing before an accountant handover, because they are the things nobody thinks about until they are gone.

Exporting lists, not just transactions

Customers, vendors, products and the chart of accounts each export separately, and each from its own screen: open the list, then use the export icon above it. These are the exports an accountant actually asks for when taking over a file, and they are easy to forget because the transaction export looks like the complete job.

The chart of accounts export is worth keeping for another reason: it is the mapping document for any future import. When a converted bank file lands in the review queue, the account names in that list are what you will be matching against.

Making exports repeatable

If you export the same report every month, customise it once and save it: Save customisation on the report screen keeps the columns, the filters and the date logic. Set the date range to a rolling period such as "last month" rather than fixed dates, and next month's export is two clicks instead of ten. Reports can also be scheduled to email themselves, which turns a recurring chore into something that simply arrives.

Going the other way

Exporting is only half of most jobs. If the reason you are exporting is to move data into another system — or to hand a client's bank history to a new bookkeeper — the return journey runs through a CSV or .qbo import, and it has stricter rules than the export side does.