Saskatchewan Rent Receipt + Ledger Template (Excel · Free)

What's in the template

Receipt sheet — fillable single-payment rent receipt with property + tenant info, payment details, late fee, balance, and a signature block.
Ledger sheet — 24-month rolling rent ledger. Type the tenancy start date and monthly rent in row 4; the ledger autofills 24 due dates, 24 amount-due rows, and a running balance that updates as you add payments.
LateNotice sheet — pre-formatted Saskatchewan-aligned informal late-rent notice for the 1–14 day window. Drop in the tenant's name, the missed amount, and your contact info; copy the body into your email or print it.

When to issue a rent receipt in Saskatchewan

Saskatchewan landlords are required to give a written receipt for any cash rent payment, and for any other payment on request. Best practice is to give every tenant a receipt for every payment regardless of method — it removes ambiguity and gives you a consistent evidentiary record across the tenancy.

Cash payments without receipts are the single most common reason ORT deposit-and-arrears disputes go sideways. The tenant claims they paid; the landlord can't prove they didn't; the ORT rules in the tenant's favour. A dated, signed receipt fixes the problem before it starts.

How to track rent properly

The ledger is built around three habits:

Update the ledger the day each payment lands. Don't batch — it's easier to remember partial payments, e-transfers that bounced, and bank-fee deductions if you log them at the time.
Keep dated paper or PDF receipts in a per-unit folder. If a tenant disputes a payment at the ORT, the receipt + ledger entry combination is your strongest evidence.
Reconcile monthly. The running balance column tells you where every tenancy stands at month-end. Anything not at $0 needs a follow-up.

For tax purposes, the Canada Revenue Agency requires you to keep all rental income and expense records for at least six years from the end of the year the records relate to. The ledger doubles as your T776 — Statement of Real Estate Rentals source data — keep a backup PDF export of the ledger at year end.

What to do when rent is late

Saskatchewan's framework for unpaid rent escalates in three steps:

Day 1–14: rent is technically late. Use the LateNotice sheet to send an informal written reminder. Give the tenant a chance to make it right and document the request.
Day 15+: under section 57 of the RTA, 2006, the landlord may serve Form 7 — Immediate Notice to Vacate and Notice of Arrears. The tenancy ends immediately on service. Form 7 must be on the approved ORT format — generate it through the ORT online portal or publications.saskatchewan.ca.
Tenant doesn't leave: apply to the Office of Residential Tenancies for an Order of Possession ($50 application fee, hearing typically 4–8 weeks out).

For the full step-by-step process — including service rules, cure periods, and the eviction-day playbook — see our Saskatchewan eviction notices + ORT forms hub.

Saskatchewan deposit context

Section 25 of the RTA, 2006 caps the security deposit at one month's rent. The ledger doesn't track the deposit (it's separate from rent), but include the deposit amount + date received in your tenancy file alongside the ledger so deposit disputes have a clean audit trail.

Frequently asked questions

When do I have to give a rent receipt in Saskatchewan?

You must provide a written receipt for any cash rent payment. For other payment methods (cheque, e-transfer, EFT, money order), you must provide a receipt on request. Best practice is to give every tenant a receipt or ledger update for every payment regardless of method — it removes ambiguity and gives you the same evidentiary record on every transaction.

What information has to be on a rent receipt?

Property address, tenant name, payment date, period covered, amount received, payment method, and the landlord's signature. The Excel template includes all of these as fillable cells. If a tenant disputes a payment at the Office of Residential Tenancies, the receipt is your primary evidence — make sure each one is dated and signed.

How long do I have to keep rent receipts and ledgers?

At least six years from the end of the tax year they relate to, per CRA's record-keeping rules for the T776 (Statement of Real Estate Rentals). The CRA can audit any rental income, so the safe practice is to keep digital + printed copies of every receipt and ledger entry. Most Saskatchewan landlords store everything as PDF in a property-specific folder.

Can I charge a late fee in Saskatchewan?

Only if the tenancy agreement specifies the late fee — and only as a 'fixed, reasonable charge' that reflects the actual cost to you (e.g., bank NSF fee, follow-up admin time). Saskatchewan caselaw consistently rejects punitive late fees that bear no relationship to actual costs, especially anything that escalates daily. Cap late fees at $25–50 per occurrence and document the cost reasoning.

What's the difference between this informal late notice and the official Form 7?

The Excel template's Late Notice sheet is an informal reminder for the 1–14 day window after rent is due. It's a friendly nudge — and a paper trail. Once rent is unpaid 15+ days, switch to the official Form 7 — Immediate Notice to Vacate and Notice of Arrears under section 57 of the RTA, 2006. Form 7 ends the tenancy immediately on service. Generate it through the ORT online portal or publications.saskatchewan.ca.

How does the running balance in the ledger work?

Each row's running balance equals the prior row's balance + amount due + late fee (if any) − amount paid. So if rent is paid in full on time every month, the balance stays at $0. If a payment is short or skipped, the balance rolls forward and shows you exactly how far behind the tenant is. The formula uses IFERROR so blank cells don't break the calculation.

Can I use this template for multiple units?

Save a copy per unit. The Excel template is set up for a single tenancy — separate workbooks per unit make CRA T776 reporting cleaner because each property maps to its own line on the T776. If you want a portfolio-level view, use a separate summary workbook that pulls totals from each per-unit ledger.

Sources

The Residential Tenancies Act, 2006 (CanLII) — full statute, especially s. 57 (non-payment) + s. 25 (deposit)
Office of Residential Tenancies — file disputes, online portal, Form 7 generation
CRA T776 — Statement of Real Estate Rentals — record-keeping rules

Need help with rent collection at scale?

GoodDoors does ledger reconciliation + receipts on every tenancy across our Regina and Saskatoon portfolio — owner statements come pre-formatted for T776, and arrears get the appropriate Form 7 escalation in the standard 15-day window. If you'd like to hand off rent collection, contact us or call (306) 994-5475.

Saskatchewan Rent Receipt + Ledger Template (Excel)

Get the Saskatchewan rent receipt + ledger template