Modify Chart of Accounts allows you to set up the accounts within the levels of your chart of accounts.
This video overview may include some out-of-date images. We appreciate your patience as we work to update these videos.
Filters
Select Balance Sheet or Income and Expense, whether you want to Show Inactive, and use your level filters as desired before clicking the Search button. The Cancel link returns you to the main General Ledger page.
You must make a selection for each level before clicking the Search button. These filters cannot be blank.
Chart of Accounts Grid
- Browse the grid manually, or click the Expand All button to expand it fully.
- The Collapse All button collapses the grid down to top-level groups.
- The Account Increment field allows you to specify the increment when adding a new account to a level.
- For example, with an Account Increment of 10, if the last account was 51030, the new one would default to 51040.
The following column headers display on the grid:
- Account Number: Displays the account number for an account and the range of account numbers for a group.
- Usage: Hover over the Information icon in this column to view information on how many times this account is used in other levels. Click the Information icon to view the Account Usage Detail window. This window allows you to see where this account exists in different levels, displays the description, allows you to update the description, and gives you the ability to add this account to other levels.
- Account Type: Displays whether this account is an Asset, Liability, Net Assets, Income, or Expense account.
- Name: Displays the Name assigned.
- Budget: Displays the Budget amount assigned.
- Closing Account: Displays the assigned Closing Account.
- Active: A Checkmark icon appears when the account is active.
- Note: A Note icon displays if text has been entered. Hover over the Note icon to view the text.
- Setup: Hover over the Information icon to view the name, date, and time of who set up and updated the account.
Add New Group
- Click the Add Group button to add a new group.
- Specify the Starting #, Ending #, Name, Account Type, and whether to Show Heading.
- Click the Add to Levels button to add this group to multiple levels of your account structure.
- Select the levels to which you want to add the group.
- Click Continue to save your selections, or click Close to return to the Add New Group window without saving.
- If you did make selections, you can hover over Levels Selected to view which levels are selected.
Cross-Level Groups
The Cross Levels option allows you to create a group that totals across levels in your account structure.
This is only applicable to Budgeted Levels (Location, Cost Center, and Department).
When using this option, a total line is created for reporting. It displays total amounts based on the selected ending level and the account number.
- Add this group to the department from which you want to start totaling.
- Select the option for Cross Levels.
- Select an ending level and enter an ending account number.
- The Starting # and Ending # fields do not have account selectors so that they can be used as a range.
- If you create new accounts within this range, they are included in the total as well.
- The Name field lets you specify the text that appears as a heading alongside the total amounts on the report.
- If you select the Show Heading option for the group, the contents of the Name field also display at the start level and account number.
The following reports display Cross-Level Group totals:
- Statement of Activities
- Budgeted Financial Statement
- Financial Spreadsheet
- Comparative Trial Balance
- Preliminary Budget
- Click the Apply button to add this group and continue adding another, or click OK to add this group and return to the Chart of Accounts page. The Reset link resets all fields, and the Cancel link returns you to the main Chart of Accounts page.
NOTE: To return to the initial Filter page, click the blue Filters bar.
Add New Account
- Click the Add Account button to add a new account.
- Specify the Account #, Name, whether the account is Active, if you want to Prevent Use of Manual Journal, and Account Type.
- If adding an Income or Expense account, you also select the Closing Account.
- A Note can also be added. Click the Add to Levels button to add this account to multiple levels of your account structure.
- Select the levels you want to add the account to, then click Continue to save your selections, or click Close to return to the Add New Account page without saving.
- If you did make selections, you can hover over Levels Selected to view which levels are selected.
- Click the Apply button to add this account and start adding another; click the OK button to add this account and return to the Chart of Accounts page; click the Reset link to reset all fields; or click the Cancel link to return to the main Chart of Accounts page.
- Click the Add Sub-Account button to add a sub-account if you have enabled sub-accounts for your company.
Note: The options for adding new accounts are the same. An example of a subaccount is 40100-100 or 50350-8540.
Note: A Sub-Account can be converted to a regular account, and a regular account can be converted to a Sub-Account, by adding or removing the number in the Sub-Account field when editing an account.
Opening Balances
Allowing users to enter opening balances is not consistent with generally accepted accounting principles.
A journal entry from a previous year is used in the program to adjust opening balances, maintaining an audit trail of activity.
- Click the Add New icon by any group in the grid to display the Add New Account window.
- If you are using sub accounts, you can click the green plus sign by any account to display the Add New Sub-Account window.
- You can also double-click any group, level, or account in the grid or click the Edit icon to edit that item.
Updated