Built for bookkeepers and accountants

PDF to Excel for QuickBooks: Convert Bank Statements and Invoices to a QuickBooks Ready CSV

QuickBooks will not read a PDF. It imports CSV, and that is the gap this closes. Upload the statement, get the transaction table back as a spreadsheet with real dates and real numbers, trim it to the columns QuickBooks expects, and upload. Drop a statement on the right to see what comes back.

We produce CSV and XLSX, not QBO files.

The converter is not live yet

We are still building the conversion engine, so we are not accepting files or payments right now. Leave us your address and we will write to you the day it goes live.

Notify me at launch

No charge, no account needed. We only email you once, at launch.

Not accepting files yet. We are finishing the conversion engine.

The short answer

To get a PDF bank statement into QuickBooks, convert it to CSV first, because QuickBooks Online accepts CSV, QBO, QFX, and OFX files but never a PDF. Convert the statement here, then arrange the sheet as either three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit), strip currency symbols and thousands separators from the amounts, and upload it under Transactions and then Bank transactions. If the bank still offers a direct connection or its own CSV download, use that instead. This route is for the statements where neither is available: closed accounts, prior periods beyond the download window, a client's other bank, or a paper statement that only exists as a scan.

Last updated August 2026

CSV

What QuickBooks reads

3 or 4

Columns it expects

Scans

Read with OCR

Batch

A year at a time

The format QuickBooks actually expects

Most failed imports are not a conversion problem, they are a formatting problem. QuickBooks Online takes a narrow CSV layout and rejects almost anything else, so the fix is nearly always in the spreadsheet rather than in the upload.

1.Three columns or four. Either Date, Description, Amount, or Date, Description, Credit, Debit. Nothing else in the sheet, and no extra columns left over from the statement.
2.Plain numbers only. An amount written as $1,250.00 will fail. It has to read 1250.00, with no currency symbol and no thousands separator.
3.One consistent date format down the whole column. Mixed formats in one file are a common cause of a rejected upload or a year that maps wrong.
4.Ordinary header names. Date, Description, Amount, Credit, Debit map cleanly. Abbreviations the statement used, like Txn Dt, usually do not.
5.Nothing above the header row. Delete the bank's letterhead, account summary, and page footers. QuickBooks expects the header on the first row.

QuickBooks also caps how large an uploaded file can be, so a long statement or a full year in one sheet may need splitting into a few uploads. Intuit's own help article carries the current limit, and it is worth checking there rather than trusting any third party page, including this one.

statement.csv, ready to upload

Date	Description	Credit	Debit
07/01/2026	Deposit, client ACH	4820.00
07/03/2026	Verizon Wireless		184.22
07/08/2026	Office rent, July		2400.00
07/15/2026	Payroll, Gusto		9317.65
07/22/2026	Card settlement	2960.40

No dollar signs, no commas inside the numbers, one date format throughout, and the header on row one. That is the whole specification. Getting the statement to this shape is the part that takes an hour by hand and seconds by conversion.

Documents QuickBooks users convert most

Bank feeds cover the routine month. These are the documents that arrive as PDFs and have to be handled some other way.

Document	What comes back	Why the feed does not cover it
Bank statements	Date, description, debit and credit columns, one row per transaction	Catch up work older than the download window, or a closed account
Credit card statements	Transaction rows plus merchant detail, with charges and payments separated	Cards a client never connected, or a card closed mid year
Vendor invoices and bills	Line items, quantities, unit prices, and totals	Bills arrive by email as PDFs and never touch a bank feed
Merchant and payout statements	Gross sales, fees, refunds, and the net deposit per payout	The feed shows one net deposit; the fee split lives in the PDF
Payroll registers	Employee, gross, taxes, deductions, and net by pay period	Needed to split a single payroll withdrawal into real accounts
Prior accountant reports	Trial balance, general ledger, and P&L as rows you can compare	Opening balances on a new client usually arrive as a PDF pack
Loan and amortization schedules	Payment, principal, interest, and remaining balance by period	The feed shows one payment; the principal and interest split does not

Statement types have their own pages if you want the detail: the bank statement converter, the credit card statement converter, the invoice converter, the general ledger converter, and the trial balance converter.

What decides whether the import goes smoothly

The details that separate a clean upload from an afternoon of fixing a spreadsheet cell by cell.

Amounts come back as numbers

Not text that looks like numbers. This matters twice over here: a text column will not total for your reconciliation check, and it carries the currency symbol that makes QuickBooks reject the row. See the fix for converting text to numbers if any tool gets it wrong.

Debits and credits stay apart

Statements print withdrawals and deposits in separate columns, and that separation has to survive the conversion. When it collapses into one column you lose the sign on every transaction, which turns a reconciliation into guesswork.

