A grocery tracker in Excel works best as two tabs: a purchase log where you record each item with quantity, unit and price, and a staples tab that shows the price per kg or litre month by month. The log tells you where the money went; the staples tab shows whether atta, dal or oil quietly became dearer.
What goes into the purchase log?
Use a tab called Log. Add one row per item bought, not per shopping trip, because price per unit is the useful figure.
| Column | Heading | Example |
|---|---|---|
| A | Date | 12-Nov-2026 |
| B | Store type | Kirana, Supermarket or Online |
| C | Item | Toor dal |
| D | Quantity | 2 |
| E | Unit | kg (always kg or litre, never grams) |
| F | Price paid | ₹ 310 |
| G | Price per unit | =F2/D2 |
| H | Month key | =TEXT(A2,"yyyy-mm") |
Convert before typing: 500 g is 0.5 kg, and 250 ml is 0.25 litre. If you mix units, the price per unit becomes meaningless and every comparison later is wrong. Use a drop-down for store type so spellings stay identical.
How do I see price per kg over time?
On a tab called Staples, list items down column A and put month keys such as 2026-10 and 2026-11 across row 1. Format row 1 as text; in Google Sheets, type an apostrophe first so it is not turned into a date. In B2:
- =IFERROR(SUMIFS(Log!$F$2:$F$500, Log!$C$2:$C$500, $A2, Log!$H$2:$H$500, B$1) / SUMIFS(Log!$D$2:$D$500, Log!$C$2:$C$500, $A2, Log!$H$2:$H$500, B$1), "")
This divides total spent on the item that month by total quantity, so buying 2 kg at one price and 3 kg at another gives a fair weighted price. The IFERROR leaves the cell empty if you did not buy the item that month.
How do I spot price creep?
Say you bought 5 kg of atta in October for ₹240 and again in November for ₹265. October works out to ₹48 a kg and November to ₹53 a kg. A change column makes it visible: =IFERROR(C2/B2-1, "") formatted as a percentage gives 0.104, or about 10.4%. Those prices are invented, but the method is the point. Do this for the ten items you buy every month and a pattern appears long before the monthly total feels different.
Be careful with comparisons across brands and pack sizes. Compare like with like, and if you switch brand, note it in a comments column so a jump is explained.
How do I split the total between kirana, supermarket and online?
Use SUMIFS on the log with the month key. For kirana in November:
- =SUMIFS(Log!$F$2:$F$500, Log!$B$2:$B$500, "Kirana", Log!$H$2:$H$500, "2026-11")
Repeat for Supermarket and Online and add a total row. With made-up numbers of ₹6,200, ₹3,400 and ₹2,100, the month's grocery spend is ₹11,700. The split helps you ask practical questions: are quick online top-ups creeping up, and are bulk buys at the supermarket actually cheaper per kg than the kirana for your staples?
What should I do about items bought without a bill?
Kirana purchases often have no printed bill. Write the entry in your phone's notes right at the shop or ask for the slip, and enter the list in the sheet in the evening. Guessing at month end gives prices that are too round to be useful.
Can an app take over the typing?
Online orders and grocery payments by card or UPI already sit in your bank statement. SpendixAI can import that statement and group them in a category, while cash kirana purchases can be added by hand in a batch, so the sheet is only needed for the unit-price detail.
Monthly routine
- Log each purchase with quantity in kg or litre
- Check the Staples tab for any price change you did not expect
- Compare the three-way split with last month
- Fix any wrong spellings in the item column
Useful ideas start with a clearer picture of your own spending.
Explore your reports


