5 Dashboards That Replace the Monthly Financial Packet

The 5-Dashboard Framework

The five construction dashboards every $20M-$100M firm needs are WIP, Job Profitability, Cash Flow, Backlog & Pipeline, and AR Aging & DSO. Together, they answer the five questions a construction CFO is asked most often— where are projects today, are they profitable, when does cash arrive, what's coming next, and who owes us money.

Five is a working set. Some firms run leaner; some run broader. For most growing AEC firms in this revenue band, five maps cleanly to the operating questions a controller, a CFO, or a fractional AI officer has to answer every week.

Start with WIP. It's the most construction-specific dashboard you'll build, and it underpins everything else.

Dashboard #1 — Work in Progress (WIP)

A WIP dashboard compares revenue earned against revenue billed for every active project, surfacing overbilling, underbilling, and projects drifting toward profit fade in real time. It's the foundational construction financial dashboard— every other dashboard borrows from its data.

Procore frames it cleanly⁴: "a WIP report compares the amount of revenue recognized on a job (based on physical progress) against the amount billed to the customer." Operational value comes from running it weekly across every active project, not just at month-end.

Overbilling equals total billings to date minus earned revenue to date⁵; a negative result means underbilled. Overbilling can mask revenue-recognition risk and inflates working capital that isn't earned. Underbilling means cash you've earned isn't on the schedule yet.

Key KPIs:

• Percent complete (POC) by project
• Revenue earned to date and billings to date
• Over/underbilling balance
• Projected margin at completion vs. original-bid margin
• Change order pipeline (pending vs. approved $)

What "good" looks like: Underbilling positions get investigated within seven days. Overbilling positions get cross-checked against physical completion to catch revenue-recognition risk before the auditor does.

WIP is only as good as the cost-to-complete updates from PMs. CLA's analysis of profit fade⁶ makes the same point— it's the integrated project information system, with bidding, billing, costing, and PM functions tied together, that makes profit fade catchable.

The ERP (Sage 300 CRE, Sage Intacct Construction, Viewpoint Vista, CMiC, Foundation, Acumatica) feeds cost-to-date and billing data. PMs feed cost-to-complete updates. The BI layer (Power BI, Anterra, SelectView) handles visualization.

Dashboard #2 — Job Profitability

The Job Profitability dashboard tracks projected margin against original-bid margin for every active project, with profit fade alerts firing when the gap widens beyond a set threshold.

Every PM and PE knows the experience. A project bids at 18% margin, starts trending at 14%, then 11%, and by the time the change order math reconciles, it's done at 7%. This dashboard makes the slope visible while there's still budget to course-correct.

Key KPIs:

• Original margin % vs. projected margin %
• Profit fade variance
• Cost-to-complete (ETC) and estimate-at-completion (EAC)
• Committed cost vs. budget
• Change order pipeline (pending vs. approved $) and approval cycle time

What "good" looks like: Profit fade above 2% triggers a PM-PE conversation. Above 5% triggers a leadership review. An alert that fires too often gets ignored; one that fires too rarely is just a slower version of the monthly packet.

The change-management problem is real. PMs often resist a dashboard that surfaces their cost overruns daily. Telling them it's for early-warning, not blame, only works if leadership behaves that way when the dashboard turns red.

The plumbing is the same as WIP— same ERP, same PM inputs— plus change order management if it lives separately. Build WIP, and Job Profitability inherits 80% of the data work.

Dashboard #3 — Cash Flow (13-Week Rolling)

A 13-week rolling cash flow dashboard projects every expected inflow (progress billings, retainage releases) and every outflow (subcontractor payments, payroll, equipment, insurance) on a weekly cadence, giving the CFO roughly 90 days of forward visibility. In construction, where retainage and progress billing distort the cash cycle, this is the dashboard that prevents profitable firms from going broke.

