Chart of Accounts List
The Chart of Accounts List is used to manage your financial accounts.
Accounts are used to record and summarize the increases, decreases, and balances of each asset, liability and owner’s equity items (like accounts receivable, accounts payable, and retained earnings). Financial accounts track your business transactions.
New accounts may need to be created as your business grows and changes. For example, if you begin accepting credit cards, you might want to set up an account for credit card transactions.
When creating new accounts, the account numbers are automatically proposed in intervals of ten (10010, 10020, 10030, etc). Proposed account numbers can be overridden as necessary.
If you want to make this account a sub-account of another account, select the account from the drop down menu and select the account that would be the higher-level account for this sub-account.
If a particular account in COAs seems to cover too much, you can divide the account into one or more sub-accounts. Sub-accounts let you track several related types of income or expenses independently yet keep them all under the all-inclusive of a single parent account.
In the parent account “Phone” you might want to set up sub-accounts for cell phones, local phone service, long distance service, toll free phone service, and pagers. You could then track how much your company spends on long distance, cell phones, etc. individually, but still have the ability to know exactly how much you pay out in the utility ‘Phone”.
Account types define the role of each account and how it behaves. The various account types available include:
Bank – Used for bank accounts (ie: Checking, Savings, Special Payroll Savings Account, etc).
Accounts Receivable – Used to track money customers owe.
Other Current Asset – Used for other assets such as petty cash, prepaid expenses, and other items.
Fixed Asset – Assets which are owned by the company but not likely to be converted into cash within one year.
Other Asset – Miscellaneous assets which are neither “current” nor “fixed”.
Accounts Payable – Used to track money owed to vendors.
Credit Card – Used to track credit card purchases and payments.
Other Current Liability – Liabilities to be paid in full within one year.
Long Term Liability – Liabilities not to be paid in full within one year (ie: building loan, car loan).
Equity – Owners equity, investments, draws and retained earnings.
Income – Money received for the sale of goods and services.
Cost of Goods Sold -The direct costs associated with acquiring and selling goods.
Expense – The indirect costs (overhead) of running a business (ie: office staff wages, utilities, copier paper, pens).
Other Income – Miscellaneous “windfall” income received from non-typical activity.
Other Expense – Miscellaneous abnormal expenses.
- From the main menu, click Banking | Chart of Accounts List.
Perhaps the easiest way of using the commands available in this list is through it’s right click menu. The right click menu is identical to the title menu.
- To create a new account, right click anywhere in the list and choose New Account from the pop-up menu.
- To edit an account, right-click on it and choose Edit Account from the pop-up menu.
- To delete an account, right-click on it and choose Delete Account from the pop-up menu. Note: It may not always be possible to perform this action — inactivation may be more appropriate.
- To inactivate an account, right-click on it and choose Make Account Inactive from the pop-up menu. This can also be done by ticking the “Inactive” checkbox within a record itself.
- To merge one account with another, right-click on the source account and choose Merge COA from the pop-up menu.
- To export whatever information is currently displayed in the list, right-click anywhere in the list and choose Export List from the pop-up menu.
- To modify which columns are displayed in the list, right-click anywhere in the list and choose Form Preferences > Show Columns from the pop-up menu.
Creating a New Account
Follows are the general steps for creating a new account. When creating a new account, some fields may vary depending on the type of account. Specialized fields particular to a certain account type should be self-explanatory. For example, when creating a new account of the type “Bank”, fields like “Bank Acct No” and “Routing” will be available. Or when creating a new account of the type “Other Asset” or “Other Current Asset”, the unique checkbox “This Account Is Used For Inventory Purposes Only” will be available.
- Right click anywhere in the list and choose New Account from the pop-up menu. The “Add Account” form will appear.
- Choose an account “Type” from the drop-down list.
- Propose, except, or modify the account “Number” as necessary.
- in the “Subaccount of” field, Identify the “parent” account if necessary.
- Enter an account “Description” if necessary.
- Complete any other available fields as applicable to the account type being created. These will vary depending on the account type being setup.
- Click the OK button to finish and close the form, or click the Next button to save and go on to create another.
If it becomes necessary to merge one account into another, use the “Merge COA” command. Be extremely careful when performing this action. It is strongly recommended that a backup of your database be created prior to merging COA accounts.
- To merge one account with another, right-click on the source account and choose Merge COA from the pop-up menu. The “Chart of Accounts Merge” window will appear.
- The “Merge From” field should display the account on which you originally clicked in the Chart of Accounts List. If it does not, or the account should be another one, select it from the drop-down list.
- Select the “Merge To” account from the drop-down list. This is the target account to which the “Merge From” source account info will be transferred. The “Merge To” drop-down list will contain only accounts of a similar type as the “Merge From” account. For example, if the source account is a “Bank” type of account, then the list of target accounts will only contain “Bank” type accounts, not “Expense” accounts or other dissimilar account types. In other words, merging which does not make accounting sense
- If desired, tick the “When complete, Inactivate the “Merge From” Account” checkbox to enable that action.
- Click the “Merge” button. A verification window will appear which explains that the merge action cannot be undone. Click “Yes” to confirm and continue with the merge. A notification will appear when the merge process is complete.
- Carefully check the “Merge To” target account to verify that the results are as expected.
- It is generally recommend to avoid deleting accounts. Consider Inactivating accounts instead.
- Use expense accounts to track reimbursed expenses as income.