How to import a PDF bank statement into QuickBooks
Convert the PDF into a file QuickBooks imports: a QuickBooks Web Connect file (.qbo) for QuickBooks Online or Desktop, or a CSV for QuickBooks Online. Check that the converted transactions reconcile with the statement's balances, then upload the file to the matching bank account in QuickBooks.
1. Convert the statement
- Upload the PDF to Balanced Statement (a scan or phone photo works too). Your first statement is free.
- Check the result: it shows the opening and closing balance, the computed closing balance and every transaction.
- Download QuickBooks (QBO), or CSV if you prefer to map columns yourself in QuickBooks Online. One credit includes every format.
2a. QuickBooks Online: upload the file
- In QuickBooks Online, open Bank transactions and choose Upload from file.
- Choose the .qbo or .csv file and the bank account to add the transactions to.
- For a CSV, map the columns: our CSV has Date, Description and Amount (a 3-column layout), plus Debit, Credit, Balance and Reference.
- Review the transactions in the For review tab, then add or match them.
Intuit's limits for uploaded files: Intuit's article on uploading transactions lists QBO, QFX and CSV files (and PDF or image statements), files of 350 KB or less, up to 1,000 lines per upload, in English. CSV files use either 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), with all dates in the same format.
2b. QuickBooks Desktop: import the Web Connect file
- Back up your company file.
- Use QuickBooks Desktop's Import Web Connect Files option and choose the .qbo file. Web Connect reads .qbo files only, and you need to be signed in to your Intuit account in QuickBooks Desktop.
- When asked, link the file to your existing bank account in QuickBooks, then review and add the transactions.
Intuit's articles: importing data into QuickBooks Desktop and fixing Web Connect import errors.
Check before importing
- Balances: the result is marked Verified (opening balance plus all transactions equals the closing balance, or the running balance matches on every row). If it says Failed or Not verified, review the highlighted rows first.
- Count: the number of transactions matches the statement.
- Signs: money out is negative and money in is positive.
- Dates: all dates fall inside the statement period, in the date format QuickBooks expects.
- Overlaps: none of these transactions are already in QuickBooks from a bank feed or an earlier import, or you'll get duplicates.
Where Balanced Statement fits
It does the conversion and the balance check: the PDF becomes a .qbo or CSV file whose transactions reconcile with the statement, or you see which rows don't. QuickBooks does the import, categorisation and matching. Balanced Statement doesn't connect to QuickBooks directly and doesn't create IIF files.
Pricing: pay per statement, no subscription. Also: import into Xero, convert to Excel.