GoodDoors Property Management
Home/Saskatchewan Rent Receipt + Ledger Template

Saskatchewan Rent Receipt + Ledger Template (Excel)

One Excel workbook with three sheets: a fillable rent receipt, a 24-month rolling ledger with an auto-calculating running balance, and an informal late-rent notice for the 1–14 day window before the official Form 7 kicks in. Built around The Residential Tenancies Act, 2006 and CRA's T776 record-keeping rules. Free.

  • Excel + printable PDF
  • Auto running balance formula
  • T776-ready record format

Get the Saskatchewan rent receipt + ledger template

Excel workbook · Fillable receipt · 24-month ledger with auto-running balance · Late-rent notice template · RTA 2006-aligned

Your download starts the second you submit. No spam — we'll just send the occasional Saskatchewan landlord update you can unsubscribe from anytime.

Excel workbook (3 sheets) + printable PDF version. Saskatchewan landlords use this for daily receipt + ledger work, not for Form 7 evictions (those are official ORT forms).

What's in the template

Three sheets in one workbook. Each one does a specific job in the rent-collection cycle.

  • 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

How to track rent properly

The ledger is built around three habits — none of them difficult, all of them disciplined.

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

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

  3. 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 CRA requires you to keep all rental income and expense records for at least six years from the end of the year. The ledger doubles as your T776 — Statement of Real Estate Rentals source data — keep a backup PDF export at year end.

What to do when rent is late

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

  1. Day 1–14: informal reminder

    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.

  2. Day 15+: Form 7

    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.

  3. Tenant doesn't leave: Order of Possession

    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

Mobile-home site rentals follow different rules

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

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.

Talk to us(306) 994-5475