The 13-week forecast separates "are we making money" (WIP, Job Profitability) from "do we have money on hand" (Cash Flow). Both matter. Only one keeps the lights on Friday.

Key KPIs:

• Projected weekly cash position
• Weeks of operating runway at minimum threshold
• Days payable outstanding (DPO)
• Expected billings vs. actual receipts variance
• Retainage receivable (separated from operating AR)

What "good" looks like: A four-week minimum runway is always visible. Forecast-to-actual variance stays under 10% by week four. Weekly review is short and decisive.

The retainage trap is what generic CFO playbooks miss. Retainage held against you by owners sits on the balance sheet but doesn't move into cash for months. Track retainage receivable as a separate line— it's contractually delayed cash, not collectible cash.

Cadence: daily updates, weekly review, monthly replan. ERP feeds AP and billing. Banking confirms receipts. Sub schedules drive outflow timing.

Dashboard #4 — Backlog & Pipeline

A Backlog & Pipeline dashboard separates contracted work (backlog) from work being bid (pipeline), and reports backlog in both dollars and forward-looking months of capacity. ABC's Construction Backlog Indicator— the industry standard— sat at 8.6 months in March 2026⁷, giving every firm a benchmark to anchor against.

Backlog is contracted work; pipeline is work being bid. Confusing them is how firms misjudge capacity, overhire ahead of phantom backlog, or underhire ahead of real backlog they haven't formally tracked.

Foundation Software's formula⁸: current month backlog ÷ previous fiscal year revenue × 12 = total months of forward-looking work. Compare directly to ABC's CBI and your own historical rolling average.

Key KPIs:

• Backlog months (current vs. ABC CBI benchmark)
• Backlog $ by sector or contract type
• Pipeline $ by stage (proposal, bid, awarded-pending-contract)
• Pipeline conversion rate and win rate by bid type
• Backlog burn rate vs. new awards

What "good" looks like: Backlog within ±2 months of capacity target. Pipeline roughly 3-4x the gap (most pipeline doesn't convert). Size capacity against CFMA's benchmark— revenue per FTE reached $514,587 in 2024⁹.

The plumbing is messier than the others. ERP holds awarded contracts; the CRM holds proposals and bids. The BD-to-finance hand-off has to be automated, not e-mailed.

Dashboard #5 — AR Aging & DSO

An AR Aging dashboard categorizes every outstanding invoice into 30-day buckets (current, 30-60, 60-90, 90+) and trends DSO over time¹⁰. Construction's industry-average DSO sits around 83 days¹¹, well above the 60-day cross-industry norm, because progress billing, retention, and multi-party payment chains stretch the cycle.

Benchmarks vary by trade. ClearReceivables puts general contracting at 60-90 days "due to progress billing, retention holdbacks, and multi-party payment chains"¹². Trade contractors run lower— HVAC and electrical often land in 35-55 days. Anything above 90 days usually signals a collections workflow problem, not a market reality.

Key KPIs:

• DSO (rolling 90-day)
• % of AR over 90 days
• Retainage receivable (tracked separately from regular AR)
• Invoices over 90 days flagged for action
• Collection cycle time by customer

What "good" looks like:

• Trade contractors target 35-55 day DSO
• GCs and heavy civil target 60-75 day DSO
• AR over 90 days stays under 10% of total AR

Retainage receivable is contractually delayed cash, not delinquent cash. Mixing them on a single AR aging view exaggerates your collections problem and hides your actual one. Most ERPs split them by default; the dashboard just has to respect the split.

ERP feeds invoices and payments. The collections workflow tool drives action triggers. Controller or AR lead compiles weekly; CFO reviews.

Why Dashboards Are the Prerequisite for AI in Construction Finance

Dashboards are the prerequisite for AI in construction finance. AI agents and automation tools depend on clean, real-time data— which is exactly what a working dashboard infrastructure forces you to build.

AI doesn't fix bad ERP data— it scales it. Real-time dashboards expose the hygiene problems AI would otherwise hide: a stale cost-to-complete, a misclassified change order, a retainage receivable booked as collectible cash.

"In 2024, a striking 70 percent of contractors reported having no formal technology roadmap, and nearly two-thirds cited uncertain payback periods— often exceeding 24 months— as the chief deterrent to new digital investments."¹³

That Deloitte gap is the why-now signal. Firms that build the dashboard layer first will absorb AI cleanly. Firms that skip the layer end up with sophisticated systems pointing at unreliable data— which means knowing what to measure when you implement AI in finance becomes harder, not easier.

Directional upside is real. Dodge Construction Network's joint study with Procore found 77% of optimized construction software adopters experience increased profit margins¹⁴. McKinsey's canonical estimate— five years old, still cited— pegs digital transformation in construction at 14-15% productivity gains and 4-6% cost reductions¹⁵. Treat both as directional, neither as guarantee.

In practical terms, what AI adds on top is genuinely useful: automated cost-to-complete forecasting, anomaly detection on profit fade, WIP narrative summarization, AR collection prompts that fire on the right customer at the right time. None of it works without the dashboard layer underneath.

Dashboards make the CFO's judgment faster. They don't replace it. People are the answer. AI is the amplifier.

Where to Start — A Sequencing Plan

Build WIP first. It's the foundation for three of the other four, and the data hygiene it forces— cost-to-complete discipline, GL-to-job coding consistency— pays off across the stack. Layer on Job Profitability second, Cash Flow third, Backlog and AR last.

The realistic timeline is 8-12 weeks for a baseline set with clean ERP data. With dirty data, the cleanup is the project. SelectView's diagnosis is exact¹⁶: "Reports are often delayed by days or weeks because the data must be manually extracted from the ERP, cleaned, and compiled. By the time the report reaches the CFO, the issue has already grown." If reporting today depends on hand-cleaning Excel exports for two days every month, the dashboard project starts there— not in Power BI.

Tooling follows data discipline. Power BI sits on top of Sage, Viewpoint, CMiC, and Procore most commonly. Vendor-specific tools like Anterra and SelectView accelerate the build but lock you into a roadmap. Both are legitimate. The hidden costs of AI projects don't show up in the BI license— they show up in the ERP cleanup hours nobody scoped.

Don't kill the packet. Run dashboards for operating decisions; run the packet for compliance. This is one of the cleaner Both/And calls in construction finance— you're moving operating decisions off the close, not replacing it.

The change-management problem is the real one. PMs need an "early-warning, not blame" framing, and leadership has to back it up. Without that, dashboards get gamed and data quality decays. The AI decision framework for founders generalizes the lesson: sequencing matters more than tools.

Frequently Asked Questions

What is a construction dashboard? A real-time visual that gives a CFO, Controller, or PM an at-a-glance view of financial and operational metrics— replacing the static monthly financial packet that lands 8-12 days after month-end. Dashboards drive intervention; reports drive compliance³.

What's a healthy DSO for a construction firm? Industry average sits around 83 days¹¹, compared to ~60 days across all industries. GCs and heavy civil typically run 60-90+; trade contractors run 35-55. Anything above 90 days usually signals a collections workflow problem, not a market reality.

What's a healthy construction backlog? ABC's Construction Backlog Indicator was 8.6 months in March 2026⁷— the industry benchmark. Too low signals a capacity gap; too high signals delivery strain. The right answer depends on capacity, sector, and the bid environment.

How long does it take to build a construction dashboard set? With clean ERP data and a tool like Power BI, Anterra, or SelectView, a baseline 5-dashboard set is achievable in 8-12 weeks. With dirty data, the ERP cleanup is the project.

Do construction dashboards replace the monthly financial packet entirely? No. The packet still serves bonders, banks, and auditors. Dashboards run the operating side; the packet runs compliance. Both can coexist, and at most $20-100M firms, both should.

The Dashboard as Operating System

The five dashboards aren't software. They're an operating system for a construction firm— the system that lets you intervene Tuesday on what would have shown up in next month's packet.

That framing changes how you scope the work. A dashboard isn't a tool purchase. It's an implementation project that touches ERP hygiene, PM behavior, BD-to-finance hand-offs, and weekly operating cadence. The tool is the smallest part. The discipline is the project.

If your firm is mapping where AI fits in finance, dashboards are step one. We help $20-100M AEC firms build the dashboard infrastructure that makes AI implementation real, not theoretical— sequencing the work so the data substrate is ready before the AI agents arrive.

Build it intentionally, and the AI conversation gets easier.

References

1. Eagle Rock CFO, "Month-End Close Benchmarks 2026: How Fast Should You Close?" (2026) — https://www.eaglerockcfo.com/blog/research/month-end-close-benchmarks
2. Bennett Financials, "Leading vs Lagging Indicators: Why You Track the Wrong Things" (2024) — https://bennettfinancials.com/leading-vs-lagging-indicators-why-youre-measuring-the-wrong-things/
3. Anterra Technology, "Top CFO Dashboards & Reports for Construction Companies" (2024) — https://anterratech.com/blog/construction-cfo-dashboards-reports/
4. Procore Technologies, "Work in Progress (WIP) Accounting: What Is It and Why Is It Important?" (2024) — https://www.procore.com/library/work-in-progress-accounting
5. Procore Technologies, "Overbilling in Construction: Understanding Billing in Excess of Costs" (2024) — https://www.procore.com/library/overbilling-construction
6. CliftonLarsonAllen, "Profit Fade Analysis Helps Construction Companies Keep Projects on Track" (2024) — https://www.claconnect.com/en/resources/articles/profit-fade-analysis-helps-construction-companies-keep-projects-on-track
7. Associated Builders and Contractors, "Construction Backlog Indicator — Monthly News Releases" (2026) — https://www.abc.org/News-Media/News-Releases?Category=construction-backlog-indicator
8. Foundation Software, "The Importance of Backlogs in the Construction Industry" (2024) — https://www.foundationsoft.com/learn/the-importance-of-backlogs-in-the-construction-industry/
9. Construction Financial Management Association, "CFMA's 2025 Construction Financial Benchmarker" (2025) — https://cfma.org/benchmarker
10. Versapay, "Accounts Receivable Aging Report: Definition & Guide" (2024) — https://www.versapay.com/resources/ar-aging-reports-how-to-create
11. Construction Credit & Financial Group, "DSO Construction Industry" (2024) — https://ccfgcredit.com/dso-construction-industry/
12. ClearReceivables, "Days Sales Outstanding by Industry [2026 Benchmarks]" (2026) — https://clearreceivables.com/blog/days-sales-outstanding-by-industry
13. Deloitte Insights, "2025 Engineering and Construction Industry Outlook" (2024) — https://www.deloitte.com/us/en/insights/industry/engineering-and-construction/engineering-and-construction-industry-outlook/2025.html
14. Dodge Construction Network, "New Study: Project Management Software for Construction Owners and Contractors Increases Profitability, Productivity, and Efficiency for High Skill Users" (2025) — https://www.construction.com/company-news/new-study-project-management-software-for-construction-owners-and-contractors-increases-profitability-productivity-and-efficiency-for-high-skill-users/
15. McKinsey & Company, "The Next Normal in Construction (Executive Summary)" (2020) — https://www.mckinsey.com/~/media/mckinsey/industries/capital%20projects%20and%20infrastructure/our%20insights/the%20next%20normal%20in%20construction/executive-summary_the-next-normal-in-construction.pdf
16. SelectView Data, "Power BI for Finance: Must-Have Dashboards for Construction CFOs & Controllers" (2024) — https://selectviewdata.com/power-bi-for-finance-must-have-dashboards-for-construction-cfos-controllers/