What is the purpose of pre-screening a reconciliation before formal audit?

Pre-screening uses structured abstract fields to quickly evaluate whether a reconciliation is likely to contain significant errors before committing time and cost to a full review. Not every reconciliation warrants a formal audit. Pre-screening identifies which ones do by checking whether the denominator matches the abstracted basis, whether management fee caps are respected, whether the gross-up assumption is consistent with prior years, and whether the audit window remains open. Leases that pass the pre-screen without any flags can be approved or deferred with low risk. Leases that generate flags during pre-screening are the candidates for formal review.

How long does a reconciliation pre-screen typically take?

For a lease with a complete audit-ready abstract, a pre-screen takes approximately 15 to 30 minutes per reconciliation, depending on the number of fields to check and whether any flags require brief follow-up. For a portfolio with well-structured abstracts, the triage step across 20 to 30 leases can be completed in a day. Leases with incomplete abstracts take longer because the reviewer must consult the source lease to resolve gaps.

Which abstract field is most frequently wrong when compared to the reconciliation statement?

The pro rata share percentage is the most frequently inconsistent field. Landlords sometimes apply a percentage that was accurate at one point in the tenancy but changed because of a denominator adjustment that was not communicated to the tenant. The pre-screen step that compares the reconciliation's stated pro rata percentage against the abstracted denominator basis catches this category of error before it becomes an approved charge.

What should a lease admin do when a pre-screen flag cannot be resolved without more information?

When a pre-screen flag cannot be resolved from the abstract and the reconciliation alone, the appropriate step is to request supporting documentation from the landlord before approving the statement. For a denominator question, request the current rentable area schedule. For a management fee cap question, request the management fee detail. For a gross-up methodology question, request the occupancy calculation supporting the normalization. The pre-screen flag is the trigger for that document request, not a conclusion that the charge is wrong.

Can the pre-screen workflow be automated?

Partially. The field comparison steps, such as confirming that the reconciliation's pro rata percentage matches the abstracted denominator calculation or that the management fee amount is within the capped percentage, can be rule-based and applied automatically when the abstract fields are structured. Interpretation steps, such as evaluating whether a gross-up methodology is consistent with prior years or whether an expense line item belongs in an excluded category, require human judgment. A hybrid approach, automated flag generation followed by human review of flagged items, is the most practical implementation for most lease admin teams.

The Fields That Let Lease Admins Pre-Screen Reconciliations Before Audit

Every annual CAM reconciliation statement that arrives represents a decision: accept as submitted, request clarification, or send for formal review. Making that decision well requires knowing which reconciliations are likely to contain errors significant enough to justify the review cost and time. The information needed to make that triage decision exists in the lease abstract.

This article presents a practical pre-screen workflow for lease admin teams, organized around the abstract fields most relevant to reconciliation accuracy. The goal is not to replace a formal review but to identify which reconciliations warrant one and which can be resolved with a quick check.

The Pre-Screen Logic

A reconciliation pre-screen is a structured comparison between what the lease says should happen and what the landlord's statement shows did happen. It does not require a full line-by-line audit of every expense category. It requires checking a specific set of abstract fields against the corresponding values in the reconciliation statement.

The pre-screen has four stages: (1) confirm the audit window is still open, (2) verify structural parameters against the statement, (3) check for expense-level flags, and (4) make a routing decision. The entire workflow can be completed with the abstract, the reconciliation statement, and a checklist.

Stage 1: Confirm the Audit Window Is Still Open

Before evaluating any of the reconciliation's contents, confirm whether the tenant's objection window is still active. This step takes priority because an incorrect reconciliation is only actionable if the dispute deadline has not passed.

Fields required: reconciliation delivery date (from the statement itself), dispute deadline (from the abstract, expressed as days after delivery), and consequence-of-silence provision (from the abstract).

Action: calculate the deadline by adding the dispute period to the delivery date. If the deadline has already passed and the lease contains final-and-binding language, note this before proceeding. Further review may still be appropriate for internal records or for future cycles, but recovery under the current statement is no longer possible. If the window is open, proceed to Stage 2.

Flag condition: deadline within 30 days. Any pre-screen finding that occurs within 30 days of the deadline should immediately escalate to priority status regardless of the finding's magnitude.

Stage 2: Verify Structural Parameters

Structural parameters are the high-level values in the reconciliation statement that should match the lease's defined terms. Mismatches in structural parameters indicate either a calculation error or a change in the lease terms that was not reflected in the abstract.

