Live planner

Rent Roll, Arrears & Lease Expiry Command Centre

Reconcile an eight-unit rent roll across contractual rent, current charges, payments, approved credits, closing receivables, aging, deposits, occupancy, lease expiries, market assumptions, evidence and professional action controls.

Who it helps: Landlords, property managers, asset managers, Realtors, accountants, bookkeepers, housing providers, lawyers and multi-residential investors

Decision: What income and cash have been reconciled, which receivable or lease date needs attention, and which action remains blocked by evidence, privacy or professional review?

Estimate generatedLedger evidence confidenceEight-unit ledgerLease expirySource controlled

Estimate confidence

42.9/100

Confidence reflects entered reconciliation and release evidence, not legal entitlement, collectability, notice validity, market rent or privacy compliance.

Closing receivable

$3,650.00

Ledger resolution

74.5%

Vacant/offline units

$3.00

Open control gates

$12.00

Decision brief

Closing receivable: $3,650.00

Next action

Reconcile the entered closing receivable of 3650.00 to bank, lease, ledger, credit and communication evidence.

Key notes

Sources

What this means

Closing receivable is $3,650.00. Use this as the anchor for your next conversation: Reconcile the entered closing receivable of 3650.00 to bank, lease, ledger, credit and communication evidence.

Report view

Client view keeps the decision clear. Professional view includes the calculation trail.

Owner rent-roll brief

Example eight-unit rent-roll review OWNER RENT-ROLL & COLLECTION BRIEF Property: Example residential rental property / Subject rental property Ledger as of: Jul 31, 2026 Units: 8 total / 5 occupied or transitioning / 2 vacant / 1 offline Occupied contract rent: $11,450/month Current ledger demand: $14,325 Payments applied: $10,675 Approved credits: $0 Closing receivable: $3,650 Ledger resolution rate: 74.5% Unavailable market-rent assumption: $6,450/month Open release gates: 12 of 15 No notice, filing, deposit application, rent increase, termination or collection remedy is generated or validated by this report.

Property-management action handoff

Portfolio income, occupancy and collection summary

Measure	Current result	Control
Occupied/transitioning units	5	2 vacant / 1 offline / 0 unknown
Occupied contract rent	11450.00	137400.00 annualized; excludes unentered charges
Current-period rent/other charges	11450.00 / 225.00	Entered ledger charges, not a determination of lawful entitlement
Opening receivable	2650.00	Reconcile to prior closing ledger and supporting entries
Ledger demand	14325.00	Opening receivable + current entered rent + current entered other charges
Payments/approved credits	10675.00 / 0.00	Match every payment to the bank deposit, payment processor or trust record; keep unapplied cash separate until allocation is confirmed.
Closing receivable	3650.00	2 account(s); excludes unsupported or unentered claims
Resolution rate	74.52%	Payments and approved credits divided by entered ledger demand; not an eviction or collectability metric

Complete unit rent roll

Unit	Status	Anonymous account	Lease term entered	Contract rent	Other monthly	Market assumption	Evidence
Unit 1	occupied	Tenant reference A	Dec 8, 2024 to Jul 31, 2027	2400.00	50.00	2600.00	complete reconciled
Unit 2	occupied	Tenant reference B	May 22, 2024 to Jan 27, 2027	2150.00	0.00	2300.00	partial
Unit 3	occupied	Tenant reference C	Jul 31, 2025 to Oct 29, 2026	1850.00	75.00	2050.00	complete reconciled
Unit 4	vacant	No current tenant	Aug 30, 2024 to Jul 21, 2026	2000.00	0.00	2200.00	partial
Unit 5	occupied	Tenant reference E	Mar 18, 2025 to Jan 22, 2028	2750.00	100.00	2900.00	partial
Unit 6	notice or transition	Tenant reference F	Jul 31, 2024 to Sep 29, 2026	2300.00	0.00	2400.00	partial
Unit 7	offline repairs	No current tenant	Feb 12, 2024 to Jul 1, 2026	1900.00	0.00	2100.00	conflict
Unit 8	vacant	No current tenant	Jun 26, 2025 to Jun 16, 2026	1950.00	0.00	2150.00	partial

Receivable and collection subledger

