What this means for the deal
- Reconcile the complete charge and recovery population to the controlling lease, amendments, invoices and property ledger before relying on an arrears balance.
- Allocate each payment, credit, deposit application, letter-of-credit receipt or approved write-off explicitly instead of assuming oldest-charge-first treatment.
- Keep gross, disputed and undisputed balances visible together; recording a dispute does not establish a right to withhold, deduct or set off.
- Enter notice need, cure period and the actual reviewed deadline separately. A calculator should not infer a legal deadline or remedy.
- Administer signed payment-plan installments without overwriting the original charge ledger, payment history or rights-review record.
Start with the complete lease and the complete ledger
An accounts-receivable report can show what the property system currently carries, but it does not by itself prove the contractual character, due date or recoverability of each amount. Begin with the executed lease, schedules and guaranties, then review every amendment, deferral, waiver, settlement, credit arrangement and side letter that may alter payment or enforcement terms.
Tie the workbench to the complete charge, invoice, credit and cash-receipt population as of one stated date. Record exact source references and preserve the original reports. A manually reconstructed balance should reconcile to the controlled ledger or explain every difference rather than silently replacing the accounting record.
| Record | Capture | Control question |
|---|---|---|
| Lease file | Executed lease, schedules, amendments and related support | Which document currently controls the charge or response? |
| Charge population | Invoices, service periods, due dates, tax and ledger IDs | Was every charge entered once? |
| Recovery population | Cash, credits, approved security applications and write-offs | What actually reduced the balance? |
| Communications | Demands, dispute notices, acknowledgements and reservations | What was said, by whom and when? |
| Adviser record | Legal, tax and accounting instructions | Which conclusion has qualified review? |
Service period, due date and charge type are separate facts
For every line, identify the charge category, invoice or transaction number, service-period start and end, due date, gross amount and exact source. Keeping service periods visible helps detect a duplicated month, late true-up, retroactive adjustment or amount that belongs in a different reconciliation.
Separate base rent, additional rent, tax, utilities, parking, interest, administration or legal charges and other amounts. A lease may label several items additional rent, but the label does not eliminate the need to test the underlying clause, calculation, invoice and tax treatment.
- Do not replace an earlier invoice when a credit or correction arrives; add the adjusting record and preserve the sequence.
- Do not use an invoice date as the service period or due date unless the source actually makes them the same.
- Reconcile annual operating-cost statements in a dedicated recovery audit before promoting the approved net charge into the arrears file.
- Keep tax visibly separate when the accounting and adviser review requires it.
A payment does not explain which charge it satisfied
Record the actual effective or posting date and full amount of each cash payment. Then allocate the amount to specific charge IDs using the supported direction, accounting policy, agreement or reviewed conclusion. Preserve unapplied cash as unapplied rather than forcing the reconciliation to balance.
Credits, deposit applications, letter-of-credit proceeds and write-offs are not interchangeable with cash. Each may require different contractual authority, accounting entry, approval, tax treatment and communication. The workbench keeps them as distinct recovery types and flags missing approval evidence.
Show gross, disputed and undisputed balances together
A dispute should not disappear into a note beside one net balance. Record the entered disputed portion against the affected charge so reviewers can see the gross outstanding ledger, the disputed outstanding amount and the remaining undisputed amount. Preserve the tenant's explanation, landlord response, supporting calculations and claimed resolution separately.
Do not let the arithmetic make the legal decision. Whether a tenant may withhold, deduct, set off, pay under protest or use another process depends on the lease, facts and applicable law. A disputed label is an administrative classification only.
Aging is arithmetic; interest requires authority
Age each remaining charge from its entered due date to the as-of date into current or future, 1–30, 31–60, 61–90 and 91-plus-day buckets. This is an administrative view, not a conclusion that a legal default started on the due date.
If a reviewed interest scenario is needed, model simple interest from the entered start date on each charge, reduce principal on each allocation date and state the annual rate, 360-, 365- or 366-day denominator, and whether the starting base includes or excludes the entered disputed amount. Keep the result labelled modelled until entitlement, compounding, rate, notice, tax and invoicing treatment are confirmed.
| Output | Calculation | Boundary |
|---|---|---|
| Outstanding charge | Entered charge less counted allocations, floored at zero | Does not establish debt |
| Disputed outstanding | Lesser of outstanding and entered disputed amount | Does not establish withholding or set-off rights |
| Simple interest | Principal × annual rate × days ÷ entered day count | Does not establish entitlement or tax treatment |
| Aging | As-of date less entered due date | Does not determine legal default or cure |
Never let a generic calculator choose the deadline
Commercial-tenancy rights and procedures are not one national template. The operative lease, province, event, service requirements and facts can all matter. Record whether notice is required as yes, no or unknown only after reviewed analysis; preserve the exact notice source, sent date, permitted delivery method and receipt evidence.
Keep an entered cure period separate from the entered reviewed deadline. The actual deadline can depend on which event starts time, whether receipt matters, how days are counted, weekends or holidays, waiver, amendments, procedural law and other facts. The workbench stores the user's reviewed deadline but does not calculate it.
An insolvency event can change the entire response path
A bankruptcy, proposal, restructuring filing, stay, monitor or trustee communication should move immediately into specialist review. Federal insolvency law can affect lease disclaimer, termination and other rights, and the relevant facts and proceeding matter. Do not rely on the ordinary arrears workflow to decide what action is permitted.
Preserve the document, court or proceeding reference, date received, responsible counsel and next controlled action. The workbench treats an unresolved insolvency signal as a critical escalation; it does not verify a filing or interpret the effect of federal or provincial law.
A payment proposal is not a signed amendment
Keep proposed installments visibly unsigned until the complete agreement is executed and verified. Once signed, record the source, legal review, rights-reservation decision and every installment's due date, scheduled amount, paid amount, status and evidence. Do not overwrite the original invoice or cash history when the plan changes expected payment timing.
A payment plan may address defaults under the plan, notices, waivers, releases, security, allocation, interest, tax and remedies. Those terms require transaction-specific advice. A checkbox records that review occurred; it does not create or preserve a legal right.
Export a review pack and keep the systems aligned
Export the charge, recovery, allocation, aging, dispute, interest, notice, plan and issue records. Retain the complete source package under the organization's approved privacy and retention rules. Reconcile any approved settlement, credit or payment back to the accounting ledger rather than treating a browser export as a posting instruction.
Route invoice questions to the Rent Invoice Audit, recurring performance issues to the Obligations register, only professionally reviewed dates to Critical Dates and any proposed deposit, guarantee or letter-of-credit action to the Lease Security workspace. Assign one accountable file owner and preserve adviser approval and communication history.
Frequently asked questions
Does the tool calculate a legal cure deadline?+
No. It stores an entered cure-period reference and a separately entered reviewed deadline. It does not add days, adjust weekends or holidays, choose a trigger date or determine whether notice or cure is legally required.
How are partial payments handled?+
Each payment can be split across one or more specific charge IDs. Only payments dated on or before the as-of date count, and any amount not allocated remains visible as unapplied.
Can I track a disputed operating-cost reconciliation?+
Yes. Enter the gross approved ledger charge and its disputed portion, but use the Additional Rent Reconciliation workspace to test the underlying statement. Recording a dispute does not create withholding or set-off rights.
How is interest calculated?+
The optional model uses simple interest on marked charges from each entered start date, reduces principal on allocation dates and applies the entered annual rate and day-count denominator. It is not an invoice or conclusion that interest is owed.
Can I apply a security deposit or letter of credit?+
You can record an entered application and allocation, but the tool flags missing authority. The lease, instrument, facts, approvals and legal, accounting and tax review control whether and how an application may occur.
Does a disputed balance count in aging?+
Yes. Aging shows the full outstanding ledger by entered due date, while disputed and undisputed portions are displayed separately so neither view erases the other.
What happens when a payment plan is signed?+
The installment schedule is administered separately from the original ledger. The workspace tracks scheduled, paid and remaining plan amounts and flags overdue or unsupported records without deciding legal consequences.
Is the export a demand notice or accounting entry?+
No. CSV, text and JSON exports are review files based on entered data. They do not deliver notice, process cash, post a credit, establish debt or authorize a remedy.
Where the factual guidance comes from
These links support narrow factual points in this guide. They do not replace review of the proposal, executed lease or advice for the actual transaction.
Canada Revenue Agency — GST/HST Memorandum 3-9: Early and Late Payments ↗Official CRA guidance on GST/HST treatment of early-payment discounts and late-payment surcharges or penalties. Transaction-specific tax review remains necessary.Ontario — Renting commercial property in Ontario ↗Official provincial overview emphasizing that commercial tenancies differ from residential tenancies and directing users to the lease and applicable law.Ontario — Commercial Tenancies Act ↗Official current statute source. The guide and workbench do not interpret the Act or apply its remedies to a file.British Columbia — Commercial Tenancy Act ↗Official current statute source for British Columbia. Obtain transaction-specific advice before acting.Canada — Bankruptcy and Insolvency Act, section 65.2 ↗Official federal provision concerning commercial leases in specified insolvency proposal circumstances. Specialist advice is required for any actual proceeding.This guide is general educational information and financial-workflow support. It is not legal, tax, accounting, engineering, environmental, appraisal or brokerage advice. Verify source documents and obtain appropriate professional advice before acting.