Cost Object Reporting

Calculation target reports can be found under "Financials > Reports and printouts > Cost object reporting".

In order for the user to see cost object reporting, they must have at least read access to "Basic reporting", "Basic accounting functions", and "Accounting report search criteria" in the accounting function-specific rights (see image below). 

Reports are directly visible with the "Company user" or "All rights" profile.

With cost object reporting, you can examine account balances and transactions related to calculation targets. The report view also includes budget monitoring. The user can access the calculation target report if they have been granted edit rights to "Basic reporting" and at least read access to "Accounting report search criteria" from the Function-specific rights view. 

Reports:

• Calculation target table 
• Calculation target table in income statement format
• Calculation target table by targets in income statement format
  • This report allows you to select a detailed calculation target. When a detailed calculation target is not used, the report shows information as Unallocated and Total (targets + unallocated). If a detailed calculation target is used, the report does not show unallocated at all but only separates each target's balance individually.

    When using a detailed calculation target in search criteria, you can report each sub-level balance separately (if calculation targets are built hierarchically). In this case, the report does not sum targets upwards. If the detailed calculation target is omitted, the report takes the hierarchy into account and sums balances to the upper level. Depending on the reporting need and how the figures are to be presented (whether to sum hierarchically upwards or each target separately), you should choose whether to use a detailed calculation target or not. 

• Calculation target transaction table
• Calculation target comparison report
  • The calculation target comparison report only includes invoice receipts from purchase and sales ledgers that have a recorded calculation target
• Controller view as calculation target table (Requires Key figures and management reporting enabled)

In report conditions, select the necessary transaction restrictions related to dates and account and other conditions.
For calculation targets, you can select or limit the desired title targets and pick multiple sub-targets as a condition. Multiple target selection is done by choosing "Show targets in multi-selection mode" and selecting the desired targets while holding down the CTRL key. NOTE! The calculation target report does not by default take into account hidden calculation targets and entries made for them. If entries have been made for hidden calculation targets, you should press "Show hidden targets and titles" in the search criteria.

The report shows account balances under the target title calculated with restriction conditions and their budget comparison. Report data is shown by title on tabs. If a combination of calculation targets from different titles is used as a restriction in the report, then transaction rows that are unallocated at the corresponding title level are also included. They can be excluded from view using the show only allocated link. Similarly, budget monitoring can be excluded from view.

When a calculation target restriction is made on the calculation target report, the unallocated column is always zero when viewing this calculation target title tab, as only these search-restricted targets are examined, meaning there are no unallocated ones. For other title levels, transactions that meet the restriction but are not recorded under the targets of the examined calculation target title are shown. For example, if a search is made with the restriction "Hki" which belongs under the title level "City":

Then when examining the "City" tab, the Unallocated column is empty:

But on the "Cost center" tab, we see that there is a receipt in the Unallocated column that is recorded for the target Hki (which we had in the search criteria), but it is in the unallocated column because the receipt is not recorded for a calculation target under the "Cost center" title level:

When no calculation target restrictions are placed in the search at all, then unallocated transactions that are not allocated to any calculation target are shown. 

Hierarchy of calculation targets in reporting

If the calculation target structure is hierarchical, for example, entries recorded at level 3 are summed upwards in the hierarchy to the levels above it. If an entry is made for a calculation target at the lowest level of the hierarchy, it is also visible on all its upper levels in reporting, even though the entry is not directly made for them.

Printing the report

The calculation target table and calculation target table in income statement format can be printed from the top corner of the report using the "Export report" button. If the report is printed in CSV format, the Total column visible in Netvisor is not brought to the report. This is because the Total column may not necessarily sum all the figures in the row together if hierarchical calculation targets are used, meaning some balance may appear on both upper and lower targets.

Calculation target table by targets in income statement format report calculation targets are printed each on their own page only through the browser's Print function (CTRL+P).

Other functions of the report

From the Show menu, other restrictions can be made for the calculation target table:

In income statement format: Changes the calculation target table to income statement format

Only allocated rows: Hides zero rows from the report. A zero row appears on the report if there are entries for the calculation target during the selected period, even if the final balance is zero.

Show budget comparison: Brings out the budget version created with the old Controller as a comparison column.

Show hidden targets and titles: Shows hidden calculation targets in management on the report

Did you find it helpful? Yes No