How to import a PDF bank statement into QuickBooks Online

When a bank connection cannot supply the transactions, for a closed account, a month the connection missed, or a client who sent statements by email, QuickBooks Online gives you two ways in from a PDF. You can upload the statement PDF itself: Intuit's help says its AI extracts the transactions and shows them beside the statement so you can edit them before you save. Or you can convert the PDF to a CSV first and upload the CSV as a list of transactions. This page is about the second way, and when it is worth the extra step.

When converting to CSV first helps

What QuickBooks expects in a CSV

Intuit's help pages describe two CSV layouts for a transaction upload, and ask for one date format throughout the file, at most 1,000 lines and 350 KB per upload:

Extra columns, such as a running balance, are best left out. StatementLocal's Download QuickBooks CSV button writes the 3-column layout: Date, Description and Amount, with dates as MM/DD/YYYY and money going out as negative numbers. If QuickBooks changes its rules, Intuit's own help page on formatting a CSV for a bank upload is the final word.

Step 1: get the statement PDF

  1. Download the statement from your bank's website as a PDF.
  2. Use the file exactly as downloaded. A statement that was printed and scanned back in has no text layer, and this version of StatementLocal cannot read scans.
  3. If you are catching up several months, download every statement first and keep the files in date order.

Step 2: convert it to a QuickBooks CSV

  1. Open the StatementLocal converter and drop the PDF on the page. The file is read inside your browser and is never uploaded.
  2. Read the verdict. Reconciled means the rows add up from the printed opening balance to the printed closing balance. Off by highlights the rows to check: fix them in the grid, and the verdict updates when you leave the cell. Cannot check means the statement prints no balances to check against, so compare the rows with the PDF yourself.
  3. Click Download QuickBooks CSV.

Step 3: upload it to QuickBooks Online

  1. In QuickBooks Online, open Bank transactions, then the Link account menu, then Upload from file. Intuit moves its menus from time to time; its help page on uploading transactions manually is the final word.
  2. Choose the CSV, then the QuickBooks account it belongs to. For a credit card statement, choose the credit card account, not a bank account.
  3. Match the columns: Date to Date, Description to Description, Amount to Amount, with the amounts in one column. If QuickBooks asks for the date format, choose MM/DD/YYYY, the format the file uses.
  4. The uploaded rows wait on the Bank transactions page for review. Nothing reaches your books until you add or match each one.

A worked example

A checking statement for March prints an opening balance of $2,410.18 and a closing balance of $1,962.43, with four transactions. The QuickBooks CSV holds:

DateDescriptionAmount
03/02/2026CLIENT PAYMENT DEPOSIT1200.00
03/05/2026OFFICE RENT ACH-845.00
03/11/2026CITY UTILITIES AUTOPAY-62.75
03/24/2026CARD PAYMENT ONLINE-740.00

The four amounts add up to -447.75, and $2,410.18 less $447.75 is $1,962.43, the printed closing balance, so the statement shows Reconciled. After the upload, QuickBooks lists the four rows for review: the deposit as money in, the other three as money out. The card payment is a transfer to your card account, so match it to that transfer rather than adding it as an expense.

Avoid duplicates

If the statements go back further than your bank connection, see adding transactions older than your QuickBooks bank feed.

Limits of this method

Try it on one of your statements

Open the StatementLocal converter and drop one statement PDF on the page. Converting and previewing are always free, and you can download 3 statements a day free, as CSV, Excel or QuickBooks CSV. The file is read inside your browser and is never uploaded.

What has and has not been tested

We tested StatementLocal on 200 synthetic (made-up) statements across 10 common US statement layouts, built by our own generator. Every statement it could not verify was flagged with Off by or Cannot check, never shown as Reconciled. We have not tested it on every bank's real statements, and we quote no accuracy figure for them.

Related guides

StatementLocal is not affiliated with any bank, card issuer or software company named on this page. Names are used only to say what the steps are for.

Need more than 3 statements a day? Buy the 30-day pass for $9 or Buy Lifetime for $39. One-time payments, taken by Stripe. Sold to US customers only.

Use Chrome? The same converter is also a Chrome extension: Add to Chrome from the Chrome Web Store.