Unit	Opening	Rent charge	Other charge	Demand	Payments	Closing	Resolution
Unit 1	0.00	2400.00	50.00	2450.00	2450.00	0.00	100.0%
Unit 2	2150.00	2150.00	0.00	4300.00	1000.00	3300.00	23.3%
Unit 3	0.00	1850.00	75.00	1925.00	1925.00	0.00	100.0%
Unit 4	0.00	0.00	0.00	0.00	0.00	0.00	100.0%
Unit 5	500.00	2750.00	100.00	3350.00	3000.00	350.00	89.6%
Unit 6	0.00	2300.00	0.00	2300.00	2300.00	0.00	100.0%
Unit 7	0.00	0.00	0.00	0.00	0.00	0.00	100.0%
Unit 8	0.00	0.00	0.00	0.00	0.00	0.00	100.0%

Arrears aging and concentration

Aging/control	Accounts	Balance	Portfolio share/response
1-30 days	1	350.00	9.6%
31-60 days	1	3300.00	90.4%
61-90 days	0	0.00	0.0%
Over 90 days	0	0.00	0.0%
Largest account concentration	1	3300.00	90.4% of closing receivable
Evidence issues	6	N/A	Resolve missing, partial or conflicting lease, ledger and payment evidence

Lease expiry and turnover horizon

Horizon	Units	Contract rent	Entered response
Expired/entered date passed	None	0.00	Verify legal tenancy status, notice rights, renewal, rent, possession, financing and work plan before acting
0-30 days	None	0.00	Verify legal tenancy status, notice rights, renewal, rent, possession, financing and work plan before acting
31-90 days	Unit 3, Unit 6	4150.00	Verify legal tenancy status, notice rights, renewal, rent, possession, financing and work plan before acting
91-180 days	Unit 2	2150.00	Verify legal tenancy status, notice rights, renewal, rent, possession, financing and work plan before acting
Over 180 days	Unit 1, Unit 5	5150.00	Verify legal tenancy status, notice rights, renewal, rent, possession, financing and work plan before acting

Market-rent, vacancy and offline assumptions

Unit/control	Contract rent	Market assumption	Entered gap/exposure	Do not infer
Unit 1	2400.00	2600.00	200.00	A market assumption permits an increase
Unit 2	2150.00	2300.00	150.00	A market assumption permits an increase
Unit 3	1850.00	2050.00	200.00	A market assumption permits an increase
Unit 4	2000.00	2200.00	2200.00	Market rent equals recoverable vacancy income
Unit 5	2750.00	2900.00	150.00	A market assumption permits an increase
Unit 6	2300.00	2400.00	100.00	A market assumption permits an increase
Unit 7	1900.00	2100.00	2100.00	Market rent equals recoverable vacancy income
Unit 8	1950.00	2150.00	2150.00	Market rent equals recoverable vacancy income
Portfolio	11450.00	18700.00	800.00 occupied gap / 6450.00 unavailable exposure	37.5% physical unavailable status; no market or legal validation

Deposit and security register

Unit	Entered amount held	Status	Required control
Unit 1	2400.00	occupied	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy
Unit 2	2150.00	occupied	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy
Unit 3	1850.00	occupied	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy
Unit 4	0.00	vacant	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy
Unit 5	2750.00	occupied	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy
Unit 6	2300.00	notice or transition	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy
Unit 7	0.00	offline repairs	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy
Unit 8	0.00	vacant	Confirm lawful collection, type, trust/interest, receipt, transfer, application, return and evidence for the jurisdiction and tenancy

Unit action and professional-review queue

Priority	Unit	Next action	Receivable/age	Arrangement	Entered action	Evidence
Escalate	Unit 7	Aug 4, 2026 / 4 day(s)	0.00 / No open receivable	none	turnover or renewal	conflict
Review	Unit 2	Aug 2, 2026 / 2 day(s)	3300.00 / 31-60 days	written unreviewed	professional review	partial
Review	Unit 4	Aug 3, 2026 / 3 day(s)	0.00 / No open receivable	none	turnover or renewal	partial
Review	Unit 5	Aug 5, 2026 / 5 day(s)	350.00 / 1-30 days	discussion only	payment confirmation	partial
Review	Unit 6	Aug 7, 2026 / 7 day(s)	0.00 / No open receivable	none	turnover or renewal	partial
Review	Unit 8	Aug 10, 2026 / 10 day(s)	0.00 / No open receivable	none	turnover or renewal	partial
Review	Unit 3	Aug 20, 2026 / 20 day(s)	0.00 / No open receivable	none	turnover or renewal	complete reconciled
Routine	Unit 1	Aug 30, 2026 / 30 day(s)	0.00 / No open receivable	none	routine	complete reconciled

Jurisdiction, legislation and privacy source registry

