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
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
