Directors with several projects have no time to read every weekly report. They need one page: which projects are safe, which need attention, and which are in trouble, with the same figures for every project. The dashboard can only be trusted if every project fills its report the same way and with the same cut-off date.
- On plan 3
- Needs attention 2
- In trouble 1
Dashboard columns
| Project | Progress plan / actual | Deviation | Cost against RAP | Unpaid bills | Status |
|---|---|---|---|---|---|
| Housing block M8 | 62% / 59.6% | minus 2.4% | 101% | Rp120 m, 35 days | Amber |
| Two-storey shophouses | 40% / 41% | plus 1% | 98% | Rp0 | Green |
| Warehouse | 80% / 71% | minus 9% | 108% | Rp260 m, 70 days | Red |
Status rules
| Measure | Green | Amber | Red |
|---|---|---|---|
| Progress deviation | above minus 2% | minus 2% to minus 5% | below minus 5% |
| Cost against RAP for the progress | up to 100% | 100% to 105% | above 105% |
| Oldest unpaid bill | up to 30 days | 31 to 60 days | over 60 days |
A project’s status follows its worst measure. The limits above are only an example; use the same limits for every project so they can be compared.
Making the numbers trustworthy
- Every project uses the same cut-off date each week or month.
- Progress comes from weights and measurement, not estimates.
- Cost comes from the books by project code, including costs incurred but not yet invoiced.
- Every figure can be traced back to its source report.
Common mistakes
- Each project reports in a different format and on a different date.
- Only progress is watched, not cost and cash.
- Green status based on the project manager’s feeling.
- The dashboard rebuilt by hand every week, so it is late and full of typos.
The full guide is in How to create a construction finance report in Google Sheets. It has a free template (Excel or Google Sheets) and a checker that reads your own workbook.
Ready to use the Komander agents on your projects?
When your workbook is complete, apply for a pilot: we help connect your project data to the Finance, Cost and Scheduler agents and review the first reports with you.
Send to melwani@komander.ai. Your workbook check result is included when there is one; the workbook itself is not sent.
Common questions
What goes in a multi-project dashboard?
For each project: planned and actual progress, deviation, cost against the RAP, billing and receivables, cash, and a green, amber or red status.
How is a project’s status decided?
With the same limits for every project on deviation, cost and bill age; the status follows the worst measure.
Why must the cut-off date be the same?
So every project’s figures are worked out on the same date and can be compared.