How to Make a Google Form Expense Tracker

A Google Form expense tracker is a short form you open on your phone to log each expense, linked to a Google Sheet that keeps the list and adds it up. It is a simple expense tracking form that covers what most people need. Logging takes a few seconds, so you are more likely to keep doing it. The Sheet does the totals by category and by month. Below you build both, put the form one tap away on your phone and see where Google Forms stops.

How to make an expense tracker in Google Forms

Keep the form to five or six questions. Every extra question makes it less likely you will log a small expense like a coffee.

1. Create the form

   Go to forms.google.com and start a blank form. Name it something you will recognize on a phone screen, such as Expenses.

2. Limit the Amount question to numbers

   Amount needs a number-only rule. Without it, an entry typed as $12.50 is stored as text. SUM skips text, so that expense quietly drops out of every total.

   Add a short answer question called Amount. Click the three-dot menu at the bottom right of the question and choose Response validation. Pick Number, then Greater than, then enter 0. In the custom error text, ask for digits only with no currency symbol. Google's rules page covers the options.

3. Add Date and Category

   Add a Date question so you can log yesterday's expense today. Add a Dropdown question called Category with your own list, such as Food, Transport, Bills, Shopping and Other. A dropdown keeps the spelling identical every time, which is what the category totals depend on. Make all three questions required.

4. Add a payment method and a note

   A multiple choice question with Cash and Card as options helps if you reconcile against statements. A short answer question called Note, not required, holds the shop name.

5. Decide about receipts

   A File upload question lets you attach a photo of the receipt. Google requires everyone who fills in the form to sign in to a Google account for it. The question is also not available on forms stored in a shared drive. For a personal tracker on your own account that is fine. For a form a partner or a team uses, leave receipts out unless everyone has a Google account.

6. Link the form to Google Sheets

   Open the Responses tab and click Link to Sheets in the top right. Choose Create a new spreadsheet. Every submission now becomes a row, with a timestamp in column A and your questions in the order you added them. Our guide on linking Google Sheets to Google Forms covers linking to a sheet you already have.

How to make the Sheet add it up

Do the math on a second tab, never in the response tab. Google inserts a new row for each submission. Formulas placed in that tab can shift or break. The formulas below assume Amount is your first question (column B), Date the second (column C) and Category the third (column D). Adjust the letters if your order differs.

If you turn on Collect email addresses (covered below), Google adds an Email Address column at B and every letter moves one to the right: Amount becomes C, Date D and Category E.

1. Add a Summary tab

   Click the plus at the bottom left of the Sheet to add a tab and name it Summary.

2. Total everything

   In any cell, enter the total for all expenses logged so far:

   =SUM('Form Responses 1'!B:B)

3. Total by category

   List your categories in column A of the Summary tab, one per row, spelled exactly as they are in the dropdown. In B2, next to the first category, enter:

   =SUMIF('Form Responses 1'!D:D, A2, 'Form Responses 1'!B:B)

   Fill the formula down. Each row now shows that category's total and keeps updating.

4. See it by month

   Select the response tab's columns by clicking the column letters, so new rows are included, then choose Insert, then Pivot table. Place it on the Summary tab. Add Date to Rows, right-click a date in the pivot and choose Create pivot date group, then Month. Add Amount to Values as SUM. You get one line per month with the spend for that month.

5. Add a chart if you want one

   Select the category table, choose Insert, then Chart, then pick a pie chart. It redraws as the totals change. The same steps, with more detail on styling, are in our post on pie charts from Google Forms responses.

This Summary tab is the expense tracker Google Sheets users build by hand. Here you never type into the spreadsheet, because the form fills the response tab for you.

How to log an expense in a few seconds from your phone

The tracker only works if logging is quick. Put the form one tap away.

• Add the form to your home screen.
  1. Click Publish.
  2. Click Published, then Copy responder link.
  3. Open the link on your phone.
  4. Chrome on Android: open the menu and choose Add to Home screen. Safari on iPhone: tap Share, then Add to Home Screen.
  The icon opens the form directly.
• Make a pre-filled link for a recurring expense.
  1. In the form editor, open the three-dot More menu and choose Pre-fill form.
  2. Pick the category and payment method you use most.
  3. Click Get link and save it as a second home-screen icon.
  You then type the amount and pick the date. Our Google Form auto filler post explains how pre-filled links work.
• Stay signed in to Google on your phone. Google keeps a half-finished entry as a draft for 30 days when you are signed in, so an interrupted log is not lost. Our post on whether Google Forms saves progress covers the conditions.

How to share the tracker with a partner or a team

One form can take entries from many people. Send them the same responder link, not the editor link, which would let them change the questions. Open Settings and expand Responses.

• Collect email addresses records who logged each expense. Turning it on adds an Email Address column to the Sheet, so check your Summary formulas afterwards. Leave it off for a household tracker where that does not matter.
• Allow response editing lets people fix their own typo later through the link on their confirmation page.

Share the linked Sheet with anyone who should see the totals. For a personal or household tracker, the linked Sheet is the shared view and the form is only the entry point. For a Google Form expense report at work, where each claim needs a manager's approval and a reimbursement record, see our post on automating expense reimbursement with forms.

What Google Forms cannot do as an expense tracker

• Show a running total. The form knows nothing about earlier entries. Totals live only in the Sheet.
• Take receipts from people without a Google account. The File upload question forces a sign-in.
• Route an expense for approval. There is no approval step, so an expense report Google Form cannot hold a claim for a manager. Every submission is final as soon as it is sent.
• Format currency. Amount is a plain number until you format the column in the Sheet.
• Let someone correct an entry unless you turned on response editing before they submitted.
• Warn you about a budget. No alerts, no limits per category, so a Google Forms budget tracker still needs a conditional format in the Sheet to flag overspend.

Where Formester fits

For a personal tracker, the Google Forms and Sheets setup above is enough. The gaps show up when a team uses a Google Form for expenses. Formester's expense report form template comes with expense categories and a receipt upload that needs no Google account from the person submitting. On the Personal plan and up, conditional logic can show only the fields for each expense type.

On the Business plan, each submission can be exported as a PDF or attached to the confirmation email, which gives finance a record per claim. For approvals and reimbursement, the automation post linked above walks through the full workflow.

Related reading

• Link Google Sheets to Google Forms, including linking to a sheet you already use.
• Google Form auto filler, for the pre-filled links behind the one-tap shortcut.
• Make a pie chart in Google Forms, for the spending chart.
• Automate expense reimbursement with forms, for the team version with approvals.