# How to Do a Spending Audit With Three Statements

- Author: CheapBankConvert (https://cheapbankconvert.com)
- Published: 2026-10-17
- Category: Cutting costs from your statements
- Canonical: https://cheapbankconvert.com/blog/how-to-do-a-spending-audit

> How to do a spending audit with three months of bank statements: sort every charge, flag what to cut, and total the yearly savings.
To do a spending audit, pull your last three months of bank and card statements, list every charge in one sheet, and mark each one keep, trim or cut. Multiply every cut and trim by its yearly frequency to see what it is worth. Then act on the biggest numbers first, within a week, before the habit returns.

## Which statements does a spending audit need?

A spending audit needs three consecutive months of statements from every account that pays for something: checking, each credit card, and any wallet or store card you spend from. Three months catches charges that bill every month, most that bill every quarter, and enough everyday spending to show a pattern without burying you in rows.

One month misses too much. A quarterly insurance premium, a gym that bills on the 1st of odd months, or a streaming service on a free trial that converted last week can all hide outside a single statement. Twelve months is better evidence, but most people stall halfway through a year of rows. Start with three and widen later if the results surprise you.

Cover every account in the same period. If your card statement closes on the 12th and your checking statement on the 30th, line them up so both cover roughly the same ninety days. A gap of a few days does not matter. A missing month on one account does, because you will undercount whatever that account pays for.

### Getting the rows into one sheet

The audit happens in a spreadsheet, so the rows have to get there. Many banks let you download recent transactions as a CSV file, and that is the cleanest route when the history reaches back far enough. When you only have PDF statements, a converter saves the typing. CheapBankConvert, which is getting ready to open, turns a PDF statement into CSV or Excel at an early price of $2.99 for up to 10 pages, with the first 2 pages shown free. The [CheapBankConvert homepage](/) lists the current prices. If a converter checkout ever shows more than the listed price, [why a PDF converter total includes sales tax](/blog/pdf-converter-sales-tax) explains where the extra comes from.

Give the sheet five columns: date, account, description, amount and label. Keep money out as negative numbers on every account, flipping the sign on card rows if your card statement prints purchases as positive.

## Keep, trim or cut: labelling each charge in a spending audit

Each row in a spending audit gets one of three labels. Keep means the charge is worth what it costs. Trim means you want the thing but at a lower price or lower frequency. Cut means you would not notice it gone. Every row gets a label, and you decide quickly: hesitation usually means trim.

Sort the sheet by description before you start. Repeat merchants line up together, so ten coffee shop visits or three months of the same phone bill become one decision instead of ten. A typical month of 100 to 150 rows often collapses into 30 or 40 distinct merchants, and those are the decisions you are actually making.

Work through the recurring charges first, because they carry the largest yearly weight per decision. A charge that repeats every month is easy to spot once rows are sorted, but some disguise themselves with a different reference number each time. The method in [finding subscriptions on bank statement rows](/blog/find-subscriptions-on-bank-statement) shows how to group those by amount and timing so none slip past.

### What each label means in practice

- **Keep:** rent, the electricity bill, the groceries you actually eat, the one streaming service the whole household watches.
- **Trim:** a phone plan with more data than you use, takeout four nights a week that could be two, a car insurance policy nobody has priced against a competitor in years.
- **Cut:** the app you signed up for during a free trial, the second cloud storage plan, the magazine you have not opened since spring.

Fixed costs such as rent rarely move in an audit, but they still get a label. Writing keep next to them makes the rest of the list honest, because you can see how much of your spending is already decided.

## What does each spending audit cut save in a year?

A spending audit cut saves its charge multiplied by how often it bills. A monthly charge times 12, a weekly habit times 52, a quarterly bill times 4. For a trim, multiply the difference between the old price and the new one. That yearly figure, not the monthly one, is what tells you which cuts deserve your time.

Monthly numbers make small leaks look harmless. A $9.99 subscription reads as pocket change; $119.88 a year reads as a decision. A $6 lunch three times a week feels routine; $936 a year is a plane ticket. Writing the yearly figure next to each flagged row changes which items you take seriously.

Add two columns to the sheet: one for how many times a year the charge repeats, and one for the yearly saving. For a cut, the saving is the full yearly cost. For a trim, write down the realistic lower figure you would accept and save only the difference. Be conservative here. A trim you will actually keep, such as takeout twice a week instead of four times, is worth more than an ambitious cut you abandon in February.

### Frequencies that trip people up

Annual renewals appear once in three months, or not at all, so the audit can miss them. Check your email for renewal receipts from the past year and add those charges by hand. Charges that bill every four weeks repeat 13 times a year, not 12. Variable bills, such as utilities, are better averaged across the three months than read off a single statement.

## A three-statement spending audit, worked through

The example below shows one household's flagged rows after labelling three months of checking and card statements. The merchants and amounts are made up for illustration. Rows labelled keep are left out to keep the table short.

| Charge | Label | Seen in 3 months | Per year | Yearly saving |
| --- | --- | --- | --- | --- |
| Video streaming, second service | Cut | 3 × $15.49 | 12 | $185.88 |
| Fitness app, unused | Cut | 3 × $12.99 | 12 | $155.88 |
| Cloud storage, duplicate plan | Cut | 3 × $2.99 | 12 | $35.88 |
| Phone plan, unlimited data | Trim to $45 | 3 × $70.00 | 12 | $300.00 |
| Weekday lunches out | Trim from 3 to 1 a week | 39 × $13.50 | 52 weeks | $1,404.00 |
| Delivery app membership | Cut | 3 × $9.99 | 12 | $119.88 |
| Car insurance, not shopped since 2022 | Trim after quote | 1 × $612 (6-month premium) | 2 | $240.00 (estimated) |

The total yearly saving comes to $2,441.52. Two rows carry most of it: the lunches and the phone plan. The four cuts together are worth barely more than a third of the lunch trim, even though they felt like the obvious win.

Notice what the table does not include. It has no row for groceries, because the household decided its food shop was reasonable. It has no row for rent. An audit is not a list of everything you could stop doing; it is a list of the charges where the money and the value no longer match.

The lunch line is worth a second look. Thirty-nine lunches over thirteen weeks is three a week. Dropping to one a week removes 26 lunches per quarter, or 104 a year, at $13.50 each. That arithmetic is what turns a vague feeling about eating out into a number you can plan around.

## Spending audit trap: cutting small pleasures and keeping big leaks

The most common spending audit mistake is cutting the small, visible pleasures, such as a weekly coffee, while leaving the large, quiet costs untouched. Insurance, phone and internet plans, and bank fees rarely feel like spending because nobody chose them recently. Those are often the rows where one phone call saves more than a month of skipped lattes.

People reach for small cuts because they are easy to make and easy to feel. Cancelling a $4 coffee feels like discipline. Calling an insurer for a quote feels like a chore. The yearly-saving column exists to correct that instinct. Sort the flagged rows by yearly saving, largest first, and work down from the top.

A second trap is labelling too harshly. If every row you enjoy becomes a cut, the audit turns into a diet, and most people quit diets. Keep the things that matter to you, even if they cost money. The point is to stop paying for what you do not value, not to stop enjoying anything.

### When a spending audit is the wrong tool

An audit looks backward at what already left your account. It will not fix a budget that has no plan for irregular costs, and it cannot tell you whether your income is enough for your fixed bills. If the keep column alone is larger than your take-home pay, the problem is not leaks. It is the size of the fixed costs, and that needs a different conversation, about housing or debt, rather than a list of subscriptions.

## After the spending audit: acting on the list within a week

A spending audit pays only when the cuts happen, so set a deadline of one week for every cut and every trim that needs a phone call. Cancel the subscriptions in one sitting. Book the insurance quotes. Change the phone plan. Then check your next statement to confirm the charges actually stopped.

Cancellation is where many audits leak back. Some services bury the cancel button, some offer a discount to stay, and some keep billing because the cancellation never registered. The steps in [cancelling subscriptions you forgot you were paying for](/blog/cancel-subscriptions-you-forgot) cover how to confirm a cancellation in writing and what to do when a charge keeps coming.

Keep the audit sheet. Next quarter, convert the new statements, paste the rows under the old ones, and compare. You will see whether the cuts held, whether new subscriptions crept in, and whether the trims stuck. A second audit takes half the time of the first, because most merchants already have a label.

### A one-week action checklist

1. Sort flagged rows by yearly saving, largest first.
2. Make the phone calls and quote requests for the top three trims.
3. Cancel every cut subscription in one session, saving each confirmation email.
4. Set a calendar reminder for the next statement date.
5. On that date, search the new statement for each cancelled merchant name.
6. Move the yearly saving you confirmed into savings, or toward a debt, so it does not disappear into everyday spending.