Year-to-date expenses are everything from the start of the year up to today. In Excel, SUMIFS does it with two date tests: on or after the start date and on or before TODAY(). For the calendar year the start is 1 January; for an Indian financial year it is 1 April. Add a month-by-month cumulative column and you can compare against last year at the same point.
What is the calendar-year formula?
Assume dates in column A, amounts in column C, rows 2 to 500 of your log.
=SUMIFS($C$2:$C$500,$A$2:$A$500,">="&DATE(YEAR(TODAY()),1,1),$A$2:$A$500,"<="&TODAY())
DATE(YEAR(TODAY()),1,1) builds 1 January of the current year, whatever today is. The second test stops at today, so entries you have already recorded for future dates do not inflate the figure. If your dates include times, change the last test to "<"&TODAY()+1 so today's entries are counted.
How do I do the same for the April-March year?
The start of the current financial year depends on whether you are before or after April. In a cell, say E1, put:
=DATE(YEAR(TODAY())-(MONTH(TODAY())<4),4,1)
The part (MONTH(TODAY())<4) is TRUE, which counts as 1, in January to March and FALSE, which counts as 0, from April onwards. So in February 2026 the start is 1 April 2025, and in July 2026 it is 1 April 2026. Then:
=SUMIFS($C$2:$C$500,$A$2:$A$500,">="&$E$1,$A$2:$A$500,"<="&TODAY())
The same structure works for any other year start; only the month number inside DATE changes.
How do I build a month-by-month YTD column?
List the first day of each month of the year down column E from E4: 01/04/2025, 01/05/2025 and so on, or drag a series. Then:
- F4, the month's spend: =SUMIFS($C$2:$C$500,$A$2:$A$500,">="&E4,$A$2:$A$500,"<"&EDATE(E4,1))
- G4, year to date: =SUM($F$4:F4)
Copy F4 and G4 down. The anchored start $F$4 and the moving end F4 make each row add every month so far. Months that have not happened show 0, so you can hide them with a conditional format, or wrap F4 in IF(E4>TODAY(),"",...) to leave them blank.
How can I compare with last year at the same point?
Add a column H with last year's monthly spend by shifting the dates back a year: replace E4 with EDATE(E4,-12) and EDATE(E4,-11) in the formula, then total it in column I the same way as G. Or, for a one-cell answer, use:
=SUMIFS($C$2:$C$500,$A$2:$A$500,">="&EDATE($E$1,-12),$A$2:$A$500,"<="&EDATE(TODAY(),-12))
That adds last year's spending from the same start date up to the same day a year ago, which is the fair comparison. Hypothetical figures for three months:
| Month | This year | This year YTD | Last year YTD |
|---|---|---|---|
| April | ₹42,000 | ₹42,000 | ₹39,000 |
| May | ₹38,500 | ₹80,500 | ₹75,000 |
| June | ₹41,200 | ₹1,21,700 | ₹1,15,500 |
By June this year's total is 42,000 + 38,500 + 41,200 = ₹1,21,700. If last year's months were 39,000, 36,000 and 40,500, the running total is ₹1,15,500, so the gap is ₹6,200.
Can I show only months that have happened?
Yes. Wrap the monthly formula so future months stay blank: =IF(E4>TODAY(),"",SUMIFS(...)). The cumulative column then needs the same guard, otherwise it repeats the last total down to March. If you chart the YTD line, blank cells leave a clean gap instead of a flat tail, which makes the picture easier to read at a glance.
What can go wrong?
- Text dates silently drop out of the sum, so the total looks too low.
- Refunds entered as positive numbers add to spending instead of reducing it.
- Opening the file next year changes TODAY(), so a saved report moves; paste values if you want a fixed snapshot.
Next step
Format the YTD cell clearly, add the budget for the year beside it, and check the monthly column adds up to the one-cell formula. When retyping statement lines is the slow part, SpendixAI lets you import statements as PDF, CSV or Excel, review the rows and download a CSV for a sheet like this.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


