How a residential developer with 22 apartments and 23 parking spaces gained one consolidated view of their project’s financials — cost tracking, unit-level sales analysis, rental yield, and market-benchmarked pricing — from raw Excel data alone.
A residential developer was managing a two-block, 22-apartment project with the project’s financials spread across multiple disconnected Excel workbooks — one for cost cashflows, one for unit sales tracking, one for rental income projections. None of them talked to each other.
There was no consolidated view of total costs paid versus outstanding, no unit-level breakdown of what had been sold at what price, no visibility into rental yield by apartment, and no structured comparison of the portfolio’s pricing against current market rates. Decisions on pricing, sales strategy, and cash management were being made without a clear financial picture of the project as a whole.
A thorough review of the source data revealed four categories of error — each with material consequences for how the project’s financial position was being understood.
Construction, specialist works, and management costs were grouped in the same buckets, making it impossible to benchmark any category individually or identify where overruns were occurring.
Scheduled future payments were being treated as pending liabilities rather than committed cashflows. This overstated outstanding project costs by approximately €2.5M against actual contract obligations.
On duplex mansardă units, price per square metre was calculated against interior area only — omitting the sous-toiture space included in the contracted pricing. This inflated the apparent €/m² by over 90% on the affected units.
Cost data was denominated in RON across multiple sheets with no consistent EUR conversion framework, making it impossible to read the project in a single currency without manual recalculation.
“The most consequential errors were not in the large numbers. They were in the structural assumptions — how costs were categorised, how square metres were defined, how currency was handled. Each one was invisible until someone looked for it systematically.”
A consolidated, standalone financial dashboard delivered as a single file — no software to install, no external dependencies, fully operational on any device. All values displayed in EUR, with RON equivalents shown in parentheses throughout.
The developer moved from five disconnected Excel files to a single consolidated view of the project’s financial position. Specific capabilities gained: