CAM reconciliation worksheet

Worksheet

Allocable expenses, this tenant’s share of each, what was billed on account, and what the reconciliation comes to.

Every line is rounded, then summed

Not summed and then rounded — which sounds like a detail and is the difference between a worksheet that foots and one that is a cent out from its own visible column. The figure printed beside each expense is the figure that went into the total, so a tenant checking it line by line arrives at the same number you did.

It has not read your lease

The worksheet decides nothing about which costs are recoverable. It applies no cap, no gross-up, no exclusion, no base year and no administrative fee, and it does not determine what any tenant owes. Which expenses go on it, and at what share, are judgments you make from the lease — and the notes column is there so the reasoning sits beside the number when somebody asks.

Shares are held to two decimal places

A pro-rata share is usually something like 12.47%, and multiplying cents by a floating-point 0.1247 puts an approximation in the middle of a figure somebody gets billed for. The share is stored as whole basis points and the split is integer arithmetic end to end.

Where the inputs come from: Rent roll · Lease abstract · Vendor bill tracker

Arithmetic on figures you entered. CompliMaint does not read your lease, does not decide which costs are recoverable, applies no cap, gross-up, exclusion or administrative fee, and determines what no tenant owes. Every input and every judgment behind it is yours. Everything runs on your device.

Questions people ask

Does it know what costs are recoverable?
No, and it must not. What a lease permits a landlord to pass through turns on the lease's own wording, which this tool has not read. You decide what goes on the worksheet; it does the arithmetic and shows its working.
Does it apply caps, gross-ups or a base year?
None of them. No cap, no gross-up, no base year, no exclusion and no administrative fee are applied automatically. If your lease provides for any of them, apply them to the figures you enter and say so in the notes.
What does a negative reconciliation mean?
That on the figures you entered the tenant was billed more on account than their share came to — an over-billing, which is an ordinary outcome and is labeled as a credit rather than as an error.
How precise are the shares?
Two decimal places of a percent, held as whole basis points, with the split done in integer arithmetic. Nothing drifts through the worksheet: each line rounds once, and the total is the sum of the rounded lines.