To compare this year's spending with last year's, add up everything from the start of the year to a chosen date, then add up last year's spending to the same date. That is year-to-date, or YTD. It avoids the classic mistake of comparing half of this October with all of last October, which makes you look far more frugal than you are.
Why does the half-month trap happen?
Say today is 15 October and you have spent ₹21,000 this month so far. Last October's full total was ₹45,000. Set side by side, this month looks 53% lower, since 24,000 divided by 45,000 is 0.533. But you are comparing half a month with a whole one. A fair comparison uses last year's spending to 15 October, not to 31 October.
How do you build a YTD comparison?
- Choose a start date. For a financial year this is 1 April.
- Choose a cut-off date, such as the last day of the most recent complete month.
- Total spending from the start to the cut-off in this year.
- Total spending from the same start to the same cut-off one year earlier.
- Subtract and compute the percentage.
In a transaction sheet with dates in column A and amounts in column C, put the start date in F1 and the cut-off in F2. This year's total is =SUMIFS($C$2:$C$1000,$A$2:$A$1000,">="&$F$1,$A$2:$A$1000,"<="&$F$2). Last year's is =SUMIFS($C$2:$C$1000,$A$2:$A$1000,">="&EDATE($F$1,-12),$A$2:$A$1000,"<="&EDATE($F$2,-12)). EDATE moves a date back twelve months and works in Excel and Google Sheets.
What does a table look like?
Say these are a household's monthly totals from April to September for two years. All figures are made up.
| To end of | This year, monthly | This year, YTD | Last year, YTD | Difference |
|---|---|---|---|---|
| Apr | ₹39,000 | ₹39,000 | ₹36,000 | +₹3,000 |
| May | ₹38,500 | ₹77,500 | ₹74,000 | +₹3,500 |
| Jun | ₹41,000 | ₹1,18,500 | ₹1,11,000 | +₹7,500 |
| Jul | ₹42,000 | ₹1,60,500 | ₹1,51,000 | +₹9,500 |
| Aug | ₹40,500 | ₹2,01,000 | ₹1,90,000 | +₹11,000 |
| Sep | ₹43,000 | ₹2,44,000 | ₹2,31,000 | +₹13,000 |
By September the household has spent ₹13,000 more than at the same point last year. The percentage is 13,000 divided by 2,31,000, which is 5.6%. The pattern is also clear: the gap widened every month, with the biggest step in June (₹4,000), so spending is running slightly higher month after month, not because of a single event.
What do you look for in the table?
- Whether the difference is growing, shrinking or steady. A growing gap means a continuing rise.
- A sudden step in the gap, such as between May and June, which points to one large payment.
- Whether the cut-off date is a clean month end. If your card statements run to the 20th, the last month may be incomplete.
Why use YTD and not just monthly totals?
Monthly comparisons are noisy. A late card bill, a festival moving by a week or one annual payment can swing a single month. Year-to-date smooths these because errors in timing wash out over several months. It also answers the question you actually care about halfway through the year: am I running ahead of or behind last year's pace?
Choose the cut-off carefully. The last day of a completed month is the cleanest choice, because both years have a full set of statements behind them. If you must use a mid-month date, make sure card statements and cash entries are up to date to that day in both years, or the comparison will lean towards whichever year is more complete.
Where does a tracker fit?
SpendixAI keeps each transaction with its date and account, and the Report builder can filter by date range, so you can run the same range for two years and compare the totals. If you prefer a sheet, download the CSV and use the formulas above.
A routine for each month end
- Set the cut-off to the last day of the month just finished.
- Calculate this year's YTD and last year's YTD.
- Write the difference, in rupees and in percent.
- Note anything that explains a jump in the gap.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

