Source the executed lease, amendments, notices and approved schedules. Keep each category and effective month explicit.
LEASE SCHEDULE · INVOICE LINES · CREDITS · PAYMENTSProve every
Prove every
rent dollar.
Rebuild the expected net charge schedule from controlling documents, allocate every invoice and credit by service month and category, reconcile tax and document arithmetic, and send unexplained differences into a controlled finance review queue.
THE CONTROL PRINCIPLE
A paid invoice can still be the wrong invoice.
Reconcile stated subtotal, tax and total to the complete line detail before comparing the lease.
Allocate multi-month bills and credits to the months and charge categories they actually describe.
Track entered settlement and ageing separately so paying a document never erases a billing exception.
01 · AUDIT CONTROL FILE
Define one lease, one period and one tolerance.
The audit compares net expected charges with net invoice-line amounts. Tax, credits, payments and documentary fields remain visible as separate control layers.
02 · EXPECTED CHARGE SCHEDULE
Transcribe the lease before testing the invoices.
Separate base rent, estimates and other fixed charges. Enter zero-charge months explicitly where needed; do not manufacture CPI, percentage rent, audit adjustments or tax treatment from a category label.
03 · CSV INVOICE INTAKE
Bring in invoice lines without uploading a file.
Paste CSV text into this browser. Repeated supplier, document type and invoice number rows become one multi-line document. Preview errors before replacing or appending to the current register.
04 · INVOICE, CREDIT & PAYMENT REGISTER
Reconcile the document before comparing the lease.
Stated document amounts, line arithmetic, tax fields, service periods, source and settlement are controlled independently. A credit note reduces invoiced net charges; an entered payment changes outstanding balance, not the billed variance.
01invoiceINV-2026-001STATED TOTAL$15,225.00OUTSTANDING$15,225.0088% DOC+
DOCUMENT CONTROL
LINE SUBTOTAL$14,500.00
LINE TAX$725.00
LINE TOTAL$15,225.00
DAYS PAST ENTERED DUE30
INVOICE LINESAllocate net and tax across the actual service period.
05 · MONTHLY CATEGORY VARIANCE
Find exactly when and where the bill diverged.
Multi-month lines are allocated evenly across their entered service months. Credit notes subtract from their month and category. Review the allocation method against the actual document before relying on a variance.
| Month | Category | Expected net | Invoiced net | Variance | Status |
|---|---|---|---|---|---|
| 2026-02 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-02 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-02 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-03 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-03 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-03 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-04 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-04 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-04 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-05 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-05 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-05 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-06 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-06 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-06 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-07 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-07 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-07 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-08 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-08 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-08 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-09 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-09 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-09 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-10 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-10 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-10 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-11 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-11 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-11 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
| 2026-12 | Base rent | $10,000.00 | $0.00 | -$10,000.00 | missing invoice |
| 2026-12 | Additional rent estimate | $4,000.00 | $0.00 | -$4,000.00 | missing invoice |
| 2026-12 | Parking | $500.00 | $0.00 | -$500.00 | missing invoice |
06 · DETERMINISTIC REVIEW QUEUE
What still prevents a controlled finance handoff?
Errors identify invalid, duplicate or unreconciled records. Warnings identify missing evidence, documentary fields, tax arithmetic, service-period allocation, settlement and charge variances that require human review.
Tenant legal name is missing.
Landlord legal name is missing.
Premises reference is missing.
Entered monthly base rent needs a source document and exact reference.
Entered monthly additional-rent estimate needs a source document and exact reference.
Entered monthly parking charge needs a source document and exact reference.
Supplier GST/HST registration number is not entered for a document of $100 or more.
Document source has not been marked verified.
Entered invoice is 30 days past its entered due date with $15,225.00 outstanding.
2026-02 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-02 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-02 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-03 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-03 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-03 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-04 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-04 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-04 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-05 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-05 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-05 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-06 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-06 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-06 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-07 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-07 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-07 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-08 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-08 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-08 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-09 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-09 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-09 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-10 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-10 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-10 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-11 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-11 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-11 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
2026-12 Base rent is missing invoice: $0.00 invoiced versus $10,000.00 expected, a -$10,000.00 variance.
2026-12 Additional rent estimate is missing invoice: $0.00 invoiced versus $4,000.00 expected, a -$4,000.00 variance.
2026-12 Parking is missing invoice: $0.00 invoiced versus $500.00 expected, a -$500.00 variance.
CONNECTED LEASE CONTROL
From lease words to the payable queue.
Use the Lease Abstract to source the executed charge mechanics, this audit to compare recurring bills, the Additional Rent Reconciliation workspace for annual recovery statements, and qualified finance, tax and legal advisers for approval, disputes and filing treatment.