Alberta · Google Sheets template
Rent payment reconciliation worksheet — Calgary
Rent due, received, credits and disputed amounts in separate columns so the balance is arithmetic anyone can check. A late-fee column exists because Alberta allows a reasonable one where the agreement provides for it — and it stays out of the amount a 14-day notice states. The deposit is held in trust and never applied to arrears during the tenancy.
Live Google Sheet
Claude Co-Work › Platuni Compliance Hub. Formulas verified on import.
Open Google SheetPreview
Blue cells are formulas; SAMPLE rows are synthetic.
| Summary | Total due | =SUM(C:C) | Total received | =SUM(F:F) | Credits | =SUM(H:H) | Disputed | =SUM(I:I) | Balance excl. disputed and fees | =C3-E3-G3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Period | Due date | Rent due | Payment ref | Received date | Amount received | Allocated to | Credits | Disputed | Late fee (informational) | Period balance | Note |
| SAMPLE 2026-07 | 2026-07-01 | 1850 | e-transfer #B7C3 | 2026-07-03 | 1850 | 2026-07 | 0 | 0 | 0 | =C6-F6-H6 | Paid 2 days after due |
| SAMPLE 2026-08 | 2026-08-01 | 1850 | e-transfer #C9D4 | 2026-08-09 | 1400 | 2026-08 | 0 | 0 | 25 | =C7-F7-H7 | Partial; late fee per agreement (verify reasonableness) |
| SAMPLE 2026-08 (credit) | 0 | 0 | 2026-08 | 100 | 0 | 0 | =C8-F8-H8 | Abatement: 2 days no hot water | |||
| SAMPLE 2026-09 | 2026-09-01 | 1850 | 0 | 2026-09 | 0 | 0 | 0 | =C9-F9-H9 | No payment as of 09-29 |
Field definitions
- Rent due
- From the agreement or the last increase notice
- Received
- Each payment as it arrived
- Credits
- Agreed abatements, with the agreement on file
- Disputed
- Kept out of the balance
- Late fee
- Informational; only if the agreement provides and it is reasonable; never in a 14-day notice
- Summary
- Totals, balance with and without disputed