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
- You want a check before anything goes in. StatementLocal adds every row to the statement's printed opening balance and compares the result with the printed closing balance. Reconciled means the amounts add up to the cent before QuickBooks sees them.
- You need only part of a statement. A CSV can be trimmed to the rows before your bank connection's first download, so nothing goes in twice.
- You would rather not hand over the PDF. The statement carries your name, address and account number. The CSV holds only the transaction rows.
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:
- 3 columns: Date, Description, Amount, with money out as a negative amount.
- 4 columns: Date, Description, Credit, Debit, with money in and money out in separate columns.
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
- Download the statement from your bank's website as a PDF.
- 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.
- 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
- Open the StatementLocal converter and drop the PDF on the page. The file is read inside your browser and is never uploaded.
- 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.
- Click Download QuickBooks CSV.
Step 3: upload it to QuickBooks Online
- 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.
- Choose the CSV, then the QuickBooks account it belongs to. For a credit card statement, choose the credit card account, not a bank account.
- 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.
- 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:
| Date | Description | Amount |
|---|---|---|
| 03/02/2026 | CLIENT PAYMENT DEPOSIT | 1200.00 |
| 03/05/2026 | OFFICE RENT ACH | -845.00 |
| 03/11/2026 | CITY UTILITIES AUTOPAY | -62.75 |
| 03/24/2026 | CARD 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 account is also connected to your bank, find the date of the oldest transaction the connection downloaded, and upload only rows before it. Delete the later rows from the CSV first.
- Upload one statement at a time, in date order, and never the same month twice. QuickBooks does not always catch a repeated upload.
- When the rows are added, reconcile the account in QuickBooks against the statement's printed closing balance. A difference points to a missing or doubled row.
If the statements go back further than your bank connection, see adding transactions older than your QuickBooks bank feed.
Limits of this method
- This page is about QuickBooks Online. StatementLocal writes CSV, not QBO, QFX or OFX, so it does not make a Web Connect file.
- It reads text-based PDFs only. Scans, photos and password-protected PDFs will not convert.
- It reads US-dollar statements in common US layouts, and we have not tested every bank's statements.
- The balance check sees amounts, not words. A Reconciled statement can still carry a misread date or description, so look over the rows for review before you add anything.
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
- Add transactions older than your QuickBooks bank feed
- Reconcile a bank statement in Excel
- Convert a statement to CSV without uploading it
- Chase statements, then QuickBooks Online
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.