Bank statement to Excel
An .xlsx file with a frozen header, a filter on every column, and any row that failed the balance check highlighted.
Columns: Date, Description, Amount, Balance
No statement handy? or open the finished Excel
What goes wrong
Dates that are text, not dates
Most converters write the date as a string. It looks correct in the cell and then quietly breaks everything downstream: sorting puts 10 January before 2 January, month grouping in a pivot table returns one row per day, and any DATE or EOMONTH formula returns an error. Our file writes real date values, built in UTC so that a midnight timestamp does not slide into the previous day for anyone west of London.
Getting the file into Excel
- 1Drop the PDF into the converter above. The first three pages convert without an account.
- 2Look at the preview. Rows where the running balance does not reconcile are flagged there before you download anything.
- 3Press Excel. The file downloads with the header frozen and a filter already applied.
- 4Open it and sort or filter as usual — the dates behave as dates.
Excel questions
Will the amounts be numbers or text?+
Numbers, formatted to two decimals, with the sign carried from the statement — money out is negative. You can sum a column straight away without cleaning anything.
Does it open in Numbers or LibreOffice?+
Yes. The file is a standard .xlsx with no macros and no external links, so anything that reads Excel reads it, including Numbers on a Mac and LibreOffice Calc.
What happens to a row that does not add up?+
It is highlighted in the sheet and counted in the preview. The balance check recomputes the running total at every line against the balance the bank printed, so a misread digit is marked rather than hidden.