Blog
Track your household like a small economy with a spending shifts worksheet
Compare this quarter's card and bank spending with the same quarter last year, category by category, to see which prices or habits actually moved your budget.
Governments and economists track a country by comparing this period with the same period a year ago, split by category: food, housing, transport, energy. You can do the same thing for your own household in an evening, with nothing more than your card statements and a pencil. The result is a one-page answer to a question most budgets never ask: of the extra money that went out this year, how much was higher prices, how much was changed habits, and how much was the cost of carrying debt?
This worksheet walks through the method with a fully worked, labeled example and then leaves a blank version for your own numbers. Everything in the example is invented for illustration; none of it is a statistic.
What you need before you start
Gather four things. The whole exercise takes about an hour the first time and about 20 minutes after that.
- Card statements for the last three months and for the same three months of last year. Most issuers keep 12 to 24 months of statements online, and many apps let you download a spreadsheet of transactions.
- Bank statements for the same two periods, because rent, utilities, insurance and a lot of other spending do not go through a card. A comparison that only covers card purchases will miss them.
- A few receipts or order histories for items you buy the same way each time, for the price check in step 5.
- A pencil, a calculator and the table below, or a spreadsheet if you prefer.
If you cannot find last year's records, start with what you have. Even a comparison of this quarter with last quarter is useful, as long as you remember that seasonal spending (heating, holidays, back-to-school) distorts it. A same-quarter, year-over-year comparison avoids that problem, which is why it is the default.
Step 1: Choose the two periods
Pick a recent quarter, which is three months, and its twin from a year ago. Using a quarter rather than a month smooths out one-off events such as a car repair or a long weekend away.
Then decide how you will treat dates. A card statement covers a billing cycle, and the cycle rarely lines up with the calendar. If your statement closes on the 12th, a purchase on the 5th of the month lands in one statement and a purchase on the 20th lands in the next. For this worksheet, use transaction dates, not statement totals, if your app lets you sort by date. If it does not, use whole statements for both years and accept a small mismatch. What matters is that the two periods are built the same way, so that you compare like with like. why your card budget should follow the statement cycle, not the calendar explains how to arrange a budget around the statement cycle if you want to keep doing this regularly.
Step 2: Choose eight to ten categories and sort every transaction
Too many categories make the work tedious, and too few hide what changed. Eight to ten works for most households. A starting list:
- Rent or mortgage
- Utilities and phone
- Groceries
- Gas or transit
- Dining and takeout
- Subscriptions and memberships
- Health and pharmacy
- Shopping and household goods
- Insurance and annual bills
- Card interest and fees
Add or merge as you like. The last line matters more than it looks: interest and fees are a cost that buys nothing, and they do not usually appear in anyone's budget until someone looks for them. Your statement lists them on a summary page, and how to find out what fees and interest your card cost you this year shows how to total them across the year.
Go through each period and assign every transaction to one category. Resist the urge to be precise about edge cases. A trip to a store that sells groceries and household goods can go wherever it usually goes, so long as you do the same in both periods. Put one-off items, such as a vet bill or a repair, in a separate line called "one-time," so they do not look like a trend.
Step 3: Fill in the table
Here is a worked example. Say a household, using round illustrative numbers, totals its spending for the third quarter of last year and the third quarter of this year. Every figure below is invented.
| Category | Same quarter last year | This quarter | Change in dollars | Change in percent |
|---|---|---|---|---|
| Rent | $4,500 | $4,725 | +$225 | +5.0% |
| Groceries | $1,200 | $1,296 | +$96 | +8.0% |
| Gas | $540 | $585 | +$45 | +8.3% |
| Utilities and phone | $330 | $372 | +$42 | +12.7% |
| Dining and takeout | $480 | $420 | −$60 | −12.5% |
| Subscriptions | $150 | $195 | +$45 | +30.0% |
| Card interest and fees | $0 | $90 | +$90 | not defined |
| Total | $7,200 | $7,683 | +$483 | +6.7% |
Check the sums before moving on, since a slip here spoils everything after it. Last year: $4,500 + $1,200 + $540 + $330 + $480 + $150 + $0 = $7,200. This year: $4,725 + $1,296 + $585 + $372 + $420 + $195 + $90 = $7,683. The difference is $483, and $483 ÷ $7,200 = 0.0671, or 6.7 percent.
Notice what the table already shows. The household spent $483 more over the quarter. The single largest piece, $225, is rent. Groceries came next at $96, then card interest at $90, then gas and subscriptions at $45 each, and utilities at $42. Dining fell $60, which offset part of the rest.
Step 4: Compute the change two ways
For each row, work out two numbers: the change in dollars (this period minus last), and the change in percent (that change divided by last year's figure). Both matter, for different reasons.
- The dollar change tells you where the pressure on your budget is. A 30 percent rise in subscriptions looks alarming, but it is $45 a quarter, less than the $225 rise in rent.
- The percent change tells you how fast the category is growing, which is what you compare with any published price measure, such as the Consumer Price Index reading for a similar category. You can get the national figures from the Bureau of Labor Statistics. Note that a published index is an average across many households, and yours may differ widely for reasons covered in Why the CPI headline may not match the inflation you actually feel.
A final calculation is each category's share of the total change. With a total change of $483, rent contributed $225 ÷ $483, or about 47 percent. That figure is easy to misuse when some categories fall (dining dropped $60, so the other rises sum to $543, not $483), so treat it as an approximation and rely on the dollar ranking.
Step 5: Split each change into price and habit
This is where the worksheet earns its keep. A change in dollars is the product of two things: how much you bought and what each unit cost. inflation affects the second; your habits affect the first. To pull them apart, use one of two simple tests.
The fixed-basket test works for groceries, pharmacy items and household goods. Pick ten items you buy in the same size every time and add up their price on a receipt from each period. Say the ten staples cost $62.00 last year and $67.00 now. That is a $5 rise, or 8.06 percent ($5 ÷ $62). Grocery spending rose 8.0 percent. The two match almost exactly, so nearly all of the grocery increase is price, with no change in habit.
The units test works for gas, dining and anything you count in visits or gallons. Say this household bought about 180 gallons of fuel in each period, at an illustrative $3.00 a gallon last year ($540) and $3.25 a gallon now ($585). Same gallons, higher price: +8.3 percent, all of it price. For dining, say 16 meals out at $30 last year ($480) and 14 at $30 this year ($420). The price did not change; the household ate out two fewer times, and the whole $60 drop is habit.
Apply both tests to every row you can. For rent and insurance, which are set by a contract, the whole change is a price you could not have bargained away this period. For utilities, look at the bill itself: most bills separate the amount of energy used from the rate charged, so you can check whether the rise came from using more or from a higher price per unit. For subscriptions, scroll the list: in this example the rise from $150 to $195 is one new $15 monthly service for three months, so it is a decision, not a price. a subscriptions audit worksheet for the recurring charges on your cards helps you list every recurring charge in one place.
Step 6: Put each change in a bucket
When you have split each change, label every row with one of three buckets:
| Bucket | Example rows | What to do |
|---|---|---|
| Price-driven | Rent, groceries, gas | You can shop around, change brands or routes, or renegotiate a contract, but the market moved, not you. |
| Habit-driven | Subscriptions, dining | These are choices. Whether to keep them is a question about what you value. |
| Debt-driven | Card interest and fees | This is the cost of an unpaid balance. It is the one bucket that shrinks the moment the balance does. |
In the example, price-driven rows add up to $225 + $96 + $45 + $42 = $408. Habit-driven rows are +$45 for subscriptions and −$60 for dining, a net of −$15. Debt-driven is +$90. The three buckets together make $408 − $15 + $90 = $483, which matches the total.
The example household's interest line deserves a second look, because it is the one thing it could remove completely. Say it carried an average of $1,500 on its cards across the quarter at an illustrative 24% APR. Interest for a quarter is $1,500 × 0.24 ÷ 4 = $90. That is the whole row. If the balance were paid off, the row would disappear, and the $90 a quarter would be $360 a year of spending that bought nothing. The credit card interest calculator works out the same figure for your own balance and rate.
A rough personal inflation figure
The buckets also give you something rare: a rough personal rate of price increase. Take the price-driven increase, $408 in the example, and divide it by last year's total of $7,200. That is 5.67 percent, or about 5.7 percent. It is not an official statistic, and it is rough, because rent and utilities are not pure price effects and because the example excludes categories such as insurance. But it answers the question "how much more did the same life cost me?" with your own weights instead of a national average.
Compare it with two other figures. The first is the total change of 6.7 percent, which includes habits and interest. The second is any published price index you want to check against, available from the Bureau of Labor Statistics; if your rough figure is well above or below it, your basket differs from the national one, which is normal. A household with high rent and a long commute will usually see a different figure from one that owns its home and works from it. The gap is exactly what Why the CPI headline may not match the inflation you actually feel sets out to explain.
Step 7: Decide what, if anything, to change
The worksheet is not a budget, and it does not tell you to cut anything. It tells you where your money went, so that you can decide with your eyes open. Three questions are worth answering in writing:
- Which rows are bigger than I expected? Surprises are where the information is.
- Which rows are price-driven and large? These are the ones to shop around for or renegotiate, because the savings repeat each month.
- Which row, if it went to zero, would help the most? For many households with card balances, the answer is interest.
If the third row is interest, the response that works is the one you can sustain. A larger payment toward the balance, a call to the issuer about a lower rate or a hardship program, or a visit to a nonprofit credit counselor are all legitimate paths. Do not close the gap by borrowing more, taking a cash advance, or paying a third party who promises to fix your debt. If you need help, call the number on the back of your card, or use the CFPB's consumer resources.
Your blank worksheet
Copy this table into a spreadsheet or onto paper and fill it in with your own numbers.
| Category | Same quarter last year | This quarter | Change in dollars | Change in percent | Price, habit or debt? |
|---|---|---|---|---|---|
| Rent or mortgage | |||||
| Utilities and phone | |||||
| Groceries | |||||
| Gas or transit | |||||
| Dining and takeout | |||||
| Subscriptions | |||||
| Health and pharmacy | |||||
| Shopping and household | |||||
| Insurance and annual bills | |||||
| Card interest and fees | |||||
| One-time items | |||||
| Total |
The two formulas to repeat on every row:
- Change in dollars = this quarter − same quarter last year
- Change in percent = change in dollars ÷ last year's figure × 100
When the table is full, add up the columns, confirm the totals, and write one sentence at the bottom saying what moved your budget most.
Common snags and how to handle them
- Annual or quarterly bills. Insurance premiums and subscriptions billed once a year can fall in one period and not the other. Put them in a separate line, or divide them across months, so that they do not create a false jump.
- Refunds and returns. Subtract them from the category they belong to rather than treating them as income.
- Shared and reimbursed spending. If you paid for a group trip and were paid back, net the reimbursement against the charge. Otherwise your spending looks higher than your real cost.
- Cash and debit. Include them if they are a large part of your spending. If they are not, say so on the page and accept a small error.
- Changes in your household. A new job, a child, a move or a roommate leaving can raise or lower a category for reasons that have nothing to do with prices. Write those events beside the relevant row.
If you want a routine from this, repeat the worksheet every quarter and keep the pages together. After a year you will have four snapshots, a clear view of where prices moved against you, and a record that makes the next budget easier to write. a monthly budget worksheet for people who pay for most things by card and a monthly statement review worksheet, line by line, in about 15 minutes fit well alongside it.
Key takeaways
- A year-over-year, same-quarter comparison by category removes seasonal swings and shows which parts of the budget actually moved.
- In the worked example, spending rose $483 (6.7 percent) from $7,200 to $7,683; rent was the largest piece at $225, and card interest of $90 was a cost that bought nothing.
- Split each change into price and habit with a fixed-basket receipt test (groceries) or a units test (gallons, meals out).
- Sort every row into price-driven, habit-driven or debt-driven; only the debt-driven bucket shrinks as soon as a balance is paid down.
- Use transaction dates or consistently built statement periods, and put one-time items on their own line so they do not look like trends.