QuickBooks Online and Desktop
Import bank statements into QuickBooks
QuickBooks Online can now read some PDF statements itself, QuickBooks Desktop cannot, and both are strict about the files they do take. Here is which file each version wants, and how to get there from a PDF.
- QBO Web Connect files with your bank’s INTU.BID
- Three-column CSV for QuickBooks Online
- IIF for QuickBooks Desktop registers
- Every row checked against the running balance
<INTU.BID>10898<STMTTRN> <TRNTYPE>CREDIT <DTPOSTED>20260302 <TRNAMT>4210.00 <FITID>a3f9c2e81b07 <NAME>ACH DEPOSIT STRIPE PAYOUT</STMTTRN><STMTTRN> <TRNTYPE>CHECK <DTPOSTED>20260305 <TRNAMT>-1250.00 <FITID>5d10e7b4c9a2 <CHECKNUM>1042</STMTTRN><LEDGERBAL><BALAMT>15354.12
The short answer
Can you import a PDF bank statement into QuickBooks?
Into QuickBooks Online, sometimes yes: Intuit’s help now describes uploading a PDF or image statement (PDF, JPG, PNG or HEIC, in English) from Bank transactions → Link account → Upload from file, after which QuickBooks extracts the rows and shows them beside the statement for you to correct. Into QuickBooks Desktop, no. Desktop imports bank activity as a Web Connect (.qbo) file, or as an IIF file written straight into a register.
Even in QuickBooks Online the transaction-file route is still the one Intuit recommends first. Its help article suggests a QBO file, also takes QFX, OFX and CSV, and caps each upload at 350 KB and 1,000 lines. So the practical question is which of those files you need and how to produce it from the PDFs your bank gave you.
VouchRow reads the PDF statement, digital or scanned, checks every row against the statement’s own running balance and printed totals, and exports the file QuickBooks wants: QBO for the banking feed in either version, a three-column CSV for QuickBooks Online, or IIF for Desktop. You then import that file yourself through QuickBooks’ own menus.
Which format to use
The file QuickBooks wants
QBO for QuickBooks
The bank ID is why your .qbo file was rejected
Step by step
How to import a PDF bank statement into QuickBooks
The same route works for bank and credit card statements. Do one account at a time so each file lands in the right QuickBooks account.
- 1Collect the PDF statements for the gapWork out which dates QuickBooks is missing for the account: before the bank feed started, while it was broken, or for an account that never had one. Download those monthly PDF statements from online banking, or scan the paper ones. Password-protected PDFs are fine; you enter the password when asked.
- 2Upload and let the statement be checkedSign in and upload the PDFs. Digital statements can go up in batches; scanned ones are read with OCR one at a time. Each statement is checked row by row against its running balance, then against page subtotals, opening plus movement against closing, and the printed totals. A row that breaks the chain is flagged and linked to the highlighted line on the PDF.
- 3Export the file your QuickBooks takesQBO for the banking feed in QuickBooks Online or Desktop: enter your bank’s INTU.BID when asked (it is in any .qbo file your bank has issued). The QuickBooks three-column CSV (Date, Description, Amount) for QuickBooks Online when you have no bank ID. IIF for QuickBooks Desktop when you want entries in the register rather than in Bank Feeds.
- 4QuickBooks Online: Upload from fileGo to Bank transactions, open the Link account dropdown and choose Upload from file. Select the .qbo or .csv, choose the QuickBooks account the rows belong to, and for a CSV match the Date, Description and Amount columns. QuickBooks then shows the rows it read; select them and continue.
- 5QuickBooks Desktop: Web Connect or IIFFor a .qbo file use File → Utilities → Import → Web Connect Files, then choose an existing QuickBooks account or create one; the transactions appear in the Bank Feeds Center for review. For an .iif file use File → Utilities → Import → IIF Files. Back up the company file before an IIF import, because IIF entries post immediately.
- 6Review, match and reconcileIn the For review list, match rows to transactions you already entered and categorise the rest. Then reconcile the account against the statement’s closing balance. Imported IIF rows sit in Uncategorized Income or Uncategorized Expense until you assign them.
Why it works
Why convert first instead of typing or uploading blind
QBO files QuickBooks recognises
The INTU.BID you enter goes into the file, so QuickBooks accepts it as a Web Connect download instead of failing with OL-301 or an unsupported-institution message.
Re-imports don’t double up
Transaction IDs (FITIDs) are built from the transaction itself, so converting the same statement twice produces the same IDs and QuickBooks treats the second import as repeats.
Checked before it reaches the books
A misread amount or a row lost at a page break breaks the running balance at that row. You fix it before import, not three months later during reconciliation.
Online and Desktop from one conversion
QBO, CSV and IIF all come from the same reviewed rows. Exporting another format doesn’t count the pages again.
Scanned statements too
Old paper statements for a catch-up or a closed account are read with OCR and go through the same balance checks as digital ones.
Checked before export
A misread digit is caught on its own row
Every conversion is tested against the statement: the running balance on every row, page subtotals, opening plus movement against closing, the printed credit and debit totals, and the transaction count. When a number does not add up, VouchRow names the row and highlights the line it came from on the PDF.
Arithmetic only: it verifies amounts, balances and totals, not descriptions or dates, and two errors that cancel out would pass. The source-line link covers the rest.
How the checks workRunning balance check
- POS AMAZON MKTPLACE−86.4316,604.12
- CHECK #1042−1,250.0015,354.12
- ZELLE FROM J MORALES+640.0015,994.12
Every row agrees with the balance printed beside it.
Formats
Which file QuickBooks Online and QuickBooks Desktop accept
The two QuickBooks products share a name and very little import code. QuickBooks Online’s Upload from file accepts a transaction list (QBO, QFX, OFX, CSV or TXT) or, more recently, a PDF or image statement. QuickBooks Desktop reads Web Connect .qbo files through its banking import and IIF files through its utility import, and Intuit’s community answers are consistent that it does not take a bank CSV into Bank Feeds.
IIF is the one people most often try in the wrong place. Intuit removed IIF import from QuickBooks Online, so an .iif file is only useful if you run Desktop.
| File | QuickBooks Online | QuickBooks Desktop | Notes |
|---|---|---|---|
| QBO (Web Connect) | Yes, Intuit’s recommended file | Yes, File → Utilities → Import → Web Connect Files | Needs a valid INTU.BID; FITIDs prevent duplicates |
| CSV | Yes, 3 or 4 columns only | Not into Bank Feeds | 350 KB and 1,000 lines per upload in Online |
| QFX / OFX | Accepted by Upload from file | Use QBO instead | QFX is Quicken’s variant; QBO is the QuickBooks one |
| IIF | No (removed) | Yes, File → Utilities → Import → IIF Files | Posts straight to the register, no review step |
| PDF / image | Yes, English statements, with a review step | No | Extraction may be passed to Intuit’s reviewers |
CSV rules
QuickBooks Online CSV format: columns, dates and limits
Intuit’s rules for a bank CSV are narrow. The file must have either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). Anything else, such as a bank export with a balance column, a reference column and a type column, has to be cut down first; Intuit’s community confirms a six-column file is not accepted.
The QuickBooks three-column preset in VouchRow writes exactly Date, Description, Amount, with money in positive and money out negative, which is the sign convention Intuit asks for.
- One file must be in English, 350 KB or smaller, with no more than 1,000 transaction lines. Split a year of a busy account into quarters or months.
- Every date in the file must use the same format. Choose the date order your QuickBooks region expects (month-first for a US company, day-first for UK, Canadian or Australian files) when you export.
- In the four-column layout, remove the word “amount” from the Credit and Debit headers and leave zero cells blank.
- If the bank put the weekday in the date cell, it has to be split out. A converted statement doesn’t have this problem.
- Intuit asks that the file start at least one day before the oldest transaction already in that QuickBooks account, so the opening position lines up.
Errors
Common QuickBooks import errors and what causes them
Most QuickBooks import errors describe the symptom, not the cause. These are the ones that come up with converted statements.
- OL-301, OL-249 or “unable to verify the financial institution”: the INTU.BID in the .qbo file isn’t one QuickBooks recognises. Copy the BID from a .qbo your bank issued and enter it when exporting.
- The account you want isn’t offered on a Web Connect import: QuickBooks matches by account type. A credit card file offers only credit card (liability) accounts, so check you converted the card statement as a card account.
- The upload is refused for size: the file is over 350 KB or 1,000 lines. Export a shorter date range.
- CSV columns can’t be mapped: the file has more than four columns or a header QuickBooks doesn’t expect. Use the three-column preset.
- Desktop stopped importing .qbo files after years of working: Intuit ties online banking features to supported Desktop versions, so an older release can lose Web Connect. IIF still imports in that case.
Duplicates
Avoiding duplicates when the bank feed covers part of the period
A QBO file carries a transaction ID (FITID) on every row. QuickBooks uses it to recognise a transaction it has already downloaded from the same account, which is why Web Connect is the safest route for a period that might overlap the bank feed. VouchRow builds each FITID from the transaction itself, so converting the same statement twice gives identical IDs.
A CSV has no such ID. QuickBooks Online will suggest matches in For review, but a second upload of the same month can still add a second copy of everything. Before uploading a CSV, check the earliest date the bank feed already holds and end the file the day before.
IIF has no review step at all. Importing the same IIF twice creates every entry twice, so back up the company file first and keep a note of which periods you have imported.
Catch-up
Importing old bank statements into QuickBooks
A bank feed only reaches back as far as the bank allows when it is first connected, which is often a few months and rarely more than a couple of years. Older history, closed accounts and accounts at banks with no QuickBooks connection exist only as PDF statements. That is the usual reason people search for this.
For a multi-year catch-up, convert the statements month by month, check that each month’s closing balance carries into the next month’s opening balance, and import in date order. Keep each upload under QuickBooks Online’s 1,000-line cap. Excel export alongside the QBO file gives you a reviewable record of exactly what was imported.
Native or converter
When QuickBooks’ own PDF upload is enough, and when it isn’t
If you use QuickBooks Online, have a handful of recent English-language statements, and are happy to check the extracted rows on screen, Intuit’s own PDF upload may be all you need. It is built in, and the side-by-side review is a sensible design.
A converter earns its place when you run QuickBooks Desktop, when you need dozens of statements for a catch-up, when you want each statement proven against its running balance before anything posts, when the same rows also need to go to Excel for a client or a file, or when you want QBO files whose transaction IDs stay stable across re-imports.
Side by side
QBO vs CSV vs IIF vs native PDF upload for QuickBooks
| QBO (Web Connect) | Three-column CSV | IIF | QuickBooks PDF upload | |
|---|---|---|---|---|
| QuickBooks Online | Yes | Yes | No | Yes |
| QuickBooks Desktop | Yes | No | Yes | No |
| Needs a bank ID | Yes (INTU.BID) | No | No | No |
| Duplicate protection | FITID per transaction | Manual date check | None | Manual date check |
| Review before posting | For review / Bank Feeds Center | For review | No, posts directly | Side-by-side review |
| Checked against running balance | Yes, before export | Yes, before export | Yes, before export | Your own review |
Who uses it
Who imports PDF statements into QuickBooks
Catch-up bookkeeping
A new client arrives with a year or two of unrecorded activity and only PDF statements. Convert, check each month ties to the next, import as QBO so overlaps with the feed are caught.
Broken or missing bank feeds
The feed stopped for six weeks, or the bank has no QuickBooks connection. Import the gap from that period’s statements instead of keying it.
QuickBooks Desktop users
Desktop has no PDF import. QBO through Web Connect, or IIF where Web Connect is unavailable, is how statement history gets in.
Credit card accounts
Card statements convert the same way and import as card accounts, which keeps the liability side of the books correct.
FAQ
QuickBooks imports: questions
Can QuickBooks Online import a PDF bank statement?
Intuit’s help now says yes: Upload from file accepts a PDF or image statement in English, extracts the rows and shows them for review, and may pass unclear items to Intuit’s reviewers. Its recommended file is still a QBO transaction file, which is what a converter produces.
Can QuickBooks Desktop import a PDF bank statement?
No. Desktop imports bank activity as a Web Connect .qbo file or as an IIF file. Convert the PDF to one of those first.
QBO or CSV for QuickBooks Online?
QBO, if you can supply the bank ID. It goes through the banking feed, where FITIDs let QuickBooks recognise transactions it already has. CSV skips that, so a second upload of the same month can double everything.
What CSV format does QuickBooks Online need?
Three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit), one date format throughout, in English, no larger than 350 KB and no more than 1,000 lines. Our QuickBooks preset writes the three-column layout.
Does QuickBooks Online accept IIF?
No. Intuit removed IIF import from QuickBooks Online. IIF is for QuickBooks Desktop only.
Why does QuickBooks say my file is not from a supported financial institution?
The INTU.BID in the .qbo file doesn’t match an institution QuickBooks knows. It is the same cause as OL-301: the tag, not your connection. Use the BID from a .qbo file your bank issued.
Where do I find my bank’s INTU.BID?
Open any .qbo file your bank has given you in a text editor and read the INTU.BID line. If you have never had one, your bank’s QuickBooks download page or support team can tell you whether it offers Web Connect.
How do I import several years of old statements?
Convert month by month, confirm each closing balance carries into the next month, and import in date order in batches under 1,000 lines. QBO is the safer format if any period overlaps the bank feed.
Does VouchRow send transactions into QuickBooks for me?
No. It produces the file; you import it through QuickBooks’ own menus. Nothing connects to your QuickBooks company.
Keep going
Related guides and converters
Files for QuickBooks
QuickBooks import errors
Every format we write for QuickBooks
Turn your PDF statements into a file QuickBooks will take
Upload a statement, check every row against the running balance, and export QBO, CSV or IIF for your version of QuickBooks.