Import a Bank Statement Into QuickBooks Online

Why QuickBooks Online rejects your PDF statement

Your bank hands you statements as PDFs, but QuickBooks Online has no way to read one. The upload tool only accepts four file types: CSV, TXT, QBO, and OFX. A PDF is a printed page to QuickBooks, not a list of dated transactions, so there is no column of amounts for it to import. That is the whole reason bookkeepers get stuck: the document they have is not the format QuickBooks wants. The fix is to turn the PDF into a clean CSV of transactions first, then use the built in upload. Once the data is in CSV form, QuickBooks reads the date, description, and amount for every line and drops them into the bank feed ready to categorize and match.

The exact Upload from file steps in QuickBooks Online

In QuickBooks Online, open Transactions in the left menu, then choose Bank transactions. If the account is already connected, select the Link account dropdown in the top right and choose Upload from file. If the account does not exist yet, add it first so QuickBooks has somewhere to put the transactions. Click Browse or Select file, pick your CSV, and choose Continue. QuickBooks then asks you to map the columns in your file to its own Date, Description, and Amount fields. Review that mapping carefully, because a wrong guess here is the usual cause of a failed import. Confirm the account the transactions belong to, review the preview of every row, and finish the import.

How to format the CSV: 3-column vs 4-column

QuickBooks Online accepts two CSV layouts. The three column format is Date, Description, Amount, where withdrawals are negative numbers and deposits are positive. The four column format is Date, Description, Credit, Debit, which splits money in and money out into separate columns. Keep only column headers in the first row, use one consistent date format across the file, and remove any day of week text like Mon or Tue. Strip commas and currency symbols out of the amount fields, since a value like 1,200.00 dollars will not parse. A good converter outputs these columns already clean, so you upload without editing the file by hand in a spreadsheet.

Upload limits and common import errors

There are hard limits to plan around. QuickBooks Online accepts up to 1,000 transactions and a 350 KB file per CSV upload, so a long history or a busy account may need to be split into several files by date range. The most common errors come from formatting: mixed date formats, currency symbols left in the amount column, extra columns QuickBooks cannot map, or special characters in a description. If an import fails, open the CSV, fix the offending column, and upload again. Because statements hold client financial data, files here are processed to produce the CSV and then deleted automatically, so nothing sensitive is stored after the conversion.

Should you upload a CSV or a QBO file?

Both work, and the right choice depends on your workflow. A CSV is the fastest path for a one time import or a cleanup, and it is easy to inspect before uploading. A QBO Web Connect file carries a unique identifier on each transaction, which lets QuickBooks skip duplicates automatically when an imported statement overlaps a live bank feed. For recurring monthly close across several accounts, the QBO file prevents double posting. If you specifically need the Web Connect route, convert your statement to a QBO file instead and import it the same way.

Frequently Asked Questions