What it is
Rental revenue should follow from the rent roll: lease rent, months billable, abatements, recoveries and percentage rent. A reconciliation to billings and the ledger exposes billing errors and unsupported revenue.
The workbook recomputes expected rent by tenant, compares it with the subledger, and reconciles billed amounts to ledger revenue with the straight-line adjustment and other explained items.
When to use it
- Auditing rental revenue.
- Monthly property accounting review.
- Due diligence on a property.
What’s inside
- Rent roll tab with expected and billed amounts
- Reconciliation tab to the ledger with unexplained difference
- Occupancy by count
- Legend tab
Standard cited
This template follows AU-C 330. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use. See AU-C 330 explained.
Questions
Is straight-line rent calculated here?
No. Enter the adjustment from the straight-line schedule.
What does a flag mean?
Billed differs from expected by more than the tolerance, or the lease dates are inconsistent.
Related templates
- Audit Program: Real Estate Entity
- Real Estate Straight-Line Rent Schedule (Lessor)
- Real Estate Owner and Operator Audit Checklist
- Proof of Cash Template (Four-Column)
Last updated 11/06/2026. All free templates.