2025 reconciliation

Controller view

Step 2

GL review

The center moved from an MRI-style system to a Yardi-style system on July 1, 2025. Both exports go into one set of cost pools, so you only look at what stands out.

Rows that need a person

  • Last year's billAlder Point Power and Water · AP-1224 · 2025-01-09 · MRI-style export

    The description says December 2024, but it posted in January 2025. It belongs in the 2024 reconciliation.

    $2,600.00
  • Legal fees in repairsWhitlow and Sands LLP · WS-3390 · 2025-04-22 · MRI-style export

    Legal fees for a tenant dispute are excluded by the leases, and this one was coded to repairs.

    $6,500.00
  • Paid twice across systemsKeystone Facility Services · KF-7741 · 2025-07-03 · Yardi-style export

    The same vendor, invoice number and amount appear in June in the MRI-style export and in July in the Yardi-style export, right after the center moved systems.

    $7,200.00
  • Unusually largeGreenline Grounds · GG-STORM · 2025-09-16 · Yardi-style export

    Three times the monthly contract. It looks like a genuine one-time common area cost, so it stays in unless someone knows otherwise.

    $9,000.00
  • Capital item in repairsSummit Roofing Co · SR-1182 · 2025-09-24 · Yardi-style export

    A roof replacement is a capital item, and the leases exclude capital replacements. It was coded to repairs.

    $48,000.00

Cost pools after your decisions

Pool20242025Change
Landscaping$34,800.00$45,000.00$10,200.00
Parking lot sweeping and repairs$39,900.00$42,000.00$2,100.00
Repairs and maintenance$28,600.00$30,000.00$1,400.00
Janitorial$11,600.00$12,000.00$400.00
Trash removal$11,500.00$12,000.00$500.00
Security$17,400.00$18,000.00$600.00
Common area utilities$28,900.00$30,000.00$1,100.00
Insurance$25,200.00$27,000.00$1,800.00
Real estate taxes$93,000.00$96,000.00$3,000.00
Management fees$23,000.00$24,000.00$1,000.00

The two exports

MRI-style export 53 rows

January to June. The column names here are illustrative, not MRI's real layout.

BLDGID,GLACCT,ACCTNAME,POSTDATE,REF,PAYEE,NOTES,AMOUNT
ALDPT,6510,CA ELEC/WATER,01/05/2025,AP-0125,Alder Point Power and Water,"Common area power and water, January",2540.00
ALDPT,6420,LOT SWEEP/REPAIR,01/05/2025,BL-0125,Bright Lot Sweeping,"Lot sweeping contract, January",2940.00

Yardi-style export 52 rows

July to December. The column names here are illustrative, not Yardi's real layout.

Property,Account,Account Name,Post Date,Reference,Vendor,Description,Debit,Credit
alderpt,5220-0000,Parking Lot,2025-07-03,KF-7741,Keystone Facility Services,Parking lot asphalt patching,7200.00,0.00
alderpt,5310-0000,Utilities - Common Area,2025-07-05,AP-0725,Alder Point Power and Water,"Common area power and water, July",2455.00,0.00

Every ledger row

Ask the live agent

A real AI model, looking things up with read-only tools. Figures come from the code, and it can’t change or approve anything. Ask about this sample center only.