Chart of Accounts

In OneStop Reporting, it is possible to customize a standard chart of accounts, which is available for Denmark, Norway, and Sweden. The changes you make to the chart of accounts will be reflected in dashboards, reports, and budgets in OneStop Reporting, provided that expressions are configured correctly.

Note: Filters can be customized based on your own chart of accounts. However, the names of the groups or which groups exist cannot be edited in the chart of accounts. If needed, you can define your own expressions, which are only editable in Report Designer.

Customization at multiple levels

You can customize the chart of accounts at the customer, client, or company level. If changes are made at the client level, all companies under that client will receive the customized chart of accounts, provided no changes have been made at a lower level. The lowest level of customization always takes precedence.

Important

You must be an administrator at the customer, group, or client level to access the chart of accounts tool. The levels you can modify depend on where you have administrator rights.

For customer and client levels, the account overview performs a validation of accounts against one of your companies. Note that this only validates that an account is included and does not check if an account exists multiple times.

If you want to change the reference company used for this validation, you can do so in the Reference Company list in the top right corner.

Tip

If you see an “Unmapped accounts” warning in a yellow box, it means you have accounts that are not part of the chart of accounts. We strongly recommend resolving these issues, but this warning will not prevent you from customizing your chart of accounts.

To customize the chart of accounts

Open Chart of Accounts.
Select an integration if you have access to multiple integrations.
(If applicable) Select the country the new chart of accounts should apply to.
Select the level you want to modify the chart of accounts for, for example a company, all companies in a client, or all companies under the top level.
- NOTE: If you select the top or tenant level, all companies under that level will receive the new chart of accounts.
Turn ON the Customize toggle.
Click Yes to begin customization.
Select the relevant filters in the filter column. See explanations of filters and operators below. Use the + Add button in the Action column to add more filter criteria.
Use Lookup to select accounts.
- TIP: You can use the search field to find accounts.
Click Apply value.
Click Save.

It is also possible to define the chart of accounts based on account groups, account names, account classes, etc. This depends somewhat on which integration is set up.

Your new chart of accounts is saved, and the changes will be reflected in dashboards, reports, and budgets in OneStop Reporting.

Filter and operator options

In the first dropdown list, the following two options are available:

Option	Function
Where	Includes all data within the specified filter.
Where not	Includes all data outside the specified filter.

If there are multiple filters in the same group, the following options will also be available in the first dropdown:

Option	Function
And	Filters the first condition AND the second condition.
Or	Filters the first condition OR the second condition.
And not	Filters the first condition AND NOT the second condition.
Or not	Filters the first condition OR NOT the second condition.

In the second dropdown list, the following filter operators are available:

Option	Function
In	account is in … (the selected parameters)
<>	account is not equal to … (the selected parameters)
<	account is less than … (for numeric values)
>	account is greater than … (for numeric values)
<=	account is less than or equal to … (for numeric values)
>=	account is greater than or equal to … (for numeric values)
Starts with	account starts with … (any phrase in the dimension)
Ends with	account ends with … (any phrase in the dimension)
Contains	account contains … (any part of the phrase in the dimension)
Like	OSR Report Designer retrieves data using `LIKE ...` in SQL.*

Modify the chart of accounts directly in the report

If our standardized expressions do not fit your needs, you can manually enter account ranges or create your own expressions
(See the separate menu item for more information about expressions).

Create a group on the row where you want to add the account range, if one does not already exist.
Drag in General Ledger Account or Account, depending on which integration you are reporting on.
Enter the account range you want to filter on.

Remember to remove the standardized expression on the row if you do not want to use it.

Benefits of using the chart of accounts

Simplified maintenance:
Changes in the chart of accounts are automatically updated in dashboards, reports, and budget templates (provided expressions are used). This saves time on manual changes when the account structure changes.

Consistency across levels:
Customizations at the client level apply to all companies under that client, ensuring consistent reporting.

Reduced risk of errors:
By using the chart of accounts, you avoid errors that can occur from hardcoded account numbers that may vary between companies or change over time. The system’s validation against a reference company also helps identify unmapped accounts.