Check 2a: Pro rata percentage. The reconciliation statement almost always states the percentage used to allocate the total expense pool to the tenant. Compare this against the pro rata percentage in the abstract. If the statement uses a different percentage, confirm whether the abstract records denominator flexibility or project pooling rights that could explain a change. If no such flexibility exists, the percentage discrepancy is a flag.

Check 2b: Denominator basis. When the reconciliation states both the tenant's area and the total area, verify that the denominator matches the abstracted denominator description. A denominator that has changed year over year without an abstracted explanation warrants a documentation request.

Check 2c: Base year or expense stop reference. For modified gross leases, the reconciliation should show the base year amount or stop amount being used as the threshold. Verify this against the abstract's base year or stop amount fields. A discrepancy here means the tenant is paying escalations above the wrong baseline.

Check 2d: Management fee amount. If the abstract records a management fee cap, verify that the management fee line in the reconciliation statement does not exceed the capped percentage of the recoverable expense pool. Calculate: cap percentage multiplied by total recoverable expenses equals the maximum permitted management fee. Compare against the statement.

Flag condition: any mismatch in 2a through 2d that cannot be explained by abstracted flexibility provisions.

Stage 3: Check for Expense-Level Flags

Once structural parameters are verified, a targeted check of individual expense categories can identify specific line items that warrant closer review.

Check 3a: Excluded categories present. Scan the reconciliation line items against the abstracted exclusion categories. Look for line items that match excluded categories: legal fees, leasing commissions, debt service, non-building insurance, or categories the specific lease excludes. This is a matching exercise, not a deep accounting review.

Check 3b: Capital expenditures. Identify any line items that appear to be capital projects, major replacements, or equipment upgrades. Compare these against the abstracted CAPEX treatment field. If CAPEX is excluded and a capital item appears in the reconciliation, it is a flag. If permitted CAPEX recovery is allowed, verify whether the line item falls within the permitted categories and whether the amortization method matches the abstracted terms.

Check 3c: Gross-up consistency. For base year leases with gross-up provisions, check whether the current year's reconciliation uses the same occupancy assumption as prior years. If the gross-up percentage changed without an abstracted explanation, that is a flag worth investigating.

Check 3d: Year-over-year variance in individual categories. Significant increases in specific expense categories, above 15 to 20% in a single year, are worth flagging for review even when the total reconciliation increase appears within the controllable cap. Category-level spikes sometimes indicate costs that were moved from one period to another or costs that were incorrectly categorized.

Flag condition: any excluded category present in the statement, any CAPEX item outside permitted recovery parameters, gross-up inconsistency, or unusual category-level variance.

Stage 4: Routing Decision

Based on Stages 1 through 3, the pre-screen produces one of three routing decisions:

Approve for payment. No flags identified in any stage, deadline is not imminent, structural parameters match. The reconciliation is consistent with the lease terms at the level of the pre-screen. Approve or route for payment with a record that the pre-screen was conducted.

Request documentation. One or more flags identified that could be explained by documentation the tenant does not currently have: a current denominator schedule, management fee detail, CAPEX itemization, or occupancy calculation. Request the supporting documentation before approving. Set a deadline for the response that preserves the dispute window.

Route for formal review. Multiple flags identified, a structural parameter mismatch, or flags that require detailed calculation to evaluate. Route to a formal CAM review before the dispute deadline. If the deadline is within 30 days, consider filing a preserving dispute notice while the review is in progress to protect the window.

Using the Pre-Screen to Prioritize a Portfolio

For a portfolio with 25 or more leases, the pre-screen workflow serves as a triage tool across the entire reconciliation season. Running Stage 1 across all leases produces an urgency-ranked list based on remaining dispute windows. Running Stage 2 across all leases identifies structural mismatches that may indicate systematic errors. Running Stage 3 is reserved for leases that pass Stage 2 but still carry substantive risk flags from the trigger scoring described elsewhere.

The pre-screen is not a substitute for a formal CAM review for high-risk leases. It is the step that determines which leases are high-risk based on the data already in the abstract, before any time is spent on full reconciliation analysis.

For lease abstraction firms that offer portfolio management or advisory services, the pre-screen workflow is a deliverable that can be included with the annual abstract maintenance engagement. Running it across a client's portfolio at the start of reconciliation season provides the kind of operationally grounded advisory output that distinguishes managed-service abstraction from commodity data entry.

Firms applying this guidance can run a free audit through CAMAudit to verify how the detection engine handles these clauses on a real reconciliation statement.

The Fields That Let Lease Admins Pre-Screen Reconciliations Before Audit