A Google Sheet works well for a small shared-expense group if it separates two things: the bill itself and the later payment that settles it. Put rent, groceries, utilities, or trip costs on Expenses; put Venmo transfers on Settlements. That prevents the most common error: counting a $40 repayment as another $40 expense.
Use a person's regular name in formulas and keep their Venmo handle in a reference field. The sheet can calculate what the group says is owed, but it cannot verify that a payment was sent or received.
Start with three tabs
Create a blank spreadsheet with these tabs:
| Tab | Put these records here | Do not put here |
|---|---|---|
Expenses |
Original bills and purchases paid for the group | Venmo repayments |
Settlements |
Payments from one participant to another | The original bill |
Summary |
Balances, checks, and category totals | Manual transaction edits |
Turns out, the cleanest tracker is usually the least clever one. Keeping expenses and repayments apart makes every row easier to audit.
Give the file a name your group will recognize, such as Group Expenses. Add the participant names before entering transactions.
Build the Expenses tab
Use one row for each shared charge. Format the date as a date and the Amount and share columns as currency.
The share columns below contain dollar amounts, not percentages. That approach handles cents more reliably.
| Column | Header | Purpose |
|---|---|---|
| A | Date | Date the expense occurred |
| B | Description | What the group purchased |
| C | Category | Rent, Utilities, Groceries, Travel, or another label |
| D | Amount | Full cost of the bill |
| E | Paid by | Participant who paid upfront |
| F | Split method | Equal, Usage, Nights, Income-based, or Custom |
| G | Alex | Alex's share of the cost |
| H | Jordan | Jordan's share of the cost |
| I | Taylor | Taylor's share of the cost |
| J | Check | Confirms the shares equal the amount |
| K | Receipt or reference | File name, private link, or payment note |
Replace Alex, Jordan, and Taylor with your group's names. Use the exact same spelling in every tab.
For example, a $120.50 utility bill split three ways could look like this:
| Date | Description | Category | Amount | Paid by | Split method | Alex | Jordan | Taylor | Check |
|---|---|---|---|---|---|---|---|---|---|
| 01/15/2026 | Electric utility | Utilities | 120.50 | Alex | Equal | 40.17 | 40.17 | 40.16 | OK |
In J2, add this check formula and copy it down:
=IF(D2="","",IF(ROUND(SUM(G2:I2),2)=ROUND(D2,2),"OK","Check shares"))
For percentage-based splits, calculate the dollar shares in the participant columns. For a three-way equal split, use =ROUND($D2/3,2) in G2 and H2, then use =ROUND($D2-SUM(G2:H2),2) in I2. The last formula absorbs the rounding cent.
Use dropdowns for Paid by, Category, and Split method. A mismatch such as Alex in one row and @alexsmith in another can make the formulas treat one person as two people.
Pick a split rule before money moves
The fairest method depends on what the expense represents. Write down the rule before someone pays.
| Split method | Works well when | Example |
|---|---|---|
| Equal | Everyone receives roughly the same benefit | A shared dinner or group admission |
| Usage-based | People use different amounts | Utilities or shared supplies |
| Nights-stayed | Trip participants stay for different lengths of time | Vacation rental or hotel |
| Room-size or space-based | Private space differs | Roommate rent |
| Income-based | The group explicitly agrees to a contribution ratio | A household budget |
| Custom | One person is excluded or an exception applies | A gift or expense someone did not join |
Income-based sharing is a group agreement, not an automatic fairness rule. The same applies to room size, nights stayed, and usage estimates.
The person who pays the bill still enters a share for themselves. Alex paid the full $120.50 utility bill, but Alex's own $40.17 share is not owed back to Alex.
Record Venmo payments on Settlements
Create a separate Settlements tab with one row per actual payment.
| Column | Header | Purpose |
|---|---|---|
| A | Date | Date the payment was sent |
| B | From | Person who sent the money |
| C | To | Person who received the money |
| D | Amount | Actual payment amount |
| E | Method | Venmo, Cash, or another method |
| F | Expense reference | Bill, trip, or date covered |
| G | Note | Partial payment or other detail |
For example:
| Date | From | To | Amount | Method | Expense reference | Note |
|---|---|---|---|---|---|---|
| 01/20/2026 | Jordan | Alex | 40.17 | Venmo | Utilities 01/15/2026 | January utility share |
Keep settlement amounts positive. The From person gets credit for paying down a balance, while the To person's amount to collect decreases.
A partial payment gets its own row. If one Venmo transfer covers several bills, use one settlement row for the full transfer and list the covered bills in the note. Never create a second expense row for the payment.
If someone only promises to pay, do not count that promise as a completed settlement. Keep it in a note until the transfer is actually sent.
Build the Summary and paste the balance formula
On Summary, list one participant per row:
| Cell | Value |
|---|---|
| A1 | Person |
| B1 | Net balance |
| C1 | Interpretation |
| A2:A4 | Alex, Jordan, Taylor |
For Alex in B2, use:
=SUMIF(Expenses!$E$2:$E$100,"Alex",Expenses!$D$2:$D$100)-SUM(Expenses!$G$2:$G$100)+SUMIF(Settlements!$B$2:$B$100,"Alex",Settlements!$D$2:$D$100)-SUMIF(Settlements!$C$2:$C$100,"Alex",Settlements!$D$2:$D$100)
For Jordan, replace "Alex" with "Jordan" and the Expenses share range $G$2:$G$100 with $H$2:$H$100. For Taylor, use "Taylor" and $I$2:$I$100.
The formula works in four parts:
- Money Alex paid upfront is added.
- Alex's assigned shares are subtracted.
- Money Alex sent in settlements is added.
- Money Alex received in settlements is subtracted.
A positive result means the person should receive money. A negative result means the person still owes money. Format the result as currency.
Add a ledger check somewhere on the Summary tab:
=ROUND(SUM(B2:B4),2)
The result should be $0.00 when every expense has matching shares and every settlement has a sender and recipient.
For a category total, use:
=SUMIF(Expenses!$C$2:$C$100,"Utilities",Expenses!$D$2:$D$100)
To create a category summary table, use:
=QUERY(Expenses!C1:D100,"select C, sum(D) where C is not null group by C label sum(D) 'Total'",1)
Extend the ranges if your group will have more than 100 rows.
Use a simple settlement workflow
- Agree on participants, eligible expenses, split rules, and an update cadence. After each purchase or once a week can both work.
- Enter the original bill on
Expenseswhen someone pays it. - Add the full amount and dollar share for every participant, including the person who paid.
- Save the receipt location or a short reference in the row.
- When a participant sends money, add the actual transfer to
Settlements. - Review the Summary tab before requesting another payment.
- Keep a dated copy at the end of a trip, billing period, or group event if everyone wants an archive.
The sheet is a recordkeeping tool. It does not send, verify, or reconcile Venmo transactions automatically.
Share the file without exposing the whole ledger
Thing is, edit access also permits accidental formula changes. Keep the input area easy to use, but protect the parts that calculate balances.
| Need | Practical setting |
|---|---|
| People enter expenses | Give trusted participants Editor access |
| Someone only reviews records | Use Viewer or Commenter access |
| Prevent formula changes | Protect the Summary and Check columns |
| Keep names consistent | Use dropdowns and one participant list |
| Store receipts safely | Link to files with appropriate sharing limits |
| Limit personal data | Avoid bank details, passwords, government IDs, and unnecessary transaction details |
Names and Venmo usernames can identify people. Venmo describes its handling and sharing of personal information in its Privacy Statement. Your shared sheet should collect only what the group needs to calculate and document its expenses.
Fix the mistakes that cause bad balances
Many spreadsheet errors begin with inconsistent records rather than difficult math.
| Mistake | Fix |
|---|---|
| A Venmo repayment is entered as a new expense | Put it on Settlements |
| One person appears under several names | Use a single name and keep the handle in a reference field |
| Share columns do not equal Amount | Check the J formula before settling |
| A promised payment is counted as completed | Record it only after the transfer is sent |
| One payment covers several bills | Use one settlement row for the full amount and list the bills |
| A formula gets overwritten | Protect formula ranges and keep an owner copy |
Do not delete an old settlement just because the group changes its mind about a split. Correct the expense shares, add a note, and record any resulting adjustment as a new settlement.
Know when a spreadsheet is enough
A spreadsheet is a good fit for roommates, travel groups, families, clubs, and other small groups that want flexible rules and a shared view. It works especially well when one person can enter receipts and the group agrees to review the Summary regularly.
It becomes less comfortable when the group needs automated imports, receipt scanning, reminders, or complicated payment matching. Compare those functions separately. A payment tool may help someone send money, while the spreadsheet keeps the group's shared calculation and supporting notes.
To be honest, a spreadsheet will not settle an argument about fairness. Agree on the rule before the bill arrives, keep the receipt, and write down exceptions while everyone remembers them.
FAQ
Should a Venmo reimbursement be marked as 100 percent for one person?
That convention can describe who receives a reimbursement, but mixing it into the expense ledger can double-count the transaction. This setup records the original bill with dollar shares and the Venmo payment as a separate settlement.
Why does the person who paid still have a share?
Everyone's share represents what that person owes for the expense. Subtracting the payer's own share shows the amount the payer should recover from the rest of the group.
What if someone pays only part of what they owe?
Enter the actual partial payment in Settlements. The unpaid portion remains in the person's negative balance.
Can the tracker include cash payments?
Yes. Use the same settlement columns and choose Cash in the Method column. The balance formula does not depend on the payment method.
What if the group changes the split after someone has paid?
Update the share amounts and leave the original payment record intact. The new balance will show whether another payment or adjustment is needed.
Create the three tabs, enter the $120.50 utilities example, and add Jordan's $40.17 Venmo settlement. If the share check passes and the Summary total is $0.00, replace the sample names with your group and share the file.