Capability template for finance and accounting
Rent roll to lease abstract match
Your property accountant gets the rent roll checked against the verified lease abstracts and amendments, unit by unit: rent, area, commencement and expiration, with every difference listed for review. It compares supplied fields only and corrects nothing.
Listed under
Add it to a workflow in the Fully Powered Planner, beside the teams and roles that will run it. Book a fit call
The outcome
The rent roll stops being something everyone assumes is right. Each month, or at a property handoff, the property accountant and the lease administrator get one list: the units that agree with the verified paperwork, the units that do not, and the units where the answer depends on something a person has to confirm.
Every difference states what the roll says, what the verified record says, where that record came from and how large the gap is. Where the roll still shows the original abstract after a verified amendment changed it, the list says so, because that points to a roll that was never updated.
The people stay in charge. The two of them decide which record is wrong, and no correction is made without their sign-off. The AI assistant changes neither the roll nor the abstracts.
Who starts the work, and when
The property accountant or the lease administrator starts it when a monthly rent roll is ready for review, or when a property is handed over from one team or owner to another. The other of the two reviews the result before any correction is made.
What they supply
- The rent roll export for the property, with its as-of date.
- The verified lease abstracts, one row per unit.
- The register of executed amendments, each marked verified or not, with its effective date.
- Optionally, the charge schedules, to settle which rent figure belongs in a flagged case.
- The tolerances the team accepts, if any. The default is an exact match.
What comes out
One review document in a fixed order: the scope, the differences for review, the items flagged for confirmation, the units and fields that could not be compared, the amendments that were not applied, the units that match, a rent total that ties the compared units on both sides, and what could not be assessed from the information supplied. Empty sections say "None."
An invented example
Illustrative example with invented data. One monthly review at Property X, an invented eight-tenant office building. Every tenant and amendment below is invented.
What the person supplies
Rent roll as of 1 November 2026 (columns: Unit, Tenant, Area (sq ft), Monthly Rent, Lease Start, Lease End)
- 101, Tenant A, 1,200, 3,000.00, 2024-03-01, 2027-02-28
- 102, Tenant B, 950, 2,375.00, 2023-07-01, 2026-06-30
- 103, Tenant C, 1,500, 3,900.00, 2025-01-01, 2028-12-31
- 104, Tenant D, 800, 2,000.00, 2025-09-01, 2030-08-31
- 105, Tenant E, 1,100, 2,750.00, 2026-10-01, 2031-09-30
- 106, Tenant F, 1,000, 2,600.00, 2022-05-01, 2027-04-30
- 107, Tenant G, 700, 1,750.00, 2024-11-01, 2027-10-31
- 108, Tenant H, 900, 2,250.00, 2026-11-15, 2029-11-14
- 110, Tenant J, 600, 1,500.00, 2026-02-01, 2029-01-31
Verified lease abstracts (columns: Unit, Tenant, Area (sq ft), Monthly Base Rent, Commencement Date, Expiration Date, Rent Abatement Through, Commencement Condition)
- 101, Tenant A, 1,200, 3,000.00, 2024-03-01, 2027-02-28, blank, blank
- 102, Tenant B, 950, 2,375.00, 2023-07-01, 2026-06-30, blank, blank
- 103, Tenant C, 1,500, 3,750.00, 2025-01-01, 2028-12-31, blank, blank
- 104, Tenant D, 840, 2,000.00, 2025-09-01, 2030-08-31, blank, blank
- 105, Tenant E, 1,100, 2,750.00, 2026-10-01, 2031-09-30, 2026-12-31, blank
- 106, Tenant F, 1,000, 2,500.00, 2022-05-01, 2027-04-30, blank, blank
- 107, Tenant G, 700, 1,750.00, 2024-11-01, 2027-10-31, blank, blank
- 108, Tenant H, 900, 2,250.00, 2026-11-15, 2029-11-14, blank, "Fit-out sign-off by Tenant H"
- 109, Tenant K, 650, 1,625.00, 2025-06-01, 2028-05-31, blank, blank
Amendment register (columns: Unit, Amendment ID, Effective Date, Field, New Value, Verified)
- 102, AM-102-1, 2026-05-01, Expiration Date, 2028-06-30, Y
- 106, AM-106-1, 2026-07-01, Monthly Base Rent, 2,600.00, Y
- 107, AM-107-1, 2026-09-01, Monthly Base Rent, 1,850.00, N
Settings: exact match on rent, area and dates; as-of date 2026-11-01.
What comes out
RENT ROLL TO LEASE ABSTRACT MATCH: Property X, rent roll as of 2026-11-01
- For: Property accountant and lease administrator, for review before any correction. Sources: rent roll (9 units), verified lease abstracts (9 units), amendment register (3 entries). Tolerances: rent 0.00, area 0 sq ft, dates exact.
- Scope: Units compared: 8. No difference or flag: 3. Differences: 3. Flagged: 2. Not compared: 2.
- Differences for review: 3.
- Unit 102, Tenant B, Lease End: roll 2026-06-30; verified record 2028-06-30 (AM-102-1, verified, effective 2026-05-01); roll earlier by 731 days. The roll equals the original abstract, not the amendment. Question: was AM-102-1 entered on the roll?
- Unit 103, Tenant C, Monthly Rent: roll 3,900.00; verified record 3,750.00 (abstract); roll higher by 150.00. No amendment on file for this unit. Question: which record is wrong, or is an amendment missing?
- Unit 104, Tenant D, Area: roll 800 sq ft; verified record 840 sq ft (abstract); roll lower by 40 sq ft. No amendment on file. Question: which record is wrong?
- Flagged for confirmation: 2.
- Unit 105, Tenant E: abstract shows rent abatement through 2026-12-31, on or after the as-of date. Rent comparison held. Area, Lease Start and Lease End match. Confirm which rent figure the roll should show during the period.
- Unit 108, Tenant H: abstract shows a commencement condition, "Fit-out sign-off by Tenant H". Lease Start matches (2026-11-15), as do area, rent and Lease End. Confirm whether the condition has been met.
- Not compared: 2 units.
- Unit 109, Tenant K: in the abstracts, not on the rent roll.
- Unit 110, Tenant J: on the rent roll, no abstract supplied.
- Fields not compared: None.
- Amendments not applied: 1. AM-107-1, Unit 107, Monthly Base Rent 1,850.00, effective 2026-09-01: not verified.
- Matched: 3 units match on every field compared: 101, 106 (rent matches AM-106-1, verified), 107.
- Rent totals: Rent compared for 7 units (105 held). Roll 17,875.00; verified record 17,725.00; roll higher by 150.00, all from Unit 103. Rent roll total as supplied: 22,125.00 across 9 units.
- Could not assess: Whether the commencement condition for Unit 108 has been met. Charge schedules were not supplied, so no flagged question was checked against them.
Prepared for the property accountant and lease administrator to review. The roll, the abstracts and the amendment register are unchanged, and nothing has been sent.
Where it fits
- Real estate, where the rent roll feeds owner reports, lender packages and every valuation discussion.
- Finance and investment, where an asset manager or lender receives a rent roll and wants it tied to the lease file.
- Finance and accounting, which owns the rent roll as an accounting record.
- Acquisitions & integration, when a property changes hands and the incoming team needs to know the roll can be trusted.
- Private equity & portfolios, where many properties report on a fixed rhythm and a bad roll is costly.
It is a different piece of work from receivables exception review, which examines what tenants have paid, and from weekly receivables summary, which reports on money owed. This one checks the recorded terms behind the rent, before any money is considered.
What has to change for your company
Match the column headers to your rent roll and abstract exports, or rename the columns once. Decide your tolerances for rent and area. Name who verifies an amendment and what "verified" means in your register. Decide who signs off a change to the roll and who signs off a change to the abstracts. It runs in ChatGPT, Claude, Copilot or Gemini, from files you supply; it needs no connection to your property system.
What has been checked
Fully Powered AI wrote this capability template. It was editorially reviewed on 10 November 2026. It was tried on its invented example on 10 November 2026 in one run in Claude; the record is published with it. The ambiguities that run found are settled in the template or listed there as open, and the small edits made afterward have not been run again. It has not yet been tested in a client environment. It has not yet been tested as a packaged version in ChatGPT, Claude, Copilot or Gemini.
Testing in your environment means running it on a past month your lease administrator already knows, with cases written in advance: a unit missing from one side, an amendment the roll never picked up, a free-rent period. The property accountant checks every difference against the lease file before anyone relies on the list.
The full capability template
Everything above is the outline. The complete capability template is the working version: the roles, the inputs, the procedure, the exceptions and stop conditions, the output format, the reviewer checklist, the acceptance tests, the instructions for an AI assistant and what to customize for your company. It comes with a download and the link to its folder in Fully Powered’s public repository.
Free with an account. Sign in by email: no password and no card.
Next step
Put this capability to work for your team: on your plan, or built with you in a sprint.
Build this in a sprint
In a sprint, Fully Powered adapts this capability template to your rules, proves it on your own work and puts it in the hands of the roles that own it.
Two ways to begin: