Google Sheets doesn't charge a fee to create, share, or update a reimbursement tracker on a personal Google account. It stays free for that job. You type who paid the electric bill, who still owes for a weekend rental, and whether the IOU is pending. Sheets never sends the cash.
So are people really paying Google for a roommate spreadsheet? They're usually mixing a log with a payment app, while cash and bank transfers still move the money and the sheet only keeps score.
A regular Google login covers roommates, families, travel groups, and small clubs that just need a shared grid. Google Workspace is a separate paid product for organizations that want admin controls. You don't need that plan to split a $120 electric bill three ways.
What free actually covers
Personal Sheets files can be built, edited, commented on, and shared without a per-row charge. Version history sits under File. Range protection sits under Data. Those tools don't add a transaction fee because no payment runs through the grid.
Thing is, free tracking is not the same as free transfers. If Alex sends Jordan $40 after you mark a row Paid, that handoff follows the other app's rules. Keep the log and the payout as two steps.
| The sheet can do | You still do somewhere else |
|---|---|
| Record date, payer, amount, and status | Send the reimbursement |
| Split a bill and show a running net | Agree on equal vs custom shares |
| Hold comments, history, and a PDF export | Keep the original receipt |
Set up a household reimbursement tab
- Open a blank spreadsheet and name the first tab Expenses.
- In row 1 add Date, Description, Paid By, Amount, Split Count, Share Each, Status, and Receipt link.
- In F2 enter
=IF(E2="","",D2/E2)and fill down so each bill divides by the people on that charge. - Set Status with Data > Data validation. Allow Pending, Paid, and Overdue.
- Add a Balances tab and list each person in A2, A3, and A4 (widen the range if you have more names).
- In B2 put
=SUMIF(Expenses!C:C,A2,Expenses!D:D)for what they paid. If the same household is on every bill, C2 can be=SUM(Expenses!D:D)/COUNTA($A$2:$A$4)and D2=B2-C2. Copy those down. A positive net means the group owes that person.
Plenty of groups dump every column they can think of into row 1, category and proof and who ate the leftovers and a color for each roommate, and then nobody wants to type a grocery run because the form feels like homework; start with the eight headers above and add a Category column later if a trip actually needs flights vs meals.
Sample row: 01/15/2026, January electric, Alex, 120, 3, which yields 40 each, Pending. Review it weekly. One person updates after bills land. Conditional formatting can paint Overdue in red if you want a visual nudge.
Park trip receipt photos in a shared Drive folder. Paste the link in the last column. Don't paste the photo into the cell.
The simple net assumes everyone is in on every bill. If Taylor skips a dinner, log that row with Split Count 2 and don't fold it into the household-wide fair share. Uneven splits need their own share column, not a single headcount.
Share access without breaking the math
Click Share in the top right and invite people by email. Give active roommates Editor on the data columns if they log their own purchases. Everyone else can live as Commenter or Viewer so they can question a charge or just read the net.
Lock Share Each and the whole Balances tab with Data > Protect sheets and ranges. Leave Date through Amount and Status editable. In the Share dialog gear, uncheck Editors can change permissions and share unless you truly want extra invites.
Turns out "anyone with the link can edit" is how a well-meant tracker becomes a mess. Restrict the file to named emails for rent, deposits, and anything that could get awkward later. Have one roommate enter a test row, then ping the group chat that the sheet is live and their net is on the Balances tab.
Where the spreadsheet stops
Sheets will not send the payment. After you mark a row, send a plain request: "Per the sheet, you owe $40 for utilities. Send it to Alex when you can." Put proof in Drive, not six group threads.
There is no built-in overdue email, and you can chase people in the group chat for weeks or you can later wire a reminder through Extensions > Apps Script once the columns stop moving around, but skip that on day one while you're still deciding whether groceries belong on the same tab as rent. File > Version history is the audit trail if someone overwrites a number. File > Download gives you PDF or CSV if you need a snapshot.
A weekly roommate log or a single trip is a good fit. A committee that wants receipt scans and auto-collection every day will outgrow it. That's a product choice, not a Sheets failure.
Common slips to avoid:
- Giving every roommate Editor rights on formula cells
- Recording a payout as if it were a new household bill
- Leaving receipts only in chat
- Skipping protection on the Balances tab
FAQ
Does sharing a reimbursement sheet ever trigger a Sheets fee?
No. A personal Google account can share a household or trip log at no Sheets charge. Workspace is a different paid product for businesses and schools. The grid isn't billing you per split.
Is Google Sheets a safe place for IOU records?
It uses Google logins and the sharing list you set. Treat it like a shared notebook, not a bank. Named-email access and protected ranges beat a public edit link. Version history shows who changed what.
Which formula shows who is ahead?
On the Balances tab, Paid minus fair share is the net. =SUMIF(Expenses!C:C,A2,Expenses!D:D) totals what that person covered. Subtract their equal share of the household total when everyone is on every bill.
Can I use the export for taxes?
You can download PDF or CSV as a backup of the log. Keep original receipts too. This is not tax advice, and U.S. rules depend on the expense and your situation.
Copy those headers into a blank Sheet tonight. Share it with one person, lock the formula cells, and enter last week's bills before anyone tries to settle from memory. To be honest, most groups only needed the net column once it was visible.