Rent roll reconciliation tool

Rent-roll control

How it works

A rent roll, tenant ledger, payment-provider report, and bank statement answer different questions. A rent roll describes scheduled obligations at a point in time; the ledger records charges and resident-account activity; a provider reports payment events; the bank confirms cash activity. A useful close does not force them into one number. It builds a bridge and explains every difference.

This browser-only worksheet creates two control tests. First it calculates expected net charges from signed-lease rent and documented adjustments, then compares that expectation with posted rent charges. Second it nets returned or reversed receipts from gross receipts and compares the result with bank-confirmed receipts. No tenant names, addresses, account numbers, or files are requested.

Make the result useful

The first bridge tests obligation to posting. Scheduled rent should come from the current executed lease or amendment effective for the period. Authorized concessions and credits reduce that schedule only when their reason, amount, approver, and effective period are retained. The resulting expected net charge is compared with the rent charge posted to the tenant ledger. A mismatch points toward a missing renewal, duplicate recurring charge, incorrect effective date, unrecorded concession, or manual posting.

The second bridge tests payment event to bank evidence. Start with receipts reported for the period, subtract returns and reversals using their provider identifiers, and compare the net with bank-confirmed rent receipts at the same cutoff. Deposits in transit, settlement batching, fees netted by a provider, transfers, and incorrect transaction classification can explain a difference, but the explanation should identify the items and clearing path.

Keep collections separate from these two controls. Posted charges minus net receipts can describe an open resident-account position, but its meaning depends on the due date, cutoff, prior balance, prepayment, dispute, payment plan, and provider state. The tool exposes the position without assigning blame, recommending enforcement, or deciding what communication is lawful or appropriate.

Expected net charges = scheduled rent − authorized adjustments. Schedule-to-ledger difference = posted rent charges − expected net charges. Net receipts = gross receipts − reversals. Receipts-to-bank difference = bank-confirmed receipts − net receipts.

The output is a pair of control differences and a separate ledger-to-cash position. It is not a certified rent roll, collection decision, bank reconciliation, accounting opinion, or legal conclusion.

The worksheet does not allocate totals by tenant, test trust-account requirements, determine lawful charges or collection steps, account for every provider settlement pattern, or replace bank reconciliation. Use the applicable lease, source reports, accounting policy, and qualified review.

• State the entity, property, period, timezone, and cutoff on every report.

• Use executed lease terms and retain each adjustment source.

• Exclude deposits, damages, utilities, and unrelated fees from rent-only totals.

• Match returns and reversals to their original provider transaction identity.

• List timing items with an expected clearing date rather than hiding them.

• Correct the source record, rerun the report, and preserve the before-and-after evidence.

A useful exception line

Unit 3 · July rent · expected $1,650 · posted $1,550 · difference −$100 · source: renewal amendment effective July 1 · cause: recurring-charge rule not updated · owner: bookkeeper · correction: replace rule and post auditable adjustment · retest: open.

Questions landlords ask

Charges and cash can differ for legitimate timing reasons, including a payment still processing, a due date after the cutoff, approved partial payment, prepayment, or a provider return. The figure is a position to investigate with the lease, ledger, provider receipt, and cutoff—not an automatic resident conclusion.

Use a concession, credit, abatement, or other change that has a retained source and effective period. Do not enter an unexplained plug merely to make the expected and posted totals agree; that hides the control failure instead of resolving it.

Start at the entity and property level, then trace any difference to unit, lease, tenant ledger, or transaction detail. A portfolio total can net unrelated errors against each other, such as an omitted charge at one property and a duplicate charge at another.

No. Equal totals can conceal incorrect tenant allocation, dates, accounts, or duplicate records that net to zero. Pair the control totals with targeted detail tests, especially changed leases, concessions, returns, transfers, and manual adjustments.

Keep exploring

Rent roll control path

Define the report first, inspect unit-level exceptions, then prove the totals against the ledger and cash before using it for an owner or lender decision.