KomanderGuides
2 · ConstructionFinance / PRACTICAL GUIDE

Multi-Project Dashboard for Directors: One Page for Every Running Project

How to build a one-page dashboard showing all of a contractor’s or developer’s projects: progress and deviation, cost against the RAP, billing and receivables, cash, and green, amber and red status rules.

Komander.ai Panduan team · 2 min read · Updated 9 October 2026

Edited by Ravi MelwaniCEO & Co-founder, Komander.ai

Prices and rules are summarised from the sources listed below and updated regularly. Check local prices and the relevant authority before relying on them.

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.

50%33%17%
  • On plan 3
  • Needs attention 2
  • In trouble 1
Status of 6 running projects this week · green, amber, red by deviation, cost and cash.

Dashboard columns

ProjectProgress plan / actualDeviationCost against RAPUnpaid billsStatus
Housing block M862% / 59.6%minus 2.4%101%Rp120 m, 35 daysAmber
Two-storey shophouses40% / 41%plus 1%98%Rp0Green
Warehouse80% / 71%minus 9%108%Rp260 m, 70 daysRed

Status rules

MeasureGreenAmberRed
Progress deviationabove minus 2%minus 2% to minus 5%below minus 5%
Cost against RAP for the progressup to 100%100% to 105%above 105%
Oldest unpaid billup to 30 days31 to 60 daysover 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

Common mistakes

Start from a template

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.

Get the templateCheck my 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 with GmailEmail app

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.