Spreadsheets

Daily expense sheet in Google Sheets that is easy to fill on a phone

Design a daily expense sheet in Google Sheets for phone entry using a Google Form, a category dropdown, a Today total cell and a monthly summary tab.

Editorial illustration for Daily expense sheet in Google Sheets that is easy to fill on a phone

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?

  1. 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).
  2. Make Amount and Category required, so no entry is half empty.
  3. Open the Responses tab of the form and choose Link to Sheets, creating a new spreadsheet.
  4. 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?

PointGoogle FormTyping in the sheet
Speed on a phoneFast, big buttonsSlow, small cells
TimestampAdded automaticallyTyped by you
Category errorsDropdown prevents typosPossible without validation
Fixing a mistakeEdit the row in the sheet laterEdit in place at once
Changing categoriesEdit the form and the summaryEdit 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports