Blog

How to Import a Bank Statement PDF into QuickBooks Online

QuickBooks Online uploads bank transactions from a CSV with three or four columns, not a PDF. How to make that file from your statement and upload it.

, updated

QuickBooks Online gets bank transactions from a connected bank, or from a file you upload. The file can be CSV, QBO, QFX or OFX, but not PDF. A statement you only have as a PDF has to become a CSV first, in the exact shape QuickBooks reads.

How far back a connected bank goes

When you connect a bank, QuickBooks asks how far back to download. The answer is up to your bank: some send the last 90 days, others up to 24 months. Anything older, and anything from an account you have closed, has to come in as a file. For those months, the PDF statement is often the only record you have.

What QuickBooks needs in the file

QuickBooks is strict about the CSV it takes:

  • Three or four columns. Either Date, Description and Amount, or Date, Description, Credit and Debit. A file with more columns is refused, so a statement's own layout, with its balance column, will not upload as it is.
  • One header row, then one transaction per row.
  • Every date in the same format, with its year.
  • Up to 1,000 lines and 350 KB in one upload.

The three-column version looks like this, money in positive and money out negative:

Date Description Amount
06/03/2024 ACH CREDIT A CUSTOMER INC CCD 1850.00
06/04/2024 ACH DEBIT WATER COMPANY PPD -41.20
06/05/2024 CARD PURCHASE 06/04 OFFICE SUPPLY STORE -23.49

The rows above are an example, not a real statement.

Turn the PDF into the file

With BankPDFtoXLS, you do not build this file by hand. We write the three-column file for you, from the statement's own dates and amounts, and leave out "Balance brought forward" and other lines that are not transactions.

  1. Drop the PDF in on our home page, and we show you its first page converted before you sign up. Sign up with your email address to download it. You do not need a card, and the free trial converts 15 pages, so you can check the columns first.
  2. Take a Standard or Plus plan and convert the whole statement. The free trial gives this file too; Lite gives Excel and CSV only.
  3. In your list of statements, beside the Excel and CSV downloads, select (US dates) for a company set up in the US: the dates are month first (mm/dd/yyyy). Select Xero / QuickBooks instead for day first (dd/mm/yyyy), as in the UK.

Many statements print a date without its year. We take the year from the statement itself. If we cannot settle a date, for example on a scan where a month did not read clearly, we make no file for that statement rather than one with a wrong date. Your Excel download still has every row.

If a statement holds several accounts, you get one file for each, because each upload goes into one QuickBooks account.

Upload it to QuickBooks Online

  1. Go to Bank transactions (under Accounting).
  2. Select Link account, then Upload from file.
  3. Select the file, then Continue.
  4. Choose the QuickBooks account the statement belongs to, then Continue.
  5. Match the file's Date, Description and Amount columns to the QuickBooks fields of the same names. If QuickBooks asks, the dates are in the format you downloaded, and the amounts are in one column, money in positive and money out negative.
  6. Select the transactions to bring in, then Continue, and confirm.

The transactions land in the For review list, where you categorize or match them as you would any others.

A statement over 1,000 transactions

QuickBooks takes at most 1,000 lines in one upload. For a longer statement, open the file in Excel, and save it as two or more CSV files of fewer than 1,000 rows each, each with the header row at the top. Upload them one after the other.

Check it before you categorize

  • Compare the balance. Once the transactions are added, the account's balance in QuickBooks should have moved by the statement's closing balance less its opening balance.
  • Do not upload a period twice. If the account is also connected to your bank, upload only the dates the connection does not cover.
  • Check any flagged rows. We check every balance against the row before it. If a row does not follow, your list of statements says so. Open the Excel download, filter the Ledger column for break, and compare those rows with the PDF before you upload. Why a balance breaks explains what to look for.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.

Start your free trial

15 pages free, up to 5 for each statement. No card.

See plans and prices