How to convert a bank statement PDF to Excel
- Download the statement from your bank's or card's website as a PDF. Add it to the box above; for several months, add them all at once.
- Look at the transactions on the right and the checks on the left. A green tick means the figures agree with the statement's own balances and totals.
- Choose Excel, CSV or QuickBooks CSV, pick one amount column or separate money in and money out columns, and download.
Locked PDFs ask for their password, which is used on your computer only. If a statement prints its dates without a year and shows no year anywhere else, you're asked which year it's from.
How the converter checks its own work
Copying a statement by hand, or with a converter you can't see inside, leaves one question: did every row come across right? This tool answers it with the statement's own numbers:
- Running balance. Where the statement prints a balance after a row, the converter adds up the amounts since the last balance and compares. One misread figure breaks the chain at exactly that row.
- Opening and closing balance. The opening balance plus every transaction should equal the closing balance, for each account and each statement in the PDF. A download that holds several months is split into its monthly statements first, so each is checked against its own figures.
- Printed totals. When the summary box prints total deposits and total withdrawals, the money in and money out found are compared with them.
A row that doesn't add up is highlighted in the preview, and in the Excel file it gets a yellow fill and a note. The workbook also has a Self-check tab listing every check and its result, which is handy to keep with your records or send to whoever reviews the books.
A failed check doesn't always mean the converter is wrong: some statements, especially sample and teaching ones, don't add up in the original. Either way, the flag tells you which rows to compare with the PDF.
A worked example
A business checking statement that prints an ending daily balance on the last row of each day. The statement opens at $3,120.44, and the first few rows read:
march statement.xlsx
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Date | Description | Amount | Balance | Check number |
| 2 | 03/02/2026 | Deposit Made In A Branch/Store | 1,500.00 | ||
| 3 | 03/02/2026 | Square Inc 260302P2 L204400067452 Springfield Hardware Supply Company | 812.35 | 5,432.79 | |
| 4 | 03/03/2026 | Check | -450.00 | 4,982.79 | 1203 |
The two deposits on March 2 share one printed balance: $3,120.44 plus $1,500.00 plus $812.35 is $5,432.79, which matches, so both rows pass. The check on March 3 takes it to $4,982.79, which matches too. Descriptions that wrap onto a second line in the PDF are joined back into one cell. The sample statement in the tool is this one; try it to see every row and check.
Money in, money out and card statements
Every amount comes out signed the same way: money in is positive, money out is negative. Statements show direction in many ways, and the converter reads all of them: separate withdrawal and deposit columns, minus signs, amounts in parentheses, CR and DR, section titles such as “Withdrawals and other subtractions”, and the running balance going up or down.
Prefer two columns? Choose Money in and out and the file gets a Money in column and a Money out column, both positive. Some software expects the opposite signs; Flip the signs turns them around.
On a card statement, the balance is what you owe, so purchases, fees and interest come out as money out, and payments and refunds as money in. The check then works on the owed balance: previous balance, less payments, plus charges, equals the new balance. Loan sections on credit union statements (principal, interest and disbursements) are left out and named, because their balance runs the other way.
Getting the transactions into QuickBooks Online
Choose QuickBooks CSV. The file has exactly three columns, Date, Description and Amount, which is one of the two layouts Intuit lists for uploading bank transactions to QuickBooks Online from a CSV. Then follow Intuit's help article “Manually upload transactions into QuickBooks Online” to upload it to the right account.
Intuit's limit is 1,000 transactions per upload file. A year of a busy account can go over that; split the CSV by rows into parts of 1,000 and upload each part.
What it can't read, and what to do
- Scans and photos. There's no text to read in a picture of a page. Download the PDF from online banking instead.
- Unusual layouts. If a statement's table isn't recognized, the tool says no transactions were found rather than guessing. If a single row is misread, the self-check flags it.
- Your records come first. The converter copies what the statement shows. It doesn't give bookkeeping or tax advice; before you rely on the file for taxes or a loan application, check its totals against the statement.