Skip to main content

Mark-up/Down Analysis

Learn about the Mark-up/Down Analysis 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, directors


Dashboard Explained

Revenue mark-ups and write-downs by slice, month, and project. Mark-up/Down Analysis makes visible the real margin cost of write-downs — identifying which offices, PMs, or projects are routinely writing time below fee and quantifying the aggregate impact across the firm.

Updated in Insights Pro: This dashboard existed in Analytics Plus as a "Written-Off Charge" report and has been substantially redesigned to also cover mark-ups for Insights Pro.

How to use it

Sort by Mark-Down/Off to identify where the firm is losing the most revenue to below-fee or written-off work. Use the Slice → Project → Project Manager drill-down to find the specific projects driving the highest values — this is often where scope creep is happening without a fee variation, or where the project was underestimated at proposal stage. Since Mark-Down and Written-Off aren't split apart here, use project-level notes or WIP Analysis if you need to distinguish "discounted at billing" from "never going to be billed."

Understanding your data

Key Fields

How it's Calculated

Net

Invoiced revenue after all adjustments: mark-ups minus mark-downs and write-offs combined

Mark-up

Total positive adjustments applied above standard charge

Mark-Down/Off

Total negative adjustments — mark-downs and write-offs combined into a single figure

Revenue Mark-up/Down & Written Off by Slice

Net adjustment value, broken out by the selected Slice By dimension

Revenue Mark-up/Down & Written Off by Month

Same, trended monthly

Slice/Project/PM table

Net adjustment value at row level, by month, drillable by Slice → Project → Project Manager, with a Total column


Visuals

  • Revenue Mark-up/Down & Written Off by Slice (diverging bar)

  • Revenue Mark-up/Down & Written Off by Month (combo chart)

  • Slice / Project / Project Manager table by month, with Total

Filters

  • Office: filter by Project Office

  • Discipline: filter by Stage Discipline

  • Project Manager: filter by Project Manager

  • Project Status: filter by Project Status

  • Project Type: filter by Project Type

  • Cost Centre: filter by Stage Cost Centre

  • Stage Manager: filter by Stage Manager

  • Stage Status: filter by Stage Status

  • Stage Fee Type: filter by Stage Fee Type

  • Project: filter to a specific project

  • Slice By: choose the dimension for the aggregated graph visuals

Did this answer your question?