Getting started

Daily expense tracker in Google Sheets: a template you can build today

Build a daily expense tracker in Google Sheets with dropdowns, monthly totals and formulas, plus variants for household, credit card, GST and multi-currency use.

Editorial illustration for Daily expense tracker in Google Sheets: a template you can build today

A good daily expense tracker in Google Sheets needs only one tab of entries and one tab of totals. Each row holds a date, an amount, a category, how you paid and a note. The totals tab then uses SUMIFS to add up each category for any month. You can build it in about twenty minutes and adapt the same skeleton for a household, a credit card, GST invoices or foreign currency.

Set up the Entries tab

Name the first tab Entries. Use these columns in row 1: A Date, B Category, C Amount, D Paid by, E Account, F Note. Enter your data from row 2 downward. Select column A and format it as a date (Format, Number, Date). Format column C as a number with two decimals.

  • Category: select B2:B500, then Data, Data validation, Dropdown, and list your categories such as Groceries, Rent, Transport, Eating out, Bills, Other.
  • Paid by: a dropdown of UPI, Cash, Debit card, Credit card.
  • Account: a dropdown of your bank and card names, so you can reconcile with each statement.

A dropdown matters more than it looks. 'Groceries' and 'grocery' count as different words to SUMIFS, so a typed category quietly breaks your totals.

Build the Summary tab with SUMIFS

On a tab called Summary, put the month start date in B1, for example 01-11-2026, and category names in A3 downward. In B3 enter:

=SUMIFS(Entries!$C$2:$C$500, Entries!$B$2:$B$500, $A3, Entries!$A$2:$A$500, ">="&$B$1, Entries!$A$2:$A$500, "<="&EOMONTH($B$1,0))

The first range is what is added up, then each pair is a range and its condition. Fill the formula down for every category. A grand total in B10 is =SUM(B3:B9). Change B1 to the first of another month and every figure updates.

How do I see today and this week?

  • Today's total: =SUMIFS(Entries!$C$2:$C$500, Entries!$A$2:$A$500, TODAY())
  • Last seven days: =SUMIFS(Entries!$C$2:$C$500, Entries!$A$2:$A$500, ">="&TODAY()-6)
  • Top categories in Google Sheets only: =QUERY(Entries!A2:F500, "select B, sum(C) where C is not null group by B order by sum(C) desc", 0)

QUERY is Google Sheets only. If you later move to Excel you will need pivot tables or SUMIFS instead.

Which tweaks suit a household, a credit card, GST or foreign currency?

VariantAdd this columnUse
HouseholdSpent by (Anita, Ravi, Kids)SUMIFS on that column to see who spends what
Credit cardBilling cycle (for example 'Nov cycle')Total per cycle to match each card statement
GSTTax rate and Net amountNet = gross / (1 + rate) and Tax = gross - net, with the rate copied from the invoice
Multi-currencyCurrency and Rate to INRINR amount = amount x rate, typed from the day's rate you used

A worked GST row: say an invoice totals ₹5,900 and the invoice shows a rate of 18%. Net is 5,900 / 1.18 = ₹5,000 and tax is ₹900. Always take the rate from the invoice, and treat the sheet as an estimate to confirm with your CA, because eligibility rules change.

For foreign currency, say you paid 40 USD for a subscription at an exchange rate of ₹83 that you noted from your card statement. The INR amount is 40 x 83 = ₹3,320. Record the rate your card actually used, not today's rate.

Keeping the sheet honest

Protect the Summary tab (Data, Protect sheets and ranges) so you do not overwrite formulas by accident. Freeze row 1 on Entries so headings stay visible.

When a sheet stops being enough

Typing every payment gets tiring by the third month, and category dropdowns do not learn from your history. If you would rather import bank or card statements and review rows than type them, SpendixAI takes PDF, CSV or Excel statements, and Pro lets you download reports as CSV. Until then, the sheet above is a perfectly good tracker.

A starting checklist

  1. Create Entries and Summary tabs.
  2. Set data validation for Category, Paid by and Account.
  3. Paste the SUMIFS formula and fill it down.
  4. Enter yesterday's spends from memory and your bank app.
  5. Reconcile the month-end total with the statement.
SPENDIXAI JOURNAL

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

Explore your reports