Technology Consultants

Match CAM with lease evidence

Replace standard three way match for CAM statements.

By Angel Campa, FounderUpdated July 15, 2026

I work as a principal engineer. I built the engine behind these audits. Each finding points to the lease clause and the bill line. Your team reviews and signs first.

Match CAM with lease evidence

Standard three way match does not fit annual CAM.

Oracle defines its match around three records. They are the bill, order, and receipt.

A landlord CAM statement has another structure. The lease sets the billing rules.

Planned CAM payments show what the client paid. The annual statement reports actual costs.

Landlord support explains those costs. These records need a lease aware match.

Know why the match fails

A purchase order states what the buyer wants. A receipt shows what arrived.

The vendor bill asks for payment. Standard matching compares those three records.

Washington State Auditor guidance uses that same basic model. Its rules apply to public agencies.

The control idea is still useful. The evidence must fit the transaction.

CAM is annual lease math. There may be no goods receipt.

There may also be no purchase order. A forced PO match can still miss lease errors.

Use three CAM evidence legs

Build the CAM match around three evidence legs.

Evidence leg Main records Main question
Lease rules Lease and changes What may the landlord charge?
Client payments Estimates and ledger What did the client already pay?
Annual actuals Statement and support What costs did the landlord report?

The third leg includes source support. Do not accept the statement total alone.

Lease invoice guidance calls for lease checks. It also calls for support on landlord true ups.

That source gives practice guidance. The signed lease remains the main source.

Map the lease rules

Turn each lease rule into a review field.

Start with these fields:

  • CAM definition
  • Cost exclusions
  • Share method
  • Area or other base
  • Management fee rule
  • Gross up rule
  • Cap rule
  • Base year rule
  • Tax treatment
  • Insurance treatment
  • Review rights
  • Notice terms

Do not guess when a clause is unclear. Assign that clause to a reviewer.

Counsel should review disputed legal meaning. The AP team should not make that call.

Match planned CAM payments

Create a payment schedule by lease year.

Use the client ledger as the source. Keep landlord planned bills as another record.

Field Purpose
Payment date Shows when money left
Payment amount Shows the amount paid
Lease year Links payment to the statement
Property Prevents site mixing
Payee Confirms the landlord entity
Invoice reference Links the source bill
Ledger link Preserves client evidence

Do not net unknown credits into the total. Route an unknown credit as an exception.

The payment sum answers one question. It does not prove the statement costs.

Test annual actuals

Break the statement into testable rows.

For each row, save these fields:

  • Cost name
  • Reported amount
  • Support link
  • Lease rule link
  • Allocation base
  • Client share
  • Deterministic result
  • Difference
  • Review state
  • Review owner

"Fixed math" means the same inputs give one answer. It does not mean the clause explains itself.

The reviewer decides which rule applies. Then the system can run the chosen math.

Use clear exception types

Do not combine every mismatch under one label.

Exception Meaning Owner
Missing lease The rule source is absent Client file owner
Missing payment A ledger record is absent AP owner
Missing support A statement row lacks proof CAM reviewer
Amount mismatch Saved amounts do not agree AP owner
Math mismatch Fixed math differs CAM reviewer
Clause question Lease meaning is unclear Senior reviewer
Legal question Rights or meaning are disputed Counsel
Payment decision Client action is needed Client approver

Walk one CAM match

This match example is fictional. The lease, property, and amounts are made up.

Green Pine Retail leases one store. Its lease allows a stated CAM share.

The client paid $12,000 in planned CAM bills. The annual statement reports $14,500 due.

The landlord asks for a $2,500 true up. That subtraction is correct.

Yet one cost row lacks support. The lease also excludes one listed cost.

Record the match this way:

Leg Evidence Result
Lease rules Signed lease and change Exclusion needs testing
Client payments Ledger totals $12,000 Payment total supported
Annual actuals Statement totals $14,500 One row lacks support
True up math $14,500 less $12,000 $2,500 stated difference
Review result Open Cost rows need review

Correct subtraction does not close the review. The cost base may still be wrong.

The AP owner confirms the $12,000 history. The CAM reviewer tests the cost rows.

The client approver controls payment action. Counsel reviews any disputed clause meaning.

Save one approval record

The final record should preserve each decision.

Save these items:

  1. Lease rule links
  2. Payment schedule link
  3. Statement and support links
  4. Recalculation record
  5. Open exceptions
  6. Reviewer decision
  7. Counsel note when needed
  8. Client payment decision
  9. Final output link

Do not replace evidence with a status word. "Matched" needs proof behind it.

Do not replace review with software output. A person must own the final decision.

Add the model to AP

Your AP tool can route the evidence. It can also track status and age.

Do not claim a native CAM connector. Use exports or linked records as needed.

Send the saved match record to the client approver.

The AP consultant pillar puts that record in the offer. The landlord invoice guide sorts issues before matching.

The CAM queue guide holds the match record. The utility control handles utility overlap.

The system consultant hub shows more system work. Use the Practice Growth hub to find another review owner.

Where CAMAudit fits

CAMAudit checks the three evidence legs in the record. It does not create the source records.

Working record Next owner
CAM match record AP automation consultant

It does not create receipt records. It does not approve payment.

CAMAudit reads the supplied lease and CAM records. It may run fixed math from chosen inputs.

It may flag a mismatch and cite source lines. It can place the checked work in a branded CAM audit.

Your firm reviews, then signs the checked CAM audit. Your team keeps final judgment.

The checked record may support a dispute letter draft.

CAMAudit may prepare that draft.

The draft is not legal advice.

Have counsel review before sending.

Carry the match record into the service line guide.

Ready to add this work to your firm? Get started.

Sources

Practice Growth

Keep growing this service

See the AP automation consultants growth guide

Ready to run this for a client?

Register and set up your branded workspace. You review and sign every report.

Next: Sell

More in Technology Consultants

Bring CAM audits to your practice

Register and set up your branded workspace. Your firm name is on every report.