Skip to content

How can we help you?

Overview

Order Statistics

Get an overview of the order's finances with key figures down to cost type.

The order statistics give you a quick financial overview of an order: what has been sold, what it costs, and what you earn. You can see the figures for the whole order, per task and all the way down to cost type, and compare them with the budget.

 

How to read the order statistics

You find the statistics on the order under the Statistics tab. Each row is a task on the order. Each task has a status: Invoiced when the task has been invoiced, and Draft when invoice lines have been created on the task that have not yet been invoiced (for example because an offer has been made). Click the arrow next to a task to expand it and see the figures broken down by Cost type.

Order statistics

 

Key figures

  • Sales (invoice lines): the sales amount from the invoice lines on the order.

  • Sales (cost posts): the sales amount calculated from the cost post entries.

  • Cost t: the total costs (both approved and unapproved).

  • Margin: the contribution margin, i.e. sales minus costs.

  • Margin %: the contribution ratio, i.e. margin as a percentage of sales.

  • Hours: the registered hours.

  • Margin/hour: contribution margin per hour.

  • Completion %: the costs relative to the budgeted costs.

 

Columns with two figures

Where the column heading includes Cost posts, two figures are shown. The upper figure is based on the sales amount from Sales (invoice lines). The lower figure is marked with an asterisk and is based on the sales amount from Sales (cost post entries). This applies to Margin, Margin % and Margin/hour.

 

Totals at the bottom

  • Order total: all tasks on the order, both invoiced and not invoiced.

  • Actual, invoiced: only the tasks that have been invoiced.

  • Budget: the budget for the order, see the next section.

  • Difference actual/budget: the difference between Actual, invoiced and the budget.

Note: If a task has been invoiced on account, only the amount invoiced on account is included in the sales under Actual, invoiced. The costs of the task are only included once the task is 100% invoiced on account.

 

Budget in the statistics

You can compare the statistics with the budget in two ways:

  • Budget per order: The budget applies to the whole order. This is the only option without the Extended Invoicing app. The budget figures are shown as totals at the bottom.

  • Budget per task: Each task has its own budget. You get a Budget row under each task. When the task is expanded, the budget per cost type is shown together with Diff. cost, Diff. cost % and Diff. hours. Budget (sum of tasks) at the bottom is the sum of the budgets of the tasks.

You choose the budget model on the order under the Invoicing tab. The tab is only shown if you have the Extended Invoicing app.

If costs or hours are higher than the budget, the figure is shown in red text. This lets you quickly see where the budget has been exceeded.

Extended order statistics

➡️ Extended Invoicing Setup

 

Setup: What to include

At the top of the Statistics tab, you choose under Costs to include which costs the statistics are based on:

  • Posted costs: the actual, realized costs that are posted on the order. You find them under the Costs tab on the order.

  • Calculated costs from invoice lines: calculated costs from manually created order lines.

The choice applies to all tasks on the order, and you can change it whenever you like. In most cases, however, you do not need to change it.

You can set the default choice in the menu Setup > Order Setup on the Statistics tab.

 

Examples of order statistics

Here you see the same offer with two different choices under Costs to include. The offer is for DKK 2,520 for a new tap and has the status Draft, as it has not been invoiced yet. DKK 780 in costs have already been booked on the task. The offer lines contain a further DKK 790 in calculated costs.

Example 1: Booked costs only

Only Booked costs is selected. The statistics only count what you have already spent: Total cost is DKK 780, and CM is DKK 1,740 (CM % is 69.05%).

This looks good, but the contribution margin is too high, because the costs for the rest of the offer have not been booked yet. Use this choice when all costs on the task have been booked, for example when the work has been completed and invoiced. The statistics then show what you have actually earned (realized contribution margin).

Order statistics including booked costs only

 

Example 2: Booked and calculated costs

Both Booked costs and Calculated costs from invoice lines are selected. The statistics also add the expected costs from the offer lines: Total cost is now DKK 1,570 (780 + 790), and CM drops to DKK 950 (CM % is 37.70%).

This is a more realistic estimate of what you will earn on the offer if you carry it out as planned. Use this choice when you make an offer and before you send it to the customer. You can also use it while the task is in progress and not all costs have been booked yet.

Statistics also including the costs from the invoice lines

 

⚠️ Note: Do not select both Posted costs and Calculated costs from invoice lines when all costs have already been posted via voucher registration or order costs. The same costs would then be counted twice, and your contribution margin would be too low.


Updated