How does General Ledger generate accounts?
Description
Cause
Resolution

After defining the account format in Custom Descriptions, and entering the applicable prefixes and base accounts, General Ledger account numbers may be created using the Generate Accounts command from the Setup menu. This command can combine every prefix combination with each of the base accounts to create a complete chart of accounts.

  • Unit and Suspense accounts

    If the Account Type is Units or Suspense, no accounts are generated.

  • Balance Sheet accounts

    A 'Balance sheet prefix' is a prefix with zeros that fill at all levels lower than the balance sheet level.

    If the General Ledger (GL) account is a balance sheet account (e.g. Current Assets, Noncurrent Assets, Current Liabilities, Noncurrent Liabilities, Equity, Retained Earnings), then GL creates the full account only if you created the appropriate Balance sheet prefix . The prefix must exist prior to running Generate Accounts; prefixes are never created by Generate Accounts. If you did not create the Balance sheet prefix , the following message will display at the end of the task, Generate Accounts.

    Not all balance sheet accounts were generated because of missing prefix records. If you store balance sheet accounts at a higher level than income statement accounts, you need to create the special balance sheet prefix (e.g. 10-00) in order to create the accounts. Set up the prefixes for the balance sheet accounts and run Generate Accounts again.
  • Profit and Loss accounts

    If the GL account is a profit/loss account (e.g. Income, Cost, Expense, or Other Income), then GL creates the full account using all existing prefixes, except for the 'Balance sheet prefixes'.

If the balance sheet level is at the lowest level (e.g. data having all three prefixes with balance sheet level at prefix C), then there are no Balance sheet prefixes. All existing prefixes are combined with all base accounts for both balance sheet accounts and profit/loss accounts.

No prefixes are ever created by Generate Accounts.

Example 1:


Account format: (ABC) x-xx-xx-xxxx
Balance sheet level: A
Fiscal Entity Level: A, B, C or Company (all give same results)
Prefix A= 9
Prefix B= 9-10
Balance sheet prefix = 9-00
Prefix C= 9-10-10
Balance Sheet prefix = 9-00-00
Base: 1111 - Account Type Current assets
Base: 4444 - Account Type Income

Result of Generate Accounts:
9-00-00-1111 - Current assets
9-10-10-4444 - Income

If the user had not set up prefix 9-00-00, then account 9-00-00-1111 would not have been created. At the end of the program, an error message would be displayed on the screen and a message would be written to the log file. There is only one message, no matter how many errors.

Example 2:


Account format: (ABC) x-xx-xx-xxxx
Balance sheet level: B
Fiscal Entity Level: A, B, C or Company (all give same results)
Prefix A = 9
Prefix B = 9-10
Prefix C = 9-10-10
Balance Sheet Prefix = 9-10-00
Base = 1111 - Account Type Current assets
Base = 4444 - Account Type Income

Result of Generate Accounts:
9-10-00-1111 - Current Assets
9-10-10-4444 - Income

If the user had not set up prefix 9-10-00, then account 9-10-00-1111 would not have been created. At the end of the program, an error message would be displayed on the screen and a message would be written to the log file. There is only one message, no matter how many errors.

Example 3:


Account format: (ABC) x-xx-xx-xxxx
Balance sheet level: C
Fiscal Entity Level: A, B, C or Company (all give same results)
Prefix A = 9
Prefix B = 9-10
Prefix C = 9-10-10
Base = 1111 - Account Type Current assets
Base = 4444 - Account Type Income

Result of Generate Accounts:
9-10-10-1111 - Current Assets
9-10-10-4444 - Income

Example 4:


Account format:(AB) x-xx-xxxx
Balance sheet level: A
Fiscal Entity Level: A, B or Company (all give same results)
Prefix A = 9
Prefix B = 9-10
Balance Sheet Prefix = 9-00
Base = 1111 - Account Type Current assets
Base = 4444 - Account Type Income

Result of Generate Accounts:
9-00-1111 - Current Assets
9-10-4444 = Income

If the user had not set up prefix 9-00, then account 9-00-1111 would not have been created. At the end of the program, an error message would be displayed on the screen and a message would be written to the log file. There is only one message, no matter how many errors.

Example 5:


Account format: (AB) x-xx-xxxx
Balance sheet level: B
Fiscal Entity Level: A, B or Company (all give same results)
Prefix A = 9
Prefix B = 9-10
Base = 1111 - Account Type Current assets
Base = 4444 - Account Type Income

Result of Generate Accounts:
9-10-1111 - Current Assets
9-10-4444 - Income

Example 6:


Account format: (A) x-xxxx
Balance sheet level: not applicable
Fiscal Entity Level: A or Company (both give same results)
Prefix A = 9
Base = 1111 - Account Type Current assets
Base = 4444 - Account Type Income

Result of Generate Accounts:
9-1111 - Current Assets
9-4444 - Income


 

Defect ID
Steps to duplicate
Related Articles