# Export Bank Transactions from QuickBooks Online

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2026-08-19
- Updated: 2026-08-19
- Category: Switching accounting software
- Canonical: https://www.simplebankconvert.com/blog/export-bank-transactions-from-quickbooks-online

> How to export bank transactions from QuickBooks Online to Excel or CSV before switching, with the report that gives one clean row per transaction.
To export bank transactions from QuickBooks Online, run the Transaction Detail by Account report, filter it to one bank account and the dates you need, and choose the columns you want. Then use Export to Excel. Save the sheet as CSV if the next program needs one. You get one row per transaction, with dates, payees and signed amounts.

## Which QuickBooks Online report exports bank transactions one row each?

Transaction Detail by Account is the report to use. It lists every transaction that touched the chosen account, one row each, with its date, type, number, name, memo and amount, plus a running balance. Filtered to a single bank account, it reads like the account's register, and it exports cleanly.

Other reports come close but fall short for this job:

- **The bank register** is good on screen, but it is a working view rather than a report built for export.
- **The general ledger** covers every account at once, so you would have to cut one bank account out of a much larger sheet.
- **Transaction List by Date** shows each transaction once, but it is not tied to one account, so transfers and card payments appear without a clear side.
- **The bank transactions review list** holds lines downloaded from the bank and not yet added. It is not your books, and much of it may be excluded or duplicated.

Pick one report and use it for every account, so each exported file has the same shape.

## Setting the bank account filter and columns before exporting from QuickBooks Online

Set the report up before you export, not afterward in Excel. Choose the date range, filter to one bank account, and pick the columns. A well-built report gives you a sheet that needs almost no clean-up, while a default report gives you subtotals, headers and columns you will spend time deleting.

### The settings that matter

1. **Report period.** Use custom dates. For a switch, start at the first day you need and end on the day before your new software takes over.
2. **Accounting method.** Keep it on accrual, the usual default. For a bank account, cash and accrual give the same lines.
3. **Filter by account.** Select only the bank account you are exporting. One account per file.
4. **Group by.** Turn grouping off if the report offers it, so no subtotal rows appear between months.

### A column checklist

Keep these columns and remove the rest:

- Date
- Transaction type (check, deposit, expense, transfer)
- Number, for check numbers and references
- Name, the payee or customer
- Memo or description
- Split, which shows the other account the money went to
- Amount
- Balance, the running balance after each row

The split column is the one people forget. It shows how each line was categorized, which is the work you most want to keep when you move.

### Several accounts, one routine

A business with checking, savings and two cards needs four exports. Save the customized report once in QuickBooks Online under a clear name, then change only the account filter for each run. That keeps the columns identical across files. Keep a short log with one line per account: the account name, the dates exported, the row count and the closing balance the report showed. When the new software asks where a figure came from months later, that log answers it in seconds.

## Exporting the QuickBooks Online bank report to Excel, then CSV

Once the report looks right on screen, export it. Intuit's steps for [exporting reports to Excel from QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/export-your-reports-to-excel-from-quickbooks-online/00/239042) are: open Reports, find the report, then select the Export icon and Export to Excel in the classic view, or Export/Print and then Export to Excel in the newer view.

The file lands in your downloads folder. Intuit's article covers Excel only, so if the next program wants a CSV, open the file in Excel and save a copy as CSV.

### Clean the sheet before saving it as CSV

The Excel file arrives with a report title, the company name and the date range in the first few rows, and a total at the bottom. Delete those so the first row is the column headings and every row after it is a transaction.

This example shows the shape before and after. The rows are made up.

| Before clean-up | After clean-up |
| --- | --- |
| Row 1: "Example Studio LLC" | (deleted) |
| Row 2: "Transaction Detail by Account" | (deleted) |
| Row 3: "January 1 - March 31, 2026" | (deleted) |
| Row 5: "Business Checking" group heading | (deleted) |
| 01/04/2026, Deposit, Harbor Design, 2,400.00 | 01/04/2026, Deposit, Harbor Design, 2400.00 |
| 01/06/2026, Expense, Office Rent, -1,850.00 | 01/06/2026, Expense, Office Rent, -1850.00 |
| "Total for Business Checking" | (deleted) |

