SimpleFinances
Money Guide

How to Do a Money Audit (With a Template)

Most people are sure they checked their recurring charges recently and only have a few of them — and in the same breath say their money disappears with no explanation. A money audit is how you find the gap between what you believe and what your statements say. Here is the template, the six steps, and a 30-second version if you would rather start small.

Take the free 30-second audit Jump to the template

What is a money audit?

A money audit is a structured comparison between two versions of your finances: the one in your head and the one in your bank and card statements. For each category, you write down what you think the number is, then you pull the real number from 60 to 90 days of statements, and you record the difference. That difference — the gap — is the entire output. Everything that follows (cancelling, renegotiating, moving money into savings) is a decision you make once you can see it.

It helps to be precise about what an audit is not. It is not a budget: a budget is a plan for next month, while an audit is a measurement of the last two or three. It is not a resolution to spend less. And it is not a one-time event; done properly, it is a routine with a date on the calendar for the next one, the way a car gets a service whether or not anything sounds wrong.

The reason a process beats willpower here is that the problem is mostly informational, not motivational. When we talk to people about their money, the same pattern shows up over and over: they believe they reviewed their subscriptions recently, they estimate they have a handful, and later in the same conversation they say their money "disappears" with no explanation they can point to. Both statements are sincere, and both can be true at once, because the guess and the statement were never put side by side. An audit puts them side by side. Nobody needs more discipline to do that; they need a sheet with three columns.

The clearest published example is the subscription category. When C+R Research asked people to estimate their monthly subscription spending, the typical guess was about $86. When actual spending was measured, the figure came in at $219. The finding is the gap between the guess and the measured number, not either figure on its own — and that kind of gap is what an audit exists to find. Subscriptions are simply the category where it has been measured most publicly; the same thing happens, more quietly, in variable spending and in the savings transfers people believe they are making.

The one-sentence version: a money audit replaces the number you would have guessed with the number your statements show, one category at a time, and writes down the difference.

How often should you audit your money?

Quarterly is the sensible default for most people. It is often enough that annual renewals and price increases get caught within a few months of landing, and rare enough that the audit stays a 60- to 90-minute task rather than a chore you start resenting by February.

There are three reasonable departures from that default:

  • Monthly, for a short while, if your first audit turned up a large gap. The second and third passes are where the habit sets, and they are much faster because the template is already filled in and most rows only need updating.
  • After any structural change. A new job, a move, a baby, a partner's finances merged with yours, a large debt paid off. Your fixed-cost base has shifted, which means your mental model is out of date by definition, whatever the calendar says.
  • Annually at minimum. Once a year, ideally the same month each year, is the floor. Below that, the gap tends to grow through annual renewals you agreed to by not cancelling and small price increases you agreed to by not noticing.

Whatever cadence you choose, the audit is not finished until the next date is in your calendar. That is step six below, and it is the step most often skipped — which is why so many people have done exactly one money audit, years ago, and remember it as a clean-up rather than a system.

The money audit template

The template is six rows and three working columns. It fits on one sheet of paper, one tab of a spreadsheet, or one note on your phone. Copy the rows exactly; the columns are the method, and the order of filling them in matters more than the layout.

Fill the "what you think it is" column before you open a single statement. The template only works if the guess is written down first.
Category What you think it is What the statements say The gap
Income Monthly take-home pay, from memory, before checking anything Deposits over 60 to 90 days, divided by the number of months covered Statements minus guess. A negative figure means you earn less than you assumed
Fixed bills Rent or mortgage, utilities, insurance, phone, internet, as you would list them without looking The same items from the statements, plus any bill that was not on your list Statements minus guess, and a note of every bill you forgot to list
Recurring charges and subscriptions How many you have and roughly what they total per month Every charge that repeats on a cycle, monthly or annual, with its date and amount. Annual charges divided by 12 Statements minus guess, in both count and dollars
Debt payments Minimums and any extra payments across every card and loan Payments actually posted, plus interest and fees charged in the period Statements minus guess. Interest and fees usually live here
Variable spending Groceries, dining, transport, shopping, as a rough monthly figure Everything left after the rows above, totaled by month Statements minus guess. Usually the largest gap in dollars
Savings and investing transfers What you believe you set aside each month Transfers actually made to savings, retirement, and brokerage accounts Guess minus statements. A positive figure means you save less than you thought

Two notes on using it. First, the manual way to do this is a spreadsheet, and a spreadsheet works fine: six rows, the three columns above, and a fourth column with a subtraction formula. Add a "decision" column (keep, cut, renegotiate) for step five and a "next audit" cell at the bottom. There is nothing about the method that needs software. The cost of the manual version is not the setup; it is the middle column, where you read 60 to 90 days of statements line by line and sort each charge into a row. Budget an hour for that the first time, and expect it to be the part you are tempted to skip.

Second, the gap column has a sign. For expense rows, "statements minus guess" is positive when you spend more than you thought. For income and savings the sign flips, because the uncomfortable finding there is earning or saving less than you believed. Keep the signs consistent and the bottom of the sheet tells you, in one number, how far your mental model was from reality this quarter.

