Create a Google Form with Date, Amount, Category and Payment mode fields, link its responses to a Google Sheet, and open the form from a home-screen shortcut on your phone. Each submitted expense lands as a new row. A separate summary tab then totals the rows with SUMIFS or QUERY, leaving the raw responses untouched.
How do you build the form?
- In Google Forms, start a blank form and call it Expense log.
- Question 1: Date, type Date. Question 2: Amount, type Short answer. Open the three-dot menu, choose Response validation, pick Number, then Greater than, and enter 0. This stops text from creeping into amounts.
- Question 3: Category, type Dropdown, with your categories as options.
- Question 4: Payment mode, type Multiple choice with UPI, Card, Cash and Bank transfer.
- Question 5: Notes, type Short answer, not required.
- Mark Date, Amount and Category as Required.
How do responses get into a sheet?
Open the Responses tab and click Link to Sheets, then create a new spreadsheet. Google adds a tab called Form Responses 1. Column A is an automatic Timestamp. If your questions are in the order above, the columns are B Date, C Amount, D Category, E Payment mode and F Notes. Do not rearrange or type inside this tab. The form writes to it, and edits to the layout can confuse it.
How do you make logging fast on a phone?
Open the form's link in your phone browser and use the browser menu to add it to your home screen. Now one tap opens a blank entry. Keep the dropdown short, because scrolling twenty categories on a small screen is what makes people give up. If you do not back-date entries, you can skip the Date question and use the Timestamp column instead, converted to a date with =INT('Form Responses 1'!A2).
How do you summarise the responses?
Add a new tab called Summary. Put the first day of the month in B1 as a date, and list your categories in A4 downward. In B4:
=SUMIFS('Form Responses 1'!$C$2:$C$1000, 'Form Responses 1'!$D$2:$D$1000, $A4, 'Form Responses 1'!$B$2:$B$1000, ">="&$B$1, 'Form Responses 1'!$B$2:$B$1000, "<"&EDATE($B$1,1))
For a one-cell version that lists every category automatically, Google Sheets has QUERY:
=QUERY('Form Responses 1'!A1:F1000, "select D, sum(C) where B >= date '"&TEXT($B$1,"yyyy-mm-dd")&"' and B < date '"&TEXT(EDATE($B$1,1),"yyyy-mm-dd")&"' group by D label sum(C) 'Total'", 1)
In the query, B is the Date column of the responses, C is Amount and D is Category. The final 1 tells QUERY that the first row holds headers.
What does a day of use look like?
| Time | What you submit | Row that lands in the sheet |
|---|---|---|
| Morning | ₹60, Transport, UPI | Date, 60, Transport, UPI |
| Lunch | ₹240, Dining out, Cash | Date, 240, Dining out, Cash |
| Evening | ₹1,150, Groceries, Card | Date, 1150, Groceries, Card |
The day's three entries add up to 60 plus 240 plus 1,150, which is ₹1,450. The Summary row for that month rises by the same amount.
What are the limits of this setup?
- Mistakes are awkward to fix. You edit them in the responses tab or through the form's edit-response link, and totals follow.
- There is no receipt capture and no offline entry, so a weak signal can stop you.
- Every category change has to be made in the form's dropdown as well as in your summary.
- Your summary list does not update itself when you add a category unless you use the QUERY version.
If you outgrow it, SpendixAI has mobile apps and lets you add several expenses at once, which suits a day of cash spending, and receipts can be kept with their transactions. The form is a good start.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

