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: Finance team, principals, project managers
Dashboard Explained
Portfolio-wide monthly revenue and charge trend, alongside a per-project financial summary table. Monthly Financials shows whether invoiced revenue is keeping pace with charge generated across the whole portfolio, and lets you compare recovery and gross profit project by project.
Monthly Financials and Monthly Financials | With Resourcing (Projects dashboard) show month-by-month financials for current and past months.
Revenue, recovery and gross profit are dated by invoice date.
Charge generated is dated by transaction date (when the work was done).
With Resourcing is the same page with two extra columns in the project table, comparing the charge recorded with the charge planned in resourcing.
Note: A "Monthly Financials | With Resourcing" variant of this page also exists, which additionally includes Resourced figures alongside the standard financial measures.
In the Security Matrix, only enable one variation of this dashboard to prevent duplicated tabs in the Projects module.
How to use it
Use the monthly trend chart to confirm invoiced revenue is tracking charge generated across the portfolio — a widening gap signals a growing WIP backlog. Use the Project filter to narrow this page down to one project if you need its individual Gross Profit and Recovery % figures; there's no separate stage-level or cumulative fee-consumption view here — for that, use Project Summary instead.
Understanding your data
Both pages: chart
Visual | Measure | How it’s calculated |
Line and column chart: Invoiced Revenue & Charge Generated | Revenue | Invoices | Invoice stage amounts ex tax for invoices dated in the month. Draft and “PRE” invoices are excluded; credit notes use the credit amount |
Line and column chart: Invoiced Revenue & Charge Generated | Invoiced Charge | Transactions | Invoice Date | Charge value of transactions Invoiced or Written off, by invoice date, excluding No Billing stages |
Line and column chart: Invoiced Revenue & Charge Generated | Charge | Transactions | Chargeable | Transaction Date | Charge value of work done in the month (transaction date), excluding No Billing stages, Internal & Non-billable Projects |
Line and column chart: Invoiced Revenue & Charge Generated | Recovery % | Transactions | Invoice Date | Transaction revenue invoiced in the month ÷ invoiced charge in the month |
Line and column chart: Invoiced Revenue & Charge Generated | Gross Profit % | Revenue | Invoices | Cost | Standard | Invoice Date | (Revenue | Invoices − standard cost of transactions invoiced in the month) ÷ revenue. Blank unless revenue is above zero and there is cost |
Both pages: project table (one row per project)
Visual | Column | Calculation |
Table | Project Number | As held in Synergy |
Table | Project Name | Truncated | Project name cut to 37 characters plus “...” when longer than 40 |
Table | Url Arrow | Opens the Project |
Table | Revenue | Invoices | As in the chart |
Table | Invoiced Charge | Transactions | Invoice Date | As in the chart |
Table | Revenue Mark Up | Transactions | Invoice Date | Mark-up or mark-down recorded on transactions invoiced in the period. Negative means work was billed below its value |
Table | Recovery % | Transactions | Invoice Date | As in the chart |
Table | Charge | Transactions | Chargeable | Transaction Date | As in the chart |
Table | Invoiced Cost | Standard | Transactions | Invoice Date | Standard cost of transactions Invoiced or Written off, by invoice date, all fee types |
Table | Gross Profit | Revenue | Invoices | Cost | Standard | Invoice Date | Revenue | Invoices − standard cost of transactions with an invoice date in the period |
Table | Gross Profit % | Revenue | Invoices | Cost | Standard | Invoice Date | Gross Profit ÷ Revenue |
Table | Cost | Standard | Transactions | Standard cost of all work done in the period (transaction date), invoiced or not |
With Resourcing only: extra table columns
Visual | Column | Calculation |
Table | Project Resourced Charge | Planned charge from resourcing estimates. For each weekday in the period, adds the daily charge (estimate total charge ÷ its number of days) of every estimate running that day, then totals the days |
Table | Variance Charge Generated - Resourced Charge | Generated - Resourced Charge. Positive means more work was recorded than planned, negative means less work was done than planned. |
All transaction-based measures exclude data-import transactions. The Office slicer filters by the project’s office.
Notes:
Two dates are in use. Charge generated and Cost | Standard | Transactions show when work was done.
Revenue, invoiced charge, recovery, mark-up, invoiced cost and gross profit show when it was invoiced.
There is the chance that in a single month the two don’t line up i.e.: work done in March may be invoiced in April.Gross Profit doesn’t equal Revenue minus the Invoiced Cost column. Gross Profit’s cost counts any transaction with an invoice date in the period.
Invoiced Cost counts only Invoiced or Written-off transactions. Treat them as separate figures.Cost | Standard | Transactions is not the cost behind Gross Profit. It is the cost of all work done in the period, including work not yet invoiced.
Resourced vs actual compares like with like by date. Both use the date the work happens: transaction date for actual charge, the days the estimate runs for planned charge.
hat changes the numbers on these pages
Control | Options (default) |
Units | Units, Thousands, Millions (Units) |
Date Hierarchy | FY, FY Qtr, Month, Week Ending, Week Start (Month) |
Fee Type | Default: everything except No Billing. This applies to every measure, so No Billing stages are hidden until the slicer is changed |
Project Status Group and Status | Default Active, Complete, On Hold, Pending Invoice |
FY and FY Qtr | Default FY2026 |
Other slicers | Account Manager, Primary Contact Name, Project Number Name, Project Salesperson, Project Director, RAG Level, Date, Project Type, Cost Centre, Stage Manager, stage Status Group and Status, Office, Discipline, Project Manager, Month |
Fixed filters | Internal & Non-billable Projects excluded (whole dashboard); current and past months only |