The money audit process, step by step

Six steps, in order. The first two are collection, the middle two are measurement, and the last two are decisions. If you only have time for half, do the first three and schedule the rest; a half-filled template is far more useful than a blank one.

Step 1: Gather 60 to 90 days of statements

Every checking account, every credit card, and any payment app you actually spend from. Two months is the minimum, because plenty of charges bill every other month or skipped last month for some reason; three months is better, because it catches quarterly ones. Download PDFs or CSVs rather than scrolling in an app — you want to be able to mark lines off as you sort them, and scrolling makes it easy to lose your place and double-count.

Before you open any of them, fill in the "what you think it is" column. This is the single most important instruction in the whole process. Once you have seen the statements you cannot un-see them, and the guess you would have made is gone for good.

Step 2: List every recurring charge, including annual ones

Go line by line and flag anything that repeats. Then, separately, go back through a full 12 months for anything that bills once a year: domain names, cloud storage, memberships, insurance paid annually, software that renewed on a card you rarely check, the app you tried during a holiday. Convert each annual charge to a monthly equivalent by dividing by 12, so it sits fairly next to the monthly ones in the table.

This is the slowest step and the one where the gap most often lives, because a recurring charge is designed to be forgotten — that is what "recurring" means. If you want a dedicated walkthrough of the places these charges hide, How to find forgotten subscriptions covers each one; and if you would rather not do the line-by-line pass by hand, a subscription tracker that reads your statements and surfaces every repeating charge on one screen turns this step from an hour into a glance.

Step 3: Total your fixed costs

Add up fixed bills, recurring charges (with annuals converted to monthly), and minimum debt payments. This is the amount that leaves your accounts each month whether or not you do anything. Divide it by your take-home income and you have your fixed-cost ratio, explained in the calculator section below. Many people have never seen this number, and it explains more about why a month feels tight than any single purchase does. If you want to see how that fixed total compares with a standard needs, wants, and savings split, the 50/30/20 calculator takes your income and shows the reference split beside it.

Step 4: Find the gap

Now fill the "what the statements say" column, row by row, and subtract. Write the gap down even when it is embarrassing, and do not adjust the guess after the fact. The guess was the point: it is a record of what your mental model believed, and the size of the gap in each row tells you where that model needs updating.

A gap near zero in a row is useful news — it means you can spend less attention there next time. A large gap tells you where attention goes. Most people find their big-bill rows accurate to within a few dollars and their recurring and variable rows off by a wide margin, which is why auditing only the big bills, the first mistake in the list further down, finds almost nothing.

Step 5: Decide keep, cut, or renegotiate for each line

Three options only, so there is no "maybe later" pile. Keep means the line earns its place; write nothing more about it. Cut means cancel it today, during the audit, not after — the audit is the only time you will have the full list in front of you, and a cancellation deferred to "this weekend" has a way of surviving until the next audit. Renegotiate is for the lines that respond to a phone call or a competitor's quote: insurance, phone, internet, and some debt rates. Write the date you will make the call next to each one.

For the debt row specifically, the decision is usually not whether to pay but where any extra payment should go. The debt payoff calculator shows how the same extra amount plays out against the highest-rate balance versus the smallest one, so the choice is made with numbers rather than a hunch.

Step 6: Set the next audit date

Put it in the calendar before you close the spreadsheet, with a link or a note pointing to the sheet. Write this quarter's total gap at the bottom so the next audit has a baseline to compare against. The goal, over a few cycles, is a shrinking gap: not zero spending, but a mental model that matches the statements closely enough that the money stops "disappearing."

What a finished audit looks like: one page, six gaps with signs, a short list of cancellations already done, one or two calls with dates next to them, a fixed-cost ratio, and the date of the next audit. If it took much more than 90 minutes, the second one will take less than half that.

What does a financial checkup calculator actually measure?

Search for a financial checkup calculator and you will find a lot of forms that ask for roughly the same inputs and return a score or a grade. The score is less useful than the four ratios underneath it, and once you have done the audit you already hold every input. Here are the formulas, so you can compute them in the same spreadsheet and see what moves them.

Every input comes straight from the completed money audit template above.
Measure Formula What it tells you
Savings rate Monthly savings and investing transfers ÷ monthly take-home income × 100 The share of each month that stays with you
Fixed-cost ratio (Fixed bills + recurring charges + minimum debt payments) ÷ monthly take-home income × 100 How much of the month is spoken for before you decide anything
Debt-to-income Total monthly debt payments ÷ gross monthly income × 100 The measure lenders use; how much of your income services debt
Months of runway Liquid savings ÷ monthly fixed costs How long essentials are covered if income stopped

Savings rate is the one most calculators lead with, and it is the one most distorted by guessing. People report the transfer they set up, not the transfer that actually happened after the month got tight. Use the statements column. If the number is lower than you expected, that gap is the finding — it is not a verdict on you.

Fixed-cost ratio is the number we would put first. It explains the sensation of a month feeling tight even when nothing extravagant happened, because a high fixed ratio leaves a thin slice for everything variable, and any surprise lands on that slice. It is also the ratio the audit changes fastest: every line cut or renegotiated in step five lowers it directly.

