Back to converter
Notes on
Blog
Notes on
statements.
How bank statements are laid out, what their codes mean, and how to get one into a spreadsheet whose balances add up.
The short codes UK banks print beside each transaction, what each one means, and where they land when the statement becomes a spreadsheet.
Copying and pasting, Excel's own PDF import, and a converter built for statements. What each one gets right, and how to check the result.
Each balance should equal the one before it, plus money in, minus money out. Why converted statements break that rule, and how to find the row.