Bank Statement to Excel Converter

Why copy and paste from a PDF fails

Select a table in a PDF bank statement and paste it into Excel, and you usually get one long column of text or a block where each cell contains a whole line. Descriptions that wrap to a second line become separate rows, negative amounts arrive as text with minus signs or brackets, and dates are strings that Excel cannot sort. Fixing that by hand is slower than typing the figures in.

A converter built for statements solves the table problem directly. It finds the header row, recognises which column holds dates, descriptions, debits, credits and balances by the position of the numbers, joins continuation lines onto the transaction they belong to, and writes the result as real cells: dates as dates, amounts as numbers you can sum, pivot or filter.

What the Excel workbook contains

• Transactions sheet. Date, Description, Debit, Credit, Amount and Balance, with a frozen header row, column widths that fit, a date format that matches the statement and a number format with two decimals.
• Summary sheet. Bank, account ending, currency, statement period, opening balance, total money in, total money out, net change, closing balance and the number of transactions, so the totals can be tied back to the statement.
• Numbers, not text. Amounts are stored as numeric values so SUM, SUMIF and pivot tables work immediately. Negative amounts are real negatives.
• Safe text. Descriptions that start with = + - or @ are escaped so a malicious or unlucky merchant name cannot run as a spreadsheet formula.

How to convert a bank statement to Excel

1. Drop the PDF into the converter above. A few pages read in a second or two.
2. Review the preview. Fix a description, delete a page-footer row, or add a missing transaction. The balance banner updates as you edit.
3. Select Excel (.xlsx), choose a date format if you want something other than the statement style, and press Download.
4. Open the file in Excel, Google Sheets, Numbers or LibreOffice. The workbook uses standard features and needs no macros.

Things people do with the Excel file

• Categorise expenses with a lookup table or filters before the data goes into a bookkeeping system.
• Prepare accounts for a tax return by summing money in and out per month with a pivot table.
• Build a cash flow forecast from twelve months of actual transactions.
• Support a loan or visa application where a lender asks for statements in a spreadsheet to run their own analysis.
• Audit and reconcile a client ledger against the bank by sorting both lists by date and amount.
• Merge several months by converting each statement and pasting the sheets into one workbook, since the columns are identical every time.

Making sure the numbers are right

The converter checks its own work. It takes the opening balance printed on the statement, adds every transaction and compares the total with the closing balance. For statements that print a balance on each row it also checks that every balance follows from the previous one. A green banner means the whole table adds up. A red banner shows the difference and highlights the rows that break the running balance, which is almost always a wrapped description, a misread digit or a transaction that was picked up twice.

Because you can edit the table before downloading, you can fix those rows and watch the banner turn green. That is the difference between a spreadsheet you hope is right and one you can prove is right.

Debit and credit columns versus a single amount

Some statements show money out and money in in separate columns, some show one signed amount and a running balance, and credit card statements often show positive charges and negative payments. The converter normalises all of them into one signed amount where negative means money left the account, then writes both the signed Amount column and separate Debit and Credit columns so you can use whichever your workflow prefers. For credit cards the sign convention is explained in the credit card statement to Excel guide.

More converters