Navigation:  »No topics above this level« Chart of Accounts maintenance     Generate Accounts example

Here’s an example based on:
 A. All Balance Sheet accounts are for the "corporate" Department
 B. All Revenue accounts apply to certain Departments
 C. All Expense accounts apply to all Departments including "corporate"
 D. Finishing up

 

A. Balance Sheet Accounts

1)        Financial: Select
Select those Financial records that are for Balance Sheet accounts. That is, within the Financial List maintenance form - do UnSelect All to empty the list, then select all the Balance Sheet Accounts. If your AccountID begins with the FinancialID then you could use a range filter on the AccountID and then do Select All. Otherwise, set a filter where Class is "Asset" and do Select All and then set a filter where Class is "Liability" and do Select All and then set a filter where Class is "Equity" and do Select All.

2)        Department: Select
Select the "corporate" Department. That is, within the Department List maintenance form - do UnSelect All to empty the list, then Add that "corporate" Department to the list.

3)        Financial: Selected

4)        Department: Selected

5)        Generate Accounts button

This generates all Balance Sheet accounts for the "corporate" Department.

 

B. Revenue Accounts

1)        Financial: Select
Select those Financial records that are for Revenue accounts. That is, within the Financial List maintenance form - do UnSelect All to empty the list, set a filter where Class is "Revenue", and then do Select All.

2)        Department: Select
Select the Departments having Revenue accounts. That is, within the Department List maintenance form - do UnSelect All to empty the list, then add the appropriate Departments to the list.

3)        Financial: Selected

4)        Department: Selected

5)        Generate Accounts button

This generates all Revenue accounts for those Selected Departments.

 

C. Expense Accounts

1)        Financial: Select
Select those Financial records that are for Expense accounts. That is, within the Financial List maintenance form - do UnSelect All to empty the list, set a filter where Class is "Expense", and then do Select All.

2)        Financial: Selected

3)        Department: All

4)        Generate Accounts button

This generates all Expense accounts for all Departments.

 

D. Finishing up

The above steps set up the basics of a desired Chart of Accounts. There may be two more steps.

 

1)        Generate missing Accounts that we want.
These are required Accounts that didn’t fit those basic rules.
To do this, select the various FinancialID and DepartmentID combinations and generate these as required.

 

2)        Delete Accounts that we don’t want.
These are Accounts generated by the basic rules that we don't want anyway.
To do this return to the Account tabsheet and Delete them.