Jurisdiction	Source	Applicability/effective record	Reviewed	Confidence
Ontario	Tribunals Ontario LTB - Interpretation Guideline 11: Rent Arrears	Updated July 1, 2026; current case facts, forms, rules and professional advice control	Jul 31, 2026	Jurisdiction matched; current file review still required
Ontario	Ontario Residential Tenancies Act, 2006	Current consolidated legislation must be checked for the tenancy and reporting date	Jul 31, 2026	Current consolidation and exact tenancy applicability required
Federal/provincial privacy	Office of the Privacy Commissioner of Canada - Privacy in the landlord and tenant relationship	Federal or substantially similar provincial private-sector privacy law may apply	Jul 31, 2026	Determine applicable privacy law and authorized purpose before sharing

Rent-roll and arrears release gates

Gate	Status	Owner	Evidence/direction
Complete lease set	OPEN	Property manager / landlord	Every lease, renewal, amendment, order and authorized arrangement
Rent roll reconciled to leases	OPEN	Property manager / landlord	5 occupied/transition account(s)
Opening balances reconciled	OPEN	Bookkeeper / accountant	2650.00
Payments matched to bank	Ready - retain dated evidence	Bookkeeper / accountant	Match every payment to the bank deposit, payment processor or trust record; keep unapplied cash separate until allocation is confirmed.
Credits/adjustments approved	Ready - retain dated evidence	Bookkeeper / accountant	Record who authorized every credit, abatement, write-off or adjustment and retain the governing agreement, order or professional direction.
Deposits reconciled	OPEN	Property manager / landlord	11450.00
Occupancy statuses verified	OPEN	Property manager / landlord	2 vacant / 1 offline / 0 unknown
Lease expiry dates verified	OPEN	Property manager / landlord	3 entered expiry date(s) within 180 days
Market assumptions documented	OPEN	Property manager / landlord	18700.00
Arrears actions reviewed	OPEN	Licensed legal professional where required	2 open receivable account(s)
Notices/service evidence verified	OPEN	Licensed legal professional where required	Current form, amount, timing, service and filing evidence
Arrangements documented	OPEN	Property manager / landlord	2 open arrangement record(s)
Privacy minimization	Ready - retain dated evidence	Property manager / landlord	Internal rent-roll, accounting and owner reporting only. Use anonymous tenant references in this public tool and share personal information only with authority and safeguards.
Owner instruction	OPEN	Ownership entity	Reconcile Unit 2 arrears and arrangement, confirm vacant/offline unit status, verify lease expiries and obtain current jurisdiction-specific review before any notice, filing, deposit application or remedy.
Reporting package released	OPEN	Property manager / landlord	Aug 7, 2026

Owner, manager, accounting and legal handoff

Party	Deliverable	Due	Boundary
Owner	Approved objectives, credits, reserves, vacancy strategy, professional instructions and reporting release	Aug 7, 2026	Ownership entity
Property manager	Leases, status, charges, payments, deposits, arrangements, dates, communications and action evidence	Aug 7, 2026	Property manager / landlord
Bookkeeper/accountant	Opening ledger, charges, cash application, credits, deposits, receivables, write-offs and financial reporting	Jul 31, 2026	Bookkeeper / accountant
Legal/tribunal professional	Current jurisdiction, characterization of amounts, notices, service, filing, arrangements, deposits, privacy and remedies	Before any legal action	Licensed legal professional where required
Realtor/leasing professional	Documented market evidence, lawful marketing authority, possession status and owner-approved leasing objectives	Aug 7, 2026	Do not disclose tenant information or promise possession/rent without authority

Rent-roll incident and exception protocol

Exception	Immediate control	Do not assume	Required record
Payment allocation dispute	Freeze unsupported reallocation; reconcile bank proof, ledger, receipt, lease and tenant communication	Oldest balance, fee or rent allocation is automatically correct	Payment date, amount, method, bank proof, intended period, applied period, reversals, communication and approval
Changed payment instructions or suspected fraud	Stop, independently verify using established contact information, preserve evidence and escalate	Email, text, caller ID, urgency or familiar branding proves authenticity	Original/change instructions, verification channel, dates, parties, account references, incident response and direction
Notice, filing or remedy contemplated	Obtain current jurisdiction-specific professional review of amount, form, timing, service, facts and relief	The tool validates arrears, notice, filing, termination, eviction or collection rights	Current ledger, lease, payments, credits, notices, service, forms, deadlines, tenant issues, advice and owner instruction
Deposit application or refund	Reconcile deposit type and amount and obtain current legal/accounting direction	A deposit can be collected, retained, increased, applied or offset	Receipt, trust/interest record, transfer, agreement, inspection, authorization, statement, advice and payment
Lease date reached or possession changes	Confirm actual occupancy, keys, abandonment/termination evidence, insurance, utilities and legal status	An entered lease end date automatically ends the tenancy or permits possession	Lease/amendments, notices, service, agreement/order, communications, inspection, keys, meter readings and professional direction
Personal information request or disclosure	Confirm purpose, authority, necessity, consent/exception, recipient and safeguards; minimize the data	Operational convenience permits broad collection or sharing	Purpose, data fields, legal basis/consent, recipient, secure method, retention, access and deletion record

