How to turn a bank statement into tracked expenses
You can log expenses diligently for a month and still be wrong, because the ones you forget are invisible by definition. Reconciling against your bank statement is how you find them — and it is far less work than people assume.
Why your log is always incomplete
Every manual tracking method leaks in the same places. Cash purchases leave no digital trace. Card charges you made while distracted never got entered. Subscriptions renew silently. Small amounts feel not worth recording, right up until forty of them add up to a real number.
The statement is the ground truth for anything that touched your account. Comparing it against your own records is the only way to separate "I spent less this month" from "I recorded less this month".
Step 1 — export the statement
Nearly every bank offers a download in at least one machine-readable format. In order of how well they work:
| Format | How well it parses | When to use it |
|---|---|---|
| CSV | Best — plain columns, no ambiguity | Default choice if your bank offers it |
| OFX / QFX | Very good — a real banking standard | Common in North America and with older banking software |
| Good — needs text extraction, layouts vary | When CSV is not offered, which is common in Europe | |
| Screenshot or photo | Workable — OCR, least reliable | Last resort, and check the parsed amounts |
Pick a full calendar month if you can. Partial ranges make it harder to tell whether something is missing or simply outside the window.
Step 2 — match it against what you logged
This is the part that used to mean a spreadsheet with two columns and an afternoon. Automated matching compares each statement line to your recorded expenses on three signals: the amount, the date (within a few days, since card charges settle late), and the merchant name — which the bank will often have mangled into something like "SQ *COFFEE 4412 LON".
In Wisspy you upload the file on the reconciliation screen. It parses the statement, proposes a match for each line, and shows you what it could not match. You confirm the matches that look right and correct the ones that do not.
Step 3 — deal with the unmatched lines
Everything left over falls into one of four buckets, and each has a different answer:
- A real purchase you forgot to log. Add it — this is the whole point of the exercise, and the reason your month suddenly balances.
- A subscription you had forgotten you were paying for. Add it, then decide whether to keep it.
- A transfer between your own accounts. Exclude it. It is not spending, and counting it will distort every category.
- Something you do not recognise at all. Do not add it — look it up. Reconciliation is how most people discover an unrecognised charge in the first place.
Adding the missing expenses in bulk rather than one at a time is what keeps this to a few minutes. Once they are in, your categories, budget, and monthly totals are all working from a complete picture for the first time.
Why it is worth doing every month
Monthly is the right cadence. Weekly is more work than it repays; quarterly means reconstructing purchases you no longer remember making. A monthly pass takes a few minutes and keeps every downstream number honest — budgets that assume complete data, subscription detection that needs consistent history, and any figure that claims to tell you what is safe to spend.
Frequently asked questions
What if my statement is a PDF with no CSV option?
PDFs work — the text is extracted and parsed into transactions. Bank PDF layouts vary a lot, so check the first few parsed amounts against the document before confirming everything. If the parse fails outright, most banks will export CSV or OFX somewhere less obvious in the interface.
Does this work with more than one account?
Yes. Each statement is tied to an account, so a current account and a card can be reconciled separately without their transactions being confused for one another. Transfers between the two are excluded rather than counted twice.
Will it catch cash spending?
Not directly — cash leaves your account as a single withdrawal, and the statement cannot know what you did with it. What reconciliation does show is the withdrawal itself, which tells you how much cash to account for. This is exactly why logging cash purchases at the moment you make them matters so much: the statement can never reconstruct them for you.
In short
Export the statement, import it, confirm the matches, and deal with what is left. A few minutes a month converts a hopeful record into a verified one — and every budgeting feature you use afterwards is only as good as that.