The main purpose of the Revenue & Profit Margin Analysis widget is to track profit margin on equipment sales for a given period.

Numerous filtering and grouping options are provided, allowing the widget to meet a range of requirements.

For example, you may wish to see:

Margins are calculated by comparing up-front buy and sell prices for invoiced products and services, and displayed in £ and % formats.

A breakdown is provided to detail filtered information at line level, allowing you to drill down to item level. This breakdown can also be exported to Excel, allowing you to manipulate data as you require.

For specifics on where various values come from, check the table at the end of the document.

You can group by:

You can filter on:

The following filtering options are also available:

Choose whether or not any discount or hardware fund values should be considered.

For example, Exclude HWF will mean that we exclude the HWF amount from the original item price. This means that the HWF offset is acknowledged.

If you want the true value of the item, you should include funds and discounts.

Choose to show All items, Products only, or Services only.

You can elect to base any user or team filters and groups based on:

You can choose to display information for a given period. Choose a Timespan Type e.g. day, month and an Initial Span to determine period length. Please note that these options refer to calendar periods. If you wish to display in non-calendar periods, please use days as your timespan type.

The date triggers for a line are:

Products: stock allocation date to SO

Up-front services: connection date

The breakdown will display line details of filtered information. Users with the required role will be able to Export this to spreadsheet.

Click the magnifying glass icon against an individual grouping or against the Total row.