Free expense-splitting spreadsheet template (Excel and Google Sheets)
A free template for tracking and splitting shared expenses in Excel or Google Sheets, with every formula explained, plus an honest look at when a spreadsheet stops being enough.
A spreadsheet is a perfectly good way to split expenses with roommates, a partner, or a small trip group, and you do not need to build one from scratch. This page gives you a free, working template for Excel and Google Sheets, explains every formula in it so you can adapt it, and is honest about the point where a spreadsheet stops being the right tool.
The short answer
An expense-splitting spreadsheet needs just two core sheets. An Expenses sheet where every row is one expense: date, description, who paid, the amount, and one column per person holding their share of that expense (equal by default, editable for uneven splits). And a Balances sheet that computes three numbers per person: what they paid (a SUMIF over the payer column), what they owe (the sum of their share column), and the net, which is paid minus owed. A positive net means the group owes them money, a negative net means they owe the group. Our template adds the step most templates leave to you: a Settle up tab that turns those nets into instructions, who pays whom, in the fewest possible transfers. Download the free template here and rename the example people to your group; it works in Excel and imports cleanly into Google Sheets.
Download the template
Grab the file: expense-split-template.xlsx. It is free, has no macros, and asks for nothing in return. For Google Sheets, open sheets.google.com, then File, Import, Upload, and pick the file; the formulas, the dropdowns, and the Settle up tab all work as-is.
The template ships with three example people (Sam, Riya, Tom) and a week of example expenses so you can see the formulas working before you clear it out. Rename the people once on the Balances tab and everything else follows: the share columns, the who-paid dropdown, the settle-up math. It supports up to six people, flags any row where the shares stop adding up, and totals spending by category on the side.
What is inside: the columns
| Column | What goes in it | Example |
|---|---|---|
| Date | When the expense happened | 2026-07-04 |
| Description | What it was | Dinner out |
| Category | Optional grouping for later review | Food |
| Paid by | Exactly one name, spelled like the Balances sheet | Riya |
| Amount | The full amount paid | 90.00 |
| One share column per person | That person's slice of this expense, filled in automatically as an equal split; type over it for uneven splits, a percentage like =E2*40%, or 0 if not involved | 30.00 |
| Row check | Shows CHECK in red when a row's shares do not add up to the amount | OK |
| Notes / receipt link | Optional: paste a link to the receipt photo so nobody has to ask what a number was | (a link) |
The formulas, explained
Three formulas do all the work, and they are worth understanding so you can extend the sheet yourself.
What each person paid. On the Balances sheet: =SUMIF(Expenses!$D$2:$D$201, A2, Expenses!$E$2:$E$201), which reads: total the Amount column for every row where Paid by matches this person's name.
What each person owes. Simply the sum of their share column: =SUM(Expenses!F$2:F$201). The template pre-fills 200 expense rows with share formulas, so balances stay right no matter how many rows you fill. Because shares are entered per expense, uneven splits and sat-out expenses are already handled.
The net. =Paid - Owes. Positive means the group owes them, negative means they owe the group. The nets always sum to zero across the group, and the template checks this for you: a Balanced indicator under the nets, plus a Row check column on the Expenses sheet that flags the exact row where shares stopped adding up to the amount.
Worked example
Sam, Riya, and Tom share a holiday week, splitting everything equally. Five expenses, $465 in total, so each person's fair share is $155:
| Expense | Amount | Paid by | Each person's share |
|---|---|---|---|
| Groceries | $60 | Sam | $20 |
| Dinner out | $90 | Riya | $30 |
| Taxi | $30 | Tom | $10 |
| Vacation rental | $240 | Sam | $80 |
| Drinks | $45 | Riya | $15 |
The Balances sheet then shows: Sam paid $300 and owes $155, net +$145. Riya paid $135 and owes $155, net -$20. Tom paid $30 and owes $155, net -$125. Settling takes two transfers: Tom sends Sam $125, Riya sends Sam $20, and everyone is at zero.
Who pays whom: the Settle up tab
Nets are still one step short of instructions, so the template does the last step for you. The Settle up tab applies a simple greedy rule: the biggest debtor pays the biggest creditor, then repeat until everyone is at zero. For the example above it outputs exactly the two transfers listed: Tom pays Sam $125, Riya pays Sam $20. A group of six never needs more than five transfers. This is the same debt simplification apps advertise as a feature, running in plain spreadsheet formulas (MIN, MAX, INDEX, MATCH) that you can unhide and inspect.
Where spreadsheets break down (honestly)
For two or three people with a handful of monthly expenses, this template is genuinely all you need. But spreadsheets have a failure mode: they depend on someone doing data entry after the fact, and that someone is usually one diligent person who slowly becomes the group's unpaid accountant. The common breaking points:
- Entry lag: expenses pile up in pockets and camera rolls, then someone spends Sunday evening transcribing receipts.
- Multiple currencies: a trip through two countries means manual exchange-rate lookups on every row.
- No receipts: the sheet says $90, but nobody can check what the $90 was when a number gets questioned.
- Visibility: on phones, shared sheets are read-mostly, so in practice one person edits and everyone else trusts.
When you hit those points, the fix is capture at the moment of spending rather than better formulas. HippoSplit runs the same ledger as a group chat: type "lunch 24.50 split with Anna and Ben" as a normal message and it is logged, or post a photo of the receipt straight into the chat, like sending a picture to friends, and the AI reads it and logs the expense with items, amounts, and currency. The balances everyone sees are computed by the backend, the same paid-minus-owes math as this template, just with nobody doing the typing, and it handles 150+ currencies with live rates.
Frequently asked questions
Does the template work in Google Sheets?
Yes. Import the Excel file via File, Import, Upload and everything works: the formulas, the who-paid dropdowns, the red and green highlighting, and the Settle up tab behave identically in both tools. Google Sheets is the better choice if the whole group should be able to view it from a link.
How do I handle an uneven split in the template?
Overwrite the share formulas on that row with typed amounts. For a $90 dinner where one person had $40 of it, type 40 in their column and 25 in each of the others. Just make sure the row's shares add up to the amount.
How do I add a fourth person?
Type their name in the next empty row on the Balances tab. Their share column appears on the Expenses sheet automatically, new expenses split across the bigger group, and the who-paid dropdown picks them up. Up to six people work this way with no formula editing. One thing to know: equal-split formulas re-split older rows too, so if someone joined partway through, type 0 in their column on the rows from before they joined; the Row check column flags each row until its shares add up again.
Can a spreadsheet handle multiple currencies?
Only manually: add a currency column and a rate column, and convert each row into one settlement currency. It works but is exactly the kind of upkeep that makes trip spreadsheets die mid-trip; our trip expense guide covers the alternative.
Is the template really free?
Yes, no email, no signup, no macros. It is a plain Excel file. We make HippoSplit, so our hope is simply that if the spreadsheet ever starts feeling like work, you will remember who gave it to you.
Get the template, or skip the spreadsheet era entirely
Download the template and set it up in five minutes, or start a free HippoSplit group and let the receipts log themselves. Either way, agree the split method up front; our guide to splitting group expenses fairly helps your group pick.