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.
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.
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.* |