A monthly groceries budget template needs only four columns and one formula: date, shop, category and amount, with a cell that adds up the month and compares it with your limit. Below is a layout that works in Excel and Google Sheets, followed by a worked example with made-up figures.
The columns to set up
Make a sheet called Groceries with these headings in row 1:
- A: Date
- B: Shop (kirana, vegetable seller, supermarket, online order)
- C: Type (Staples, Vegetables and fruit, Dairy, Snacks, Household, Other)
- D: Amount in ₹
- E: Week number, calculated with =WEEKNUM(A2)
The Type column is what makes the template useful. A single Groceries total tells you little; knowing that staples are steady while snacks and household items swing tells you where to act.
The formulas
Put your monthly limit in G1, say 10,000, and the first day of the month in G2. Then:
- Month total: =SUMIFS($D$2:$D$400, $A$2:$A$400, ">="&$G$2, $A$2:$A$400, "<="&EOMONTH($G$2,0))
- Left to spend: =G1-G3 (if G3 holds the month total)
- Spent on staples: =SUMIFS($D$2:$D$400, $C$2:$C$400, "Staples", $A$2:$A$400, ">="&$G$2, $A$2:$A$400, "<="&EOMONTH($G$2,0))
- Spent per shop: the same formula with $B$2:$B$400 as the criteria range and the shop name in quotes.
WEEKNUM counts weeks from the start of the calendar year, so a month straddles weeks like 44 to 48. That is fine for comparing weeks inside one month; do not read the numbers as week one to four.
A worked example with made-up numbers
Say a family of three sets ₹10,000 for November. Instead of one lump, split it by type, with a small buffer for festival cooking:
| Type | Planned (₹) | Actual by 25th (₹) | Difference (₹) |
|---|---|---|---|
| Staples (atta, rice, dal, oil) | 3,800 | 3,650 | 150 left |
| Vegetables and fruit | 2,000 | 2,300 | 300 over |
| Dairy | 1,500 | 1,500 | 0 |
| Snacks and drinks | 1,000 | 1,420 | 420 over |
| Household | 1,200 | 900 | 300 left |
| Buffer | 500 | 0 | 500 left |
| Total | 10,000 | 9,770 | 230 left |
Total spent is 3,650 plus 2,300 plus 1,500 plus 1,420 plus 900, which is ₹9,770, so ₹230 remains of the ₹10,000 with five days to go. Vegetables and snacks ran over; the buffer and household absorbed it. Without the split, you would only see 'almost on budget' and miss the pattern.
How do I set a realistic limit?
Do not copy a number from a website. Add up groceries from the last three months of your own statements, divide by three, and set the limit at that figure. If you want to cut, reduce it by about a tenth for one month and see if it holds. Online orders, kirana UPI payments and cash all belong in the total, so check each source.
If your family size or visitors vary, note the number of guests in a column. A month with relatives staying will look high for a reason, and the note stops you from cutting the limit for the wrong reason.
Which is cheaper, weekly or monthly shopping?
There is no universal answer, and a template can tell you for your family. Tag each row with Monthly stock-up or Top-up in an extra column and compare the totals after two months. Many households find that a large monthly stock-up reduces small trips, but also that more gets wasted; your sheet will show which pattern applies to you.
When a sheet becomes tedious
Typing each kirana UPI payment gets old. If your groceries come through UPI and card, an expense tracker that imports statements saves the typing: SpendixAI can take them as PDF, CSV or Excel and let you set a rule so a particular merchant always lands in Groceries, with cash added by hand. Until then, the template above is enough.
Quick set-up list
- Create the sheet with the five columns.
- Enter this month's limit and first date.
- Log each purchase the same day, or every night.
- On the 15th, compare spent against half the limit.
- At month end, adjust next month's limit by the difference.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

