Commercial Rent Roll vs. General Ledger: A Reconciliation Workflow for Landlords

Commercial Rent Roll vs. General Ledger: A Reconciliation Workflow for Landlords

Month-end gets uncomfortable when the rent roll says one thing and the general ledger says another.

For a commercial landlord, this is not a cosmetic reporting issue. The rent roll is the operating view: who occupies the space, what each tenant owes, what is past due, and which lease charges are active. The general ledger (GL) is the accounting record. If the two do not agree, you can lose time chasing a tenant balance, send the wrong follow-up, or carry a problem into a CAM true-up, owner report, or year-end close.

The goal is not to force the reports to match by changing a number. The goal is to explain every difference, make the correct entry in the correct system, and retain support for the decision.

> This is an operating-control workflow, not legal, tax, or accounting advice. Your lease terms, accounting method, entity structure, and accountant's close procedures should control where they differ.

Start by Comparing Like With Like

Most reconciliation problems begin before the first variance is reviewed. A rent roll and a GL report can both be accurate while covering different dates, properties, or types of charges.

Before comparing totals, set the same rules for both reports:

• As-of date: Run both reports through the same last day of the month.
• Entity and property: Confirm the same ownership entity, property, and building set are included.
• Basis: Know whether each report reflects billed charges, cash received, accruals, credits, or a mix.
• Charge categories: Decide which GL accounts should tie to base rent, additional rent, CAM estimates, taxes, insurance, percentage rent, late fees, deposits, and other receivables.
• Tenant status: Confirm how future commencements, move-outs, legal entities, inactive tenants, and vacant suites are handled.

A common mistake is comparing the rent roll's total open receivables to a single revenue account. Usually, the cleanest control is to reconcile tenant-level receivable balances to the related accounts-receivable control accounts first, then separately reconcile current-period charges and cash activity.

Use a Three-Part Monthly Reconciliation

A reliable close can be run in three parts: balance, activity, and exceptions.

1. Tie the Ending Tenant Balance to the GL

Export a detailed rent roll as of month-end. Include tenant or customer name, suite, charge type, beginning balance, current charges, payments, credits, and ending balance where available.

Then pull the GL detail and trial-balance totals for the related receivable accounts. Build a simple reconciliation schedule:

| Reconciliation item | Amount | | --- | ---: | | Rent-roll ending balance | $_____ | | Less: items on the rent roll that belong in a different GL account | ($_____) | | Plus/minus: approved timing or posting differences | $_____ | | Expected GL receivable balance | $_____ | | GL receivable balance | $_____ | | Unexplained variance | $0 |

The target is not necessarily a zero difference on the first export. The target is a zero unexplained variance after every identified difference has an owner, evidence, and a resolution date.

2. Reconcile the Month's Activity

A balance can tie by coincidence. Review the activity that got you there.

For each major charge category, compare:

• charges posted from lease administration or the rent roll;
• GL postings to the matching receivable and income or liability accounts;
• cash receipts and unapplied-cash movements;
• credit memos, write-offs, concessions, and reversals; and
• manual journal entries that affect tenant receivables or revenue.

For NNN properties, keep estimates and recoveries easy to trace. A tenant's monthly CAM, tax, or insurance estimate may be a recurring receivable charge, while the property invoices land in expense accounts and the eventual true-up creates a tenant charge or credit. Do not assume that an expense total is itself a billable tenant amount. The active lease, amendments, caps, exclusions, gross-up rules, and allocation method determine the calculation.

Commercial CAM practices commonly use monthly estimated tenant charges, track applicable actual expenses during the year, and compare each tenant's share of actuals with estimates at reconciliation time.[^1]

3. Work an Exception List Instead of Hiding Differences

Every difference should land in a named exception list. Useful columns include:

• property and tenant;
• amount and charge category;
• first month seen;
• likely cause;
• supporting documents or report links;
• owner of the follow-up;
• proposed correction; and
• resolution date.

This turns reconciliation from a private spreadsheet exercise into a repeatable control. It also makes recurring issues visible: a mapping problem, an interface failure, a move-out not completed in one system, or a pattern of manual entries without adequate support.

The Variances Worth Checking First

Start with the largest dollar differences, then look for categories that can distort tenant communication or owner reporting.

Timing Differences

A payment deposited on the last business day may be on the bank activity but not yet posted to the rent roll or GL. A charge may be approved in one system and batched into the other after the cutoff. Log the date, confirm the next-period posting, and avoid calling it resolved merely because it is expected.

Unapplied Cash and Misapplied Payments

