Yes. A free Google Sheet can track a household budget and manual Zelle reimbursements. It will not pull payment activity into the file, so someone must enter each transfer.
Use two logs. The Expenses tab answers who paid and what each person owes. The Payments tab answers whether money moved later. That separation keeps one rent bill from being counted again when roommates reimburse the payer.
Build the workbook around three tabs
Keep the structure plain. One row should represent one event.
| Tab | Purpose | One row means |
|---|---|---|
| Expenses | Bills, purchases, and each person's share | One expense |
| Payments | Zelle or other reimbursements | One person-to-person payment |
| Summary | Totals and remaining balances | One household member |
For a small household, this is usually enough. Add a fourth tab only if you need a place for house rules, member names, or a receipt index.
Create the Expenses tab
The Expenses tab holds the original cost and the agreed split. Replace Alex, Jordan, and Casey with the actual names in your group before copying formulas.
| Column | What to enter |
|---|---|
| Expense ID | A simple label such as EXP-001 |
| Date | When the purchase or bill occurred |
| Description | January rent, groceries, electricity, or moving supplies |
| Category | Rent, utilities, food, deposit, household, or other |
| Amount | The full cost |
| Paid By | The person who paid the merchant or landlord |
| Split Method | Equal, Proportional, Usage-based, Room-based, or Custom |
| Alex % | Alex's agreed share of the cost |
| Alex Share | Alex's calculated dollar share |
| Jordan % | Jordan's agreed share |
| Jordan Share | Jordan's calculated dollar share |
| Casey % | Casey's agreed share |
| Casey Share | Casey's calculated dollar share |
| Allocation Check ($) | Confirms that all shares equal the full amount |
| Notes / Receipt | Receipt link, billing detail, or agreement note |
Enter one row for every bill or purchase. Keep old rows rather than overwriting them, especially for recurring rent and utilities.
Paid By and the percentage columns do different jobs. If Alex fronts a $1,200 rent payment for three people, Paid By is Alex, but all three members can still have a one-third share. Do not set Alex's share to 100% just because Alex paid upfront.
A reimbursement is a payment event, not a split method. Record it on the Payments tab.
Record every Zelle reimbursement separately
One reimbursement gets one row. This matters when Jordan and Casey both repay Alex for the same rent bill.
| Column | What to enter |
|---|---|
| Payment ID | A label such as P-001 |
| Expense ID | The matching expense, such as EXP-001 |
| Sender | The person sending money |
| Recipient | The person who originally paid |
| Amount | The reimbursement amount |
| Method | Zelle, cash, bank transfer, or another method |
| Status | Pending, Sent, or Confirmed |
| Sent Date | The date the sender marked it sent |
| Note | Optional message or transaction reference |
Use Zelle as the method label. Update the status manually. Pending means the payment has not been sent, Sent means the sender recorded it, and Confirmed means the recipient checked the transaction record.
The sheet does not verify the transfer. Confirmed is a household record, not an automatic connection to a bank or payment service.
For the $1,200 rent example, the Payments tab might look like this:
| Payment ID | Expense ID | Sender | Recipient | Amount | Method | Status | Sent Date | Note |
|---|---|---|---|---|---|---|---|---|
| P-001 | EXP-001 | Jordan | Alex | $400 | Zelle | Confirmed | Jan 3 | January rent |
| P-002 | EXP-001 | Casey | Alex | $400 | Zelle | Pending | January rent |
Add formulas that catch mistakes
Turns out, the most useful formula is the one that exposes an incomplete split.
In the three-person layout above, enter these formulas in row 2 and copy them down:
| Purpose | Cell | Formula |
|---|---|---|
| Alex's share | I2 | =IF($E2="","",$E2*$H2) |
| Jordan's share | K2 | =IF($E2="","",$E2*$J2) |
| Casey's share | M2 | =IF($E2="","",$E2*$L2) |
| Allocation check | N2 | =IF($E2="","",SUM($I2,$K2,$M2)-$E2) |
Format the percentage columns as percentages. Format the amount and share columns as currency.
For an equal three-way split, enter =1/3 in each percentage cell. You can also set the final percentage to =1-SUM(H2,J2) so the percentages always total 100%. The allocation check should show $0.00.
Use 0% for someone who did not participate. An explicit zero is easier to audit than a blank cell.
For a two-person proportional split, enter 60% and 40%. For a usage-based utility split, use the agreed percentages and describe the basis in Notes.
For a fourth household member, add another percentage and share pair. Include that new share in the allocation check and Summary formulas.
Calculate who owes whom
The Summary tab turns expense rows and confirmed payments into a running position.
Place the member names in A2:A4:
| Cell | What to enter |
|---|---|
| A2 | Alex |
| A3 | Jordan |
| A4 | Casey |
Then add these headings in row 1:
| Person | Paid Upfront | Allocated Share | Confirmed Sent | Confirmed Received | Remaining Balance |
|---|
Use the following formulas:
| Cell | Formula |
|---|---|
| B2 | =SUMIF(Expenses!$F$2:$F$100,$A2,Expenses!$E$2:$E$100) |
| C2 | =SUM(Expenses!$I$2:$I$100) |
| C3 | =SUM(Expenses!$K$2:$K$100) |
| C4 | =SUM(Expenses!$M$2:$M$100) |
| D2 | =SUMIFS(Payments!$E$2:$E$100,Payments!$C$2:$C$100,$A2,Payments!$G$2:$G$100,"Confirmed") |
| E2 | =SUMIFS(Payments!$E$2:$E$100,Payments!$D$2:$D$100,$A2,Payments!$G$2:$G$100,"Confirmed") |
| F2 | =B2-C2-E2+D2 |
Copy B2 and D2:F2 down through row 4. The share formulas in column C use different source columns for each person, so enter those three formulas separately.
A positive Remaining Balance means the group still owes that person. A negative balance means that person still owes the group. Zero means the recorded expenses and confirmed payments balance.
With Alex paying $1,200 and keeping a $400 share, Alex starts at positive $800. Two confirmed $400 payments reduce Alex's balance to zero. If Casey's payment remains Pending, Casey's negative balance and Alex's positive balance remain visible.
Extend the formula ranges beyond row 100 if your household will record more entries.
Set up the file in Google Sheets
- Create a blank spreadsheet and name the tabs
Expenses,Payments, andSummary. - Choose the member names before entering formulas. Use the same spelling everywhere.
- Add the column headings from the tables above.
- Format dates, currency amounts, and percentage cells before entering a large batch of data.
- Add data-validation dropdowns for Split Method, Paid By, Sender, Recipient, and Status. Use the same status values throughout: Pending, Sent, and Confirmed.
- Enter one known expense, such as rent or a utility bill. Check that Allocation Check shows
$0.00. - Add a test payment and mark it Confirmed only after the recipient checks the transaction record.
- Share the workbook only with people who need access. Give edit access to the members entering rows, and use view or comment access for others when those options fit the group.
Keep a copy of important receipts outside the sheet too. Paste a receipt link in Notes, but do not store passwords, full bank credentials, or other unnecessary sensitive information there.
Choose a split rule before anyone pays
Percentages make the arithmetic easy. They do not decide what is fair.
| Split rule | Works well when | Tradeoff |
|---|---|---|
| Equal | People receive similar use or benefit | Simple, but may ignore meaningful differences |
| Proportional | A household agrees to tie contributions to income or another ratio | Requires agreement and enough information |
| Usage-based | Consumption or participation can be estimated | More accurate, but takes more tracking |
| Room-based | Bedrooms, private space, or nights stayed differ | Shared areas still need a separate rule |
| Custom | Deposits, moving costs, owner-only items, or special purchases need a tailored split | Write the rule down before paying |
Thing is, a clean formula cannot settle a disagreement about the rule. Add a short note such as "utilities split by reported usage" or "rent split by room and shared space" before the first payment.
If someone pays an expense for everyone, attach the receipt before requesting reimbursement. That keeps the conversation about the record rather than memory.
Review the workbook regularly
A short weekly check-in can catch forgotten bills while the details are still fresh. Ten minutes is often enough for a small household.
- Check new expense rows and receipt links.
- Look for an allocation check that is not
$0.00. - Match each Confirmed payment to the sender, recipient, amount, and expense ID.
- Do not enter a reimbursement as a second household expense.
- Add a note before changing a split on an older expense.
- Remove edit access when a roommate or group member leaves.
A plain reminder works well: "I logged the electricity bill and your share is $48. Please send it when you can, then mark the payment Sent so we can close the row."
At month-end, save a dated copy if your group wants a fixed record. Keep the original receipts and payment records with it.
Know when a spreadsheet is enough
This setup fits a small group with recurring rent, utilities, groceries, deposits, or occasional shared purchases. It also works for couples, family households, trip groups, clubs, and committees that can agree on one process.
To be honest, the sheet becomes harder to manage when expenses arrive constantly, many people edit at once, or members need automatic reminders and receipt capture. Consider another tool only for a specific need. A new app will not fix an unclear split rule.
The payment method and the recordkeeping method can stay separate. Your group can pay through Zelle while keeping the agreement, receipt, and balance history in a spreadsheet.
Keep tax questions separate
A shared-expense workbook documents what your group recorded. It does not decide whether a payment is income, rent, a gift, or a business transaction.
The IRS Form 1099-K FAQs say keeping business and personal transactions separate can make it easier to determine what tax is owed. If a payment relates to business or rental activity, or you receive a tax form that does not match your records, preserve the statements and receipts and get advice for your specific situation.
Common questions
Can this workbook send a Zelle payment?
No. It records a payment made elsewhere. It does not move money or verify a transfer.
What if two people reimburse one bill?
Create two rows on the Payments tab with the same Expense ID. Each row should have its own sender, amount, status, and sent date.
Should the person who paid the bill have a 100% share?
Not automatically. Paid By identifies who fronted the money. The percentage columns describe each person's agreed share of the expense.
Can I use the sheet for uneven household incomes?
Yes. Use proportional percentages if everyone agrees that income should affect contributions. Record the rule in Notes so the percentages are not mysterious later.
Start with one current bill. Add the expense row, verify that Allocation Check is $0.00, then add a Payments row only when someone reimburses the payer. Once that test works, share the workbook with the household.