The easiest daily expense sheet to fill on a phone is a Google Form linked to a Google Sheet. The form gives you big tap targets and a category dropdown, the responses tab collects entries with an automatic timestamp, and two formulas give you a Today total and a monthly summary. Typing straight into the grid works, but it is fiddly on a small screen.
How do I build the form?
- Create a new Google Form with four questions: Amount (short answer, number only), Category (dropdown), Payment mode (multiple choice: Cash, UPI, Card) and Note (short answer, optional).
- Make Amount and Category required, so no entry is half empty.
- Open the Responses tab of the form and choose Link to Sheets, creating a new spreadsheet.
- Open the form link on your phone and use the browser menu to add it to the home screen for one-tap access.
The linked sheet gets a tab called Form responses 1. Column A is the timestamp, B is amount, C is category, D is payment mode and E is the note, in that order. Do not reorder those columns, since the formulas below depend on them.
How do I show today's total?
On a new tab called Summary, put this in B1:
=SUMIFS('Form responses 1'!$B$2:$B$2000, 'Form responses 1'!$A$2:$A$2000, ">="&TODAY(), 'Form responses 1'!$A$2:$A$2000, "<"&TODAY()+1)
The timestamp holds both date and time, so the formula takes everything from midnight today up to, but not including, midnight tomorrow. Open the sheet on your phone at night and the figure is there.
How do I build the monthly summary?
Type the first day of the month in B3. List your categories in A5 downward, exactly as they appear in the form dropdown. Then in B5:
=SUMIFS('Form responses 1'!$B$2:$B$2000, 'Form responses 1'!$C$2:$C$2000, A5, 'Form responses 1'!$A$2:$A$2000, ">="&$B$3, 'Form responses 1'!$A$2:$A$2000, "<"&EDATE($B$3,1))
Fill it down the categories. Add a check cell beneath: the month's total of all entries minus the sum of the category column should be zero. If it is not, a category in the form does not match one in the summary, usually a spelling or spacing difference.
Form or typing straight into the sheet?
| Point | Google Form | Typing in the sheet |
|---|---|---|
| Speed on a phone | Fast, big buttons | Slow, small cells |
| Timestamp | Added automatically | Typed by you |
| Category errors | Dropdown prevents typos | Possible without validation |
| Fixing a mistake | Edit the row in the sheet later | Edit in place at once |
| Changing categories | Edit the form and the summary | Edit one list |
Most people end up using the form to record and the sheet to correct. Edit wrong entries in the Responses tab; the formulas catch the change straight away.
A made-up day
Say you log three entries: tea and a snack for ₹40, an auto ride for ₹120 and vegetables for ₹260 in cash. The Today cell shows 40 + 120 + 260 = ₹420. At month end the Groceries row adds up all the vegetable and kirana entries, and the check cell stays at zero as long as the categories match.
A few habits help the entries stick. Keep the form open in a browser tab on your phone, enter amounts before you put the wallet away, and use the Note field only when something is unusual. A one-word category is enough for almost everything; long notes are the quickest way to stop using the sheet.
When a sheet stops being enough
Cash needs a manual entry whichever way you do it, but card and UPI payments appear in bank statements. SpendixAI can import those statements and also lets you add cash expenses by hand, singly or several at once, so the entry effort goes mostly to cash.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


