We took the standard R-Keeper report package and they tailored it to us on top of that. It all just works.
Business analytics for construction companies
In construction, profit is counted on the site, not in the company. These reports set each site's estimate against actual while there is still time to act — not after handover.
In construction the combined result almost always lies: profitable sites cover for loss-making ones, and you only see it when each site is costed on its own. The estimate, material write-offs, subcontractor certificates and labour hours all sit in different places, so site margin is usually worked out only after handover.
Power BI analytics joins the accounts to the estimating system and the time records. The drift from the estimate becomes visible while the work is still running — while there is still time to renegotiate, change supplier or stop.
The figures worth watching
Profitability by site
Every site treated as a business of its own: revenue, materials, labour, subcontractors, margin. Without that, a construction firm sees only the combined result, in which the profitable sites cover for the loss-making ones.
Estimate against actual
The single most important figure in the industry. A variance caught mid-build can still be managed; one caught at handover is already a loss.
Material costs by site
Where more material was used than planned, and whether that is systematic at one site or with one crew.
Subcontractor costs
Subcontracting as a share of site cost, and how it moves. This is often exactly where the planned margin disappears.
Cash flow by stage
In construction the money goes out before it comes in. A stage schedule with payment dates shows when the gap will open.
Receivables by client
Retentions and late payment are normal in construction. How much money is tied up, and for how long, is visible per client.
How it looks in the report
The sites row
The top row answers how the sites are doing: profitability by site with the margin on each, materials used against materials planned, and cash flow by stage. A loss-making site stands out at once, even while the combined result stays positive.
The causes row
The bottom row shows the causes. Estimate against actual gives the size of the variance as a percentage; the subcontractor share of site cost shows where the planned margin goes; and receivables by client separate retentions from ordinary late payment.
Cash flow
The cash flow chart with stage payments is often the most valuable of all: it names the month in which the gap will open, several weeks before it does.
Where the data comes from
- the accounting system
- the estimating system (planned quantities and prices)
- time recording by site
- subcontracts and completion certificates
What people usually notice first
- 1 What emerges first, almost every time, is that profitability varies between sites far more than anyone expected — not by 2 or 3 points but by 15 to 20.
- 2 The second is that the drift from the estimate starts early, usually within the first third of the work, and only widens from there. Caught in time, some of it can still be recovered by renegotiating or changing supplier.
Data that helps you decide
See how companies like yours put Analitika360 reports to work in Power BI.
Where to start
Most people start with a ready-built report set, which connects to your accounting system within a few days, and add the industry-specific reports as a second stage. Describe your situation and we will tell you what would work best in your case.