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.