Debt-to-income uses gross income rather than take-home, because that is how lenders calculate it. The debt row of the audit gives you the numerator. Each lender publishes its own thresholds, so compare against the one you are actually dealing with rather than a generic target.

Months of runway divides what you could reach within a few days by what you must pay each month. It is why the fixed-cost total in step three matters twice: a lower fixed base means each dollar of savings buys more time. There is no universally right number of months; the useful question is whether the figure matches what you assumed, which brings the exercise back to the gap.

A calculator fed with guesses returns a score for the guess. Most people who feel their checkup score was "fine" entered the number they believed, not the number the statements show. Run the audit first; run the calculator second.

The 30-second version: a free five-question money audit

If the full audit is more than you want to start with today, SimpleFinances has a free five-question version at simplefinances.co/audit. It takes about 30 seconds, asks for no account access, and is deliberately built from the guess column of the template above. The five questions:

  1. What annoys you most about your money? This picks the row to start with. Someone whose answer is "I never know where it goes" begins with variable spending; someone whose answer is "the card balance never moves" begins with debt.
  2. When did you last check every recurring charge? Not the big ones — every one, including annual renewals. The honest answer for most people is "a while ago" or "I am not sure I ever have," and either answer is fine; it sets the baseline.
  3. How many subscriptions do you think you pay for? This is the guess column for the recurring row, written down before anything is checked, exactly as the full template requires.
  4. What would an extra $100 a month go toward? This gives the gap a purpose. A gap with somewhere to go gets closed; a gap that is just a number gets forgotten.
  5. How do you track spending today? A spreadsheet, an app, a bank app, or nothing. The answer says whether the "what the statements say" column will be an hour of reading or something that fills itself.

Questions two and three are the same guess you would write in the template, captured before the statements are opened. That matters because once you have seen every recurring charge you can no longer make an honest guess — so the free audit gets it on record while it is still a guess.

What happens after the five questions

You get a short read on which row of the template is likely to carry the biggest gap for you, and the option to fill in the statements column with SimpleFinances instead of by hand. That part is the Full Financial Review: $49.99, one time. One payment, no subscription, nothing that renews. The five questions are the free part and the review is the paid next step, and we would rather say that plainly. It carries a 30-day money-back guarantee, full refund, no questions asked.

What the review does is fill the middle column of the template. Bank connections are read-only, so nothing can be moved from inside the app; if a bank will not connect, drag and drop a statement instead and it is read the same way. Transactions are categorized automatically into the rows above, every recurring charge is surfaced on one screen with its cycle and amount (including the annual ones step two sends you hunting for), your report is yours to keep, your data can be exported any time, and the review includes 7 days of full Premium access. The decisions in step five are still yours; the app does the reading.

So far, 900+ people have signed up, 140+ bank accounts have been connected, and 35,000+ transactions have been analyzed, covering over $750,000 in customer spending and over $1,000,000 in debt being managed. That is a lot of statements columns filled in that would otherwise have been an hour each in a spreadsheet.

Spreadsheet or app, the method is identical. Guess first, measure second, record the gap, decide per line, schedule the next one. The only difference is who reads the statements.

Common money audit mistakes

Each of these is common precisely because it feels like doing the audit. They are the ways an audit gets completed on paper and finds nothing.

  • Auditing only the big bills. Rent, the car payment, and insurance are the lines you already know to the dollar, which is why they are the ones people check. The gap almost never lives there. It lives in the small repeating lines and the variable row, which is exactly where checking feels least worthwhile.
  • Skipping annual renewals. Sixty to ninety days of statements cannot show a charge that bills in a month you did not pull. If the audit does not include a separate 12-month scan for annual charges, the annual charges are, by construction, not in the audit — and they are the ones most likely to have renewed without a decision.
  • Counting the guess as the number. This takes two forms: writing the guess into the statements column because opening the statements felt tedious, or quietly revising the guess once the statement disagreed so the gap looks smaller. Either way the audit measures nothing. The guess is supposed to be wrong; that is what makes the gap informative.
  • Never scheduling the next one. An audit with no next date is a clean-up, and clean-ups get undone. Renewals keep renewing, prices keep drifting, and the mental model goes back to being a guess within a couple of quarters. The calendar entry is what turns a good afternoon into a system.
  • Deferring the cancellations. A smaller cousin of the mistake above. "Cut" decided during the audit and acted on next weekend often becomes "cut" decided again at the next audit. Cancel while the list is open.

None of these are character flaws. They are the natural shortcuts of a slightly boring task that is easy to declare finished early, and the fix for all of them is the same: a template with the columns in the right order, and a date for the next pass.

Start with the 30-second version

Five questions, about 30 seconds, no account access. You will have the guess column of your own money audit on record and a clear row to start with.

Take the free 30-second audit

Sources

  1. C+R Research, "Subscription Service Statistics and Costs" (survey of 1,000 U.S. consumers, 2022): crresearch.com. Source of the $86 estimated versus $219 measured monthly subscription spending comparison.