Ontario · Google Sheets template
Rent payment reconciliation worksheet — Toronto
Lawful rent, received, credits and disputed amounts in separate columns so the balance is arithmetic anyone can check. No late fees (Ontario doesn't allow them); the rent deposit is tracked separately and never applied to arrears.
Live Google Sheet
Claude Co-Work › Platuni Compliance Hub. Formulas verified on import.
Open in Google SheetPreview
Blue cells are formulas; SAMPLE rows are synthetic.
| 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 | Lawful rent | Payment ref | Received date | Amount received | Allocated to | Credits | Disputed | Period balance | Note |
| SAMPLE 2026-07 | 2026-07-01 | 2200 | e-transfer #B7C3 | 2026-07-03 | 2200 | 2026-07 | 0 | 0 | =C9-F9-H9 | Paid 2 days after due |
| SAMPLE 2026-08 | 2026-08-01 | 2200 | e-transfer #C9D4 | 2026-08-01 | 1600 | 2026-08 | 0 | 0 | =C10-F10-H10 | Balance to follow |
| SAMPLE 2026-08 (credit) | 2026-08-01 | 0 | 0 | 2026-08 | 200 | 0 | =C12-F12-H12 | Abatement agreed 07-28 | ||
| SAMPLE 2026-09 | 2026-09-01 | 2200 | 0 | 2026-09 | 0 | 0 | =C13-F13-H13 | No payment as of 09-18 |
Field definitions
- Lawful rent
- From the lease or the last N1/N2
- Received
- Each payment as it arrived
- Credits
- Agreed abatements, with the agreement on file
- Disputed
- Kept out of the balance
- LMR deposit
- Info cell only; never netted against arrears
- Summary
- Totals, shortfall count, last payment, balance with and without disputed