British Columbia · Google Sheet template
Rent payment reconciliation worksheet
Expected, received, credits and disputed amounts in separate columns so the balance is arithmetic anyone can check. No late fees are assumed and none are calculated.
Live Google Sheet
Claude Co-Work › Platuni Compliance Hub. Totals, shortfall count and balance (with and without disputed) verified on import.
Open Google SheetPreview
Six synthetic rows showing a partial payment, an agreed credit, and a missed period. Blue cells are formulas.
| Summary | Total expected | =SUM(C:C) | Total received | =SUM(F:F) | Credits | =SUM(H:H) | Disputed | =SUM(I:I) | Balance excl. disputed | =C4-E4-G4 |
|---|---|---|---|---|---|---|---|---|---|---|
| Period | Due date | Expected | Payment ref | Received date | Amount received | Allocated to | Credits | Disputed | Period balance | Note |
| SAMPLE 2026-06 | 2026-06-01 | 2400 | e-transfer #A1F2 | 2026-06-01 | 2400 | 2026-06 | 0 | 0 | =C8-F8-H8 | |
| SAMPLE 2026-07 | 2026-07-01 | 2400 | e-transfer #B7C3 | 2026-07-03 | 2400 | 2026-07 | 0 | 0 | =C9-F9-H9 | Paid 2 days after due |
| SAMPLE 2026-08 | 2026-08-01 | 2400 | e-transfer #C9D4 | 2026-08-01 | 1800 | 2026-08 | 0 | 0 | =C10-F10-H10 | Tenant: balance to follow |
| SAMPLE 2026-08 (2) | 0 | e-transfer #D2E5 | 2026-08-14 | 400 | 2026-08 | 0 | 0 | =C11-F11-H11 | Partial | |
| SAMPLE 2026-08 (credit) | 0 | 0 | 2026-08 | 200 | 0 | =C12-F12-H12 | Credit agreed in writing 07-28 | |||
| SAMPLE 2026-09 | 2026-09-01 | 2400 | 0 | 2026-09 | 0 | 0 | =C13-F13-H13 | No payment as of 09-10 |
Field definitions
- Period / due date
- One row per rent period; extra rows for extra payments in the same period
- Expected rent
- From the agreement; 0 on extra-payment rows
- Received
- Each payment as it arrived, with a reference
- Allocated to
- Which period a payment counts toward
- Credits
- Agreed reductions (e.g. a tenant-paid repair), with the agreement on file
- Disputed
- Anything the tenant contests; kept out of the balance
- Period balance
- Expected − received − credits
- Summary
- Totals, shortfall count, last payment date, balance with and without disputed amounts