Skip to content

Non-financial accounts

xpna allows you to create and manage non-financial accounts, which are used to track non-financial data such as FTE, Headcount, Website visitors, New logos, or other qualitative metrics. Non-financial accounts can be created and managed in the same way as financial accounts, but they do not aggregate in the same way as normal financial accounts.

Manage non-financial accounts

This action, available only on the Accounts hierarchy, shows a dialog that allows for the creation and management of non-financial accounts. These accounts live in their own section of the accounts hierarchy at All accounts > Non-financial accounts.

You can use the Add new action button to add a new non-financial account to your accounts hierarchy by giving it a name and a unique code.

You can update an existing non-financial account by using the Update existing action button and then selecting the non-financial account to modify.

Aggregation types

When creating non-financial accounts, you can choose their Aggregation type to determine how they will aggregate. The available options are:

  • Sum (FOREX), this will sum the values of the account across all currencies, and convert the values using the monthly average exchange rates for the periods.
  • Sum, this will sum the values of the account, without applying any exchange rate conversion.
  • Average of periods, this will sum the values of the account across periods, and divide by the number of periods in the selection. This is useful for accounts such as headcount or FTE.
  • Last non-empty, this will return the last non-empty value of the account across all periods. This is useful for accounts that are not expected to change frequently, or where the most recent value is the most relevant. For example, customer satisfaction scores or employee engagement scores.

Using non-financial accounts in hierarchies

Non-financial accounts can be used in hierarchies in the same way as financial accounts, but they will only aggregate if all children of the selected member have the same aggregation type. If the children have different aggregation types, the hierarchy will not aggregate, and no value will be returned.