Reference · built on requestOperator by FibricProperty & tenants

Rent Roll Audit

Compares each lease's rent steps and concessions with the charges on its ledger, and proposes the correction.

About

A rent roll drifts from the leases behind it. A step increase is entered for the wrong month, a free-rent concession runs past its end date, a renewal is signed and the schedule is never touched. Rent Roll Audit reads the lease abstract you keep in a spreadsheet, the rent schedule or scheduled charges on each lease in your property system, and the charges and credits posted to the ledger.

Each month it lists every lease where the amount billed differs from the amount the abstract calls for, with the months affected and the difference. For each one it proposes the schedule change and, where months were billed short or long, a one-time charge or credit. You approve every correction.

This is a reference listing. It documents what Fibric would read from Rent Roll Audit and what it could propose, based on the vendor's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Rent schedules on each Buildium lease: StartDate, EndDate, RentCycle, and each charge's Amount, GLAccountId, and NextDueDate
  • Scheduled charges on Entrata leases, with charge code, amount, startDate, endDate, and monthToMonthAmount
  • Recurring charges on AppFolio occupancies with their StartDate and EndDate, and the tenant ledger beneath each occupancy
  • The lease abstract you maintain in Google Sheets or an Excel table: base rent steps, escalation dates, concession months, and end dates per lease
  • Property, floorplan, and unit specials and concessions from Entrata getSpecials, with their dates, lease terms, and recipient types
  • Ledger lines on each lease: Buildium lease transactions, Entrata getLeaseArTransactions with the scheduledChargeId behind each line, AppFolio tenant ledgers
  • Signed leases and amendments landing in SharePoint, Google Drive, or Box, or completing in Docusign, so each abstract row traces to a document

Proposed actions

  • Target capability: propose an updated rent schedule in Buildium through PUT /v1/leases/{leaseId}/rent/{rentId} when a step in the abstract has no schedule behind it
  • Target capability: propose updateScheduledCharges on an Entrata lease to end a concession on its lease date or raise the amount on its escalation date
  • Target capability: propose a one-time charge or credit on the lease ledger for months already billed short or long, with each month listed
  • Target capability: propose an appended row in your rent roll spreadsheet naming the lease, the expected amount, the billed amount, and the difference
  • Target capability: propose a review list of abstract rows that cite a lease document newer than the row, for a person to re-abstract

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Catch a step rent that never stepped

    The abstract says base rent rises on the anniversary. The Buildium rent schedule still carries the old amount. The operator proposes a schedule starting on the anniversary and a charge for the months billed short, each month listed.

    With Buildium, Google Sheets

  • End a concession on its date

    Entrata getSpecials shows a concession with an end date. The scheduled charge still nets it out a month later. The operator proposes updateScheduledCharges with the lease's endDate and a charge for the month given away.

    With Entrata, Microsoft Excel

  • Tie the roll to the books

    AppFolio recurring charges are summed by property and set beside the rent revenue account in QuickBooks Online for the same month. Any difference is listed lease by lease before close.

    With AppFolio Property Manager, QuickBooks Online

  • Re-abstract when a lease changes

    A signed amendment completes in Docusign and lands in SharePoint. The operator lists the abstract rows that cite that lease and asks a person to confirm the steps before the next comparison runs.

    With Docusign eSignature, Microsoft SharePoint

Requirements

  • A property management connector with read access to leases, rent schedules or scheduled charges, and ledgers: Buildium, Entrata, or AppFolio Property Manager
  • A lease abstract you keep current: base rent steps, escalation dates, concession periods, and end dates per lease, in Google Sheets or Microsoft Excel
  • Write access for corrections: Buildium rent schedules, Entrata scheduled charges, or AppFolio charges on a plan that includes API writes
  • Optionally, a ledger connector such as QuickBooks Online or Sage Intacct, so rent posted in the property system can be checked against the books
Authentication
Rent Roll Audit signs in nowhere itself. Leases, ledgers, and spreadsheets are read through the connectors you attach, and each correction is proposed through the property system connector that owns the record.

Limits

  • It audits the lease as abstracted. A step missing from both the abstract and the schedule is not found; the abstract is your record.
  • Index-linked escalations need the index value entered in the abstract. The operator does not fetch price indices.
  • AppFolio charges are written only on a plan with read and write API access. On a read-only plan a person enters the correction.
  • Corrections cover amounts and dates on charges. It does not draft amendments, renewal terms, or notices to tenants.

Access and pricing

Reference listing. Fibric builds the operator under a managed deployment when you request it. Your quote covers the build, capabilities, usage, and support.

Request Rent Roll Audit ↗

Questions and answers

What do you approve each month?
Each correction: the lease, the abstract row, the schedule or charge as it stands, and the exact change proposed with its amount and start date. You can edit the amount or the date before approving, or dismiss it with a reason.
What record does an audit leave?
A receipt per correction: the abstract row and the schedule compared, the difference found, who approved it, the values before and after, and how to reverse it. Dismissed findings are kept with their reason so the same lease is not raised again for the same term.
Does it change rent on its own?
No. It compares, then proposes. A rent schedule, scheduled charge, or ledger charge changes only after a person approves it, through the property system connector, and never on a lease you mark as excluded.
Ask about Rent Roll Audit

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.