Financial consolidation for a family office
Family office · commercial real estate · three cities · consolidation · reporting
4 → 1
accounting systems into one consolidated P&L
sources3 property managers · 4 ledgers
cadencemonthly files · quarterly close
run byus, with the client's accountant approving mappings
A family office owns office, retail, multifamily, and hotel properties in three cities. Each property manager reported from its own accounting system. Every month the trial balances arrived in different formats with different line-item names, and a legacy consolidation product tied them together on an annual license. We built a system that collects the monthly files and maps every line item to one chart of accounts. It consolidates them with tie-outs and emails the finished workbook to the finance team.
- The client's accountant approves every mapping before it's used
- A second check runs on every workbook before it goes out
- Every number traces back to its source file