Spreadsheets

Track expenses by salary cycle (25th to 24th) instead of month

Group expenses by a salary cycle such as 25th to 24th instead of the calendar month using a helper column that shifts dates, then SUMIFS or a pivot as usual.

Editorial illustration for Track expenses by salary cycle (25th to 24th) instead of month

To track expenses by a 25th-to-24th salary cycle, add a helper column that shifts every date back by 24 days and returns the first day of that shifted month. A purchase on 25 September becomes 1 September and one on 24 October becomes 30 September, so the whole cycle lands in one budget month. SUMIFS and pivot tables then work on the helper column as normal.

Why does the calendar month not fit?

If salary arrives on the 25th, the money you spend on 26 September is funded by September's pay, yet a calendar report files it under September while the 5 October bills are filed under October. Your month looks lopsided: the first 24 days of October spend September's salary. A cycle report that runs 25th to 24th matches what you actually have to stretch.

The helper formula

Assume dates in column A, categories in B and amounts in C. In D2, label D1 Budget month, enter:

=EOMONTH(A2-24,-1)+1

The cycle starts on day 25, so subtract 24. Then EOMONTH(...,-1)+1 returns the first day of the month of the shifted date. Format column D as mmm yyyy. The general version for a cycle starting on day S is =EOMONTH(A2-(S-1),-1)+1, which works for start days up to 28. With S equal to 1 it simply gives the calendar month.

Do the check on the edges, because the edges are where cycles go wrong:

Date of expenseDate minus 24 daysBudget monthAmount
24 Sep 202531 Aug 2025Aug 2025₹1,800
25 Sep 20251 Sep 2025Sep 2025₹22,000
10 Oct 202516 Sep 2025Sep 2025₹3,500
24 Oct 202530 Sep 2025Sep 2025₹640
25 Oct 20251 Oct 2025Oct 2025₹900

The Sep 2025 budget month runs from 25 September to 24 October. Its total is 22,000 + 3,500 + 640 = ₹26,140. The ₹1,800 on 24 September belongs to the cycle before, and the ₹900 on 25 October to the one after.

How do I total a cycle with SUMIFS?

Type the first day of the budget month you want in G1, such as 01/09/2025, and use:

=SUMIFS($C$2:$C$500,$D$2:$D$500,$G$1)

For one category, add $B$2:$B$500,"Groceries". Because the helper column holds true dates, equal matches work without any date arithmetic. In a pivot table, put the helper column in Rows and Category in Columns or Rows, and Amount in Values; the cycles group themselves.

Which month should the cycle be named after?

That is a choice, not a rule. The formula above names the cycle after the month in which it starts, so 25 Sep to 24 Oct is Sep. Many people prefer the month in which it ends. In that case wrap the helper so the label moves forward when the day is on or after the cycle start: =IF(DAY(A2)>=25,EDATE(DATE(YEAR(A2),MONTH(A2),1),1),DATE(YEAR(A2),MONTH(A2),1)). Pick one and write it in a note cell on the sheet so you do not guess later.

Do budgets work with this?

Yes. Put the budget for the cycle beside the cycle total and compute the difference. Mid-cycle comparisons need care: on the 10th of October you are 16 days into the Sep cycle, not 10 days into October, so days-left formulas should use the cycle's end date. For a cycle labelled 01/09/2025 in G1, the end date is =EDATE($G$1,1)+23, which gives 24 October.

Checklist

  • Dates are real dates.
  • You tested a date on the 24th and on the 25th.
  • The helper column is filled down the whole log, including new rows.
  • A note on the sheet says which month name the cycle uses.

If shifting dates by hand ever feels fiddly, SpendixAI offers a Report builder to filter and group your transactions, and a CSV download for sheets like this one.

SPENDIXAI JOURNAL

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

Explore your reports