How to import bank transactions into QuickBooks Online (CSV, Excel, QBO or PDF)
QuickBooks Online pulls transactions from a connected bank on its own, but plenty of accounts never connect, connections break, and the feed doesn't reach back to the months before you started. For all of those, QuickBooks Online takes a file instead: a CSV or Excel export, a .QBO / .QFX / .OFX download, or the PDF statement itself. This guide shows each route, which file to pick, how to fill a gap the feed left, and how to check that every transaction came in before you categorize.
Short answer: go to Bank transactions, select the account's tile, then Link account ▾ → Upload from file. Upload a .QBO (Intuit's suggestion), .QFX, .OFX, or a CSV with 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit), up to 1,000 lines and 350 KB per file. Pick the QuickBooks account, map the columns, select the transactions and import. They land on For review. From Excel, save as CSV first. A PDF or photo of the statement uploads on the same screen and QuickBooks extracts it. Only have PDFs and want a file that's checked against the statement balance first? Convert it with bank statement to QuickBooks.
See a statement turned into QuickBooks Online files
Open Utilly's fictional September 2026 checking statement (31 transactions: 11 deposits totalling 29,597.43 and 20 withdrawals totalling 28,575.27) in the converter. You get the QuickBooks Online CSV and the .QBO, each checked against the 13,440.52 ending balance, all free because the data is made up. Your own PDF gets a free preview.
- The ways to get bank transactions into QuickBooks Online
- Which file to use
- Upload a file, step by step
- From a CSV or Excel file
- From a PDF statement
- Missing transactions and months before the feed
- Check the import against the statement
- Take an upload back out
- Upload errors and what they mean
- Convert your own statement
1. The ways to get bank transactions into QuickBooks Online
| Route | When it fits | Watch out for |
|---|---|---|
| Bank feed (connect the account) | Your bank connects, and you only need recent activity | Intuit says QuickBooks doesn't download pending transactions or transactions older than 90 days |
| Upload a transaction file (.QBO, .QFX, .OFX, CSV) | No connection, a broken one, or months before the feed started | 1,000 lines and 350 KB per file; CSV columns must follow Intuit's format |
| Upload the PDF or image statement | The bank only gives you statements | Review QuickBooks' extraction in the side-by-side view before saving |
| Convert the PDF first | Many months of statements, or you need proof nothing was missed | Use a converter that ties each statement to its balances |
| Enter it by hand | One or two transactions | Intuit's advice when the feed fails is to use file import instead of entering transactions manually |
On QuickBooks Desktop the menus and file types are different: see importing a CSV into QuickBooks Desktop and Desktop without bank feeds. For a credit card account, the same Upload from file screen works; the sign rules are in importing credit card transactions into QuickBooks.
2. Which file to use
| File | What QuickBooks Online does with it | Our take |
|---|---|---|
| .QBO (QuickBooks Web Connect) | Intuit's suggested format; fixed layout, so usually no column mapping | Best if your bank offers it |
| .QFX (Quicken) / .OFX | Accepted on the same screen | Fine; same data as .QBO |
| CSV (or .txt) | 3- or 4-column layout, you map the columns and confirm the signs | Most banks offer it; fix the layout first |
| Excel (.xlsx) | Not accepted as is | Save as CSV (on a Mac, as a Windows CSV) |
| PDF / JPG / PNG / HEIC statement | QuickBooks' AI extracts the transactions, any bank, English only | Check the extraction against the statement totals |
Intuit's file guidelines list QBO, QFX and CSV, and its Upload a list steps name .csv, .txt, .qbo and .ofx. All of these go through the same screen. A .QBO is the least work because it carries signed amounts, dates and IDs in a fixed layout. Intuit also notes that some banks' CSVs simply aren't in a format QuickBooks can read, and suggests a QFX, QBO or OFX download instead.
3. Upload a file, step by step
- Pick the date range at the bank. For an account with nothing in QuickBooks yet, go back as far as you want QuickBooks to track. If you set an opening balance, start on that date. If the account already has transactions, Intuit's walkthrough says to find the date of the last one and start the next day, so nothing comes in twice.
- Download the file from online banking, or convert the PDF statement.
- In QuickBooks Online go to Accounting → Bank transactions. If the account already has a tile, select it.
- Open Link account ▾ and choose Upload from file. If the account isn't connected to online banking yet, you'll see Upload from file or Or upload transactions manually.
- Drag the file in, or select it, then Continue.
- In QuickBooks account ▾, pick the account to import into, or Add New to create it. Then Continue.
- For a CSV, tell QuickBooks whether the file has a header row and which date format it uses, then match the columns to Date, Description and Amount (or Credit and Debit).
- Check that money out shows as negative and deposits as positive. If every amount is backwards, select Reverse all values.
- Select the transactions to import, Continue, Yes, then Done.
- On For review, match or categorize each transaction, then reconcile the account.
Set up bank rules before you upload if you want QuickBooks to categorize as the transactions come in. Rules set to auto-add skip For review entirely, so those transactions go straight into your books.
4. From a CSV or Excel file
QuickBooks Online reads two CSV layouts. Three columns: Date, Description, Amount, with payments negative and deposits positive. Or four: Date, Description, Credit, Debit, with each amount in one column and the other left blank. A bank's own export usually needs cleaning first: delete anything above the header row (account number, statement period, opening balance) and any balance or totals columns and rows. Then apply Intuit's rules:
- Leave cells that only hold a zero blank.
- Use one date format throughout. If the bank adds the day of the week (
20/11/2018 TUE), split it off with Data → Text to Columns using Space as the delimiter. - Headers should read just
CreditandDebit, without the word "amount". - Intuit says to "correct any transactions that display numbers in the Description column".
- On a Mac, save the file as a Windows CSV.
Here's how the fictional sample statement's first rows look in the 3-column layout. These are the first lines of its QuickBooks Online CSV, with dates as MM/DD/YYYY:
Date,Description,Amount
09/01/2026,ACH DEBIT GUSTO PAYROLL 0912,-6420.18
09/01/2026,STRIPE TRANSFER ST-K2M8Q4,3184.27
09/02/2026,CHECK 2041,-1850.00Utilly's QuickBooks Online CSV also drops characters Intuit's upload doesn't accept, so the statement's POS PURCHASE OFFICE DEPOT #1123 comes out as POS PURCHASE OFFICE DEPOT 1123. Blank 3- and 4-column files with known totals are on the QuickBooks Online CSV import template, and the free QuickBooks Online CSV checker flags header rows, zeros, mixed dates and balance columns before you upload.
Excel: Upload from file doesn't take .xlsx. Delete the extra rows and columns, check the amount signs, then File → Save As → CSV. If the workbook has several tabs, only the active sheet is saved. For a messy bank export, CSV to QBO or Excel to QBO maps the columns for you and writes a .QBO, which usually skips the mapping step in QuickBooks.
5. From a PDF statement
QuickBooks Online now reads PDF and image statements (PDF, JPG, PNG or HEIC, in English, from any bank). Use the same Upload from file screen and choose the account. Intuit says it may flag items for review, and that its team of experts may review the statement; you're told on the Bank transactions page when it's ready. Then check the side-by-side view of the statement against what QuickBooks extracted, edit anything that needs attention, and Save.
That's built in and free. What it doesn't do is prove that every line was caught, so compare the totals before you save (section 7). If you're importing a year of statements, or the PDFs are long, converting first can be quicker to check: Utilly reads each PDF, including scanned ones of up to 10 pages, and checks the transactions against the statement's opening and closing balance before you download the QuickBooks Online CSV or .QBO. The full walkthrough, including how to tie out QuickBooks' own extraction, is in uploading a PDF bank statement to QuickBooks Online.
6. Missing transactions and months before the feed
Before you upload anything to fill a gap, make sure the transactions really are missing. Intuit's checklist:
- Update the connection: on Bank transactions select Update. Intuit says new transactions can take up to 48 hours to come over, and pending transactions aren't downloaded at all.
- Look on every tab: For review, Categorized and Excluded. An excluded transaction can be brought back with Undo.
- Check Uncategorized Income and Uncategorized Expense, and the account register (Chart of accounts → View register).
- Check your bank rules: auto-add rules post transactions without showing them in For review.
If they're still missing, or they're older than the feed reaches, upload them from a file. Intuit says to use file import rather than entering them manually, and that QuickBooks doesn't download transactions older than 90 days. For months before the feed started:
- Find the date of the first transaction the feed brought in. Download or convert the months before it, and end the file the day before that date.
- Upload one month per file. That keeps each file inside the 1,000-line and 350 KB limits and makes each month easy to check against its statement.
- Intuit's prerequisite is that the file "starts at least one day before your oldest QuickBooks transaction in that account". Start it where your opening balance date is, so the reconciled balance lines up.
Catching up a whole year this way is covered in catch-up bookkeeping from bank statements.
7. Check the import against the statement
Before you categorize, confirm the count and the totals. With the sample statement, these are the numbers that should appear:
| Check | Sample checking 0427, September 2026 | If it's off |
|---|---|---|
| Transactions | 31 | 62 means it was uploaded twice; fewer means rows were skipped or deselected |
| Deposits (positive) | 11, totalling 29,597.43 | If deposits show as spending, the signs are reversed: use Reverse all values |
| Withdrawals (negative) | 20, totalling 28,575.27 | Fees and interest lines are the usual gap |
| Net change | +1,022.16 | Must equal the ending balance minus the beginning balance |
| Balance | 12,418.36 → 13,440.52 | Reconcile to the statement's ending balance and date |
The free bank statement balance checker does this sum for any statement. Then reconcile in QuickBooks with the statement's ending date and balance. If the difference isn't zero, see reconciliation not matching.
8. Take an upload back out
There's no single undo button for an upload. To remove a file that went in twice or into the wrong account, filter For review to the file's dates, tick its transactions and select Exclude. Undo any that were already added or matched on the Categorized tab first, then exclude them. Excluded transactions don't count in your books. Step by step, and how to stop an upload overlapping the feed: duplicate transactions after an import.
9. Upload errors and what they mean
| What you see | Likely cause | What to do |
|---|---|---|
| "The uploaded file contains invalid transaction amount information." | Intuit: a transaction with 12 or more digits | Remove it from the file, enter it as a separate sales receipt or expense, upload again |
| "The uploaded file is of a different type than these accounts." | The file is for a different type of account than the one picked (Intuit's example: savings transactions into checking) | Cancel and pick the right account, or OK to continue |
| (Parent Account Error) or (Sub-account Error) | The related parent or subaccount is already connected to online banking | Intuit: disconnect it temporarily, upload, reconnect |
| "An Online Banking update is currently in progress" | QuickBooks' daily download is running | Wait until it finishes |
| "We were unable to upload the file…" / "couldn't upload your file" | A time-out or temporary server problem | Wait a few minutes and upload again |
| Upload refused as too large | Over 350 KB or 1,000 lines | Split the file by month |
| CSV won't map, or columns come in wrong | Extra rows above the header, a balance column, zeros, mixed date formats, a Mac CSV | Fix per section 4, or run the CSV checker |
| Every amount has the wrong sign | The bank writes withdrawals as positive | Select Reverse all values at the review step |
| Transactions appear twice | The file overlapped the bank feed or an earlier upload | Exclude one copy (duplicates guide) |
10. Convert your own statement
Have the bank's PDF, or a CSV QuickBooks won't take? Each converter shows every transaction and the balance check before you download. CSV, Excel and OFX files are free up to 100 rows, and PDFs get a free preview. Files are read in memory and not stored.
Get your bank transactions into QuickBooks Online
Pick what you're starting from.
Utilly isn't affiliated with Intuit or any bank. Menu names change; the paths above are from Intuit's help, checked November 10, 2026, and weren't run in a live QuickBooks Online company. Sources: Intuit, Manually upload transactions into QuickBooks Online (file types, 350 KB / 1,000 lines, PDF and image upload, date range, Reverse all values), Format CSV files in Excel to get bank transactions into QuickBooks (3- and 4-column formats), Fix bank upload errors and Find missing downloaded transactions (48 hours, 90 days, pending, Excluded, bank rules). The sample statement is fictional.
FAQ
How do I import bank transactions into QuickBooks Online?
Go to Bank transactions, select the account's tile, then Link account, Upload from file. Upload a .QBO, .QFX, .OFX or CSV file of up to 1,000 lines and 350 KB, choose the QuickBooks account, map the columns for a CSV, select the transactions and import them. They land on the For review tab, where you match or categorize them and then reconcile.
What file types can I upload to QuickBooks Online?
Transaction lists as .QBO (Intuit's suggestion), .QFX, .OFX, CSV or .txt, and account statements as a PDF or an image (JPG, PNG or HEIC) in English. Excel .xlsx files aren't accepted directly: save the sheet as CSV first.
How do I import bank transactions into QuickBooks Online from Excel?
Arrange the sheet as Date, Description, Amount (payments negative, deposits positive) or Date, Description, Credit, Debit, delete any rows above the header and any balance column, leave zero cells blank and use one date format. Save it as CSV (on a Mac, a Windows CSV), then upload it with Upload from file.
Can you import a PDF bank statement into QuickBooks Online?
Yes. Upload the PDF or an image of the statement on the same Upload from file screen, choose the account, then check QuickBooks' side-by-side view of the statement and what it extracted before you save. Compare the deposit and withdrawal totals with the statement, because the extraction isn't checked against the balances for you.
How do I add missing bank transactions in QuickBooks Online?
First select Update on Bank transactions, wait up to 48 hours, and check the For review, Categorized and Excluded tabs, the Uncategorized accounts and any auto-add bank rules. If they're still missing, download those dates from your bank as a file and upload it. Intuit suggests file import over entering transactions by hand.
How do I import transactions from before the bank feed started?
Download or convert the months before the feed's first transaction, ending the file the day before that date, and upload them one month per file. QuickBooks doesn't download transactions older than 90 days, so older months have to come in from a file or statement.
Can I undo a bank upload in QuickBooks Online?
There's no single undo button. Filter For review to the uploaded dates, select the transactions and choose Exclude; undo any that were already added or matched on the Categorized tab first. Excluded transactions don't count in your books.
Related guides
- How to upload a PDF bank statement to QuickBooks Online (and check nothing was missed)
- Free QuickBooks Online CSV import template for bank transactions (3- and 4-column)
- How to import credit card transactions into QuickBooks Online and Desktop (CSV, Excel or PDF)
- Duplicate transactions in QuickBooks after an import: find them, remove them, and stop them coming back
- QuickBooks reconciliation not matching: beginning balance is off, or the difference isn't 0.00
- Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled
Related tools
- Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
- Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.