Dates stay dates

A date column that arrives as text sorts alphabetically, so July lands next to January. Fix it before the upload, not after, because a wrong year on imported transactions is tedious to unwind. The date format guide covers the repair.

OCR for scanned statements

Older statements, anything a client photographed, and paper files scanned to PDF arrive as images with no text to select. Built in OCR reads them. See the OCR PDF to Excel converter.

Twelve months in one pass

Catch up bookkeeping means a year of statements at once, not one file at a time through a web form. Upload the folder and take the spreadsheets back together with the batch converter.

Multi page statements stay one sheet

A statement whose transaction table runs across nine pages comes back as one continuous list, not nine blocks with the bank's header repeated in the middle of your data every time the page turned.

From PDF to posted transactions

Four steps, and only the third one needs any judgment.

Convert the statement

Upload the PDF at the top of this page and download CSV. Scanned statements go through the same way, since OCR runs automatically when there is no selectable text.

Trim to three or four columns

Delete the letterhead rows, the running balance column, and anything else the statement carried. Keep Date, Description, and either Amount or the Credit and Debit pair.

Tie out the totals

Sum the credits and debits and check them against the statement's printed totals before you upload. Thirty seconds here saves untangling a bad import later.

Upload and map

In QuickBooks Online go to Transactions, then Bank transactions, and upload the file. Map your columns to the fields it asks for, pick the account, and review before you accept.

The step by step version with the screens and the errors people hit is in the guide to importing bank transactions into QuickBooks Online.

Who uses this

Mostly people who bill by the hour and would rather not spend those hours retyping a statement.

Catch up bookkeepers

A new client hands over eighteen months of PDFs and no bank connection. This is the single most common reason people land on this page. More at PDF to Excel for bookkeepers.

Accounting firms

Cleanup engagements, prior period corrections, and opening balances from another firm's PDF report pack. See PDF to Excel for accountants.

Small business owners

One bank the feed will not connect to, or a card that closed before anyone thought about the books. One statement, converted, uploaded, done.

Controllers and finance teams

Reconciling merchant payouts and payroll registers against what the feed posted as a single line. See PDF to Excel for finance teams.

QuickBooks questions

Not directly. QuickBooks Online accepts CSV, QBO, QFX, and OFX files for bank transactions, and a PDF is none of those. You convert the statement to CSV first, arrange it as three or four columns, then upload it. The PDF itself is only ever a source document, and it is worth keeping the original alongside the books as support for what you imported.

No. We output XLSX and CSV, and we would rather say so plainly than let you find out after signing up. CSV is a fully supported import format for QuickBooks Online bank transactions, so for most people it is all you need. If your specific workflow requires a QBO, QFX, or OFX file, for instance because you are on a QuickBooks Desktop version that expects one, you need a converter built for that format instead of this one.

Nearly always one of five things: an amount that still carries a dollar sign or a comma, more columns than the three or four QuickBooks allows, the bank's letterhead sitting above the header row, mixed date formats down the column, or a file over the upload size limit. Work through them in that order. The amount formatting catches the most people, because a column can look perfectly clean on screen and still contain the symbol.

Yes, whenever you can. A live bank connection is less work than any conversion and it keeps running by itself. This page exists for the cases where that option is not on the table: transactions older than the ninety days or so most connections backfill, an account that has since closed, a bank or card the connection does not support, a client who will not share credentials, and paper statements that only exist as scans. Use the feed for the current month and conversion for the history.

Convert all twelve PDFs in one batch, then stack the monthly sheets into a single CSV sorted by date before you upload. Keep an eye on the file size limit, since a busy account's full year can exceed it and will need splitting into two or three uploads. Import them in date order, and reconcile each month as it lands rather than all twelve at the end, because an error found in January is a five minute fix and the same error found in December is not.

It is more accurate than retyping, and unlike retyping it comes with a built in check. Total the credits and debits in the converted sheet and compare them to the totals printed on the statement. If they match, every transaction came across. If they do not, you know before the data reaches QuickBooks rather than during a reconciliation three weeks later. Do that check on every statement and treat the PDF as the document of record.

Not while it is locked, and we do not remove passwords. Banks often protect statement PDFs with the account holder's date of birth or the last four digits of an account number. Open the file with that password, save an unlocked copy, and convert that. Our guide to converting a password protected PDF to Excel explains why no legitimate tool can skip that step.

Built for other teams too

Audiences

Get the statement into QuickBooks

Drop a PDF statement at the top of the page and download a CSV you can shape for import in a minute. For everyday work start with the PDF to Excel converter, or go straight to PDF to CSV.

Convert a Statement View Pricing