Spreadsheets

Log expenses from your phone with a Google Form and Sheets

Log expenses from your phone with a Google Form linked to Google Sheets: build the form, link responses, and summarise them on a separate tab with SUMIFS or QUERY.

Editorial illustration for Log expenses from your phone with a Google Form and Sheets

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?

  1. In Google Forms, start a blank form and call it Expense log.
  2. 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.
  3. Question 3: Category, type Dropdown, with your categories as options.
  4. Question 4: Payment mode, type Multiple choice with UPI, Card, Cash and Bank transfer.
  5. Question 5: Notes, type Short answer, not required.
  6. 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?

TimeWhat you submitRow that lands in the sheet
Morning₹60, Transport, UPIDate, 60, Transport, UPI
Lunch₹240, Dining out, CashDate, 240, Dining out, Cash
Evening₹1,150, Groceries, CardDate, 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.

SPENDIXAI JOURNAL

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

Explore your reports