Commercial rent schedule and invoice audit in Canada

Separate the four records that explain a rent dollar

A reliable rent audit does not begin with the accounts-payable ledger. It begins with the controlling lease documents and builds a month-by-month expectation. The invoice then becomes evidence of what the supplier billed, the payment record shows what was settled, and the tax file supports the organization’s tax review. Those records interact, but none proves the others.

Give each lease a stable identifier and preserve the executed lease, amendments, commencement evidence, rent notices, operating-cost estimates, parking or storage agreements and other applicable schedules. The audit file should state its as-of date, currency, property, parties, preparer and reviewer. Browser storage is a working convenience; approved records belong in the organization’s controlled system.

Rebuild the expected charge schedule before comparing invoices

Create one expected-charge rule for each category and effective period. Base rent, operating costs, property taxes, utilities, parking, storage, management or administration fees and other charges should not be collapsed into an all-in total. Separate categories make escalation, caps, exclusions, credits and annual true-ups reviewable.

For each rule, record the first and last service month, monthly net amount, entered tax treatment and rate, exact source location and verification status. Do not infer a recurring monthly amount from one invoice. If a contractual formula, index, proportionate share or annual estimate changes, preserve the prior period and add a new sourced rule rather than overwriting history.

• Keep signing, possession, commencement and rent-commencement dates distinct.
• Record gross, semi-gross and net lease allocations according to the actual documents, not the marketing label.
• Split fixed recurring charges from estimates, direct charges and annual reconciliations.
• Use exact section, schedule, notice and page references wherever possible.
• Leave unknown periods visible; do not manufacture a complete schedule from incomplete evidence.

Use a charge taxonomy that survives review

The category assigned to a line determines where the variance appears and which lease clause or annual reconciliation it connects to. A vague label such as ‘monthly rent’ can conceal a base-rent escalation, a property-tax estimate, a utilities recovery and a parking charge. Classify by the economic source described in the lease and supporting document, while preserving the supplier’s original line description for traceability.

Classification does not determine legal entitlement or accounting treatment. A landlord may combine categories on an invoice or use terminology that differs from the lease. Record the mapping, cite the source and send uncertain or new charge types to the lease administrator, finance owner and counsel or tax adviser as appropriate.

Capture the invoice at line level and by service period

An invoice date and due date are not enough to compare rent. Capture supplier, invoice number, document type, invoice and due dates, stated subtotal, stated tax, stated total, entered payment amount and date, source reference and every underlying line. Each line needs a net amount, category, service-period start and end, and entered tax treatment and rate.

When one line covers multiple months, allocate it across the inclusive service period using a documented method. The workbench divides an entered line evenly across its stated service months; if the actual contract requires daily proration, uneven instalments or another calculation, prepare the correct line allocation outside the tool and import the resulting monthly detail. Never use the invoice date as a silent substitute for the service month.

Preserve credits, payments and ageing without erasing variance

Enter a credit note as its own document with its original reference, lines and service periods. A credit should reduce the applicable monthly and category charge while remaining traceable to the invoice or issue it corrects. Avoid manually netting a credit into a later invoice because that destroys the sequence and can hide an unresolved prior-period error.

Track entered payment separately from invoice correctness. Outstanding and overdue calculations can help prioritize review, but they are not a legal determination of the amount owing, default, interest or remedy. Partial payments, unapplied cash, set-off, disputed amounts, security deposits and landlord statements require their own evidence and authorized decisions.

• Retain the original invoice even after a full credit.
• Link partial credits to the affected category and service month.
• Do not mark a variance resolved merely because the invoice was paid.
• Reconcile payment records to AP, bank and supplier statements in the authoritative system.
• Escalate disputed or overdue items under the approved legal and finance process.

Check entered arithmetic and documentary fields—do not decide tax

