Codeinate
Find your tool

Menu

How to track expenses in Google Sheets™, step by step

You can build a working expense tracker in about ten minutes: five columns, one formula for the running balance and two for the totals. Here is each step, and an honest look at where a hand-made sheet starts to hurt.

Updated By the Codeinate team

Try Splendly now

What you will build

  • One simple table

    Date, category, note, amount and balance. One row per expense or payment received.

  • A running balance

    One formula, copied down, shows what is left after every row.

  • Totals by category and by month

    Two short formulas add up what you spent on groceries, or in November, without any manual sums.

  • Shared when you want

    Share the sheet with the people who add entries, as editors, or as viewers who can only look.

A good fit: You are tracking your own money, or a small shared pot, and you like to understand every cell.

Not the best fit: Many people add entries from their phones, you need receipts next to each entry, or you want reports and a PDF without building them. For that, see Splendly.

Build it in six steps

  1. 1

    Make the sheet

    Open Google Sheets™ and start a blank sheet. In row 1 type these headings, one per column: Date, Category, Note, Amount, Balance.

  2. 2

    Decide how to write money in and money out

    Type money you spend as a negative number, for example -12.50, and money that comes in as a positive number, for example 300. Then every sum works without extra rules.

  3. 3

    Add the running balance

    In cell E2 type =SUM($D$2:D2) and press Enter. Copy that cell down the column. Each row now shows the total of every amount from row 2 down to that row.

  4. 4

    Add totals by category

    Make a second tab called Totals. In column A list your categories. In B2 type =SUMIF(Sheet1!$B:$B, A2, Sheet1!$D:$D) and copy it down. It adds the amounts of every row whose category matches.

  5. 5

    Add a total for one month

    In any empty cell type =SUMIFS(Sheet1!$D:$D, Sheet1!$A:$A, ">="&DATE(2026,11,1), Sheet1!$A:$A, "<"&DATE(2026,12,1)). Change the two dates to the month you want. The result is the net of that month.

  6. 6

    Share it

    Press Share, add the email addresses of the people who should add entries, and give them Editor access. Give people who only need to look Viewer access.

When an app on top of the same idea makes sense

Splendly keeps the same idea: your entries are rows in a Google Sheets™ file in your own Google Drive™. On top of it the app gives you a form for each entry with a category picker, a running balance for every book, receipts attached to entries, owner, editor and viewer roles, an activity log, reports and a PDF statement. New entries also wait on your phone when there is no signal.

  • It does not connect to a bank, and it has no budgets or reminders.
  • It does not split bills or say who owes whom.
  • You can try it with sample data first, without signing in. Try Splendly.

What the table looks like (made-up numbers)

These rows are an example, not real data.

What the table looks like (made-up numbers)
DateCategoryNoteAmountBalance
2026-11-01SalaryNovember pay3000.003000.00
2026-11-02GroceriesWeekly shop-64.802935.20
2026-11-03RentNovember rent-1200.001735.20
2026-11-04FuelTank-42.301692.90

Where a hand-made sheet starts to hurt

  • Formulas live in cells, so anyone with edit access can overwrite one by accident. One changed cell can shift every balance below it.
  • Sorting or deleting rows can break formulas that were not set up with care. Check the balance after you change the order.
  • Typing into cells on a phone is slow, and there is no category picker, so categories drift (Groceries, groceries, Grocery).
  • A receipt has to be uploaded to Google Drive™ and its link pasted into the row by hand.
  • Google Sheets™ keeps a version history, but there is no list of who changed what next to each entry.
  • None of this is wrong. It is the price of building it yourself, and for one person it is often a fair price.

Questions people ask

What is the simplest expense tracker in Google Sheets?

A table with five columns: Date, Category, Note, Amount and Balance. Type spending as negative numbers and income as positive numbers, and use =SUM($D$2:D2) in the Balance column.

How do I add up expenses by category in Google Sheets?

Use SUMIF. For example =SUMIF(Sheet1!$B:$B, "Groceries", Sheet1!$D:$D) adds every amount in column D whose category in column B is Groceries.

How do I get the total for one month?

Use SUMIFS with two date conditions: =SUMIFS(Sheet1!$D:$D, Sheet1!$A:$A, ">="&DATE(2026,11,1), Sheet1!$A:$A, "<"&DATE(2026,12,1)). Change the dates to the month you need.

Can two people use the same expense sheet?

Yes. Press Share and add them as Editors. Anyone with Editor access can change any cell, including the formulas, so many people choose Viewer access for those who only need to look.

Can I track expenses on my phone with Google Sheets?

Yes, with the Google Sheets™ app or a browser. It works, but typing into cells is slow and there is no category picker. An app such as Splendly gives you an entry form instead.

How do I keep receipts with my expenses?

Upload the photo or PDF to Google Drive™, copy its link, and paste the link into the row. With Splendly the receipt is attached to the entry and saved in a folder in your Google Drive™.

Do I need Splendly to track expenses?

No. A hand-made sheet works well for one person. Splendly is for when many people add entries, when you want receipts, roles and reports without building them, or when you add entries from a phone.

Google Sheets, Google Drive, Android and Google Play are trademarks of Google LLC. Splendly is not affiliated with or endorsed by Google.