A Google Sheets rent split calculator works best when it separates the bill from the payment. Put what the household owes in one tab, then log each Zelle transfer in a payments tab. A summary compares the two.

That distinction matters. Why can a sheet show a roommate owing money after they paid? Usually, the template counted a payment as a new expense. Use one charge row for January rent, then record each payment against that charge.

Use two ledgers, not one

Turns out, most balance errors come from mixing obligations and transfers.

A charge answers, "How much should each person cover?" A payment answers, "What money actually moved?" Keeping those questions separate makes direct landlord payments and roommate reimbursements easier to reconcile.

Record Example What it answers
Charge January rent of $2,000, split into $800, $600, and $600 What the household owes
Payment Alex sends $2,000 to the landlord by Zelle What Alex actually paid
Reimbursement Jordan sends $600 to Alex by Zelle Whether part of Alex's advance came back

A sample roommate spreadsheet from Expensesorted includes date, payer, amount, split method, individual shares, and settlement status. That is a useful starting layout. The separate Payments tab is what keeps the direction of each Zelle transfer clear.

Agree on the rent split before building formulas

The spreadsheet should reflect a household rule, not quietly create one. Write the rule down in the Setup tab and use the same method each month.

Split method Good fit Tradeoff
Equal Roommates have similar rooms and usage Simple, but it ignores room size
Room size Bedrooms differ substantially Requires an agreed percentage
Income-based The household wants contributions tied to ability to pay Requires a more personal conversation
Usage or nights stayed Temporary arrangements or some utilities Takes more tracking

A $2,000 rent with a 40%, 30%, and 30% rule creates shares of $800, $600, and $600. For four roommates, an example custom split could be 40%, 30%, 20%, and 10%. The percentages must total 100%, but the choice is a household agreement.

Build the Google Sheets rent split template

Create four tabs: Setup, Charges, Payments, and Summary. The names are not special. Consistent columns are.

  1. Set up the names and percentages. In Setup, place Roommate in A1 and Share in B1. Enter one person per row, such as Alex with 40%, Jordan with 30%, and Sam with 30%. Add =SUM(B2:B4) below the percentages. It should return 100%.

  2. Create the Charges tab. Use columns such as Date, Period, Description, Fronted by, Total, Split type, one share column per roommate, and Notes. For example, a three-person sheet might use Alex share, Jordan share, and Sam share. Leave Fronted by blank when roommates pay the landlord separately; use it for context when one person paid the full bill.

    If four people split a $2,000 charge equally and the total is in E2, enter =E2/4 in each share column. For an uneven setup, use formulas such as =E2*Setup!$B$2 and =E2*Setup!$B$3. Add a check column with =SUM(G2:I2)-E2, adjusting the range for more roommates. A result of zero means the shares match the charge.

  3. Create the Payments tab. Use Date, From, To, Method, Amount, Status, Reference, and Period. Enter Zelle as the method when appropriate. The To value can be Landlord or a roommate's name. Add one row for each transfer, even when several payments relate to the same month's rent.

  4. Build the Summary tab. Use Name, Owed, Sent, Received, and Balance. If Alex's share column is G, the owed formula in B2 is =SUM(Charges!$G$2:$G). In C2, use =SUMIFS(Payments!$E:$E,Payments!$B:$B,$A2,Payments!$F:$F,"Confirmed") to total confirmed payments sent by that person. In D2, use =SUMIFS(Payments!$E:$E,Payments!$C:$C,$A2,Payments!$F:$F,"Confirmed") to total confirmed reimbursements received. In E2, use =B2+D2-C2.

A positive balance means the person still owes money. A negative balance means they should receive money. Copy the Summary formulas down for every roommate, and update the share-column reference for each person.

Record Zelle payments without changing the rent obligation

Use the payment date, not the date you happened to open the sheet. Include the sender, recipient, amount, method, status, and period so another roommate can understand the row later.

For a direct landlord payment, a row might read 2026-01-01 | Jordan | Landlord | Zelle | 600 | Confirmed | January rent. For a reimbursement after Alex fronted the bill, it might read 2026-01-02 | Jordan | Alex | Zelle | 600 | Confirmed | January rent reimbursement.

