Chart of Accounts

In OneStop Reporting, we have a default chart of accounts, however, you can customize these to suit your business needs. The changes you make to the chart of accounts are reflected in your dashboards, reports*, as well as budgets* in OneStop Reporting. (*You need to set up Expressions in order for this to work.)

You can customize the chart of accounts at the top-, client-, or company level. If you, for example, make changes at the client level, all companies under that client will get the customized chart of accounts.

Note that you must be an administrator at the top, group, or client level to be able to access the Chart of Accounts tool, and the levels you have access to customize depend on which level you have administrator rights for.

For the top- and client level, the Chart of Account tool always performs a validation of the accounts against one of your companies. If you want to change the reference company for this validation, use the Reference company drop-down list in the upper right corner to change.

If you see a ‘Not mapped’ notification in a yellow box, it means you have accounts that are not part of the chart of accounts. We strongly recommend that you fix the issues, however, this warning will not prevent you from customizing your chart of accounts.

To customize the Chart of Accounts;

1. Open Chart of Accounts.
2. (If applicable) Select integration if you have access to multiple integrations.
3. (If applicable) Select country the new chart of accounts will apply for.
4. Select the level for which you want to change the chart of accounts, such as for a company, all companies in a client, or all companies under the top level. NOTE: If you select the top- or client level, all companies under that level will get the new chart of accounts.
5. Click the Customize switch.
6. Click Yes to start customizing.
7. In the Filters column, select the appropriate filters. (See explanation for Filters and Operators below.) Use the Add button in the Action column to add more filter criteria.
8. Use the Lookup to select accounts. TIP: You can use the Search field to search for accounts.
9. Click Use value.
10. Click Save.

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

*Filter and Operator options

In the first drop-down box, these two options are available:

If there are multiple filters in the same group, these options will also be available in the first drop-down box:

In the second drop-down box, select Account or other account attributes such as Account type, Account description, or External Code.

In the third drop-down box, these filter operators are available: