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;
- Open Chart of Accounts.
- (If applicable) Select integration if you have access to multiple integrations.
- (If applicable) Select country the new chart of accounts will apply for.
- 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.
- Click the Customize switch.
- Click Yes to start customizing.
- 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.
- Use the Lookup to select accounts. TIP: You can use the Search field to search for accounts.
- Click Use value.
- 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:
Option | Function |
Where | Will include all data inside the specified filter. |
Where not | Will include all data outside the specified filter. |
If there are multiple filters in the same group, these options will also be available in the first drop-down box:
Option | Function |
And | Will filter the first condition AND the second condition. |
Or | Will filter the first condition OR the second condition. |
And Not | Will filter the first condition AND NOT the second condition. |
Or Not | Will filter the first condition OR NOT the second condition. |
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:
Option | Function |
In | account is In… (the selected parameters) |
<> | account is Not equal to… (the selected parameters) |
< | account is Less than… (for numerical values) |
> | account is Greater than… (for numerical values) |
<= | account is Less than or equal to… (for numerical values) |
>= | account is Greater than or equal to… (for numerical values) |
Begins with | account Begins with… (for any phrase contained in the dimension) |
Ends with | account Ends with… (for any phrase contained in the dimension) |
Contains | account Contains… (any part of the phrase contained in the dimension) |
Like | OneStop Reporting will retrieve any data using “LIKE …” in SQL.* |