Convert Bank Statement to CSV for QuickBooks from PDF Statements
StatementsConverter turns PDF, scanned and photographed bank statements into a CSV that QuickBooks Online accepts on the first upload, in the 3 column or 4 column layout its Banking screen maps. Every statement is balance checked before the file is written, so you import a complete period instead of finding a missing row at reconciliation. CSV export is on every plan.
Choose a statement file first, or use our sample statement.
This file is larger than 10 MB. Split the statement or upload fewer pages.
This file type is not supported. Upload a PDF, JPG or PNG statement.
We could not read this statement. Try a sharper scan or the original PDF from the bank.
No transactions were found on these pages. Check that the file is a bank or credit card statement.
You have used today's sample conversion. Create your account to keep converting statements.
Something went wrong on our side. Try again in a moment. If it keeps happening, write to support@statementsconverter.com.
No card needed for the sample. Demo files are deleted right after conversion.
Converting your statement
- Reading pages
- Finding the transaction table
- Extracting rows
- Checking balances
The short answer for QuickBooks users
To convert a PDF bank statement to CSV for QuickBooks, upload the statement, confirm the balance check passes, then export a CSV with Date, Description and Amount (or Date, Description, Credit and Debit) in one date format. Upload that file under Banking in QuickBooks Online and map the columns. QuickBooks Desktop needs a QBO file instead of a plain CSV.
Most failed CSV uploads come down to four things: mixed date formats, withdrawals with the wrong sign, an extra running balance column, or a file that is too big. The converter handles all four through a saved preset, so the second client statement takes the same two clicks as the first.
3 column vs 4 column CSV for QuickBooks Online
QuickBooks Online reads two bank CSV layouts. Both import the same transactions. The difference is how money in and money out are written, and which one matches the habits of the person reviewing the file.
| Layout | Columns | How amounts are written | Pick it when |
|---|---|---|---|
| 3 column | Date, Description, Amount | Deposits positive, withdrawals negative in one column | You want the simplest mapping and fewest import questions |
| 4 column | Date, Description, Credit, Debit | Money in under Credit, money out under Debit, both positive | Your reviewers read statements the way the bank prints them |
The converter saves either layout as a preset per client workspace, with the date format, delimiter and header setting attached. Need other columns for analysis instead of import? The general bank statement to CSV export adds running balance, payee, category and account columns.
How to convert a PDF bank statement to CSV for QuickBooks
- Upload the statement. Downloaded PDFs, scanned PDFs and JPG or PNG phone photos all work, one file or a batch of client statements at once.
- Review the extracted table in your browser. Wrapped descriptions that the bank printed over two or three lines are already merged into one row.
- Clear the balance check. If a page does not tie out, the app points to the page and the row range, and you fix the row before export.
- Choose CSV with a 3 column or 4 column QuickBooks layout, with dates as MM/DD/YYYY.
- In QuickBooks Online, open Banking, choose Upload from file, pick the bank account, then map Date, Description and Amount (or Credit and Debit).
- Review the transactions in the For Review tab, match or add them, then reconcile against the same statement.
The QuickBooks Online import guide walks through the upload screen field by field if a client file is your first one.
Why the balance check matters before a QuickBooks upload
A CSV carries no totals. Once QuickBooks has the rows, a dropped transaction looks exactly like a month with one fewer purchase, and you only find it when the reconciliation is off by an odd amount.
That is why the check runs before export. Opening balance plus credits minus debits has to equal the closing balance the bank printed, for each statement and each page.
When a scan smudges a single amount, the failing page and rows are flagged in the editor. You correct the figure against the original and the check passes before any file leaves the app.
The export screen lists every statement in the batch with its result, so a 12 month catch-up for a new client ties out before you open QuickBooks.
Common QuickBooks CSV import errors and fixes
Intuit's community guidance points to the same handful of causes again and again. Here is what each looks like and how the export settings prevent it.
| What QuickBooks shows | Usual cause | Fix in the export |
|---|---|---|
| Dates rejected or shifted to the wrong month | Mixed or regional date formats in one file | Pick one format, MM/DD/YYYY for US accounts, applied to every row |
| Deposits imported as spending | Withdrawals written as positive numbers in a 3 column file | Use the signed amount style, or switch to the 4 column layout |
| File will not upload | File over the size limit Intuit moderators cite (350 KB, about 1,000 rows) | Export one CSV per statement instead of one merged file per account |
| First row imported as a transaction | Header handling mismatch | Turn the header row on and tell QuickBooks the file has one |
| Mapping screen shows extra columns | Running balance or reference columns included | Leave them out of your saved QuickBooks preset |
| Same transactions twice | The same period uploaded again | Upload each statement once and check the For Review tab dates first |
If an upload still fails after these fixes, the QuickBooks users workflow covers when to switch to a QBO file instead.
QuickBooks Desktop needs a QBO file
QuickBooks Desktop does not import a plain bank CSV into its Bank Feeds center without a third party add-on. For Desktop clients, export a Web Connect file from the PDF to QBO converter instead. Each row carries a stable unique FITID, so exporting the same statement again does not duplicate transactions that are already in the register.
QBO also works in QuickBooks Online and skips the column mapping step entirely. CSV stays the better choice when you want to edit rows in a spreadsheet first, or when you are on a plan without QBO export.
Who converts statements to CSV for QuickBooks
- Bookkeepers catching up a new client whose bank feed only reaches back 90 days and the rest of the year exists as PDFs.
- QuickBooks ProAdvisors cleaning up a file before tax season, working from statements a client emailed as scans.
- Small business owners whose bank connection broke and who need last quarter in the books before a loan application.
- Accounting firms that keep one saved CSV preset per client so every month imports the same way.
Comparing tools for this job? The best PDF to QBO converter roundup lists the tests worth running on any converter, CSV or QBO.
CSV export on every plan
CSV and Excel exports come with Starter at 49 USD a month, or 24 USD a month billed yearly, with 400 pages a month, batches of up to 20 files and the balance check.
Professional at 149 USD a month, or 74 USD a month billed yearly, adds QBO, QIF, OFX and Xero files, client workspaces with saved presets, categorization rules, 1,500 pages and 3 seats. Business adds batches of up to 200 files, 15 seats with roles and the API. See every limit on the pricing page.
Files are encrypted in transit and at rest, deleted after 24 hours by default and never used to train models.
How do I convert a PDF bank statement to CSV for QuickBooks
Upload the PDF to StatementsConverter, check that the statement balances, and export CSV in a 3 or 4 column QuickBooks layout. Then upload the file in QuickBooks Online under Banking and map the date, description and amount columns. Scanned PDFs and phone photos convert the same way.
What CSV format does QuickBooks Online accept
QuickBooks Online accepts a 3 column CSV with Date, Description and Amount, or a 4 column CSV with Date, Description, Credit and Debit. Use one date format for every row, keep withdrawals negative in the 3 column layout, and remove extra columns such as running balance before you upload.
Can I import a CSV bank statement into QuickBooks Desktop
Not directly. QuickBooks Desktop does not read a plain bank CSV into its Bank Feeds center without an add-on. Export a QBO Web Connect file instead, which Desktop imports natively. StatementsConverter creates QBO files from Professional, with a stable transaction ID on each row to prevent duplicates.
Why is QuickBooks not accepting my CSV file
The usual causes are mixed date formats, a file over the size limit Intuit moderators cite (350 KB or about 1,000 rows), extra columns, or a header row QuickBooks does not expect. Export one statement per file, use one date format and stick to the 3 or 4 column layout.
Should I use CSV or QBO for QuickBooks
Use QBO when you want the fastest import with no column mapping, or when the client is on QuickBooks Desktop. Use CSV when you want to edit rows in a spreadsheet before importing, or your plan includes only CSV and Excel. Both formats come from the same balance checked extraction.
Can I convert scanned bank statements to CSV
Yes. StatementsConverter reads scanned PDFs and JPG or PNG phone photos on every plan and applies the same balance check used for downloaded PDFs. Any page that does not tie out is flagged with its row range, so you can correct a faint amount before the CSV goes into QuickBooks.
Get your next client statement into QuickBooks today
Upload one statement, check the balance and download a CSV that maps on the first try.