How to import a bank statement PDF into QuickBooks Online

Why QuickBooks will not take the PDF

A PDF statement is a printed page. QuickBooks needs rows: a date, a description and an amount for each transaction. A connected bank feed sends those rows for you. When the feed does not cover the months you need, because the bank will not connect, the account is closed, or the statements are older than the feed reaches, you have to bring the rows in as a file.

If your online banking has a Download transactions option with a QuickBooks (.qbo) format, use that. If the bank only gives you PDF statements, convert them.

Step 1: Get the right PDF

Download the statement from online banking instead of scanning a paper copy. A downloaded PDF has a text layer, so every date and amount can be read exactly. Scans and phone photos go through OCR and need more checking. Use one statement per upload, for one bank account.

Step 2: Convert the statement

1. Sign in and upload the PDF on the bank statement to QuickBooks page.
2. Look at the result. It says Reconciled when the opening balance plus money in minus money out equals the closing balance, Not reconciled when it does not, and Could not be checked when a balance is missing.
3. Download the .qbo file. Download the QuickBooks Online CSV too if you want a copy you can open in a spreadsheet.

The balance check does not cover dates or descriptions. Skim those against your statement before you import, because fixing a row before it reaches your books is easier than fixing it after.

Step 3: Upload the file into QuickBooks Online

1. Download the .qbo file from your FastOCR result.
2. In QuickBooks Online, open Banking > Bank transactions. Some accounts show it as Transactions > Bank transactions.
3. Open the Link account menu and choose Upload from file. Older menus call it Upload transactions.
4. Choose the .qbo file, then pick the QuickBooks account the transactions belong to.
5. Review the rows in the For review tab, then add or match each one.

The .qbo file uses a generic bank ID, so QuickBooks may show a bank name that is not yours during the upload. Pick your own account in the account step and the rows land in the right place.

Step 4: Review before you add

Imported rows wait in the For review tab. For each one, QuickBooks either suggests a match with something already in your books or asks you to add it with a category. Bank rules you already set up apply here too.

If the account also has a live bank feed, watch for overlap. A row from your file and the same row from the feed have different transaction IDs, so QuickBooks may list both. Import only the dates the feed does not cover, and exclude any duplicate that slips through.

If you use the CSV instead

QuickBooks Online reads two CSV layouts: three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). The FastOCR QuickBooks CSV uses three columns, with money out as a negative amount. QuickBooks asks you to map the columns and confirm the date format during upload. If you edit the file in a spreadsheet first, keep these rules from Intuit’s CSV guidance:

• Use one date format for the whole Date column.
• No currency symbols or thousands separators in amounts.
• Leave empty cells empty instead of typing 0.
• On a Mac, save as a Windows CSV.

The CSV has no transaction IDs. Uploading the same CSV twice adds every row twice.

Common upload problems