You can keep a perfectly good receipt log in Excel with six columns and three formulas. Photograph or save each receipt, give the file a predictable name, and note it in the sheet so totals and missing receipts take care of themselves. This works the same in Google Sheets, with one difference noted below.
Which columns does the template need?
Put headers in row 1 and start data in row 2. Keep one receipt per row and never merge cells.
| Column | Header | What goes in it |
|---|---|---|
| A | Date | Real dates, such as 14-10-2026, not text |
| B | Vendor | Shop or service name |
| C | Category | Food, Fuel, Medical, Home, Travel |
| D | Amount | Number only, no rupee sign |
| E | Paid by | UPI, Card, Cash |
| F | Receipt file | File name, for example 2026-10-14-fuel-1450 |
Name receipt files the same way every time: year-month-day, a word for the spend, then the amount. Sorted by name, they line up with the sheet.
How do you total a category for one month?
Put the first day of the month in cell H1 (say 01-10-2026) and the category you want in H2. Then use:
- Month total for a category: =SUMIFS($D$2:$D$500, $C$2:$C$500, $H$2, $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&EOMONTH($H$1,0))
- Month total for everything: =SUMIFS($D$2:$D$500, $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&EOMONTH($H$1,0))
- Number of receipts in the month: =COUNTIFS($A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&EOMONTH($H$1,0))
SUMIFS takes the range to add first, then pairs of range and condition. EOMONTH(date,0) returns the last day of the same month, and it works in both Excel and Google Sheets.
A worked example with made-up receipts
Say October has these rows: groceries ₹1,250 on the 3rd, fuel ₹1,450 on the 9th, pharmacy ₹380 on the 14th, fuel ₹1,600 on the 22nd, and groceries ₹2,075 on the 28th. The Fuel formula gives ₹1,450 + ₹1,600 = ₹3,050. The Food formula, if you tag groceries as Food, gives ₹1,250 + ₹2,075 = ₹3,325. The whole month is ₹1,250 + ₹1,450 + ₹380 + ₹1,600 + ₹2,075 = ₹6,755.
How do you find receipts you forgot to save?
Add one more formula to count rows that have an amount but no receipt file name:
- Missing receipts: =COUNTIFS($D$2:$D$500, ">0", $F$2:$F$500, "")
- To highlight them, use conditional formatting with a custom formula such as =AND($D2>0, $F2="") applied to A2:F500.
What are the limits of a receipt sheet?
Everything is typed by hand, categories drift (Food in one row, food in another is still matched by SUMIFS, but Groceries is not), and nothing checks your entries against the bank. Dropdowns help: select column C, choose Data validation, and allow a list of your categories.
When does a sheet stop being enough?
When statements and receipts both pile up, matching them manually becomes the job. SpendixAI imports bank and card statements (PDF, CSV or Excel), lets you review rows, and keeps receipts attached to the transactions. It does not scan a receipt photo into a row for you, so the sheet and the app solve different halves of the problem.
Can you build a category summary table?
Yes. List your categories in K2:K8 and, next to each, repeat the SUMIFS with the category cell: =SUMIFS($D$2:$D$500, $C$2:$C$500, K2, $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&EOMONTH($H$1,0)). Copy it down the column. Add a total under it with =SUM(L2:L8) and compare that total with the whole-month formula above. If the two differ, some rows carry a category that is not in your list, often because of a typo or an extra space. That one check catches most mistakes before they spread.
For payments by UPI, card or cash, the same pattern works on column E instead of C, which shows how much of the month left as cash and is easy to forget.
Monthly habit
- Save each receipt the same day.
- Add the row while the details are fresh.
- On the last day, check the missing-receipt count is zero.
- Compare the month total with your statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

