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

Start with a rent roll and a monthly statement in USD. Choose both files on the home page. Open the preview, ask about a unit or an expense, and inspect the original field before putting the figure in your model.

One rent roll and one T12 are proposed at $9 per property pack. Billing is pending. The synthetic Fig East example is free.

Download the offline trial (.zip). Extract the folder and open index.html to inspect the sources. You can also open reviewed-t12.xlsx directly in your spreadsheet app.