Suggested next steps

Reconcile the entered closing receivable of 3650.00 to bank, lease, ledger, credit and communication evidence.
Resolve lease, ledger or payment evidence for 6 unit(s).
Review every entered lease date within 90 days without assuming the tenancy ends or a notice is available.
Resolve 12 open rent-roll release gate(s) before releasing the reporting package or taking legal action.

Warnings

Rent, lawful charges, deposits, notices, service, filing, limitation periods, termination, eviction, payment arrangements, collection and privacy requirements vary by province, tenancy, property and facts.
A closing receivable is arithmetic from entered ledger lines. It is not a finding that the amount is legally owing, collectible or properly characterized as rent.
An entered lease-end date does not establish that a tenancy ends, that possession is available, or that a notice or remedy is valid.
A market-rent assumption does not authorize a rent increase, vacancy recovery, notice, marketing statement or investment conclusion.
Never expose full tenant names, banking information, SIN, identity documents, credit reports, health information or unrelated communications in a public report.

Sources and data freshness

Tribunals Ontario LTB - Interpretation Guideline 11: Rent Arrearsneeds review

Effective Updated July 1, 2026; current case facts, forms, rules and professional advice control · Last reviewed 2026-07-31

Jurisdiction context only. Confirm current forms, rules, procedures, facts and professional advice before action.

Ontario Residential Tenancies Act, 2006needs review

Effective Current consolidated legislation must be checked for the tenancy and reporting date · Last reviewed 2026-07-31

Confirm the current consolidation and exact application to the property and tenancy.

Office of the Privacy Commissioner of Canada - Privacy in the landlord and tenant relationshipneeds review

Effective Federal or substantially similar provincial private-sector privacy law may apply · Last reviewed 2026-07-31

Determine whether federal or substantially similar provincial privacy law applies and minimize collection and disclosure.

RealEstateTools.ca provides educational estimates only. Results are not legal, financial, tax, mortgage, appraisal, accounting, or investment advice. Confirm all numbers with qualified professionals.

Quick answer

Rent Roll, Arrears & Lease Expiry Command Centre helps landlords, property managers, asset managers, realtors, accountants, bookkeepers, housing providers, lawyers and multi-residential investors decide: What income and cash have been reconciled, which receivable or lease date needs attention, and which action remains blocked by evidence, privacy or professional review? It provides a transparent educational estimate with assumptions, warnings, source citations where applicable, and next steps for professional review.

How this tool should be used

Use the output as a decision aid, not a final answer. Some tools produce calculations, while others create checklists, timelines, comparison tables, or review prompts that help you move the file forward.

Frequently asked questions

What is the Rent Roll, Arrears & Lease Expiry Command Centre?

Rent Roll, Arrears & Lease Expiry Command Centre is a Canadian real estate planning tool for landlords, property managers, asset managers, realtors, accountants, bookkeepers, housing providers, lawyers and multi-residential investors. It helps answer: What income and cash have been reconciled, which receivable or lease date needs attention, and which action remains blocked by evidence, privacy or professional review?

Are the results guaranteed?

No. Results are educational estimates only and are not legal, tax, mortgage, appraisal, accounting, investment, or financial advice. Confirm all numbers with qualified professionals.

Does this tool use Canadian assumptions?

Yes. The platform is designed for Canada-first calculations, province-aware source metadata, Canadian terminology, and rule freshness tracking.

Can I export or save the result?

The free workflow includes email and PDF-style report calls to action. Saved report storage and account dashboards can be layered on later without changing the public calculators.

Rent Roll, Arrears & Lease Expiry Command Centre

Planning details

Property, reporting period and account ownership

How this tool should be used

Frequently asked questions

Related tools