Bank statement PDF to a QuickBooks import CSV
QuickBooks Online can import bank transactions from a CSV file, which is handy for older months, closed accounts or statements a client sent you as PDFs. The catch is that QuickBooks wants a simple layout: a 3-column file (Date, Description, Amount) or a 4-column file (Date, Description, Credit, Debit).
StatementLocal converts the PDF in your browser and exports a CSV that already contains those columns, with amounts as plain signed numbers. A balance check flags missed or misread rows before they end up in your books.
Try it on your own statement. Free: 1 file per day, CSV & Excel export, nothing uploaded.
Open the free converterHow to do it
- Download the PDF statement from online banking (or use the PDF you were sent).
- Open the converter, drop the PDF, and wait for the balance check. Fix any flagged rows by clicking the cell.
- Export CSV. Open it and keep Date, Description and Amount for the 3-column layout (delete Debit, Credit, Balance, Source File and Check), or keep Date, Description, Credit and Debit for the 4-column layout.
- In QuickBooks Online go to Bank transactions, choose Upload from file, pick the account, then map the columns and the date format.
What columns you get
Every export, CSV or Excel, has the same columns, so your templates and import mappings keep working from month to month:
| Column | What it contains |
|---|---|
| Date | Transaction date (YYYY-MM-DD in CSV, a real date cell in Excel). The year is inferred from the statement period, including December–January rollovers. |
| Description | The transaction text, with multi-line descriptions joined into one cell. |
| Amount | One signed number: money in positive, money out negative. |
| Debit / Credit | The same amount split into money-out and money-in columns. |
| Balance | The running balance, when the statement prints one. |
| Source File | Which PDF the row came from, useful when merging several statements. |
| Check | OK when the row reconciles with the running balance, or a MISMATCH note to review. |
Tips for a clean result
- In the 3-column layout, money out must be negative and money in positive. That is exactly how StatementLocal's Amount column is signed.
- QuickBooks recommends one consistent date format. The CSV uses YYYY-MM-DD; if your QuickBooks date options don't include it, reformat the Date column in Excel first.
- Remove opening and closing balance rows if you added any by hand. QuickBooks only wants transaction lines.
- QuickBooks limits upload size, so import one statement or one month at a time if a file is rejected.
Private by design
The PDF is opened by JavaScript inside your browser tab and never uploaded. No AI is involved: parsing is deterministic, so the same PDF always gives the same result. Scanned (image-only) PDFs aren't supported yet. Read more in the privacy guide or the Privacy Policy.
Pricing: the free plan converts 1 file per day. Pro ($9/month or $59/year) and the one-time 30-Day Pass ($19) unlock unlimited files and batch merging. See plans.
Try it on your own statement. Free: 1 file per day, CSV & Excel export, nothing uploaded.
Convert a statement nowFAQ
Does StatementLocal export QBO (Web Connect) files?
No, not yet. It exports CSV and Excel. QuickBooks Online accepts CSV bank uploads, which works for most cases.
Which QuickBooks layout should I use?
The 3-column layout (Date, Description, Amount) is simplest because StatementLocal already signs the Amount column. Use the 4-column layout if you prefer separate Credit and Debit columns.
Does it connect to my QuickBooks account?
No. StatementLocal never asks for QuickBooks or bank logins. You download the CSV and upload it yourself.
Is it suitable for bookkeepers handling client statements?
Yes. Statements never leave your browser, and Pro converts many PDFs in one batch.