unit & ledger

Fig East · Synthetic property

The repairs total was right. Two months were wrong.

An acquisitions analyst found $310 of repairs in February. The vendor dated the work to January. Both statements still totaled $1,160 for the year.

Inside the sample workbook

Open the T12 sheet to see the monthly amounts. Field evidence gives the original CSV line and original value. Human changes records each correction.

RepairsSeller’s CSVReviewed Excel
January 2026$125.00$310.00
February 2026$310.00$125.00
Full year$1,160.00$1,160.00

The analyst made both corrections. The workbook retains its review flag because the source CSV supplies no independent yearly control total.

Trace the entries

  1. Compare lines 4 and 5 of the T12 CSV with the dates and amounts on the vendor statement.
  2. In the reviewed workbook, find Repairs for January and February 2026. The annual repair expense stays at $1,160.00.
  3. Open the rent roll for the same property. Unit 003 is occupied at $496.15 per month.

Take the property pack

The ZIP contains the two workbooks, a list of the exported versions, and a comparison note. Unit rent and operating income measure different things and each has its own workbook.

Download Fig East property pack (.zip)

Try one property

Open reviewed-t12.xlsx or reviewed-rent.xlsx directly from this folder in your spreadsheet app. Use the local application to upload a different property or ask a live question.

The proposed trial pack covers one rent roll and one T12 for $9. Billing is pending. The sample is free.