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-, tenant-, or company level. If you, for example, make changes at the tenant level, all companies under that tenant will get the customized chart of accounts.
Note that you must be an administrator at the top, group, or tenant 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 tenant 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;
Your new chart of accounts is saved and the changes are reflected in your dashboards, reports, and budgets in OneStop Reporting.
In the first drop-down box, these two options are available:
|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:
|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:
|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.*|