Skip to main content

Portfolio Summary

Learn about the Portfolio Summary Dashboard

Edition: Business + Insights Pro Add-on, Enterprise + Insights Pro Add-on
​User-level: Permissions are set at an Organisation level by System Administrators
​Who this is for: Principals, directors, finance team


Dashboard Explained

Portfolio-wide financial summary by slice, with four headline gauges and a full financial breakdown table. Portfolio Summary is the executive lens on the project portfolio - which parts of the business are performing, which are lagging, and where margin is being won or lost.
​​

How to use it

Use Portfolio Summary for leadership review meetings or board reporting. Switch Slice By to Project Manager to compare portfolios across PMs rather than offices. If one office/PM has high fee value but low Recovery % or Gross Profit %, investigate whether charge rates, write-downs, or project mix are driving the difference. Remember Project Status defaults to Active — change it if you need visibility into completed or on-hold work. Cross-reference with Monthly Financials to see whether the trend is improving or worsening over time.
​

Understanding your data

Progress bars

Visual

Measure

How it’s calculated

Net Invoiced as % of Fee

Net Invoiced | % of Agreed Fee/Cap | Stages

Stage net invoiced totals ÷ stage agreed fee or cap

Net Invoiced as % of Fee

Progress Bar | Net Invoiced as % of Fee | Target

Target line (0-100%)

Recovery %

Recovery % | Stages

Stage revenue ÷ stage invoiced charge (charge invoiced, plus the full charge of No Billing stages)

Recovery %

Progress Bar | Net Invoiced as % of Fee | Target

Target line (0-100%)

WIP 60+ Days vs Total WIP

WIP | Transactions | Transaction Date | 60+ Days

Value of WIP and Draft invoice transactions dated 60 or more days before today

WIP 60+ Days vs Total WIP

WIP | Transactions | Transaction Date

Value of all WIP and Draft invoice transactions

Gross Profit %

Gross Profit % | Stages | Standard

(Stage revenue − stage standard cost) ÷ stage revenue. Blank unless revenue is above zero and there is cost

Gross Profit %

Config | Target Gross Profit %

The organisation’s Target Gross Profit % (Target margin) from the financial controls entry in Synergy

Table (one row per Slice by group, Office by default)

Visual

Column

Calculation

Table

Office (or the Slice by choice)

The grouping field, as held in Synergy

Table

Projects #

A count of projects

Table

Agreed Fee/Cap | Stages

Stage agreed fee or cap, as held in Synergy

Table

Fee/Cap | Stages

Stage fee or cap, as held in Synergy

Table

Net Invoiced | Stages

Stage net invoiced total ex tax (lifetime)

Table

Net Invoiced | % of Agreed Fee/Cap | Stages

Net Invoiced ÷ Agreed Fee/Cap

Table

Residual | Stages

Fee still to invoice (agreed fee/cap − net invoiced)

Table

Revenue Forecast | Unweighted

Forecast at full value, current month onwards, active forecasts only. This page is fixed to the Gross category

Table

Revenue | Stages

Stage revenue total ex tax (lifetime)

Table

Invoiced Charge | Stages

Stage charge invoiced, plus the full charge of No Billing stages

Table

Recovery % | Stages

Revenue ÷ Invoiced Charge

Table

Charge | Stages

Stage total charge, all fee types

Table

Net Residual | Stages

Agreed fee/cap − net invoiced − WIP: work still to do and invoice. Negative stages reduce the total

Table

WIP | Stages

Stage WIP value; blank for Unsuccessful or Complete stages

Table

WIP | Transactions | Transaction Date | 60+ Days

WIP and Draft invoice transactions dated 60+ days before today

Table

Cost | Standard | Stages

Total Cost (default): stage total standard cost. Invoiced: standard cost of transactions by invoice date

Table

Gross Profit | Stages | Standard

Revenue − Cost

Table

Gross Profit % | Stages | Standard

Gross Profit ÷ Revenue

Table

Debtors Inc Tax

Amount still owing (inc tax) on Owing invoices, shared across stages by stage amount

Table

Debtors Inc Tax | 60+ Days

The same, for invoices 60 or more days old (from due date or invoice date to today)

The Office slicer and the Office grouping both use the project’s office.

Transaction-based measures exclude data-import transactions.

Notes:

  • The Invoiced/Total button only changes cost and gross profit.

  • The project Status slicers default to Active, so Complete, On Hold and other projects are hidden until the slicer is changed.

  • Group totals here should match the sum of the matching projects on Projects Snapshot when the same slicers are applied, because the measures are the same.

What changes the numbers on this page

Control

Options (default)

Units

Units, Thousands, Millions (Units)

Invoiced/Total

Invoiced, Total Cost (Total Cost)

Slice by

Office, Project Type, Cost Centre, Discipline, Project Director, Project Manager, Stage Manager, Primary Contact (Office)

Project Status Group and Status

Default Active

Other slicers

Account Manager, Primary Contact Name, Project Number Name, Project Salesperson, Project Director, RAG Level, Project Type, Cost Centre, Stage Manager, stage Status Group and Status, Fee Type, Office, Discipline, Project Manager

Fixed filters

Internal & Non-billable Projects excluded (whole dashboard); revenue forecast Category is Gross

Notes:

Stage totals, stage progress and invoices all come from Synergy, and corrections are made there.

Did this answer your question?