Dashboards - Management

David Stevenson -

Choosing the management dashboard displays four panels of data - Financial summary, Billings forecast, Staff utilization, Top clients.  All four management dashboards can be set to show data from jobs where you are the account handler, or for all account handlers.

Financial summary.

This dashboard shows several series of data for the past quarter (based on the current date).  There are two views available for this dashboard, Standard and Cumulative.  The Turnover data series is the total billed amount in each month displayed.  Gross profit uses tickoff to calculate a profit figure taking only purchase costs into account.  Aged WIP is the work in progress figure based on current data, but each WIP transaction included is aged according to its date - this cannot be reliably reconciled to the Aged WIP report as that uses a fixed number of days rather than calendar months for aging.  This figure only includes purchase invoices - time / material WIP is excluded from the values.  The cumulative view of Aged WIP shows total WIP as at the end of each month displayed, again based on current data - so is effectively WIP Retro as at the end of each month.

Billings forecast.

This dashboard has two views which switch between showing Planned vs Invoiced and Planned GP vs Actual GP.  The data series are shown per month, you can set the number of months and start month from the controls at the top of this dashboard.  Planned values come from your billing plan data, invoiced / actual gp uses the same data as the financial summary dashboard.  Ticking the box to include targets adds a third data series for target turnover or target gp.  These targets are set up for each client, per month or per year (spread evenly). For systems that use revenue recognition, if the 'Recognise value' box is ticked on the billing plan, this value is used for the planned values.

Staff utilization.

This dashboard shows the breakdown between chargeable and non-chargeable hours of all timesheets entered into your database in the period set using the controls within this dashboard.  Timesheets on internal jobs, in-house status phases or those marked as investment are considered non-chargeable.  All other timesheets are counted as chargeable.  This breakdown can be shown for the whole company, or broken out further by staff team.  Ticking the box to include targets adds two series of data - target and charge target.  These targets are set against staff resources.

Top clients.

This dashboard has two views which switch between turnover and gross profit.  The period used to calculate these values is set using the controls in this dashboard, and the number of clients which can be reported on individually can be toggled between 5 / 10.  In addition this dashboard can be set to display a pie chart or a bar chart.

Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk