To compare two financial years side by side, list April to March down the rows, put one year in each of two columns, add a difference column and a cumulative column. Each cell is a SUMIFS that looks at one month of one year. Once the pattern is in place you change two year numbers and the whole table updates.
How should the layout look?
Put the first financial year's start year in B3 (say 2024) and the second in C3 (2025). Column A, from A5 to A16, holds the numbers 1 to 12, and column H shows month names. Your data sheet has dates in column A and amounts in column C, rows 2 to 500.
| Column | Holds |
|---|---|
| A | Fiscal month number, 1 to 12 |
| B | Spend in the first year |
| C | Spend in the second year |
| D | Difference, second minus first |
| E | Percentage change |
| F | Cumulative for the first year |
| G | Cumulative for the second year |
What is the monthly SUMIFS?
In B5 write:
=SUMIFS(Data!$C$2:$C$500, Data!$A$2:$A$500, ">="&EDATE(DATE(B$3,4,1),$A5-1), Data!$A$2:$A$500, "<"&EDATE(DATE(B$3,4,1),$A5))
DATE(B$3,4,1) is 1 April of the year in the header. EDATE moves forward A5-1 months to reach the start of that month, and the second EDATE gives the start of the next month. Using "less than the next month's first day" means every date inside the month is caught, including ones with a time attached. Fill B5 right to C5 and down to row 16.
Which formulas fill the other columns?
- Month name in H5: =TEXT(EDATE(DATE(2000,4,1),A5-1),"mmm"), showing Apr to Mar.
- Difference in D5: =C5-B5
- Percentage change in E5: =IF(B5=0, "", D5/B5)
- Cumulative in F5: =SUM(B$5:B5), and in G5: =SUM(C$5:C5)
What does a worked example look like?
These numbers are hypothetical. Say total spending was as follows.
| Month | 2024-25 | 2025-26 | Difference | Cumulative 2025-26 |
|---|---|---|---|---|
| Apr | ₹32,000 | ₹35,500 | ₹3,500 | ₹35,500 |
| May | ₹30,500 | ₹31,000 | ₹500 | ₹66,500 |
| Oct | ₹44,000 | ₹38,000 | -₹6,000 | ₹2,48,000 |
| Nov | ₹36,000 | ₹49,500 | ₹13,500 | ₹2,97,500 |
In October, spending looks lower than the previous year, and in November it looks much higher. If Diwali fell in October one year and November the next, the festival shopping moved with it. The cumulative column irons that out, which is why it deserves a place in the table.
How do you read the comparison fairly?
- Compare the cumulative lines, not single months, because one-off purchases and festivals shift between months.
- Check that both years have the same number of complete months. A half-finished current year will always look lower.
- Split out one-off items such as a laptop or a trip, or filter by category, so a single purchase does not hide the trend.
What about running this in Google Sheets?
The formulas are identical. SUMIFS, EDATE, DATE and TEXT behave the same way in Sheets, so you can copy them across without edits.
How do you chart the two years?
Select the month names, the two cumulative columns F and G, and insert a line chart. Two lines that run together and then split show exactly when spending started to differ, which a table of monthly differences hides. Label the lines with the financial year text, such as 2024-25 and 2025-26, rather than Series1 and Series2. If a month in the current year has not finished yet, leave its cumulative cell blank so the line stops instead of dropping to zero.
Keep a note under the table saying which categories were included and whether one-off purchases were left in, so that anyone reading it next year knows exactly what was compared.
If you keep the data in SpendixAI, the Report builder lets you filter and group the figures, and a CSV download gives you the rows to paste into this layout when you want the side-by-side view.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

