What Should a Contractor Financial Dashboard Include?
A contractor financial dashboard should give owners and leadership a clear, current view of:
profitability;
project performance;
liquidity;
backlog;
cash flow;
WIP;
receivables;
bonding indicators; and
emerging risks.
The goal is not to display every available metric.
It is to show the financial information management needs to make decisions while there is still time to act.
Start With the Questions Management Needs Answered
A useful contractor dashboard should help answer questions such as:
Are we profitable?
Which jobs are performing well or poorly?
Are margins holding?
How much work is under contract?
Do we have enough cash?
Are customers paying?
Are underbillings growing?
Is working capital strengthening or weakening?
Are we financially positioned for the next level of work?
If the dashboard cannot answer those questions quickly, it may be too complicated—or focused on the wrong metrics.
Include Company-Level Profitability
At a minimum, management should understand current:
revenue;
gross profit;
gross margin;
operating income;
net income; and
major variances from budget or forecast.
These metrics provide the company-level financial picture.
But they should not be viewed alone.
Construction profitability is often driven by a small number of active projects.
Show Gross Margin by Job
Project-level gross margin is one of the most important construction metrics.
A dashboard may show for each significant job:
contract value;
current estimated revenue;
estimated total cost;
expected gross profit;
expected gross margin;
percentage complete; and
margin movement.
This helps leadership see which projects are driving—or eroding—company performance.
Show Margin Fade and Gain
A project that originally expected:
20% margin
but now forecasts:
14%
deserves attention.
The dashboard should make significant margin changes visible.
Useful views may include:
original margin;
current margin;
percentage-point change;
gross-profit dollar change; and
projects above a defined exception threshold.
Related Resource: What Causes Construction Job Margins to Fade? →
Include WIP
WIP should usually be central to a contractor financial dashboard.
Key WIP metrics may include:
contract value;
costs incurred;
estimated total cost;
percentage complete;
earned revenue;
billings;
gross profit;
underbillings;
overbillings; and
backlog.
The dashboard does not need to reproduce every WIP column.
It should highlight what management needs to investigate.
Related Resource: What Is a Construction WIP Schedule? →
Highlight Underbillings
Underbillings can tie up working capital.
The dashboard may show:
total underbillings;
largest underbilled jobs;
underbillings as a percentage of revenue;
aging or persistence;
and change from prior month.
Large or growing balances should trigger questions.
For example:
Is billing delayed?
Is a change order pending?
Is the amount collectible?
Is project documentation incomplete?
Highlight Overbillings
Overbillings can support liquidity.
But they can also create future cash obligations.
A useful dashboard may show:
total overbillings;
largest overbilled jobs;
remaining cost to complete;
and current cash position.
That helps management avoid treating overbilled cash as excess cash.
Related Resource: What Is Overbilling vs. Underbilling in Construction? →
Include Backlog
Backlog helps leadership understand future workload.
The dashboard may show:
total backlog;
expected backlog revenue;
expected backlog gross profit;
expected backlog margin;
backlog by project;
backlog by customer;
and expected timing.
This turns backlog from a sales number into a planning tool.
Related Resource: What Is Construction Backlog? →
Show Backlog Concentration
A strong backlog can still carry risk.
Management should understand:
largest project as a percentage of backlog;
largest customer as a percentage of backlog;
top three customer concentration;
and concentration by market or geography.
This helps leadership identify dependency before it becomes a problem.
Include Cash
Current cash belongs on the dashboard.
But the current bank balance should not be treated as the whole liquidity picture.
Show:
current cash;
change from prior period;
minimum cash target;
and potentially available line-of-credit capacity.
The more useful question is:
How much liquidity do we have relative to upcoming obligations?
Include Forecasted Cash
A forward-looking dashboard should show where cash is headed.
Useful metrics may include:
current cash;
13-week forecasted low point;
13-week ending cash;
minimum liquidity threshold;
line-of-credit usage; and
available borrowing.
This helps leadership move beyond reacting to the bank balance.
Related Resource: What Is a 13-Week Cash-Flow Forecast for a Contractor? →
Show Working Capital
Working capital generally reflects:
Current assets − Current liabilities
Contractors may monitor:
total working capital;
change from prior period;
current ratio;
and working-capital trends.
This can be especially important for:
bonding;
banking;
growth;
and liquidity.
Related Resource: What Is Working Capital and Why Does It Matter to Contractors? →
Include the Current Ratio
The current ratio provides another view of liquidity:
Current Assets ÷ Current Liabilities
It should be interpreted alongside the quality of current assets.
A high ratio supported by:
stale receivables;
large underbillings;
or questionable balances
may not be as strong as it first appears.
Include Accounts Receivable
Receivables directly affect cash.
A dashboard should generally show:
total accounts receivable;
current balances;
31–60 days;
61–90 days;
over 90 days;
retainage;
and major disputed balances.
The goal is to quickly identify collection problems.
Include Days Sales Outstanding
Days sales outstanding, or DSO, can help track collection speed.
A rising DSO may indicate:
slower customer payments;
billing issues;
documentation problems;
or collection weakness.
Trend matters more than one isolated period.
Show Retainage
Retainage can materially affect liquidity.
A useful dashboard may include:
total retainage receivable;
percentage of receivables represented by retainage;
expected release timing;
and large aging retainage balances.
Retainage should be actively monitored rather than allowed to accumulate unnoticed.
Include Accounts Payable
Cash visibility also requires understanding obligations.
Show:
total payables;
current payables;
overdue payables;
major subcontractor balances;
and large upcoming payments.
A strong cash balance combined with unusually high payables can give a misleading view of liquidity.
Include Committed Costs
Invoices already recorded are only part of the picture.
Contractors may also have significant:
subcontract commitments;
purchase orders;
material commitments;
and equipment obligations.
These should inform both WIP and cash planning.
Include Debt and Credit Availability
Useful financing indicators may include:
total debt;
current debt;
monthly debt service;
line-of-credit balance;
line-of-credit limit;
and available borrowing.
Increasing line usage can be an early warning sign.
Include Budget and Forecast Variances
A strong dashboard should help management compare:
Actual
vs.
Budget
vs.
Current Forecast
For example:
Revenue actual: $12 million
Budget: $13 million
Current full-year forecast: $24 million
Those views answer different questions.
Related Resource: Budget vs. Forecast: What Should Contractors Use? →
Include Key Forecast Changes
The dashboard should show material changes in expectations.
Examples:
forecasted revenue down 5%;
gross margin down 2 points;
cash low point reduced by $400,000;
backlog increased by $3 million;
payroll increased due to hiring.
The important information is often not the current value.
It is what changed.
Include Revenue Concentration
Management may want to see:
largest customer percentage of revenue;
top three customer percentage;
largest project percentage;
and concentration by sector.
This helps identify dependency risk.
Include Bonding Indicators
For contractors using surety bonding, the dashboard may include metrics relevant to financial capacity, such as:
working capital;
equity;
current ratio;
debt;
backlog;
WIP;
margin trends; and
financial statement status.
The dashboard does not determine bonding capacity.
But it can help leadership identify issues before a surety conversation.
Related Resource: What Does a Surety Look for in a Contractor's Financial Statements? →
Include Equity
Equity can indicate how much financial strength has accumulated in the business.
Management may track:
total equity;
retained earnings;
owner contributions;
owner distributions;
and change from prior year.
Large distributions can reduce both cash and equity.
Show Owner Distributions
Distributions can materially affect:
liquidity;
working capital;
equity;
and bonding.
A dashboard may compare:
Net income
with
Owner distributions
and
Retained earnings.
That helps management see how much of the company's profitability is being retained to support future work.
Include Payroll Trends
Payroll may be a major driver of liquidity.
Useful views may include:
current payroll;
payroll as a percentage of revenue;
overtime;
headcount;
and forecasted payroll.
Rapid payroll growth can affect cash before revenue collections catch up.
Include Labor Performance Where Relevant
Labor-intensive contractors may also track:
estimated labor hours;
actual labor hours;
labor variance;
overtime;
and productivity.
This can identify project problems before they fully appear in gross margin.
Include Change Orders
A contractor dashboard may track:
approved change orders;
pending change orders;
change-order value;
related cost;
aging;
and billing status.
Large pending changes can create both margin and cash risk.
Related Resource: How Should Contractors Account for Change Orders? →
Include Completed-Job Performance
Completed jobs provide feedback on estimating and project execution.
Management may compare:
original margin;
final margin;
original cost;
final cost;
and total margin fade or gain.
Patterns can inform:
estimating;
pricing;
project management;
and future budgeting.
Use Trend Lines, Not Just Snapshots
A single month may be misleading.
Where practical, show trends for metrics such as:
gross margin;
working capital;
cash;
DSO;
backlog;
line-of-credit usage;
and underbillings.
A deteriorating trend may matter more than the absolute number.
Use Exception Reporting
The dashboard should make problems obvious.
Examples may include:
jobs with more than 2% margin fade;
receivables over 60 days;
underbillings over a defined threshold;
cash below minimum target;
large pending change orders;
or customers exceeding concentration thresholds.
The exact limits should reflect the contractor's business.
Use Targets and Thresholds
A metric becomes more actionable when management knows what is acceptable.
For example:
DSO
Target: <45 days
Warning: 45–60 days
Critical: >60 days
Or:
Minimum cash
Target: >$750,000
Warning: $500,000–$750,000
Critical: <$500,000
Thresholds should be company-specific.
Avoid Too Many KPIs
A dashboard with 40 metrics can become harder to use than one with 12.
The purpose is not to display everything accounting knows.
It is to highlight what leadership needs to manage.
Start with the metrics tied to the biggest decisions.
A Practical Contractor Dashboard Structure
A useful contractor dashboard might be organized into five areas.
Profitability
Revenue
Gross profit
Gross margin
Operating income
Net income
Margin fade/gain
Projects
WIP
Backlog
Underbillings
Overbillings
Change orders
Completed-job performance
Liquidity
Cash
Working capital
Current ratio
Accounts receivable
DSO
Retainage
Accounts payable
Forecast
13-week cash low point
Forecasted ending cash
Full-year revenue forecast
Full-year margin forecast
Expected project starts
Risk & Capacity
Revenue concentration
Backlog concentration
Debt
Credit availability
Bonding indicators
Major financial exceptions
That provides leadership with a balanced view of where the business has been and where it is headed.
What Should Be on the First Page?
The first page should usually contain the highest-value information.
For example:
Revenue
Gross margin
Net income
Cash
Forecasted minimum cash
Working capital
Backlog
Underbillings
DSO
Largest margin fade
Largest project concentration
Current full-year forecast
Detailed supporting schedules can sit behind the dashboard.
Dashboard vs. Financial Statements
Financial statements remain important.
The dashboard serves a different purpose.
Financial statements provide structured reporting around:
financial position;
results of operations;
and cash flows.
The dashboard translates key financial and operational information into a management view.
The two should work together.
Dashboard vs. WIP
WIP is also not the same as the dashboard.
WIP is a detailed project-management and financial-reporting schedule.
The dashboard should pull the most important WIP information into an executive view.
For example:
Instead of showing 50 project rows, it might show:
total underbillings;
total overbillings;
largest five margin fades;
largest three jobs;
and total backlog.
Management can drill into WIP when something requires attention.
Dashboard vs. Cash Forecast
The cash forecast provides detailed expected cash movement.
The dashboard may summarize it using:
current cash;
forecasted low point;
ending cash;
line-of-credit usage;
and major upcoming cash events.
Again, the dashboard provides the executive view.
Update the Dashboard Monthly
For many contractors, monthly reporting is a practical baseline.
The dashboard should generally be refreshed after:
close;
WIP update;
receivable review;
cash forecast update;
and backlog review.
Certain metrics may need weekly attention.
Cash May Need Weekly Attention
Even if the formal financial dashboard is monthly, management may review weekly:
current cash;
receivables;
major collections;
payroll;
upcoming vendor payments;
and 13-week cash forecast.
Liquidity can change faster than the monthly close cycle.
Assign Ownership
Each dashboard section should have clear ownership.
For example:
Finance
financial statements;
working capital;
cash;
receivables;
forecast.
Project Management
margins;
cost to complete;
WIP;
change orders.
Operations
backlog timing;
staffing;
equipment.
Leadership
growth;
risk;
debt;
distributions;
bonding.
The dashboard becomes more useful when management knows who owns the underlying action.
Use the Dashboard in a Recurring Meeting
The dashboard should be discussed—not simply emailed.
A monthly financial meeting may ask:
What changed?
What is outside expectations?
Why?
What happens next?
What decision is required?
Who owns the follow-up?
That turns reporting into management.
Connect the Dashboard to the Budget
The annual budget establishes expectations.
The dashboard shows how actual performance compares.
For example:
revenue vs. budget;
gross margin vs. budget;
overhead vs. budget;
cash vs. plan;
working capital vs. target.
Related Resource: How Should Contractors Build an Annual Budget? →
Connect the Dashboard to the Forecast
The dashboard should also answer:
What do we now expect?
That might include:
full-year revenue;
full-year gross margin;
ending cash;
backlog conversion;
and staffing requirements.
Historical reporting without a forecast leaves management looking backward.
A Dashboard Should Lead to Decisions
If the dashboard shows:
Margin fade
Management may review project execution.
If it shows:
Growing underbillings
Management may address billing or change orders.
If it shows:
Increasing DSO
Management may focus on collections.
If it shows:
Cash falling below minimum
Management may adjust spending, financing, or project timing.
If it shows:
Rapid backlog growth
Leadership may evaluate working capital and staffing.
Every important metric should connect to a potential action.
Common Dashboard Mistakes
Common contractor dashboard mistakes include:
tracking too many metrics;
focusing only on revenue;
omitting WIP;
showing cash without forecasted cash;
ignoring working capital;
reporting backlog without margin;
ignoring concentration;
showing actuals without budget;
showing budget without forecast;
failing to define thresholds;
and producing reports that nobody discusses.
A dashboard should simplify decision-making.
Not create more reporting noise.
The Bottom Line
A contractor financial dashboard should provide a clear view of:
profitability
project performance
WIP
backlog
cash
working capital
receivables
forecasted performance
bonding indicators
and
emerging risk.
The best dashboard is not the one with the most data.
It is the one that helps leadership quickly answer:
What changed?
Why?
What is coming next?
and
What do we need to do about it?
That is the difference between financial reporting and financial management.
How Bilotta & Company Can Help
Bilotta & Company, CPAs, LLC works with construction contractors on financial dashboards, WIP reporting, job costing, budgeting, cash-flow forecasting, backlog analysis, working-capital planning, accounting, tax, assurance, and financial leadership.
Through our Contractor Compass® Financial Stewardship program, we help contractors build a recurring management view that connects:
financial statements
projects
cash
KPIs
forecasting
and
decisions.
Our Financial Stewardship as a Service® rhythm is:
Close → Analyze → Forecast → Decide.
The objective is not another report.
It is giving leadership financial information while there is still time to use it.
Related Resource: What KPIs Should a Construction Company Track? →
Related Resource: Budget vs. Forecast: What Should Contractors Use? →
Related Resource: What Is Construction Backlog? →
Visit the Construction Contractor Financial Resource Center →
This article is provided for general educational purposes and should not be considered accounting, tax, legal, bonding, lending, estimating, or financial advice for a specific contractor. Appropriate dashboard metrics, targets, calculations, and reporting frequency vary based on company size, project mix, business model, financing arrangements, and management objectives.