Free template
Shared expenses spreadsheet
A shared expenses spreadsheet needs four columns: date, description, who paid, and amount, followed by one share column per person. Each person's balance is then what they paid minus what they owe, using a SUMIF on the "paid by" column. This template already contains those formulas.
An .xlsx file, 4 KB. No signup, no email required. Works with Excel, LibreOffice Calc, Numbers and Google Sheets.
What is inside
A single sheet, three sample expenses to replace, and the balance formulas already written.
| Date | Description | Paid by | Amount | Alex | Jordan | Sam | Gap |
|---|---|---|---|---|---|---|---|
| 2026-08-01 | Groceries | Alex | 60 | 20 | 20 | 20 | 0 |
| 2026-08-01 | Fuel | Jordan | 45 | 15 | 15 | 15 | 0 |
| 2026-08-02 | Dinner | Sam | 90 | 30 | 30 | 30 | 0 |
| Person | Paid | Owes | Balance |
|---|---|---|---|
| Alex | 60.00 | 65.00 | -5.00 |
| Jordan | 45.00 | 65.00 | -20.00 |
| Sam | 90.00 | 65.00 | +25.00 |
How to use it
Three moves, and the spreadsheet keeps itself up to date.
1. Put the names at the top
Cells E5 to H5 hold the names. The balance formulas refer to them, so renaming someone takes a single edit.
2. One row per expense
Date, description, who paid, amount, then each person's share in their column. For an equal three-way split, just divide the amount by three.
3. Watch the Gap column
It reads 0 when the shares add up to the amount. Anything else means a row is mis-split. Most templates leave this column out.
What a spreadsheet will not do
This template is genuinely useful, and it will still die eventually. Better to know why before relying on it.
- One person keeps it up to date, and it is always the same person. The others never open the file.
- It needs a computer, while expenses happen at the restaurant or the petrol station.
- Two people editing at once create two versions, and nobody knows which one counts.
- It does not say who should pay whom: it gives balances, not the list of transfers.
- Past four people, you have to add columns and fix every formula by hand.
Key points
- A shared expenses spreadsheet is structured as one row per expense, with one share column per participant.
- A person's balance is what they paid minus what they owe, and the sum of every balance in a group is always zero.
- A SUMIF on the "paid by" column gives the total advanced by one person without sorting the rows.
- A gap column, equal to the amount minus the sum of that row's shares, immediately reveals a mis-split expense.
- A spreadsheet gives balances but not a settlement plan: turning balances into the minimum number of transfers requires a separate calculation.
- The .xlsx format is a ZIP archive of XML files, which is why Excel, LibreOffice Calc, Numbers and Google Sheets can all read it.
Frequently asked questions
How do you make a shared expenses spreadsheet?
Create one row per expense with the date, description, who paid and the amount, then one column per participant holding their share. Add a balance block at the bottom: what each person paid, computed with a SUMIF on the "paid by" column, minus the sum of their share column.
Does the template work with Google Sheets?
Yes. Import the .xlsx into Google Sheets and the formulas carry over as they are. It also works with LibreOffice Calc and Numbers.
Do you need to give an email to download it?
No. The file downloads directly, with no signup and no email.
How do you add a fifth person?
Insert a column after column H, copy the gap formula across, then add a row to the balance block reusing the formulas from the row above. This is the format's main limitation: past four people, upkeep becomes manual.
How do you know who should pay whom?
The spreadsheet gives balances, not transfers. You then have to match those who owe with those who are owed by hand, or use a calculator that finds the minimum number of transfers.
Why should the balances add up to zero?
Because every euro spent is both advanced by someone and owed by someone. If the check at the bottom does not read 0, a row is mis-split, and the Gap column shows which one.
Three weeks. That is the average lifespan of a shared spreadsheet.
Not because it is badly made, but because one person maintains it and expenses happen far from a computer. CountClub does the same thing, except everyone adds their own in ten seconds, from their phone.
- Everyone adds their own
- Balances always current
- Free