Contract value development shows how the values saved from contract billing rows have changed. You can view the value per invoice or per year, with or without discounts. The report does not show actual billing, paid invoices, or revenue for the report period.
Requirements and opening the report
Use the report in a browser. The Spot contract summaries on Android and iOS show basic contract information, not this value development report. The report includes only non-deleted contracts that are visible with your user permissions and have saved value history.
In the browser's main menu, open Dashboard → Report pages and select a page using the selector at the top of the page. An administrator can add the report by selecting Add new report at the top. In the report selection that opens, enter the report name or part of it in the Search for a report or browse reports by item field. You can also open the initially collapsed Contracts section. Drag Contract value development from the selection onto the page and select Save the page at the top. Confirm that it was saved by reloading the page and checking that the report appears.
Adding reports and permanently saving settings require administrator rights. A saved report is a shared configuration on the report page, but its data depends on the viewer's permissions. Without the report manager's additional features, one report page is available. For more information about working with pages, see adding and arranging a report.
Choose the value, time period and filters
Open Settings from the report's title bar. In the All filters section, select the Field used to calculate the value:
- Discounted total per invoice: the combined value of the billing rows excluding VAT, after row discounts. This is the default.
- Total per invoice: the same value per invoice without row discounts.
- Discounted total per year: the discounted value per invoice multiplied by the calculated annual number of invoices.
- Total per year: the annual value without row discounts.
In the same section, filter by Customer, Contract group, Contract and Status as needed. Filters in different fields apply together: a contract must meet all the filters set. An empty field does not filter the data.
Above the report chart, Tme period for the data sets the period to view. Time grouping for data sets the intervals for the points or bars: day, week, month or year. The default is monthly grouping and a period covering the current month and the previous three months. The current-year period selection cannot be combined with daily grouping. For background on the time selections, see report time periods and filters.
In the Ryhmittele section of the settings, you can break down values by customer, contract group, contract or status. Without grouping, the report adds the values of the included contracts into a single series. Time grouping and contract grouping are separate selections.
To keep changes to a saved report, select Save Settings in the title bar while the settings are open, using an administrator account. Settings for a new report are saved using Save the page. Changing settings for viewing alone does not save them permanently.
How are the values per invoice and per year calculated?
The value of one billing row excluding VAT is Lukumäärä × Jakso × Yksikköhinta. The row's Jakso is a multiplier for the price; it is neither the report time period nor the contract billing interval. For the discounted value, the row's percentage discount is first deducted from the unit price. A missing price or discount is treated as zero. VAT is not included in the report values.
Each row total is rounded to the nearest €0.05 before the rows are added together. In a tie, a positive amount is rounded up. The total per invoice is also rounded to €0.05 before the annual value is calculated.
The annual value is calculated from the value per invoice at the time it was saved and the number of invoices in the calendar year when the calculation is performed. When Use fixed invoice dates is enabled on the contract's Billing settings tab, the multiplier is the number of annual dates configured. For the annual value calculation, this selection overrides the recurrence interval.
Otherwise, the calculation starts on the first day of the year and proceeds according to the contract billing recurrence period and interval. The first day is included. Subsequent calculated creation dates are shifted according to the billing advance; in monthly advance mode, the selected exact day of the month also affects them. If that day does not exist in a month, the last day of the month is used. Dates falling on or before the end of the year are included.
The annual value is not prorated according to the contract start or end date or the first invoice creation date. It also does not prove that automatic billing is enabled or that invoices have been sent. Maintaining billing settings is described in contract billing and price changes.
For example, a row has a quantity of 2, a period of 3, a unit price of €10 and a discount of 10%. The total per invoice is €60 and the discounted total is €54. If there are four fixed annual invoice dates, the annual values are €240 and €216. The €216 shown at a monthly point is then an annual value, not billing for that month.
How is the history interpreted?
The value for each time period is the last saved value for each contract by the end of that period. The report adds these values by contract or according to the selected grouping. Values saved during the same period are neither added together nor averaged. The report's final total is rounded to two decimal places.
The last value saved before the report period serves as the starting value. The value carries forward into subsequent periods until a new value is saved. If a contract's value is €100 in January and €120 is saved in February, the monthly points are €100 and €120. March still shows €120 if no new value is created. Adding the monthly points together does not give actual billing.
Before the first saved value, the contract does not contribute to the period total. Periods entirely in the future are empty. The current incomplete period shows the last value saved so far, so its result may still change.
Filtering and grouping use the contract's current customer, contract group and status even for past periods. For example, changing the group can move a contract's earlier values into the new group. The report does not reconstruct the historical state of this information.
Deleted contracts are excluded from the report entirely, including for past periods. Expiration, archiving or a future start date alone do not exclude a contract or reset its value. Choose the Status filter according to the purpose of your review. Changing the status is covered in contract history and archiving.
Value updates and checking the result
Changes to the billing recurrence interval, advance or exact creation date, as well as changes affecting billing row prices, trigger a value calculation in the background after saving. A new history entry is created on the first calculation or if any value per invoice, annual value or annual number of invoices changes. The history timestamp is when the new value is saved; a price change does not rewrite earlier values.
Update limitation: changing only the fixed invoice dates or whether they are enabled does not trigger this recalculation. A change of calendar year alone also does not guarantee a new annual value. Check the saved value after changes; if it is outdated, consult an administrator or support about updating it.
Deleting all billing rows does not save a zero value. The previous value may therefore continue to appear in the report. Do not interpret an empty set of rows as proof that the report value has been reset to zero.
- Filter the report to one contract using All filters → Contract, and check the selected value field and time period.
- Open Customers → Contracts from the main menu, find the same contract and compare the corresponding total per invoice or total per year column in the table view. Compare the discounted total with the discounted value field. If the column is hidden, open the column icon showing vertical bars at the right end of the table's header row and select the column to display it. The list shows the latest saved value, so compare it with the report's most recent period.
- Open the contract details by clicking its name. Check the quantities, periods, prices and discounts in the Billing rows section of the Billing settings tab, and the billing schedule in the Basic information section. On the History tab, check the Contract value update event and its timestamp.
- After background processing, reload the report page and check that the new value appears in the correct time period. If you changed the report's permanent settings, reopen them to confirm that they were saved as well.
Changing the report's filters or grouping changes the presentation, not the contract's billing rows or value history. If the result is missing or unexpected, first check permissions, filters, the current status and the time of the last value update. See also troubleshooting an empty report.