Skip to main content

Monthly Financials

Learn about the Monthly Financials 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: 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

Did this answer your question?