Twelve months of statements will tell you what budgets won't
One weekend, one spreadsheet, and an honest look at where your money goes. Most leaks are small, and they add up to thousands.

Quick answer: Download twelve months of every account, sort by merchant instead of category, and total what each one cost you for the year. Then add up the irregular bills and divide by twelve. That number, not your guess, is what your life costs. This is general education, not financial advice.
Your budget is what you hoped would happen. Your statements are what did.
A month of data lies to you. December has Christmas, and August has the car registration. The annual insurance premium lands in March and the vet bill in June. Look at one month and you'll call it normal. Look at twelve and you'll see the whole machine.
Gather everything
Log into every checking account, savings account, credit card and payment app you use. That includes Venmo, Cash App and PayPal, which people forget because the money feels like it's passing through. Download each as a CSV file. Most banks let you pull at least twelve months. If one gives you only ninety days of CSV, grab the older months as PDFs and type in the totals that matter.
Budget an hour for this part. It's tedious. Do it anyway.
Put everything into one spreadsheet with three columns: date, merchant, amount. Delete transfers between your own accounts, or you'll count the same dollar twice. Credit card payments from checking are transfers too. The purchases on the card are the real spending.
Sort by merchant, not by category
Your bank's category labels are guesses. "Shopping" can mean a work boot or a fourth phone charger. Ignore them.
Sort by merchant and total each one for the year. Then look at the top fifteen. For most households that list is boring and a little painful: the mortgage or rent, the grocery store, the gas station, the power company, the insurance company, and then two or three names that surprise you.
Two merchants need splitting. Amazon and Walmart aren't one thing. Open your Amazon order history, export or skim it, and tag what you actually bought. Often a third of it is stuff you can't name now.
Do the same with the drive-through. Say you spend $6 on a coffee four mornings a week. That's $24 a week, $1,248 a year. A $9 lunch on 250 workdays is $2,250. Those are examples, so plug in your own figures. The point is that nobody feels $6. Everybody feels $1,248.
Sort every line into one of three buckets
Add a fourth column and label each line:
- Fixed. Rent or mortgage, insurance, utilities, loan payments, phone. They come every month and you can't change them without a phone call or a move.
- Irregular. Car registration, property tax, repairs, medical bills, vet bills, birthdays, holidays, the annual subscription you forgot. They aren't monthly, but they're certain.
- Drift. Everything chosen in small moments. Food out, impulse buys, apps, gas-station snacks, the extra cable tier.
Irregular is where budgets die. Total that bucket for the year and divide by twelve. Say it comes to $5,400. That's $450 a month your budget never mentioned, and it's the reason you felt broke in months when nothing seemed wrong. Set that $450 aside every month in its own savings account, and the "surprise" bills stop being surprises. This isn't the same job as an emergency fund, which covers what you can't predict. This covers what you can.
Hunt the repeating charges
Search the sheet for the same amount appearing month after month. Streaming services, cloud storage, app subscriptions, a gym you drove to in January, a free trial that wasn't. Then look for the once-a-year charges: $79.99 in October from a company you don't recognize is how annual renewals hide.
Multiply each monthly charge by twelve. A $14.99 service costs $179.88 a year. Ask the only question that matters: if this were a $180 bill sitting on the counter, would you pay it? If yes, keep it without guilt. If you hesitate, cancel it today, while the page is open.
Check the cash lines too. ATM withdrawals with no story attached are a hole in the audit. You don't have to account for every dollar. You do have to know whether it's $40 a month or $400.
Find your real number
Add all twelve months of spending and divide by twelve. Compare that to your monthly take-home pay, not your gross. If the two numbers are fuzzy, read your payslip first so you know what actually lands in the account.
Three outcomes are possible.
You spend less than you take home. Good. Now find out where the difference went, because "left over" that never shows up in savings usually leaked into the drift bucket.
You spend about what you take home. You have no margin, and one bad month becomes a credit card balance.
You spend more. The gap is on a card or coming out of savings. That's the one to fix first, and if there's debt in the picture, the order matters. The arithmetic on paying it off is worth ten minutes.
Pick three cuts and one raise
Don't try to fix everything. People who slash twelve categories at once quit by February.
Pick the three biggest leaks you wouldn't miss. Cancel or cap them. Then pick one thing you value and fund it deliberately. If dinner out with your wife on Friday is what holds the week together, that's not a leak. That's a good use of money. Put it in the budget with a number on it and enjoy it without a side of guilt.
The aim isn't to spend as little as possible. It's to have your money go where you decided it should.
If you're married, do this together
Don't run the audit on your spouse. Sit down, put the numbers on the table, and treat them as the household's numbers, not as evidence. Nobody opens the statement hoping to be ambushed.
And hold your own line. If the statements show you've been handing out money you can't spare, whether it's an adult relative, a friend who never repays or a cause that eats your margin, set a limit and keep to it. Generosity is good. A hole in the family budget isn't generosity. It's a failure to look after your own.
Keep it going
Put a thirty-minute appointment on the calendar once a quarter and look at the top fifteen merchants again. New ones show up. Old ones creep up. If a lump sum arrives, a bonus or a refund, decide where it goes before it dissolves into the drift.
For specifics, like tax effects or what to do with a surplus, talk to a CPA or a fee-only financial planner. This piece can show you where the money goes. They can tell you what to do about your situation.
Block out Saturday morning. The statements are already written. All you have to do is read them.
Ray Okonkwo
Money & Business
Former commercial banker turned small-business owner. Covers salary, credit, margins and the arithmetic nobody does before signing.
Watch
Watch how it's done
Picked for this article.
From channels we rate. Plays on YouTube.
Excel Campus - Jon
How To Analyze Bank Statements Fast With Pivot Tables - Calculated Fields, Custom Form
Mikael @ Scaleability
How to make sense of your bank statement - Categorise your transactions in google sheets!
Read next
