NNN Operating Expense Reconciliation: A Landlord's Month-End Workflow

NNN Operating Expense Reconciliation: A Landlord's Month-End Workflow
The worst time to discover an expense-coding problem is after you have sent an NNN true-up to a tenant.
By then, the questions are harder to answer: Was that invoice recoverable? Which expense pool applies? Did the tenant's pro-rata share change after a vacancy? Does the lease cap apply to this category? A year-end reconciliation can look like an accounting project, but most of its risk is created during the ordinary months before it.
A dependable month-end process gives each invoice, lease rule, and allocation a place to land while the details are still fresh. It also gives you a file that can explain a number before a tenant has to ask.
This workflow is for commercial landlords and property managers who need to keep NNN operating expenses organized throughout the year. Your leases control what is recoverable and how it is allocated, so use this as an operating framework—not a substitute for the lease, your accountant, or local advice.
What Month-End Is Supposed to Accomplish
Month-end is not the time to prepare a tenant's annual true-up. It is the time to make the eventual true-up easier to prepare and easier to support.
At the end of each month, you should be able to answer five practical questions:
1. Which operating expenses were posted for this property and period? 2. Which costs appear recoverable, nonrecoverable, or still need review under the lease? 3. Which expense pool and allocation method applies to each recoverable cost? 4. Has anything changed in occupancy, leased area, or another denominator that affects allocations? 5. What documents support the entries and any judgment calls?
If those answers live in inboxes, vendor portals, and separate spreadsheets, the annual reconciliation becomes a reconstruction exercise. If they live in a consistent monthly file, the final process becomes reviewable.
Step 1: Close the Expense Period Before You Start Calculating
Start with a defined cutoff. Confirm that the major invoices, payroll or contract charges, utility bills, tax payments, and credits that belong to the month have either been recorded or flagged as pending.
This does not mean every bill must arrive before you close the month. It means late bills and estimates need an obvious status so they do not disappear. Keep a short exception list with the vendor, service period, expected amount if known, and expected posting month.
A simple rule helps: record expenses by the period they relate to whenever your accounting process permits, and keep the source document attached or linked. A January utility bill may cover December usage; an annual insurance premium may need to be tracked over a longer period. The goal is not to force every cost into a perfect monthly number. The goal is to preserve the period and reasoning you will need later.
Step 2: Review New Charges Against Your Expense Map
Do not wait until year-end to decide whether a charge belongs in CAM or another recovery category. Review new and unusual expenses while the invoice, vendor, and property context are close at hand.
For each material charge, confirm:
- The property and service period are correct.
- The expense category matches your chart of accounts and lease abstracts.
- The cost belongs in the right pool, such as common area, building-wide, or a tenant-specific category.
- The invoice includes a note or documentation if the treatment is not obvious.
- Credits, rebates, insurance proceeds, or vendor adjustments are not being overlooked.
A $4,000 landscaping bill may be ordinary common-area maintenance at one center. At another, it may include work for an exclusive-use area that should not be shared by every tenant. The invoice amount is only one part of the decision; the lease and the purpose of the work determine how you treat it.
Step 3: Refresh the Lease Rules You Will Need Later
The lease is not a document to reopen only when a tenant challenges a bill. Keep a working abstract for each tenant that captures the clauses that affect operating-expense recovery.
At month-end, review any leases affected by new costs, renewals, amendments, move-ins, move-outs, or unusual allocations. Confirm the current rules for:
- Recoverable and excluded expense categories
- Pro-rata share or another allocation basis
- Gross-up language, if applicable
- Caps on controllable expenses
- Management-fee treatment
- Audit rights, notice requirements, and statement deadlines
- Expense pools or costs that are unique to a building, parcel, or tenant
This is also the time to note ambiguity. Do not silently make a one-off interpretation in a formula and hope to remember it next year. Record the question, the lease section, the working treatment, and who needs to confirm it. A clear exception log is far better than a mysterious adjustment at reconciliation time.
Step 4: Check the Denominators Before They Distort the Whole Year
Many reconciliation errors are not caused by bad arithmetic. They are caused by a denominator that was correct in January and wrong by June.
Review the property facts that drive allocations:
- Rentable or leasable square footage used by the lease
- Occupied versus vacant space when gross-up rules matter
- Tenant openings, closures, expansions, contractions, and renewals
- Changes to a shared service area or expense pool
- Any fixed share, minimum share, or special allocation in the lease
Keep the effective date with every change. If a tenant takes additional space on the 15th, a year-end file needs to show whether the lease calls for a mid-month allocation, the first full month, or another treatment. Do not overwrite the old value without preserving the date and source.
Step 5: Compare Actuals to Budget and Monthly Estimates
A month-end variance review is your early-warning system. Compare year-to-date actual operating expenses with the budget and with the tenant estimates you have billed.
You are looking for explanations, not just differences. Large changes can be legitimate: insurance renewals, property-tax assessments, storm repairs, utility usage, or a newly required contract may all move the numbers. But an unexplained difference deserves a second look before it compounds through the year.
Use a consistent review threshold that fits the property. For example, flag a category when it is materially over budget in dollars or percentage terms, then write a brief reason for the variance. The note may be as simple as "annual insurance renewal posted in March" or "invoice belongs to prior ownership period; awaiting support." Those notes are valuable when you revisit the category months later.
Step 6: Keep a Reconciliation-Ready Support File
A tenant should not receive a surprise balance supported only by a final spreadsheet. Build the support file as you go.
For each period, retain or link:
- General-ledger detail and the trial balance or property expense report
- Material invoices, contracts, tax bills, and credits
- Lease abstracts and amendments used for recovery rules
- Allocation schedules and effective-date changes
- Variance notes and exception decisions
- A record of estimated payments billed and received
The file does not need to be complicated. What matters is that another person can follow the path from an expense total to the tenant's share. Good records reduce the time required to answer a reasonable question and help you catch your own mistake before the statement goes out.
Step 7: Carry Open Questions Forward—Do Not Bury Them
End each month with a short list of unresolved items. Typical examples include an invoice waiting on backup, a lease clause that needs interpretation, an ownership-period adjustment, or a vendor credit that has not posted.
Assign an owner and a next action for each item. At the next close, review the prior list before creating a new one. This keeps temporary workarounds from becoming permanent errors.
A useful discipline is to separate three statuses:
- Complete: posted, categorized, and supported
- Pending: expected information or a late item is still outstanding
- Needs decision: the accounting entry is known, but lease treatment or allocation still requires review
That distinction makes it clear what can proceed and what should not be included in a final tenant calculation yet.
A Month-End Checklist for NNN Operating Expenses
Use this concise checklist after each close:
1. Confirm the expense-period cutoff and list late or estimated items. 2. Review new and unusual charges for property, category, pool, and recovery treatment. 3. Update lease abstracts for amendments, tenant changes, and exceptions. 4. Verify allocation denominators and their effective dates. 5. Compare actuals with budget and monthly estimates; document material variances. 6. Save or link the reports and source documents that support the period. 7. Assign owners and next steps for open questions.
The Payoff at Reconciliation Time
The annual NNN reconciliation still requires careful work. You will need to apply the lease rules, calculate tenant shares, account for caps or exclusions, and compare actual recoveries with estimated payments. But you will be working from a maintained record instead of rebuilding the year from memory.
For a deeper walkthrough of the true-up itself, read our NNN CAM reconciliation guide. If you are testing allocation assumptions before finalizing a schedule, the CAM calculator can help you model the math; the applicable lease and supporting records remain the source of truth for each tenant.
PigJet helps commercial landlords keep lease obligations, operating expenses, and tenant follow-up work in one place—so month-end is less of a scramble and year-end has fewer surprises. See how PigJet supports commercial property operations.