Spreadsheets

Weekly expense tracker template in Excel with a seven-day grid

A weekly expense tracker template in Excel: a seven-day grid by category, weekly limit and left-to-spend cell, plus how to roll weeks into months safely.

Editorial illustration for Weekly expense tracker template in Excel with a seven-day grid

A weekly expense tracker in Excel is a grid with categories down the left, the seven days across the top, a total column on the right, a weekly limit in one cell and a left-to-spend cell that subtracts the week's total from that limit. Make one tab per week, keep the dates in the header row, and roll the weeks into a month with a formula that checks each day's month, so the week that straddles two months is never counted twice.

What should the weekly grid look like?

Create a sheet called Week_1 with these cells. The first column holds categories, columns B to H hold Monday to Sunday, and I holds the week total.

  • B1: the Monday date, typed as a real date such as 27-Oct-2025.
  • B2: =B1, then C2: =B2+1 and so on across to H2. Format row 2 as ddd d-mmm so you see Mon 27-Oct.
  • A3 to A8: Food, Transport, Bills, Shopping, Health, Other.
  • B3:H8: the amounts you spend, entered each evening.
  • I3: =SUM(B3:H3), filled down to I8.
  • B9 (day total): =SUM(B3:B8), filled across to H9, and I9: =SUM(B9:H9).
  • K1 labelled Weekly limit, with your number in K2.
  • K4 labelled Left to spend, with =K2-I9 in K5.

Add a conditional formatting rule to K5 so it turns red when it is below zero. A negative number is not a failure; it is the sheet telling you the week ran over by that much.

How do I roll four or five weeks into a month?

The trap is that a week can start in one month and end in the next. If you simply add up Week_1 to Week_5 you will count days that belong to the next month. Use the dates in row 2 as the guard. Put a month number in B1 of a Month sheet (say 11) and the year in B2 (say 2025), and then for each week write:

=SUMPRODUCT((MONTH(Week_1!$B$2:$H$2)=$B$1)*(YEAR(Week_1!$B$2:$H$2)=$B$2)*Week_1!$B$9:$H$9)

SUMPRODUCT multiplies each day's total by 1 when the date is in the chosen month and year, and by 0 when it is not, then adds the results. Repeat the line for Week_2, Week_3 and so on, and add them up in one cell. Sheet names with an underscore need no quote marks, and a name such as Week_1 cannot be mistaken for a cell address.

What does the straddling week look like with numbers?

Say Week_1 runs Monday 27 October to Sunday 2 November 2025, and the hypothetical day totals are:

DayDateDay total (₹)Counts toward
Mon27 Oct400October
Tue28 Oct650October
Wed29 Oct300October
Thu30 Oct900October
Fri31 Oct1,200October
Sat1 Nov1,500November
Sun2 Nov700November

The week total is ₹5,650 (400 plus 650 plus 300 plus 900 plus 1,200 plus 1,500 plus 700). Against a weekly limit of ₹6,000 the left-to-spend cell shows ₹350. For the monthly roll-up, October gets ₹3,450 from this week and November gets ₹2,200, which together make the same ₹5,650. Nothing is lost and nothing is counted twice.

How should the weekly limit be set?

Start from what you actually spent. Take four recent weeks from your records, add the totals, divide by four, then round to a tidy number you are willing to try. Leave fixed items such as rent and EMIs out of the weekly grid and track them in the monthly sheet, so the weekly limit covers only the day-to-day spending. Revisit the number after a month; it is a working figure, not a verdict.

Can I reuse the sheet every week?

  1. Right-click the finished tab and choose Move or Copy, tick Create a copy.
  2. Rename it Week_2, type the new Monday in B1, and clear B3:H8 (the dates and totals update themselves).
  3. Add the new week to the Month sheet as another SUMPRODUCT line.

When a weekly sheet is not enough

A grid is perfect for cash and daily habits. For card and bank spending, SpendixAI lets you upload statements as PDF, CSV or Excel, review the rows, and see them in a dashboard and a weekly summary, while cash goes in by hand, so the sheet can then focus on the part only you know.

SPENDIXAI JOURNAL

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

Explore your reports