Thing is, those are payments, not new rent charges. The January rent obligation stays in Charges once. The payment row simply credits the sender and, when the recipient is a roommate, records money coming back to that person.

Some simple split sheets label a one-person-covered cost as Reimbursement, with that person's share at 100% and everyone else's at 0%. The Expensesorted example uses that convention. It can help identify who owned a fronted expense, but it should not replace the Payments tab or be applied to every roommate-to-landlord payment.

Use Confirmed only after checking the payment record. Keep pending or canceled transfers out of the balance formula. A short reference or receipt link is enough; don't put bank login details or account credentials in the shared sheet.

Share the file while protecting the formulas

Give roommates Editor access when they need to add charges or payments. Use Viewer access for someone who only needs to check totals. The Google Sheets permissions guide covers the difference between these roles.

Before sharing, check these items:

  • Invite named email addresses for a private household record. If you use a link, check its permission before sending it.
  • Leave the input cells on Charges and Payments editable, but protect Setup, Summary, and formula columns. The steps in this guide to protect sheets and ranges show how to allow edits only in selected cells.
  • Add dropdowns for Split type, Method, and Status. Data validation can keep entries consistent; see these Google Sheets data validation examples.
  • Review version history after an unexpected change. It can show earlier versions and help restore a damaged formula.

Don't make the whole file editable by everyone with the link unless the group accepts that risk. A roommate payment record contains more personal information than a shared shopping list.

Close the books once a month

Choose a simple household rule. Logging a payment the same day or next day and reviewing the sheet on the first of the month is easy to remember.

During the review, filter Payments by Period, look for pending or canceled rows, and compare the confirmed sent and received amounts with the records in the relevant bank or payment app. Check that every charge's share columns add up to its total. Then discuss any remaining positive or negative balances before the next rent cycle.

If your group keeps receipts, use a private Drive folder and place a link in the Notes column. Save only the details needed to match the record, such as date, amount, recipient, and status. Version history can show who changed a row, but it does not prove that money moved; keep the payment confirmation as well.

Mistakes that make balances look wrong

Duplicating the rent. Entering January rent once as a charge and again as a payment-created expense makes the household owe twice. Keep the bill in Charges and every transfer in Payments.

Using reimbursement for every Zelle entry. A roommate paying their own share directly to the landlord is a payment to the landlord. A roommate sending money to the person who fronted the bill is a reimbursement.

Counting unconfirmed transfers. A screenshot of a sent request or a pending status is not the same as a completed payment. Keep the row pending until the payment record supports it.

Overwriting a formula. If a formula breaks, use version history or restore the earlier cell rather than replacing the number with a guess. The sheet should show how the balance was calculated.

When a spreadsheet is enough

To be honest, a sheet is often enough for a small, trusted household with recurring rent, a few utilities, and someone willing to enter payments. It gives everyone the same record without requiring a separate workflow for each bill.

Consider a dedicated split-bill tool when manual entry becomes the problem: the group has many one-off expenses, receipts are frequent, or reminders are regularly missed. Tracking, requesting, paying, and recordkeeping are separate jobs, so compare those functions instead of assuming one tool handles them all.

This spreadsheet won't send money or verify a Zelle transfer. It records the agreed split and the payment information your group enters.

Questions roommates often ask

Should a roommate's payment to the landlord be an expense or a reimbursement?

It is a payment against the shared charge. Use Reimbursement when money moves back to the person who covered a shared bill, not as a label for every rent payment.

How do I change the template for three or four roommates?

Add or remove share columns, rename them, copy the formulas across and down, and check that the percentage total is 100%. Then update each person's Owed formula on Summary.

What if someone sends the wrong amount?

Keep the original row if the payment happened. Add a note, record a separate corrective payment or adjustment, and mark a canceled transaction appropriately. Don't silently change the original amount if the old record may matter later.

Can everyone edit the sheet?

They can, but they don't need to edit every part. Give Editor access to people who enter data, protect formulas and summary cells, and use Viewer access for people who only review the balance.

Create the four tabs before the next rent cycle. Enter the agreed shares, add one monthly charge, record the first confirmed payment, and check that the balance sign makes sense before sharing the file.