The Canada Revenue Agency describes documentary information that registrants generally need to support input tax credit claims. Its current guidance distinguishes documents under $100, documents from $100 to $499.99, and documents of $500 or more. The required information grows with the amount and can include the supplier name, date, total, GST/HST amount or inclusion indication, taxable status, supplier registration number, recipient name, description and payment terms.

The workbench uses those current thresholds only to flag missing entered fields and compares stated tax to the user-entered line treatment and rate. It does not verify a supplier registration number, determine place of supply, decide whether a supply is taxable, zero-rated or exempt, establish input-tax-credit eligibility, allocate mixed-use amounts, apply Québec sales tax rules or prepare a return. Use official current guidance and qualified tax advice for the actual transaction.

Review the monthly category matrix, not just annual totals

Compare expected net charges with net invoiced charges after credits for every category and month. The useful exception set includes exact matches, overbilling, underbilling, an expected charge with no invoice and an invoice with no expectation. Keep tax variance and document arithmetic separate so a correct net rent comparison does not hide a tax or subtotal problem.

An annual net match can still contain timing and classification errors: one month may be doubled while another is missing, or an operating-cost amount may be coded as base rent. Review document-level exceptions beside the monthly matrix. Require an owner, explanation, supporting evidence, action and resolution date for every material difference under the organization’s threshold policy.

Connect recurring estimates to the annual additional-rent statement

Monthly invoices often collect estimated operating costs, property taxes or other recoveries. The annual landlord statement can then compare estimated collections with actual costs and produce a balance or credit. The recurring invoice audit should prove what was billed and credited by month; the Additional Rent Reconciliation workspace should separately test the annual cost pool, exclusions, allocation, gross-up, caps, fees, direct charges and capital-cost treatment entered by the user.

Tie the annual statement’s prior billings to the audited monthly ledger. Differences can arise from missing invoices, late credits, service-period allocation, lease-year versus calendar-year timing, tax, tenant area changes or the landlord’s own aggregation. Do not force the two files to agree. Preserve the reconciling items and obtain the complete source package required by the lease and review team.

• Export category totals from the recurring audit for the statement period.
• Separate net recovery amounts from GST/HST or other entered tax.
• Reconcile opening credits and prior-year adjustments explicitly.
• Keep estimated monthly rates and final annual allocation mechanics distinct.
• Carry unresolved statement issues into the approved dispute and payment process.

Route evidence to the people authorized to decide

A deterministic exception is not a legal conclusion. The lease administrator can verify the document hierarchy and schedule; accounts payable can validate document intake and settlement; the controller can define materiality and approval controls; tax advisers can assess tax treatment; and counsel can interpret entitlement, notice, audit, dispute, interest, set-off and remedy provisions. Assign the right owner instead of allowing a calculator status to approve or reject payment.

Document the organization’s response timelines and escalation path. Some leases contain short notice or audit windows, specific delivery mechanics or payment-without-prejudice considerations. The workbench does not calculate or adjust those legal dates. Connect any response deadline to the Critical Dates register using the complete lease and qualified legal review.

Make rent review a recurring close control

Run the audit at invoice intake and again during the monthly close. Refresh the expected schedule only from new controlling evidence. Import or enter complete documents, review the exception queue, reconcile payments in the authoritative ledger, preserve approvals, and export a dated variance file. At quarter- or year-end, review source coverage, duplicate patterns, open credits, overdue items and changes that may also affect the lease abstract, obligations, critical dates, portfolio and accounting records.

The workbench stores its draft locally on the device and exports CSV, text and JSON. It does not upload lease or invoice documents, post to an accounting system, initiate payment, send a dispute, validate records or retain an enterprise audit trail. Store the reviewed file in the approved repository with access, version, retention and preparer-reviewer controls.

• Lock the period and retain the reviewed export before changing source rules.
• Use stable lease, property, supplier and document identifiers across systems.
• Reconcile the invoice register to AP completeness reports and supplier statements.
• Trend recurring exception types and fix upstream intake or lease-data problems.
• Keep legal, tax, accounting and payment approval outside the browser tool.