Accounting Firms

Pro rata share worksheet

A worksheet for checking rentable area, denominator area, and share logic before partner signoff.

By Angel Campa, FounderUpdated June 28, 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.

Pro rata share worksheet

Use this worksheet when the billed share may not match the lease or area support.

The tenant is your client's client. Your firm owns the relationship, decides the scope, and signs off before delivery.

Where it fits

Use it when the file needs an owner, a source page, and a stop point. It is for workpapers, client prep, and partner review inside the firm.

Copy-and-use artifact

Copy this into your workpaper system. Keep the left column steady so reviewers can compare files across clients.

Field Entry Source or note
Tenant rentable area
Building rentable area
Center area
Stated lease share
Billed share
Landlord pool
Excluded areas
Amendment changes
Calculated share
Difference
Reviewer method

Review path

  1. Name the staff owner and partner reviewer.
  2. Save the lease, amendments, statement, and backup in the file.
  3. Tie each note to a clause, statement line, or support page.
  4. Mark missing support in plain words.
  5. Separate math checks from judgment calls.
  6. Draft client wording only after source support is reviewed.
  7. Record partner signoff before delivery.

Share methods

Method Numerator Denominator Calculated share Difference from billed
Lease stated share
Area-based share
Landlord billed share

Partner signoff note

Reviewed by:
Date:
Client-ready items:
Open items:
Items held back:
Counsel review needed:
Next step approved:

Common mistakes

  • Using building area for a center-wide charge.
  • Missing an amendment that changed square footage.
  • Reporting a share variance without the source page.

Pro-rata share worksheet

Use this worksheet when the client's share may not match the lease or rentable area schedule. Show the stated share, source area, billed share, and recalculation path.

Intake Fields

Field What to Capture Why It Matters
Client and location Legal client name, store or site name, property address, and internal owner Keeps multi-location work from mixing files
Lease source Base lease, amendments, side letters, renewal notices, and abstracts used Shows what the reviewer actually relied on
Statement source CAM, NNN, tax, insurance, utility, or operating expense statement reviewed Ties every question to the landlord document
Review period Month, quarter, reconciliation year, or renewal window Prevents old support from being used for a new issue
Client goal Scope, cost question, renewal support, diligence, or operating control Keeps the work from drifting into unsupported advice
Partner owner Person who reviews and signs the output Makes professional judgment explicit

Document Request

Send a narrow request first. Ask for the signed lease package, every amendment, side letter, commencement letter, latest reconciliation statement, landlord backup already received, and the prior-year statement if the client has it. If the client has a lease abstract, request it but do not treat it as the source of truth. The reviewer should use the abstract as a map and cite the signed documents.

If a file is missing, mark it in the exception log instead of filling the gap from memory. A missing amendment, side letter, or backup schedule can change the answer. The partner can still continue scoping, but client-facing findings should wait until the gap is acknowledged.

Review Workflow

Step Reviewer Action Partner Check
1 Confirm the lease package is complete enough for the agreed scope Decide whether gaps are acceptable or need a hold
2 Mark the clause, statement line, and support page for each review item Confirm the source cite is strong enough for client use
3 Separate math issues from classification issues Decide whether deterministic math or professional classification is needed
4 Draft the client note in plain language Remove overclaiming, legal advice, or unsupported recovery language
5 Prepare the next-action options Choose whether to request backup, monitor, escalate, or close

Decision Gates

Use these gates before the partner signs off:

  • The finding cites a lease clause and a statement line.
  • The math can be repeated from the source packet.
  • The client impact is described as a review item, not a promised outcome.
  • Any legal-rights question is routed to counsel.
  • The client communication names what is known, what is missing, and what the partner recommends next.

A file that fails one of those gates is not bad work. It is simply not ready for delivery. Keep it in the review queue and send a focused follow-up request.

Client Communication Draft

We reviewed the lease documents and the landlord support available for this scope. The item below is ready for partner review because it ties to a specific lease term and statement line. Before any landlord communication, we recommend confirming the open items listed in the source packet.

Use that wording as a starting point. It keeps the partner in control and avoids promising an outcome.

Where software supports the math file

CAMAudit can keep the clause, statement line, support page, and recalculated amount in one review file. The math path stays visible, and the partner decides whether the item is strong enough for client delivery.

Quality-Control Checklist

  • Source packet names every document used.
  • Findings are grouped by client decision, not by software output.
  • Open gaps are visible in the handoff.
  • The final note avoids legal advice unless counsel supplied it.
  • The partner can explain the finding without rereading the entire file.
  • Internal links point to adjacent resources the reviewer can actually use next.

Delivery review notes

Use these notes before the artifact becomes client-facing work. Confirm the decision, the source support, the owner, and the items that should stay internal.

First, name the decision the client needs to make. Some files need a backup request. Some need a renewal question. Some need a pricing or scope decision. If the decision is unclear, the partner should not send the item yet.

Second, tie the recommendation to source support. The reviewer should be able to point to the lease clause, amendment, statement line, invoice, or backup page that caused the issue. If the support is missing, the deliverable should say that support is missing and ask for the exact item.

Third, assign an owner. A staff member can prepare the workpaper, but a partner or senior reviewer should own the client-facing note. That owner checks tone, removes overstatement, and decides whether counsel needs to review the file.

Fourth, save the final packet. Keep the source documents, workpaper, draft note, and signed client communication together. That file becomes the starting point for next year's reconciliation season or the next location review.

Follow-up Prompts

  • What would change the partner's answer?
  • Which missing document would stop delivery?
  • Which line should the client see first?
  • What should be routed to counsel, if anything?
  • What can be closed with no client action?

These prompts keep the work practical. They also help the firm train staff without turning the process into a black box.

Frequently asked questions

Who should use the pro rata share worksheet?

Partner firms that serve commercial NNN lease tenants can use it to structure review work before client delivery.

Is this built for partner-led delivery?

Yes. It is written for partner-led work where the partner owns the client relationship and final review.

Where does CAMAudit fit?

CAMAudit can be the branded engine behind document review, workpapers, and report support while the partner reviews and signs.

What should the partner check before using it?

Check scope, documents, review rights, missing backup, and who has authority to approve client-facing language.

Can the wording be changed?

Yes. Partners should adapt the language to their engagement terms, review process, and professional standards.

Ready to run this for a client?

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

Next: Sell

More in Accounting Firms

Bring CAM audits to your practice

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