Free tool and guide
Rent roll reconciliation, tied to the T12, step by step
A rent roll says what tenants owe. The T12 says what the property booked. Reconciliation explains the difference. Enter one month below to see the bridge.
Rent roll reconciliation is checking that the rent on a rent roll agrees with the rent on the property's T12 or ledger for the same period. Start from the rent roll's monthly rent, take out concessions and unpaid rent, adjust for move-ins, move-outs and timing, and compare the result with the ledger. Whatever is left is unexplained, and that is what you chase.
Rent roll tie-out calculator
Enter one month's rent roll rent, the lines that explain the difference, and the ledger income. See the expected income and the unexplained gap. It runs in your browser: your numbers are not uploaded, saved or tracked, and there is no sign-up.
- Rent roll to ledger, before the bridge
- -$5,020
- Ledger income less rent roll rent
- Expected ledger income
- $113,650
- Rent roll, less concessions, plus move changes, less unpaid rent, plus timing
- Unexplained gap
- -$270
- Ledger income less expected income
- Gap as a share of the rent roll
- -0.23%
- Your limit: 0.50%
Worth a look
- The unexplained gap is inside the limit you set. Keep the support for each line with the file.
Arithmetic only, with no market benchmarks. This is not a loan quote or advice.
What rent roll reconciliation is
A rent roll lists every unit or suite, its tenant and the rent due on one date. The T12 lists what the property booked as income and expense over twelve months. They describe the same income from two sides, so they should tell one story. Reconciliation is the work of proving that they do.
It is not a test for a zero difference. It is a test for an explained one. A buyer, a lender or an asset manager wants to know that every dollar between the two figures has a reason, and that the income in the rent roll is income the property really collects.
How to reconcile a rent roll to the T12
- Pick the month. Use the month the rent roll is dated in, and the T12 column for that same month. A rent roll dated mid-month needs the move-ins and move-outs after its date.
- Add the rent column yourself. Do not trust the total row. Count only occupied units, and check for duplicate units and for tenants listed twice.
- Subtract free rent and concessions. The rent roll often shows the full lease rent while the ledger shows what was billed. Take the amounts from the concession schedule or the tenant ledgers.
- Adjust for moves. Add rent from tenants who moved in after the rent roll date, and subtract rent from those who left.
- Subtract unpaid rent. If the T12 is on a cash basis, rent billed but not collected is missing from it. The aged receivables report lists it.
- Adjust for timing. Add rent collected this month for earlier months, and subtract rent paid in advance for later ones.
- Compare with the ledger. What the bridge cannot explain is the gap. Chase it to a unit, a posting or a missing document.
Use one basis throughout. If the T12 records rent when billed, leave out the unpaid and timing lines. If it records cash, use them. Mixing the two creates a gap that is not real.
A worked example
One month, with the inputs stated. The rent roll shows $118,400 of in-place rent. The month's concessions are $2,100. Net rent from moves since the rent roll date is negative $1,350, because more rent left than arrived. Billed rent that went uncollected is $3,200. Collections of earlier months, net of rent paid early, are $1,900.
| Line | Amount |
|---|---|
| Rent roll, in-place rent | $118,400 |
| Less free rent and concessions | -$2,100 |
| Net move-in and move-out change | -$1,350 |
| Less rent billed but not collected | -$3,200 |
| Plus prior-month rent collected, net | $1,900 |
| Expected ledger income | $113,650 |
| Ledger income on the T12 | $113,380 |
| Unexplained gap | -$270 |
The gap is $270, or 0.23% of the rent roll. The raw difference between the rent roll and the ledger was $5,020, so the bridge explained almost all of it. Whether $270 is acceptable is your call: you set the limit, and the calculator above compares the gap with it. Either way, find what the $270 is.
What an unexplained gap usually means
- Ledger lower than the bridge. Unbilled rent, credits that are not on the concessions line, or rent posted to another account such as a deposit or a fee line.
- Ledger higher than the bridge. Rent posted twice, deposits or fees booked as rent, or a rent roll that is out of date and still lists a lower rent.
- A gap that repeats every month. A unit that is billed differently from its lease, or one that is on the rent roll and not in the ledger. Run the bridge on several months to see the pattern.
- A large gap with no reason. Treat the rent roll as unproven until it is explained. Ask for the tenant ledgers and the bank deposits.
Rent roll audit: testing the rent roll against support
A reconciliation compares two reports. An audit goes behind them to the documents. In a purchase or a loan, a rent roll audit usually does some or all of this:
- Lease to rent roll. For a sample of units, or all of them in a small property, check that the tenant, area, rent, start and end dates match the signed lease and its amendments.
- Tenant ledger to rent roll. Check that what was billed and paid agrees with the rent column, and read any credits.
- Bank deposits to ledger. Trace a month's rent receipts from the deposit records to the ledger.
- Estoppel certificates. In a sale of a commercial property, tenants may be asked to confirm their rent, term and any defaults in writing. A difference from the rent roll is a finding.
- Vacant and special units. Confirm that vacant, model, employee and down units are what the rent roll says they are.
Where this sits in a buyer's review is covered in the commercial real estate due diligence guide. The offering memorandum checker compares what an OM states with what the T12 shows.
By hand, in a spreadsheet, or with AI
The bridge is arithmetic, and a spreadsheet does it well. The slow part is collecting the inputs: concession schedules, receivables reports and tenant ledgers arrive in different layouts from different systems. AI can help read those exports into one table and flag units that appear in one report and not another. It does not replace checking each figure against the document it came from, so keep the support for every line. For how Pacific Software Ventures applies AI to rent rolls and T12s, see best AI rent roll and T12 software.
This page is general information, not accounting, legal or investment advice.
Frequently asked
- What is rent roll reconciliation?
- Rent roll reconciliation is checking that the rent a rent roll says a property earns agrees with the rent the property's ledger or T12 shows for the same period. Each difference is explained, by concessions, vacancy changes, unpaid rent or timing, until nothing unexplained is left.
- How do you reconcile a rent roll to a T12?
- Pick one month. Take the rent roll's in-place rent for that month, subtract free rent and concessions, add or subtract the rent from move-ins and move-outs, subtract rent billed but not collected, and adjust for rent collected early or late. The result is the income you expect to see on the T12 for that month. The difference between it and the T12 is the unexplained gap.
- Why does a rent roll never match the T12 exactly?
- The two are different things. A rent roll is a list of leases on one date and shows rent due. A T12 is a record of money booked over a month or a year. Concessions, move-ins and move-outs, delinquency and timing all sit between them, so the work is explaining the difference, not expecting zero.
- What is a rent roll audit?
- A rent roll audit tests the rent roll against its own support: the leases, the tenant ledgers, the bank deposits and, in a sale, tenant estoppel certificates. It looks for rent that is wrong, units that are missing or duplicated, and leases that have ended or changed.
- How big a gap is acceptable between the rent roll and the T12?
- There is no universal figure. Set your own limit before you start, based on the property's size and the purpose of the review, and explain every line whatever the gap. A lender or an investment committee may name its own limit, so ask.
- When should you reconcile a rent roll?
- Before you rely on one: during acquisition due diligence, when underwriting a loan, when a property changes managers, and at year end. A rent roll that is the base for an offer or a loan should be tied out first.
Keep reading
Rent roll analyzer
Paste a rent roll for occupancy, loss to lease and rollover.
T12 analyzer
Check what the property actually earned and spent.
Commercial real estate due diligence
Where the tie-out fits in a buyer's review.
Pacific Software Ventures built this tool and guide, and sells AI consulting and training to commercial real estate firms. This is general education, not investment, legal or tax advice.
Next step
Doing this on every deal? Let AI do the first read.
Ten minutes. An honest read on where AI would save your team time, and which option fits, including when it is not us.