Article
Reading a statement without a spreadsheet
You do not need to build a spreadsheet to see where your money goes. You need one month of transactions, in a format your computer can read, sorted into a handful of buckets.
Getting a clean export
Most banks hide the export behind the account view rather than the statements page. Sign in on a computer, open the checking account, and look for Download, Export, or an arrow icon near the transaction list. Choose CSV if it is offered — it is plain text, and it reads far more reliably than a PDF designed for printing.
- Pick a full calendar month, not the last 30 days, so nothing is counted twice.
- Export checking and credit cards separately, then upload both.
- If only PDF is available, choose the plain transaction statement rather than a scanned or image-based copy. Scanned pages have no text to read.
What the columns mean
| Column | What to do with it |
|---|---|
| Date | Posting date. Fine for budgeting; it can lag the purchase by a day or two. |
| Description | The merchant string. Messy, but it is what categorization keys off. |
| Amount | One signed column, or two columns for debit and credit. Money out is what you want. |
| Balance | Running total. Ignore it — it is not spending. |
Two traps account for most bad numbers. The first is a credit card payment: a single large transfer that hides a whole month of spending behind it, which is why uploading the card statement alongside it matters. The second is annual bills — insurance, tuition, property tax — entered as if they were monthly. Divide those by twelve.
Sorting a month by hand
Sort the file by amount, largest first, and label from the top down. The twenty biggest lines usually cover most of the month. Group them as housing, transportation, utilities, food, health, debt payments, and everything else — that is enough detail to see whether basic needs are above or below half your income.
Or let the tool read it
Upload a statement and it is read in your browser and sorted for you. Nothing is sent anywhere.
Educational only. Not financial, tax, or legal advice.