Skip to content
GuideEvergreen guide

Guess where your money went, then check the statements

Most people can't name their three biggest expenses. One Saturday with twelve months of statements shows you the gap between what you think and what's true.

By Ray Okonkwo · Money & Business5 min read
Guess where your money went, then check the statements

Quick answer: Write down what you think you spend in each category. Then add up twelve months of actual statements and compare. The gap is the whole exercise. Set aside three hours and don't skip the guessing step.

Take an index card before you open a single statement. Write down nine categories: housing, groceries, eating out, transportation, insurance and medical, kids and family, giving, savings, and everything else. Next to each, write a monthly number from memory. No peeking.

Now put the card face down. You'll need it later.

Pull twelve months, not three

Three months lies to you. It misses the car registration, the semiannual insurance bill, the vet, the December spending, the week the water heater quit. Download twelve months of statements from every checking account and every card. Most banks let you export a CSV. If yours doesn't, the PDFs work, just slower.

Open a spreadsheet. One column for date, one for the merchant, one for the amount, one for the category. Sort every line. Yes, every line. It's tedious. A budgeting app can pre-sort for you, but it will miscategorize things, so skim its work instead of trusting it.

Two rules keep the numbers honest:

  • Count what you paid, not what you meant to pay. The gym membership you meant to cancel is a gym expense.
  • Don't count transfers between your own accounts. Moving $500 to savings isn't spending, but it's worth its own line.

If you're married, do this with your wife, at the same table, with the same rule: numbers, not verdicts. Nobody's on trial. Whoever normally handles the money doesn't get to run the audit alone, and whoever doesn't handle it doesn't get to be surprised and angry. You're on the same side of the spreadsheet.

Flip the card

Add up each category, divide by twelve, and set it next to your guess.

Say you guessed $400 a month on eating out and the statements say $710. That's $310 a month. Over a year, $3,720. That's an example, not anybody's data, but it's the shape these gaps usually take. People tend to underestimate the small, frequent, easy-to-forget spending and overestimate the big, painful, memorable stuff. The mortgage payment you know to the dollar. The forty visits to the drive-through you don't.

Any category off by more than about a quarter deserves a closer look. That's a rule of thumb, not a law, but it gets you to the right rows quickly.

The three places the leaks hide

Recurring charges. Sort by merchant and look for anything that shows up every month or every year. A streaming service at $14.99 a month costs $179.88 a year. Five forgotten subscriptions run close to $900. You don't have to cancel them all. You do have to decide, on purpose, that each one's worth it. Free trials that quietly turned into paid plans are the usual culprits.

The "everything else" bucket. If it's your largest category, your audit isn't done. Open it and sort again. Cash withdrawals with no trail, big-box store runs that mix groceries with a patio chair and a phone charger, and online orders are where money goes to disappear. Split the receipts mentally: what was food, what was a want, what was a need.

Small daily purchases. Arithmetic helps here. If you buy lunch out most workdays at $11, multiply by roughly 250 workdays. That's $2,750 a year. Maybe it's worth it. A hot lunch with your crew can be good for morale and relationships. But you should be choosing it, not discovering it.

Find the annual hits

This is the part that wrecks monthly budgets. Scroll your twelve months for the bills that come once or twice a year: property tax, car registration, insurance premiums paid in a lump, Christmas, birthdays, back-to-school, vet visits, the annual membership renewals.

Add them up and divide by twelve. If they total $3,600, you need to be setting aside $300 a month for them whether or not a bill is due. Open a separate savings account, name it "annual bills," and automate the transfer. When the registration comes due, it's already paid. No credit card, no scramble.

Same goes for repairs. Your car payment isn't the price of owning the car, and the audit will show you the rest of it: tires, brakes, insurance, fuel. Put them next to each other for once.

Make one or two changes, not ten

Here's where people overdo it. They see a column of red, declare a new era, and cancel everything. By February they've burned out and gone back to the old habits, plus a little rebellion.

Pick the biggest gap and the easiest fix. Two changes are plenty. Cancel the subscriptions you didn't know you had. Cap eating out at a number you set in advance, and take the cash for it out of the account on the first of the month. Whatever you free up goes somewhere with a job: an emergency fund that works as insurance, the debt with the highest interest rate, or the annual bills account.

Be careful about what you cut. A family dinner out once a week might be the best money you spend. Your kid's baseball season isn't a leak. The audit exists to find money that's going nowhere, not to turn you into a man who can't enjoy a Friday night or take his wife on a date. Cut what you won't miss and protect what holds the family together.

And watch for the other kind of leak: spending to keep up. The boat your brother-in-law bought, the vacation the neighbors took, the kitchen your coworker redid. Saying no to them is a line item too, and it's usually the highest-return one. You can be generous and still keep the line. Help the people who need it and don't fund anybody's image.

Start from take-home pay

Do your math against what actually lands in your account, not your salary. If you're unsure why the two numbers differ, your payslip explains where the money went before you ever saw it. Budgeting from gross pay is how you end up "short" every month on money that never arrived.

The honest limits

An audit tells you what happened, not what's coming. A job change, a baby, or a move will change the numbers, and the audit will need redoing. Cash spending is hard to reconstruct, and some of it will always be a guess. And a spreadsheet can't tell you whether a purchase was wise, only that it occurred.

This is general education, not personal financial advice. If your situation is complicated, with a business, rental property, or a tangle of debt, a CPA or a fee-only financial planner can look at your actual numbers in a way an article can't.

Put the index card in the folder with the statements and write the date on it. Next January, write a fresh guess before you open anything. If the gap has shrunk, you've learned something about your own money, and that's worth more than any app.

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.

Money with Dan

How to open BANK Statement CSV file in EXCEL #1

MyOnlineTrainingHub

Excel Personal Finance Tracker 101 | Build & Automate Yours in Minutes