Convert bank statements to Excel

What the Excel file looks like

Every bank lays out its statements differently. The Excel file doesn't: you get the same clean columns for every bank, so your formulas, pivot tables and imports keep working.

Dates are date cells and amounts are numbers, not text — so SUM, SUMIF and pivot tables work immediately.

Why a balance check matters

Copying transactions out of a PDF is easy to get almost right: a skipped line at a page break, a debit read as a credit, a smudged digit in a scan. Each of those makes your spreadsheet wrong without telling you.

We check every statement against its own numbers. The opening balance plus everything in, minus everything out, must equal the closing balance, and the running balance must agree on every row. If it doesn't, the rows to look at are highlighted with their page number — and that statement uses no pages.

Common problems when copying a statement into Excel

If you have tried pasting a PDF statement into a spreadsheet, you have probably met at least one of these. Each is handled automatically:

• Descriptions split over two lines — merged back into one cell instead of becoming an extra row.
• Separate Debit and Credit columns — combined into one signed Amount column, so totals are a simple SUM.
• Dates without a year — the year is taken from the statement period, including December–January statements.
• Numbers as text — values like 1.234,56 or (45.00) become real numbers, with the minus sign where it belongs.
• Headers and totals repeated on every page — dropped, so only transactions remain.

The Summary sheet

Next to the transactions you get a Summary sheet with the numbers people usually build by hand:

• Total money in, money out and the net change
• Spending and income by category
• Totals by month, for statements that span several months
• Opening and closing balance for each statement

Combine a whole year into one workbook

Select several statements — twelve months of a checking account, or a checking and a credit card account — and export them together. Transactions are merged in date order into one Excel file, optionally limited to a date range, which is what accountants and mortgage lenders usually ask for.

Works with any bank and any language

There are no bank templates to wait for. Statements from large banks, credit unions, online banks and card issuers all work, in any language. Number formats like 1.234,56 and dates without a year are handled, and a PDF that contains several accounts — for example a local-currency and a EUR account — becomes one statement per account.

If your bank also lets you download CSV or OFX files, upload those instead: they use no pages. See how to convert a bank statement to CSV.

Excel or something else?

Excel is the most flexible choice. If the transactions are going straight into accounting software, export a file made for it instead:

• QuickBooks Online CSV for the bank upload screen
• Xero statement CSV in Xero's precoded format
• A .qbo (Web Connect) file for QuickBooks Desktop, OFX for Wave and Sage, and QIF for Quicken
• CSV for Google Sheets, Numbers and budgeting apps

Questions