Group expense tracker Google Sheets template for shared editing

How to use this template

One shared file carries the whole group’s expenses. It has three tabs: Members, Log and Balances. Print the grids or copy them into a new sheet.

1. Type the names once. On the Members tab, write each person’s name exactly as everyone will type it. Two people with the same first name get a last initial.
2. Choose who can edit. As of October 2026, Google Sheets lets you control who can view, comment or edit a spreadsheet, and several people can work in the same file at the same time. Give edit access to the people who log expenses and comment access to the rest.
3. Enter one row per expense, at the bottom of the Log tab, on the day it happens. The person who paid enters it.
4. Name a checker. One person reads new rows each week and writes their initials in the Checked column. Someone else checks the checker’s own rows.
5. Read Balances at the end of the period. It adds up what each person paid and their fair share. The difference is their balance, and the balances total zero.
6. Settle, then start a fresh Log. Keep the old tab and put the period in its name.

The template

Members tab

In from and Out after hold dates, so a row can list only the people who were in the group that day.

Member	In from	Out after

Log tab

For a row everyone shared, “All 5” is enough in Shared by. Otherwise list the names.

Date and what	Amount	Paid by	Shared by	Checked

Balances tab

Paid is the total of the Amount cells in the rows the person paid. Fair share is the total of their portion of each row they shared. Balance is paid minus fair share.

Person	Paid	Fair share	Balance
Total			Must be 0

A filled example: five friends, three game nights

Say Mia, Noah, Omar, Priya and Quinn split a weekly game night. Priya and Quinn skipped the drinks on October 3, and Omar skipped the pizza on October 17. Mia is the checker and Noah checks her rows.

Date and what	Amount	Paid by	Shared by	Checked
Oct 3, room booking	40.00	Mia	All 5	Noah
Oct 3, pizza	52.50	Noah	All 5	Mia
Oct 3, drinks	18.75	Omar	Mia, Noah, Omar	Mia
Oct 10, room booking	40.00	Mia	All 5	Noah
Oct 10, snacks	27.00	Priya	All 5	Mia
Oct 10, new board game	60.00	Quinn	All 5	Mia
Oct 17, room booking	40.00	Noah	All 5	Mia
Oct 17, pizza	45.00	Priya	Mia, Noah, Priya, Quinn

The last row has no initials yet. Balances counts every row, checked or not, so settle only once the Checked column is full. Omar’s fair share is 8.00 + 10.50 + 6.25 + 8.00 + 5.40 + 12.00 + 8.00, which is 58.15.

Person	Paid	Fair share	Balance
Mia	80.00	69.40	owed 10.60
Noah	92.50	69.40	owed 23.10
Omar	18.75	58.15	owes 39.40
Priya	72.00	63.15	owed 8.85
Quinn	60.00	63.15	owes 3.15
Total	323.25	323.25	0

Both columns total 323.25, the sum of the Amount cells. Settling takes four payments. Omar pays Noah 23.10, Mia 10.60 and Priya 5.70, and Quinn pays Priya 3.15.

What to agree on

Who edits, and the way back

Each extra editor is one more person who can overwrite a row by accident. As of October 2026, Google Sheets has revision history that can revert a sheet to an earlier version, and that is the way back after a bad edit. A mistake is easiest to undo the day it happens.

Names and new rows

A name spelled “Dan” in one row and “Daniel” in another becomes two people in Balances. Copy names from the Members tab and add new rows at the bottom, never in the middle. To fix a mistake, correct the cell and add “fixed” and your initials to the Date and what cell, so the checker sees it.

Late joiners and leavers

Fill In from and Out after on the Members tab, and list people by name in Shared by for any row dated near a change. Writing “All 5” on a day when only four were in the group makes the fifth person owe for a cost they were never part of.

When the sheet stops being worth it

A sheet works while most rows are shared by everyone equally. When rows are shared by different subsets of people or split by percent, each one is a hand calculation. EvenOut does that split per expense, with five methods (equally, exact amounts, percent, shares or by item), and works offline. People who are not on it yet can be added to a group as guests. “Simplify debts” is on by default and reshuffles who pays whom so a group settles in the fewest payments with every total unchanged.

The formulas for each person’s paid total, share and net, with a check that the nets add up to zero, are on the split expenses spreadsheet template. If you would rather use an app, the best group expense tracker apps compares the options, and how to split expenses walks through the five split methods.