A tenant may have paid, but the receipt remains unapplied, is applied to the wrong suite, or is sitting under a former legal name. Compare the bank or lockbox detail, tenant ledger, and GL customer detail before changing the balance.

Manual Journal Entries

Manual journals are sometimes necessary, but they should be visible to the person reconciling the rent roll. Review entries that hit receivables, rent revenue, tenant credits, deposits, or recovery accounts. Each should have a clear business reason and support.

Lease Changes and Move Events

A commencement, renewal, amendment, transfer, expansion, termination, or move-out can create a mismatch when the charge schedule changes in one system but not another. Verify the effective date, tenant legal entity, suite area, rent steps, free-rent period, and recovery setup against the active lease record.

Credits, Concessions, Write-Offs, and Bad-Debt Decisions

These items can reduce a tenant balance without looking like a routine payment. Confirm the approval path, the accounting treatment selected by your accountant, and the evidence supporting the entry. Do not use a write-off to make a reconciliation schedule balance without documenting what happened.

CAM, Tax, and Insurance Recovery Setup

When a recovery charge differs from expectation, check the source before changing the charge: property and tenant allocation data, expense-pool mapping, lease caps and exclusions, estimate schedule, and effective dates. For a focused annual process, see our CAM reconciliation checklist for commercial landlords and CAM reconciliation backup-package guide.

A Practical Close Calendar

The exact calendar depends on staffing and system timing, but the sequence matters more than the number of days.

Day 0: Close the operating period

• Finalize recurring charges and approved adjustments.
• Post known receipts, credits, and reversals.
• Save the month-end rent-roll export and GL detail with the as-of date in the file name.

Days 1–2: Prepare the tie-out

• Reconcile the rent-roll ending balance to each related GL receivable account.
• Reconcile current-period charges and cash activity by category.
• Open an exception item for every difference.

Days 2–4: Resolve and review exceptions

• Gather lease records, invoices, deposit detail, journal support, and approval records.
• Correct errors in the appropriate source system; do not overwrite the evidence trail.
• Have a second person review material adjustments when your team size allows.

After review: Lock the evidence package

Keep the signed or approved reconciliation, both source reports, exception log, support for material adjustments, and a list of open carryforward items together. The IRS likewise emphasizes keeping records that support income and expense entries; the right retention period and records for a property entity should be confirmed with your tax and accounting advisers.[^2]

Build Controls That Make Next Month Faster

The best monthly reconciliation is designed upstream.

• Use a documented account map. List which rent-roll charge types tie to which GL accounts, including whether a category is receivable, income, liability, or deposit-related.
• Require a reason and support for manual entries. A short explanation plus source document can save hours later.
• Preserve tenant and lease identifiers. A consistent tenant ID, lease ID, and property code reduce guesswork when entities or suite names change.
• Review recurring charges after lease events. Put a charge-schedule check into your commencement, renewal, amendment, and move-out workflow.
• Separate open exceptions from resolved corrections. An old variance should not disappear because a later month happens to tie.
• Escalate unusual accounting treatment. When classification, revenue recognition, recoverability, or lease interpretation is unclear, ask your controller, CPA, or counsel before posting.

The Monthly Reconciliation Checklist

Use this checklist before declaring the close complete:

• Rent roll and GL reports use the same entity, property set, and as-of date.
• Related receivable control accounts are identified and reconciled.
• Current-period charges, payments, credits, and reversals are reviewed by category.
• Unapplied cash and tenant-level credit balances are investigated.
• Manual journals affecting tenant balances have a reason and support.
• Lease changes and move events are checked against charge schedules.
• CAM, tax, and insurance recovery variances are traced to lease and allocation inputs.
• Every difference is either corrected or listed as an owned, dated exception.
• Source reports, supporting documents, and approvals are retained with the reconciliation.

Close With an Explanation, Not Just a Match

A rent roll and a general ledger are built for different jobs. One helps the property team operate; the other helps the business account for what happened. A disciplined reconciliation connects them.

When the tie-out is part of every monthly close, your team spends less time rebuilding the past and has a clearer starting point for collections, owner reporting, and year-end recovery work.

PigJet was founded by Ryan to help commercial landlords keep lease obligations, tenant charges, documents, and follow-up work organized around the property. See how PigJet supports commercial property operations when you are ready to replace scattered month-end work with a clearer operating workflow.

[^1]: Yardi, "Common area maintenance (CAM) reconciliation made easy", accessed September 30, 2026. [^2]: Internal Revenue Service, "What kind of records should I keep?", accessed September 30, 2026.