How to import bank statements into QuickBooks Online
When the bank feed won’t connect, misses some months, or the account is closed, QuickBooks Online lets you upload the transactions from a file instead. Here’s which file to use, where the upload is, and what to check before the transactions reach your books.
Last updated October 2026
Which file to upload
QuickBooks Online’s upload takes several kinds of file. In order of how little can go wrong:
- QBO (Web Connect), the one Intuit suggests. It says which kind of account it’s for and gives every transaction an ID, so QuickBooks can tell a transaction it already has from a new one, and there are no columns to map. What a QBO file is.
- QFX or OFX, the same data labelled for Quicken or for any app. Both are accepted.
- CSV, in one of the two layouts below. You tell QuickBooks which column is which. A CSV has no transaction IDs, so overlapping uploads are on you to avoid.
- The PDF statement itself, or a photo of it. QuickBooks reads the transactions out of it for you to check. See uploading a PDF statement to QuickBooks.
Intuit’s help page also lists a size limit of 350 KB per file. A few years of transactions can be more than that: split them into several files, a year or a quarter each.
How to upload the file
- Download the file from your online banking: look for “Export”, “Download transactions” or “QuickBooks Web Connect”. If the bank only gives you PDFs, convert one first (below).
- In QuickBooks Online, open Bank transactions. In the newer layout it’s under All apps › Accounting; older layouts call it Banking.
- Choose Upload from file. It’s in the menu next to Link account; some layouts show an Upload transactions button instead.
- Drop or browse to the file, then pick the QuickBooks account the transactions belong to. A credit card statement goes in a credit card account, so purchases and payments land the right way round.
- For a CSV, match the columns: Date, Description, and either Amount or Credit and Debit. Pick the date format the file uses. If money out shows as positive numbers, choose the option to reverse the amounts.
- Open the For review tab, check the transactions against the statement, then categorize and add or match each one.
The CSV layout QuickBooks Online reads
Either three columns, with money out as negative amounts:
Date,Description,Amount
10/01/2026,COFFEE SHOP,-4.50
10/02/2026,PAYROLL DEPOSIT,2500.00or four, with money in and money out in their own columns:
Date,Description,Credit,Debit
10/01/2026,COFFEE SHOP,,4.50
10/02/2026,PAYROLL DEPOSIT,2500.00,Write every date the same way, and amounts as plain numbers: no currency signs, no thousands separators, no brackets for negatives. A bank’s own CSV often has a title above the column names or totals at the bottom; delete those rows first.
Problems we ran into, and what to do
We imported test files through this screen in a QuickBooks Online sandbox company (US, October 2026). These are what we saw there; your QuickBooks may differ.
“The uploaded file isn’t a valid Web Connect file”
A .qbo file without an ending balance (the <LEDGERBAL> block) was refused with this message, and so was one whose header said ENCODING:UTF-8. So a Web Connect file needs an ending balance, even though it doesn’t change any transaction, and the classic header, ENCODING:USASCII. More in what a QBO file is.
Question marks instead of accents
Any accented or non-English letter in a .qbo, .qfx or .ofx file showed as “?”: Café came out as Caf?. If your descriptions have accents, spell them plainly in the file (Cafe), or upload a CSV.
Amounts in another currency
A file in Canadian dollars, uploaded into an account kept in US dollars, was booked as dollars without any warning: C$4.75 became $4.75. QuickBooks doesn’t convert the amounts, so upload a statement into an account kept in the statement’s currency.
The same transactions twice
Uploading the same .qbo file a second time added nothing, because QuickBooks recognises each transaction’s ID. A CSV doesn’t have IDs: if two statements overlap by a few days, take the overlapping rows out of one of them first.
Check the totals before you save
However the transactions get in, compare them with the statement before you categorize anything: the number of transactions, the money in and money out, and the closing balance. A missed line or a misread amount is far easier to fix in the file than after it has been matched against invoices.
That check is what BankToRows does as it converts. It adds the rows up against the opening, closing and running balances printed on the statement and shows any difference, row by row, so you can fix it before you download the .qbo file or the CSV for QuickBooks.