How to import a bank statement into QuickBooks (CSV, OFX or QBO)
QuickBooks' bank feeds only reach back so far. Intuit says that on QuickBooks Desktop's Direct Connect, "some banks offer up to a year of history, while most provide about 90 days" (Intuit). For anything older, a closed account, or a bank that won't connect, you upload a file. Which file depends on which QuickBooks you use.
Which file does each version of QuickBooks accept?
| QuickBooks Online | QuickBooks Desktop (Windows) | |
|---|---|---|
| CSV | Yes (3- or 4-column layout) | No for bank transactions. Intuit's community team confirms bank import via CSV "isn't currently an option" in Desktop (QuickBooks Community) |
| QBO (Web Connect) | Yes | Yes, the only file type for Web Connect: "Web connect only works with .qbo files. Other types like QFX and QIF Quicken files won't work" (Intuit) |
| OFX | Yes (.ofx is in the accepted list) | No |
| QFX | Yes | No |
| PDF or image of a statement | Yes, through a separate statement upload | No |
QuickBooks Online's accepted types come from Intuit's manual upload article, which lists .csv, .txt, .qbo and .ofx for transaction lists and a separate path for statement PDFs and images.
A note on QBO vs OFX. A .qbo file is Intuit's flavour of the OFX format, which is why the two look alike inside. Desktop insists on the .qbo variant; a plain .ofx file won't go through Web Connect.
QuickBooks Online: upload a transaction file
From Intuit's steps (source):
- Go to Bank transactions (in the current navigation: All apps > Accounting > Bank transactions).
- Open the Link account dropdown and choose Upload from file (or "Upload transactions manually" if the account isn't connected).
- Drag in your file and select Continue.
- Choose the QuickBooks account the transactions belong to. For a credit card statement, choose the credit card account.
- Match the columns in your file to QuickBooks' fields and confirm the date format.
- Select the transactions to import, confirm, and select Done.
The transactions land in For review, where QuickBooks suggests matches and categories before anything posts to your books.
Intuit's CSV rules (the ones that cause most failures)
From Intuit's upload and CSV formatting articles (upload, formatting, common errors):
- 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), headings in the first row.
- File in English, 350 KB or less, up to 1,000 lines per upload. Split long periods into smaller date ranges.
- Leave cells that would only hold a zero blank.
- Remove the word "amount" from Credit and Debit headings.
- All dates in one format; Intuit recommends dd/mm/yyyy. Split off any weekday text.
- No currency symbols or thousands separators in amounts.
- If a 4-column file has only money-out rows, Intuit suggests adding a temporary positive line so the upload works, then unticking it on the review screen.
QuickBooks Desktop: import a Web Connect (.qbo) file
- Back up your company file first. Intuit is explicit that imports can't be undone (Intuit).
- Go to File > Utilities > Import > Web Connect Files.
- Pick the .qbo file.
- When asked, choose Use an existing QuickBooks account or Create a new QuickBooks account, then Continue.
- Review and match the downloaded transactions in the Bank Feeds Center.
(Steps as given by Intuit's support team on the QuickBooks Community.) Intuit also notes you can't download the same transactions into a Desktop company file twice, and that newer versions require signing in to your Intuit account to import Web Connect files.
From PDF to an importable file
If the bank only gives you PDFs for the months you need:
- Convert the statement to CSV (for QuickBooks Online) or QBO (for Desktop).
- Verify before import: opening balance + money in − money out must equal the statement's closing balance. QuickBooks checks the file's format, not whether every transaction is present.
- Import using the steps above.
- Reconcile the account in QuickBooks against the statement's ending balance so a missing or duplicated line shows up now, not at year end.
Footed converts statement PDFs to CSV and OFX, both of which QuickBooks Online accepts. It opens the PDF in your browser, sends only the extracted text for parsing, and reconciles every conversion against the statement's own balances before you download. Footed does not produce .qbo Web Connect files today, so it is not the right tool for QuickBooks Desktop.
Avoiding duplicates
- Check the date range against existing bank feed data. If the feed already brought in the last 90 days, upload only what's older.
- One statement period per file, named by account and month, so you can see what's already in.
- In QuickBooks Online, transactions arrive in For review; exclude anything that matches an existing entry rather than adding it.
FAQ
Can QuickBooks read a PDF bank statement directly? QuickBooks Online now has a statement upload that accepts a PDF or image (Intuit). Check the extracted transactions against the statement totals either way. QuickBooks Desktop does not import PDFs.
Why does my credit card import show payments as charges? The file's signs are reversed for a card account, or it was uploaded into a bank account. Intuit says to upload card files to the credit card account (Intuit).
My dates imported but they're wrong. A day-first file mapped as month-first imports silently for any day 12 or under. Delete the batch, remap the date format, and re-import.
3-column or 4-column? Either works. Three columns with signed amounts is less error-prone if your converter gets the signs right; four columns is easier to eyeball against the PDF.
Have statements QuickBooks won't take? Footed turns them into CSV or OFX, keeps the PDF in your browser, and flags any row that doesn't reconcile with the statement. Free for 5 pages a day.
Published 2026-10-07.