Daily Expenses Tracker in Google Sheets: How to Set It Up

Yes—you can make a daily expenses tracker in Google Sheets by recording each purchase on its own row, then using SUM and SUMIF formulas to total spending by day, category, or month. In a browser, create a blank sheet, add columns for date, description, category, payment method, and amount, and enter expenses as they happen; the setup below adds useful summaries without requiring a paid budgeting app.

What a daily expenses tracker does

A tracker is a record of money spent, not a bank account or a financial plan. Its main job is to make purchases visible: what you paid, when you paid it, and what kind of expense it was. A basic sheet can answer practical questions such as how much you spent today, how much went to groceries this month, or whether your recorded expenses match the transactions on a bank statement.

Google Sheets is useful for this because it works in a web browser, saves changes to Google Drive, and supports formulas, filters, charts, and collaboration. You can open the sheet on a phone as well as a computer, though entering a long list is usually easier on a larger screen. A spreadsheet is flexible, but it will not automatically know about purchases unless you enter or import them.

Choose columns that make recording easy

Start with one tab called Transactions. Put these headings in row 1, then enter one expense per row. Keeping the transaction table simple matters: an entry should take only a few seconds, or the tracker can become a chore.

Date: the date the purchase happened. Use a real date value, not text that only looks like a date.
Description: a short label such as “weekly groceries” or “bus fare.”
Category: a consistent group, such as Groceries, Transport, Housing, or Dining.
Payment method: optional; examples include debit card, cash, or credit card.
Amount: the amount spent, entered as a positive number.
Need/want: optional, if distinguishing essential from discretionary purchases helps you review habits.
Notes: optional details, such as who shared a bill or whether a purchase was reimbursed.

For example, a grocery purchase on November 1 could be recorded as 2026-11-01, “weekly groceries,” Groceries, Debit card, 42.60. Use the currency that makes sense for your records and format the amount column through Format > Number > Currency. If you use multiple currencies, add a currency column rather than totaling unlike amounts as if they were the same unit.

Build the sheet in Google Sheets

Open Google Sheets in a web browser and create a blank spreadsheet. Rename the file with a clear name, such as “Daily expenses.”
Enter the column headings in row 1. Select the header row and use bold text or a fill color so it is easy to distinguish from entries.
Freeze the headings with View > Freeze > 1 row. The labels will remain visible while you scroll through a longer list.
Format the Date column as a date and Amount as currency. Use Format > Number to choose the appropriate display format.
Enter each expense on a new row. Keep the same category spelling each time; “Dining” and “Eating out” will otherwise be treated as separate categories.
Turn on a filter using Data > Create a filter. The filter controls let you show a particular month, category, or payment method without deleting other records.

Use a separate row for each purchase rather than placing several expenses in one cell. If a supermarket receipt contains groceries and household supplies that you want to track separately, you can split it into two rows, provided the two amounts add up to the receipt total. If category detail is not important to you, record the whole receipt as one grocery transaction instead. A useful tracker is one you can maintain consistently.

Calculate daily and monthly totals

Suppose the Date column is A, Description is B, Category is C, Payment method is D, and Amount is E. With amounts in E2:E5 of 42.60, 6.00, 4.75, and 18.20, enter this in an empty cell to total those four sample expenses: =SUM(E2:E5). It returns 71.55. Keep summary cells outside the transaction columns so they are not accidentally included in the data table or counted twice.

To total one date, put the date you want to review in H2. With dates in A2:A and amounts in E2:E, use this formula in I2: =SUMIF($A$2:$A,H2,$E$2:$E). If the first three example transactions are dated November 1, 2026, and the fourth is dated November 2, the November 1 total is 53.35: 42.60 + 6.00 + 4.75. The dollar signs keep the source ranges fixed if you copy the formula to other summary rows.

For a month summary, put a real first-of-the-month date in B2—for example, November 1, 2026—and use this formula in B3, with transaction dates in A2:A and amounts in E2:E: =SUMIFS($E$2:$E,$A$2:$A,">="&B2,$A$2:$A,"<"&EDATE(B2,1)). For the four sample expenses dated November 1 and 2, it returns 71.55. The start-of-month condition includes November 1; the less-than condition excludes December 1 and later. This pattern works for months of different lengths.

To total a category, put a category label such as Groceries in H4. With category labels in C2:C and amounts in E2:E, use =SUMIF($C$2:$C,H4,$E$2:$E). If the 42.60 and 18.20 entries are both labeled Groceries, the result is 60.80. These formulas use standard Google Sheets functions. Excel has equivalent SUM, SUMIF, and SUMIFS functions, but its menu layout and some sharing features differ; the menu paths above refer to Google Sheets in a browser.

Make entries consistent with dropdowns and formatting

Categories are easiest to summarize when people use the same labels. You can type a short list of categories on a second tab named Lists, select the category entry cells, and choose Data > Data validation to create a dropdown from that list. The exact controls shown may change as Google updates its interface, but Data validation is the relevant Sheets feature. A dropdown reduces spelling variations and makes it quicker to enter routine purchases.