Format the amount column as plain numbers without thousands separators before saving, so no comma splits a figure across two CSV columns. Save one file per account, named with the account and dates, such as checking-2026-q1.csv.

## QuickBooks Online's Export data bundle versus a single bank report

The Export data bundle saves many reports and lists at once, and it suits an archive. A single Transaction Detail by Account report suits moving one bank account's history. Most people switching software want both: the bundle as a record, and a tidy report per bank account as the working file.

Intuit's guide to [exporting reports, lists and more](https://quickbooks.intuit.com/learn-support/en-us/help-articles/export-reports-lists-and-more/00/261915) describes the bundle: open the Settings gear, choose Export data, set a date range on the Reports tab, switch on the reports and lists you want, and export everything as Excel files in one zip file. Intuit notes that it covers posting transactions, which are the ones that affect account balances. Estimates, purchase orders and attachments have their own export steps.

The bundle's reports come with QuickBooks Online's standard layout, so a bank account's rows are mixed in with every other account. That is fine for an archive but slow to clean for an import. Keeping the bundle, and knowing how long you need it, is part of a wider decision covered in [keeping old QuickBooks data after switching](/blog/keep-old-quickbooks-data-after-switching).

## Can exported QuickBooks Online bank rows go into new software as a bank file?

Sometimes, but it is usually the wrong source. An export shows what you recorded in QuickBooks, not what the bank sent. That matters because most programs treat imported bank lines as the bank's own statement, which you then reconcile against. Importing your own records as if they were the bank's skips the check that makes reconciling worthwhile.

### When exported rows are reasonable

- Your QuickBooks Online account was reconciled every month, so the recorded lines match the bank.
- The bank no longer offers downloads for those months, for example a closed account.
- You only need the rows for reference, not for reconciling.

If you do import them, trim the sheet to the columns the new program reads, such as date, description and a single signed amount, and drop the type, split and balance columns.

### When to go back to the bank's statements instead

If any month was not reconciled, use the bank's statements for that month. SimpleBankConvert is being built to turn those PDFs into CSV files for QuickBooks or Xero, and the [get started page](/get-started) adds you to the list for early access.

Moving to Xero? The reverse task, taking bank lines out of Xero, has its own report choices; [exporting bank transactions from Xero](/blog/export-bank-transactions-from-xero) walks through statement lines and account transactions.

## Bank exports from QuickBooks Online that mislead: transfers, deposits and investment accounts

Three kinds of row look wrong in an exported bank report even when the books are right: transfers between your own accounts, deposits that combine several payments, and investment accounts set up as banks. Each needs a quick check before you rely on the export as a history of what cleared.

### Transfers

A transfer from checking to savings appears in both accounts' exports, once as money out and once as money in. That is correct. But if you export both accounts and import both into new software, and that software also gets the same lines from a bank feed, the transfer can end up recorded four times. Decide which source each account's history comes from, and use only that one.

### Combined deposits

When several customer payments were grouped into one bank deposit in QuickBooks Online, the report may show the deposit's lines as well as its total, depending on the columns you chose. Compare the deposit's total with the bank statement, not the individual lines.

### Investment and brokerage accounts

Some businesses set up a brokerage cash account as a bank account in QuickBooks Online. Its export lists cash moving in and out, but not trades or changes in value. [What to record from a brokerage statement in QuickBooks](/blog/brokerage-statement-to-quickbooks) explains why those accounts need different handling from a bank upload.

### A last check on every file

Add up the amount column in each exported file and compare it with the change in the account's balance over the same dates. If the opening balance plus the total equals the closing balance, the file is complete. If not, a row is missing or a subtotal survived the clean-up.