How to Track Split Rent Payments Across Tenants

Why split rent breaks a spreadsheet

When three tenants share a $2,400 apartment, you rarely receive $2,400 once. You receive $800 on the 1st, $800 on the 3rd, and $800 on the 9th — sometimes as $400 twice. A spreadsheet row built around "one month, one payment" cannot answer the only question that matters: how much of this month's rent is still outstanding, and who owes it?

Record the charge and the payments separately

The rule that fixes almost every multi-tenant ledger: a rent charge is one thing, a rent payment is another. Create the full monthly charge once, then attach each incoming payment to it. The balance is simply the charge minus the sum of the payments received.

• Charge: $2,400 rent due on the 1st.
• Payment: $800 from Tenant A on the 1st — balance $1,600.
• Payment: $800 from Tenant B on the 3rd — balance $800.
• Payment: $400 from Tenant C on the 9th — balance $400 outstanding.

In Guestbo this is how income entries work: each payment is its own dated transaction against the property, so partial amounts never overwrite each other.

Tag every payment with the payer

Put the tenant's name in the description of each payment. It costs two seconds and it turns an anonymous list of deposits into an audit trail you can defend if a tenant disputes what they paid in March.

Handle partial installments and late top-ups

Never edit an existing payment to "make the month add up". If a tenant pays $400 now and $400 next week, log two payments. If a late fee applies, log it as a separate income line rather than folding it into the rent amount — otherwise your rent-per-month figure drifts and your yearly totals stop matching your bank statements.

Reconcile monthly, not yearly

Once a month, compare the sum of recorded payments to what actually hit your account. Differences almost always come from a payment logged in the wrong month, a bank fee deducted at source, or a deposit that was really a security deposit and not rent.

Keep expenses on the same ledger

Split rent only tells half the story. Mortgage, condo fees, hydro, water, internet, and cleaning all draw from the same property. Recording them alongside rent is what turns a payment log into a real net-income picture per property.

A simple monthly checklist

1. Create the month's rent charge for each unit.
2. Log each tenant payment on the day it arrives, with their name.
3. Check the outstanding balance mid-month and chase what's missing.
4. Log every expense paid that month.
5. Reconcile against the bank, then review net income per property.

Track it in Guestbo

Guestbo keeps per-property income and expenses, partial payments, and outstanding balances in one place, with charts for net income and occupancy. See the plans or create a free account.