Bank Statement to QuickBooks: Import PDF Statements as CSV
QuickBooks Online can't read a PDF statement, but it imports CSV. Convert the PDF into a clean Date / Description / Amount file and upload it to the right bank account in a few clicks.
How do I import a PDF bank statement into QuickBooks?
QuickBooks Online imports bank transactions from CSV, not PDF. Upload the PDF here and download the CSV, keep the Date, Description and Amount columns (or split Amount into Credit and Debit), then in QuickBooks open Bank transactions, choose Upload from file, map the columns and review the transactions before accepting them.
Import a PDF statement into QuickBooks Online
- 1
Convert the PDF to CSV
Upload the statement below (digital or scanned, any bank) and download CSV. Each row is checked against the statement balance before you get it.
- 2
Shape it for QuickBooks
Keep Date, Description and Amount — the 3-column format. If you prefer Credit and Debit columns, use the formulas further down. Delete any opening/closing balance rows.
- 3
Upload from file
In QuickBooks Online go to Transactions → Bank transactions (called Banking in some versions), open the Link account / Update menu and choose Upload from file. Select your CSV.
- 4
Map and choose the account
Pick the QuickBooks bank account, tell it the first row is a header, map Date, Description and Amount (one column or two), and choose the date format that matches the file.
- 5
Review and accept
The rows land in For Review. Categorise or match each one and add it — nothing is posted to your books until you accept it.
Convert your statement to a QuickBooks-ready CSV
Drop PDF here or click to upload
Max 20 MB · Text-based or scanned PDF
The two CSV formats QuickBooks Online accepts
QuickBooks Online accepts either a 3-column file or a 4-column file. Both need a date and a description; the difference is how money in and money out are shown.
| Format | Columns | Money out shown as |
|---|---|---|
| 3-column | Date, Description, Amount | Negative amount (e.g. -45.90) |
| 4-column | Date, Description, Credit, Debit | Positive number in the Debit column |
Our CSV uses a single signed Amount column (negative = money out), so it maps directly to the 3-column format.
Remove extra columns you don't want to map (such as Balance or reference numbers) or simply leave them unmapped during upload. Keep one header row and no blank rows between transactions.
Formulas to make a 4-column file
Open the CSV in Excel. With Amount in column E, add two columns and fill them down:
Credit (money in)
=IF(E2>0,E2,"")Debit (money out, as a positive number)
=IF(E2<0,-E2,"")Copy the two new columns, paste them as values, delete the original Amount column and save as CSV (comma delimited).
Tips that avoid failed or messy imports
- Date format: pick the same format in the upload screen as the file uses. Our dates are written year-first (YYYY-MM-DD); if your QuickBooks only offers day/month or month/day formats, reformat the column in Excel before saving.
- File size: QuickBooks Online limits the size of an uploaded file (around 350 KB is commonly cited). Split a very long history into several files, for example one per month.
- Duplicates: if the account already has a bank feed, uploading the same dates again creates duplicates. Upload only the period the feed doesn't cover.
- Numbers only: amounts must not contain currency symbols or thousands separators. Our CSV writes plain numbers.
- One account per file: a CSV goes into one QuickBooks bank or credit card account at a time.
QuickBooks Desktop and other formats
Besides CSV, QuickBooks generally accepts bank files in QBO, QFX and OFX format — those come from your bank's own download options, not from a PDF. QuickBooks Desktop handles imports differently from QuickBooks Online and typically expects Web Connect (QBO) files; for Desktop, check Intuit's current help pages or use your accountant's preferred import tool with our Excel or CSV output.
Menu names in QuickBooks change from time to time; if a label above doesn't match your screen, search QuickBooks help for "upload transactions from a file".
Frequently asked questions
Can QuickBooks import a PDF bank statement directly?
No — QuickBooks Online imports CSV (and bank-provided QBO/QFX/OFX files), not PDF. Converting the PDF to CSV first is the standard workaround.
Which CSV format does QuickBooks Online need?
Either 3 columns (Date, Description, Amount with negatives for money out) or 4 columns (Date, Description, Credit, Debit). Our CSV matches the 3-column format out of the box.
Is there a direct QuickBooks integration?
No. You download a CSV and upload it to QuickBooks yourself, which takes about a minute. Developers can automate the conversion step through our REST API.
Why does QuickBooks reject my file?
The usual causes are a date format that doesn't match the one selected, currency symbols or commas inside amounts, extra header or balance rows, or a file that is too large. Fix those and upload again.
Will it work with scanned statements?
Yes. Scanned or photographed PDFs are read with OCR, and every row is still checked against the running balance.
Does it work with old statements a bank feed can't reach?
Yes — that is one of the main uses. Bank feeds often only go back a few months; converting older PDF statements fills the gap.
Is it free?
The first 50 pages each month are free with no credit card. Paid plans start at $25/month for 500 pages.
Related tools and guides
50 pages free every month
Create a free account — no credit card. Need more? See the plans.