Getting started

Baseline spending: how to strip one-off costs out of your month

Build a baseline month in pounds by tagging each transaction as baseline, irregular or one-off, then totalling with SUMIFS to see your real running costs.

Editorial illustration for Baseline spending: how to strip one-off costs out of your month

Your baseline is what a month costs when nothing unusual happens. To find it, give every transaction one of three tags, baseline, irregular or one-off, then total only the baseline rows. The result is the figure to plan your regular months around, and the other two tags tell you how much extra to expect on top.

What are the three tags?

  • Baseline: costs that happen every month in some form, such as rent, food, travel and bills, even when the amount changes.
  • Irregular: costs that are normal but not monthly, like a boiler service or a school trip. You will pay them, you just cannot say which month.
  • One-off: a purchase you do not expect to repeat, such as a sofa or a flight to a wedding.

Three tags are better than two. A two-way split of normal and one-off forces annual bills into one group or the other, and either way misleads you.

How do I set it up in a spreadsheet?

  1. In your transaction sheet, keep Date in A, Description in B, Amount in C, and Tag in D with the words Baseline, Irregular or One-off.
  2. In column F, add the month with =TEXT(A2,"yyyy-mm") and fill down.
  3. In a summary block, use =SUMIFS($C$2:$C$500,$F$2:$F$500,"2025-10",$D$2:$D$500,"Baseline") for the baseline total.
  4. Repeat with "Irregular" and "One-off" for the other two rows.

Check the three together equal the month total. If they do not, some rows have no tag, and =COUNTBLANK($D$2:$D$500) will show you how many.

What does one month look like?

TagRowsAmount
Baseline64£1,331.80
Irregular1£212.50
One-off1£640.00
Month total66£2,184.30

The one-off is a £640.00 sofa and the irregular row is a £212.50 flight booked for a family visit. Add them: 1,331.80 plus 212.50 plus 640.00 equals 2,184.30. If you had planned from the raw total you would think a normal month costs £2,184.30, about £852.50 more than the baseline.

Where do I put things we are not sure about?

Ask whether you could have predicted the cost three months ago. If yes, it belongs in baseline or irregular. If no, and it is large, call it a one-off. When you still cannot decide, choose irregular. It keeps the money visible without letting it inflate your regular months.

How do I make use of the baseline?

  • Use the baseline average of the last three months as the figure for your regular plan.
  • Add the irregular rows over a full year, divide by 12, and set that amount aside monthly.
  • Treat the one-off total as a separate decision each time and keep it out of the monthly average.

How do I tag a whole year quickly?

Do not tag all twelve months at once. Start with the last three, tagging only rows above a size you choose, such as £100, since small rows are almost always baseline. Fill the rest of the column with Baseline using a formula or a fill-down. Then review only the large rows by eye. That turns a long job into a ten-minute one, and the baseline totals are close enough to be useful from the first pass.

The limit of this method

Tags are judgement, and judgement can be bent. If every awkward expense lands in one-off, the baseline will look flattering. Look at the one-off total at year end. If it comes to a large share of your yearly spending, you are not describing rare events, and the plan needs a bigger buffer.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports