Multi-Project Margin Analysis for AU Construction Firms — Building Portfolio-Level Visibility Beyond the Single Project P&L

May 28
5 min read

Running a single project well is one thing. Running a portfolio of 8-25 active projects with disciplined margin visibility across all of them is another. Most builders we engage with have decent visibility on each project individually but no rolled-up view at the portfolio level — meaning they can't answer questions like "which client / segment / project manager is most profitable?" or "where should I focus business development next quarter?"

This guide walks through multi-project margin analysis — the rolled-up portfolio view that sits above individual project P&Ls and surfaces the insights single-project reporting misses. If you've already read our Project P&L walk-through, this is the next layer up.

Why portfolio-level analysis matters

Three things become visible at portfolio level that single-project P&L misses:

1. Margin variance by segment. Your government work might run 12% gross margin. Your private-commercial work might run 18%. Your residential might run 22%. At single-project level you see each margin in isolation. At portfolio level you see the structural mix — and can decide deliberately how much of each segment to win in the next quarter.

2. Client profitability concentration. Some clients pay on time, accept variations gracefully, run clean projects. Others delay, dispute everything, drag retention release. At portfolio level you can see which clients deliver above-average margin and which actively erode it.

3. Project manager performance. One PM might consistently land projects at FAC = bid. Another might consistently land 2-4 points below. Single-project data doesn't surface the systematic pattern. Portfolio data does.

The 4 cuts of portfolio-level analysis

Cut 1: By project status (active / completed / pipeline)

Roll up margin metrics across:

All currently-active projects (in-flight)
All projects completed in the trailing 12 months
All projects in the forward pipeline (won-but-not-started, plus weighted pipeline)

Comparison signals: are active projects tracking better or worse than completed projects' final margins? If worse, that's a deteriorating trend. If better, that's competitive discipline strengthening.

Cut 2: By segment / vertical

Group projects by:

Sector: government / commercial / residential / industrial / education / health
Procurement type: lump sum / cost plus / GMP / D&C
Project size: <$1M / $1-5M / $5-15M / $15M+
Duration: <6 months / 6-12 / 12-24 / 24+

For each segment, compute: average gross margin %, FAC variance vs bid, working capital utilisation, average payment terms achieved. Surface the segment with the highest margin AND the lowest variance — that's your growth target.

Cut 3: By client

Group projects by client. For each client surface:

Total revenue across all projects (trailing 24 months)
Average gross margin %
Variation approval rate (% of claimed variations approved)
Average days-to-payment on progress claims
Retention drag (% of total revenue tied up in retention at any time)
Project-success rate (% of projects landing at or above bid margin)

Clients in the top quartile across all metrics are your A-list — focus business development on more like them. Clients in the bottom quartile are candidates for "we won't bid your next job."

Cut 4: By project manager

Group projects by lead PM. For each PM surface:

Number of projects supervised
Average bid margin vs final margin (the FAC accuracy score)
Variation management quality (variations identified and claimed vs missed)
Project safety / quality metrics
Client satisfaction (if tracked)

Note: this cut is sensitive — share with leadership only, not openly. The signal is for management decisions (training, redeployment, recognition), not blame.

The recommended monthly portfolio pack

Add the following two pages to your standard monthly management pack:

Page A — Portfolio summary

Active project count + total contract value — current state
Average gross margin % across active projects — weighted by contract value
FAC variance summary — total $ of margin slippage vs bid (positive = ahead, negative = behind)
Top 5 projects by contract value — name, % complete, current gross margin %, FAC trend (up/flat/down)
Bottom 3 projects by FAC variance — projects most behind bid, with reason and remediation plan
Pipeline visibility — weighted forward pipeline by segment

Page B — Segment / client / PM rollups

Margin by segment — table with average margin %, variance to bid, $ contribution
Margin by client — top 10 clients ranked by total contribution, with metrics per client above
Margin by PM — leadership-only, FAC accuracy + project mix
Quarter-on-quarter trends — are these metrics improving or deteriorating?

The data infrastructure needed

Multi-project margin analysis requires data infrastructure single-project P&L doesn't:

Every project tagged by segment + client + PM + duration band in your accounting system. Configure custom fields in Xero / MYOB / NetSuite for these.
Every supplier invoice, sub-contract invoice, and timesheet entry tagged to a specific project — see our Job Cost Reporting Setup guide.
FAC updated monthly per project with documented variance commentary.
Forecast pipeline tracking — separate system or columns to track weighted pipeline.
Client master record — each client a distinct entity with metadata (industry, payment terms, relationship-tier).

This is foundational data discipline. Most $5-25M builders don't have it. Most $25M+ builders do (or are paying the cost of not having it).

The PowerBI / dashboard layer

Once data is tagged correctly, the rollup is straightforward — a PowerBI / Tableau / Looker dashboard or even a well-built Excel model can produce the views in minutes per refresh. The cost-engineering decision: build vs buy.

Excel-based portfolio pack: low cost (few hours of FC time monthly), high flexibility. Recommended for $5-15M revenue.
PowerBI dashboard: $10-30k initial setup, ~$2k/year maintenance. Live updating. Recommended for $15-40M revenue.
Cloud-native ERP (NetSuite / SAP B1): $50k+ initial, ongoing licensing. Native project costing. Recommended for $40M+ revenue or M&A readiness.

Six common mistakes we fix in first-quarter engagements

1. No segment tagging on projects. Every project is "construction" — no commercial / government / residential split. Without it you can't see segment-level margin variance.

2. Client data is messy. Same client appears under 3 different names (Big Co Pty Ltd / BigCo / Big Co Construction). Without clean client records you can't roll up client-level margin.

3. PM data not captured. Projects don't have a lead-PM tag. Can't run PM-level analysis even if leadership wants to.

4. FAC not updated monthly. If FAC only updates at PC, you don't have running variance to surface in the portfolio pack.

5. Overhead recovery rate not consistently applied. Some projects bear overhead, others don't. Portfolio margin comparisons become apples-to-oranges.

6. Tracking too late. Trying to build portfolio analysis from data captured loosely. Garbage in, garbage out. Install the data discipline at job-cost setup, not retroactively.

Where this fits in a TechEdge engagement

Finance Manager (from $2,750/mo): Single-project P&L every month. Foundation data discipline. Suitable up to ~$10M revenue.
Financial Controller (from $4,950/mo): Adds segment / client rollups to the monthly pack. PM-level analysis on request. Suitable $10-25M.
Head of Finance (from $8,500/mo): Full portfolio pack with quarterly trend analysis. Capex allocation by segment performance. Suitable $25M+.

Take the Maturity Audit

5 minutes. 12 questions. Tier recommendation back within 48 hours.

Take the Maturity Audit →

Multi-project margin analysis approaches are operator-specific. This article is general guidance. Engage a CPA to set up portfolio-level reporting appropriate for your business. Last updated 27 May 2026.