aACE comes with a default Chart of Accounts. You can also create your own Chart of Accounts by manually adding new accounts or editing the default list. You can also import a new list:
Import a New Chart of Accounts
Step 1: Preparing the Data for Import
To import your own Chart of Accounts, the first thing you will need is an aACE compatible spreadsheet populated with the general ledger accounts you wish to import. (Note: We recommend using an .XLSX file.)
Start by downloading an aACE compatible template from the General Ledger module.
- Navigate from Menu > Accounting > GL Accounts.
- Follow the instructions here for downloading the template. When you are finished downloading the template, return to this page and continue.
- Populate the template with your own Chart of Accounts:
Step 2: Preparing aACE for the Import
The list of accounts in aACE should match the corresponding accounts in your spreadsheet. The easiest way to accomplish this is to first delete the unused accounts in aACE. Review information about the types of relationships GL accounts can carry, then follow the instructions for deleting unused GL accounts.
When you are finished, return here to continue to Step 3.Step 3: Update the remaining GL Accounts in aACE
Synchronize the remaining aACE accounts with the corresponding accounts in your spreadsheet. This may include updating the account numbers, names, and the header/detail relationships.
Do a final review of your spreadsheet for accounts already listed in aACE and remove any duplicates from your spreadsheet. When finished, proceed to Step 4.