Keep the list short enough to use. A starting set might include Housing, Groceries, Dining, Transport, Utilities, Health, Shopping, Entertainment, and Other. Add a category only when it answers a question you genuinely want to ask. Too many narrow categories make recording slower and can leave you with tiny totals that are hard to interpret.

Conditional formatting can draw attention to unusually large entries or a daily limit, but it does not verify that a transaction is correct. Choose Format > Conditional formatting to set a rule for a range. For example, you could highlight amounts above a threshold you choose. Treat the highlight as a review prompt, not proof of overspending: a large rent payment may be expected, while a smaller duplicate charge may be the one worth checking.

Review the record and keep it accurate

Entering a purchase promptly helps reduce forgotten cash expenses and vague descriptions. A practical routine is to add transactions daily or several times a week, then compare the sheet with receipts or account activity at a regular interval. Reconciliation means checking that the entries correspond to real transactions and that amounts and dates are plausible; the spreadsheet cannot perform that check on its own.

Check that dates are actual dates, especially after pasting data from another source.
Compare totals with bank or card activity, allowing for pending transactions and different posting dates.
Look for duplicates before adding an imported statement to manually entered records.
Record refunds as negative amounts if your goal is to calculate net spending, or use a separate Refunds column and summary approach. Choose one method and apply it consistently.
Keep transfers between your own accounts separate from purchases so they are not mistaken for spending.

There is no universal rule for whether a transaction belongs on its purchase date or its account posting date. Choose one convention and use it consistently. If you care about matching a statement, posting dates may be convenient; if you care about when you made a purchase, transaction dates may be more meaningful. Writing the convention in a note at the top of the sheet can prevent confusion later.

Common problems and useful fixes

A total that seems too low often comes from amounts stored as text, an incomplete formula range, or inconsistent dates. Click a sample amount and check whether it behaves like a number; reformatting text as currency alone may not convert text into a numeric value. If a formula covers only E2:E20, purchases below row 20 will not be included. Open-ended ranges such as E2:E can include later rows, but avoid placing unrelated numbers far down the same column.

Dates can also be misleading. A value that looks like “11/01/2026” may mean November 1 or January 11 depending on regional settings and how it was entered. Use an unambiguous date entry or confirm the sheet’s locale under File > Settings. When summing a month, the cells in the date column must contain valid date values for the date conditions to work as intended.

Another common misconception is that a monthly total is the same as a budget. A total reports recorded spending; a budget is a target or limit you choose separately. If you want a simple comparison, place a monthly target in one cell and subtract actual spending from it. The target is an assumption you set, not a recommendation from Google Sheets, and the result is only as complete as your transaction records.

Costs, privacy, and alternatives

Google Sheets is available through a Google account, and ordinary spreadsheet creation does not require buying a dedicated expense-tracker template. Account storage limits and Google Workspace plans can affect storage or organizational features, so check current Google account terms if those details matter to you. A template can save setup time, but inspect its formulas, sharing settings, and any add-ons before entering sensitive information.

Because expense records can reveal routines and purchases, review who can access the file. Google Drive sharing controls let you choose whether a file is restricted or shared with specific people; avoid public-link access for personal financial records. Use a strong account password and available account security protections. A sheet is not a bank connection, and it should not be treated as a secure place to store full card numbers, passwords, or account credentials.

Alternatives include a notes app for a very small number of cash purchases, a budgeting app if automatic account imports and built-in reports are important, or a desktop spreadsheet if you prefer local files. Automatic imports can save manual entry but may require permissions, supported financial institutions, or a paid plan. Compare privacy, fees, export options, and how corrections are handled before choosing. Sheets is a good fit when you value customization and are willing to maintain the entries yourself.

Frequently Asked Questions

Does Google Sheets have a free expense tracker template?
Google Sheets may offer templates through its template gallery, and third-party templates are also available. Availability can change. You can also build a basic tracker from a blank sheet using the columns and formulas above, which makes it easier to understand how the totals are calculated.

Can Google Sheets automatically track my purchases?
Not by itself. A blank spreadsheet does not connect to your bank or detect card purchases. You need to enter transactions or import data from another source, then check for duplicates and errors. Any third-party connection or add-on should be reviewed for permissions and privacy before use.

How do I track expenses by month in Google Sheets?
Keep transaction dates in one column and amounts in another, then use SUMIFS with a start date and the first day of the following month as the end boundary. The example above uses EDATE to calculate that next-month boundary, so it handles shorter and longer months without manually changing the date range.

Should I record income in the same tracker?
You can, but label each row clearly as income or expense and design the summary formulas to distinguish them. For a simpler expense-only sheet, keep income on another tab or in a separate table. Do not add income to an expense total without accounting for the difference.

Can I use the tracker on my phone?
Yes. Google Sheets can be accessed on mobile devices, although the interface and data-entry experience differ from the browser version. For frequent phone entry, keep columns concise and categories controlled with a short list. Review formulas and summaries on a larger screen when needed.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.