Budgeting

Year-over-year spending table: twelve months side by side

A twelve-month, two-year layout with change and percent change columns, plus a 25% rule for which months need an explanation. Hypothetical numbers.

Editorial illustration for Year-over-year spending table: twelve months side by side

A year-over-year spending table puts the same twelve months from two years side by side, with a change column in rupees and another in percent. Add a total row and a rule for which months deserve a closer look, and you have a one-page review of how your spending has moved. Here is the layout, with made-up numbers.

What should the table contain?

  • Column A: the month, in financial-year order from April to March.
  • Column B: last year's total for that month.
  • Column C: this year's total for that month.
  • Column D: change in rupees, =C2-B2.
  • Column E: change in percent, =IF(B2=0,"",(C2-B2)/B2), formatted as a percentage.
  • A final row for totals, using =SUM(B2:B13) and =SUM(C2:C13), with the same two change formulas.

Keep the table to one sheet and one purpose. Instead of adding category columns to the monthly ones, make a separate copy of the same layout for each large category, such as groceries or transport, which is clearer than one wide table. Format the percentage column with one decimal place so small changes do not round away to nothing.

How does a filled table look?

MonthLast yearThis yearChange (₹)Change (%)
Apr₹38,000₹41,000+₹3,000+7.9%
May₹40,000₹42,500+₹2,500+6.3%
Jun₹39,500₹40,000+₹500+1.3%
Jul₹41,000₹43,000+₹2,000+4.9%
Aug₹40,000₹41,000+₹1,000+2.5%
Sep₹43,000₹44,500+₹1,500+3.5%
Oct₹52,000₹50,000-₹2,000-3.8%
Nov₹47,000₹61,000+₹14,000+29.8%
Dec₹46,000₹45,000-₹1,000-2.2%
Jan₹40,000₹41,500+₹1,500+3.8%
Feb₹39,000₹40,500+₹1,500+3.8%
Mar₹42,000₹43,000+₹1,000+2.4%
Total₹5,07,500₹5,33,000+₹25,500+5.0%

Check the total: the monthly changes add up to 25,500, which matches 5,33,000 minus 5,07,500. And 25,500 divided by 5,07,500 is about 5.0%.

What should you do with months that look different?

Use a simple rule: any month that differs by more than 25% gets a one-line explanation. In the table only November does, at 29.8%, with ₹14,000 more than the year before. October was lower by ₹2,000, which hints that some festival spending slid from one month into the other, a common reason for a month swap.

When you add the two months, October and November were ₹99,000 last year and ₹1,11,000 this year, a rise of ₹12,000 or about 12.1%. Seen together, the November jump is smaller than it first looked.

Which months should you compare, and which should you not?

  • Compare festival months in pairs, since festivals move between months.
  • Check months with annual payments, such as insurance, school fees or travel, against what was paid last year.
  • Be careful with February, which has fewer days, and with months that had a different number of weekends.
  • If you changed city, job or household size, a comparison may not make sense for some categories.

How do you fill the table quickly?

Export or copy monthly totals for each year. If your data is in a transaction sheet with dates in column A and amounts in column C, this formula gives one month's total: =SUMIFS($C$2:$C$1000,$A$2:$A$1000,">="&DATE(2026,4,1),$A$2:$A$1000,"<"&DATE(2026,5,1)). Change the dates for each row, or put each month's start date in a helper column and use EDATE to find the next month. Missing data deserves a mention too. If an account was opened mid-year, write that beside the affected rows so a gap is not read as a drop in spending.

If you use SpendixAI, the Report builder can group your imported transactions by month, and a CSV download gives you the monthly totals to paste into the table. You will need at least two full years of records for the comparison, so import older statements first.

A closing checklist

  1. Fill both years with full-month totals.
  2. Calculate the rupee and percent changes.
  3. Flag every month beyond 25%, and write a one-line reason for each.
  4. Compare adjacent months for festivals and annual payments.
  5. Save the table, so you can add next year's column beside it.
SPENDIXAI JOURNAL

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

Explore your reports