1.  Account No

An account number in the standard account number format.  This depends on the account number Account, Profit Center, and Department number format you previously entered in the Company Setup application.  Refer to the System Manager manual for formats available.

In change or delete mode press the F7 key for account search by number or the F8 key for account search by description.

The entry of a zero or spaces for the main account number is reserved for the definition of profit centers.  Entry of zero or spaces for the main account will cause the system to prompt for a Profit Center entry and Department will default to zeros.  No accounts to which posting is desired may have a main account number of zero or spaces.  The definition of profit centers is recommended if your accounting system supports profit centers.  In those applications where the entry of a profit center is allowed, the account description entered here will display beside the profit center entered to confirm the validity of the entry.

If you do not wish to distinguish between accounts by profit center or department we recommend that these numbers should not be used.  To do this, set the number of digits for Profit Center or Departments to 0, using the Company Setup application.  This will greatly simplify your chart of accounts.

Most users will wish to group accounts logically by main account number.  For instance, all P&L accounts might be numbered from 03100 through 99999 with revenue accounts having the numbers up to 03999 and expense accounts having the numbers 04000 through 99999.

Similarly, Balance Sheet accounts could be numbered from 01000 through 02999 and grouped accord­ing to categories of assets, liabilities and equity.

Such numbering conventions are not a requirement of the package, however.  Any main account number from 00001 through ZZZZZ is an allowable entry for postable accounts.  Main account number 00000 is the only number having a special significance to the pack­age.  Posting will not be allowed to accounts bearing a main account number of 00000 or spaces.

Account Number

A change to the account number is not allowed in change mode. In order to change the number assigned to an account you must delete the account then add the account with the correct account number.

2.  Description

30 alphanumeric characters.  This is the description that will print on all reports that show this account, including financial statements where the user requests this account to print out.

3.  Counter Bal Acct

An account number in the standard account number format.  No validation of the counter‑balancing account occurs at this time. 

Once the full G/L Accounts has been entered you should verify that each counter‑balancing account referenced has been pro­perly defined.  

Press the F7 key for account search by number or the F8 key for account search by description.

An entry in this field will allow you to answer Yes to the Counter-Balance? question in General Journal Transaction Processing application.  If you answer Y to that question, an automatic entry will be made to the account entered here.  If no account is entered here, you will not be allowed to make counter-balance entries to the main account number entered above in field #1.

4.  Consolidation Acct

An account number in the standard account number format.  No validation of the consolidation account occurs at this time.

Once the full G/L Account File has been entered you should verify that each consolidation account referenced has been properly defined.

Press the F7 key for account search by number or the F8 key for account search by description.

This account allows the user to define the multi‑company consolidation account that this particular account will belong too.

5.  Auto Dist Code

4 numeric digits.  No validation of the Distribution code occurs at this time.  The Distribution code need not be on file for it to be entered here.  Any number from zero through 9999 is allowed.  The validity of a Distribution code can be determined manually from a printout of the Distribution Code file.

Auto Dist Code

An entry in this field will allow you to answer Yes to the Auto-Distribute? question in the General Journal Transaction Processing application.  If you answer Y to that question, an automatic entry will be made to the account entered here.  If no account is entered here, auto-distributions will not be allowed for the main account number entered above in field #1.

6.  T/B Subtotal Level

1 numeric digit.  The trial balance subtotal level allows the user to insert his own subtotals anywhere on the trial balance.  Up to nine levels of subtotaling are allowed.  (These subtotals are in addition to the subtotals generated automatically by the trial balance program each time the main account number changes. 

Permissible entries for this field are zero through nine.  The entry of zero signifies no subtotal.

In order to visualize the posi­tions of these subtotals it will help to lay out your entire chart of accounts in numeric order on a sheet of paper or to wait until all accounts have been entered and then work from a G/L Account File printout.  The example below will present a highly simplified G/L Account File to demonstrate how the first three subtotaling levels function.  Additional levels be­have the same way.

7.  Fin Statement Type

Must be a B or a P.

B              =              Balance Sheet

P              =              Profit and Loss (P&L)

There is no default.

The financial statement type defines the account as a Balance Sheet or P&L type account.  Asset, liability and equity accounts should be identified as Balance Sheet accounts.  Revenue and expense accounts should be identi­fied as P&L accounts.  An entry is required for all postable accounts.

Fin Statement Type (continued)

It is vitally important that the financial statement type be pro­perly assigned.  Subsequent applications rely upon this infor­mation being correct.

For example, the year-end closing procedure cannot execute properly if information in this field is not correct.

8. SAF Type

1 alphabetic character.  May be left blank.

If you desire to automatically generate the Statement Of Cash Flows and the Sources and Applica­tions of Funds Statements you must assign an SAF type to each Balance Sheet account.  An entry is not required by the program, however, since some users may wish to post­pone implementation of this feature.  A submenu will appear showing the SAF type options.

Every Balance Sheet account must be categorized into one of six basic types in order to generate the statement of cash flows and run the source and application of funds reports.

SAF Types:

1. C          =              Cash

2. N          =              Non‑cash charges against income (e.g.,accumulated depreciation, allowance for bad debts)

3. A          =              Current assets (excluding cash)

4. L          =              Current liabilities

5. F          =              Cash flow (financing)

6. I           =              Cash flow (investing)

9.  Paren Control Code

1 alphabetic character.  Must be a C or a D for all postable accounts.

There is no default.

The parenthetical control code specifies whether the account is typically a debit or credit account.  On financial statements, non‑typical balances are enclosed in parentheses to set the balance off from the other balances shown on the statement.  An entry of D, or C is required for each postable account depending upon whether the account is typically debit or typically credit.  A submenu will appear to remind the operator of the available options.

Paren Control Code (continued)

Typically debit accounts would be all expense and asset accounts.  Typically credit accounts would be all revenue, liability and equity accounts.  Certain accounts may be coded with a parenthesis control code opposite from the account's typical balance so that the account's balance would appear within parentheses under normal circumstances.  (For instance, contra‑asset accounts such as accumulated depreciation could appear in the assets section of the Balance Sheet highlighted by parentheses.)

10.  Compression Code

1 alphabetic character.  Defaults to N for No compression.

The compression code is required for all accounts.  This code is accessed by the Compress General Ledger Trx File application. 

Refer to the Application Overview of that application for more information 

When the compression application is run, transactions for a given account will be consolidated into a single transaction for each day or each period or will not be consolidated at all depending on the entry for the compression code.

N              =              No compression

D              =              By Date

P              =              By Period

S              =              By Source Within Date

X              =              By Source Within Period

If you want no compression for this account's transactions, enter N for no compression.

If you desire all transactions for the accounts to be consolidated into a single transaction for each day, enter D, for date compres­sion.

If you desire all transactions for the account to be consolidated into a single transaction for each period, enter P, for period compression 

If you desire the identity of the source to be retained while still consolidating transactions by date, enter S for source‑ within‑date compression.

If you desire the identity of the source to be retained while still consolidating transactions by period, enter X for source‑within‑period compression.

11. Ratio Type

2 alphanumeric characters.  Ratios are a grouping together of a specific related set of accounts for generating Financial Ratios.

You Must enter one of the following ratio types.

For additional information refer to the Financial Ratio reports application.

Press F7 to search for an appropriate type.

C              =              Cash

CA           =              Other Current Assets

CL            =              Other Current Liabilities

CS           =              Cost Of Goods Sold

D              =              Depreciation

E              =              Property, Plant, Equipment

I               =              Inventory

N              =              No Ratio Type

OA           =              Other Non-current Asset

OE           =              Other Equity

OL           =              Other Non-current    Liability

P              =              Payables

R              =              Receivables

RE            =              Retained Earnings

S              =              Sales

ST           =              Common/Preferred Stock

If you do not want to define a ratio type, enter N to delineate No Ratio Type.

11. Inactive Account?

Y or N.      If you answer Y, the G/L Account will be flagged as inactive and will not show up in the F7 search window and will not allowed to be used throughout the system.  You can still pull up the account for maintenance (in this screen), in each sub module account maintenance (AR, AP, PR, IM & JC), GL Account Inquiry, Financial Entity Maintenance and in the report printing selection screen that prompts for an account number.

RETURN defaults to N.

Starting Main Account

A main account number in the standard account number format.  Enter the starting main account number of the range of accounts for which a new profit center or department will be created.

Pressing the RETURN key defaults to All accounts.

Ending Main Account

A main account number in the standard account number format.  Enter the ending account number of the range of accounts for which a new profit center or department will be created.

Starting Profit Center

A profit center number in the standard profit center format.

Enter the starting profit center number for the range to be copied from.  Default is to ALL profit centers.

Ending Profit Center

A profit center number in the standard profit center format.

Enter the ending profit center number for the range to be copied from.  Default is to the starting profit center.

Starting Department

A department number in the standard department number format.

Enter the starting department number for the range to be copied from.

Ending Department

A department number in the standard department number format.

Enter the ending department number for the range to be copied form.

Starting Profit Center

A profit center number in the standard profit center format.

Enter the starting profit center number for the range to be copied to. 

Ending Profit Center

A profit center number in the standard profit center format.

Enter the ending profit center number for the range to be copied to.

Starting Department

A department number in the standard department number format 

Enter the starting department number for the range to be copied to.

Ending Department

A department number in the standard department number format.

Enter the ending department number for the range to be copied to.

1.  Starting Account

An account number in the standard format.  The account number entered need not be a valid account on the G/L Account File.  It will still serve to define the begin­ning of the range for the printout.

Pressing the RETURN key defaults to All accounts.

2.  Ending Account

Same format as for the starting account number.  Pressing RETURN defaults to the same account as the starting account number entry.

3.  Financial Entity

5 alphanumeric characters.  Enter the financial entity you wish to see represented on the list of accounts, or press the RETURN key if you do not wish to show accounts belonging only to a single entity.  If a non‑blank value for this field is entered, the Entity file is checked to make sure that this entity has pre­viously been entered and defined.

4.  Profit Center

A standard profit center number in the standard profit center number format.  Enter the profit center you wish to see represented on the list of accounts or press the RETURN key to default to All profit centers.

Pressing the RETURN key defaults to All profit centers.  Entry of a single profit center or a single financial entity are mutually exclusive.  If you entered a non‑blank financial entity above, the entry of a profit cen­ter will be skipped.

5.Show Inactive Accounts Only ?

Y or N.      If you answer Y, the G/L Account File List will show only those accounts that have no transaction in the General Ledger Transaction file (the main Year‑to‑Date file).

RETURN defaults to N.

Starting Description

30 alphanumeric characters.  Enter the beginning of the range for the printout.

Pressing the RETURN key defaults to All accounts.

Ending Description

Same format as for the starting description.  Pressing RETURN defaults to the same description as the starting description entry.

Financial Entity

5 alphanumeric characters.  Enter the financial entity you wish to see represented on the list of accounts, or press the RETURN key if you do not wish to show accounts belonging only to a single entity.  If a non‑blank value for this field is entered, the Entity file is checked to make sure that this entity has pre­viously been entered and defined.

Profit Center

A standard profit center number in the standard profit center number format. Enter the profit center number you wish to see represented on the list of accounts or press the RETURN key to default to All profit centers.

Pressing the RETURN key defaults to All profit centers.  Entry of a single profit center or a single financial entity are mutually exclusive.  If you entered a non‑blank financial entity above, the entry of a profit cen­ter will be skipped.

Show Inactive Accounts Only ?

Y or N.  If you answer Y, the G/L Account File List will show only those accounts that have no transaction in the General Ledger Transaction file (the main Year‑to‑Date file).

RETURN defaults to N.

1.  Account No

An account number in the standard account number format.  Enter a valid account number on file in G/L Account File Maintenance application.

Press the F7 key for account search by number or the F8 key for account search by description.

2.  Description

30 alphanumeric characters.  The description is automatically displayed when an appropriate account number is entered. 

3.  Counter Bal Acct

An account number in the standard account number format.  If a counter balance number is on file it will be automatically displayed.

4.  Consolidation Acct

An account number in the standard account number format.  If a Consolidation Account is on file it will be automatically displayed 

This field displays the multi‑company consolidation account that this particular account will belong too.

5.  Auto Dist Code

4 numeric digits.  If an Auto Dist Code account is on file it will be automatically displayed.

6.  T/B Subtotal Level

1 numeric digit.  This field is automatically displayed.

T/B Subtotal Level

(continued)

In the G/L Account File, application The trial balance subtotal level allows the user to insert his own subtotals anywhere on the trial balance.  Up to nine levels of subtotaling are allowed.  (These subtotals are in addition to the subtotals generated automatically by the trial balance program each time the main account number changes.)

7.  Fin Statement Type

1 alphabetic character.  This field will display one of the following:

B              =              Balance Sheet

P              =              Profit and Loss (P&L)

The financial statement type defines the account as a Balance Sheet or P&L type account.  Asset, liability and equity accounts are identified as Balance Sheet accounts.  Revenue and expense accounts are identi­fied as P&L accounts.

8.  Saf Type

1 alphabetic character.  Every Balance Sheet account is categorized into one of six basic types in order to run source and application of funds reports.  This field may appear as blank or display one the following SAF Types:

1. C          =              Cash

2. N          =              Non‑cash charges against income (e.g., accumulated depreciation, allowance for bad debts)

3. A          =              Current assets (excluding cash)

4. L          =              Current liabilities

5. F          =              Cash flow (financing)

6. I           =              Cash flow (investing)

If your company desires to automatically generate the Statement Of Cash Flows and the Sources and Applica­tions of Funds Statements an SAF Type must be assigned to each Balance Sheet account in the G/L Account File Maintenance application.

9.  Paren Control Code

1 alphabetic character.  The parenthesis control code specifies whether the account is typically a debit or credit account.  On financial statements, non‑typical balances are enclosed in parentheses to set the balance off from the other balances shown on the statement.

This field will display an entry of D, or C for each postable account depending upon whether the account is typically debit or typically credit.

Paren Control Code

(continued)

Typically debit accounts would be all expense and asset accounts.  Typically credit accounts would be all revenue, liability and equity accounts.

1 alphabetic character.  Certain accounts may be coded with a parenthesis control code opposite from the account's typical balance so that the account's balance would appear within parentheses under normal circumstances.  (For instance, contra‑asset accounts such as accumulated depreciation could appear in the assets section of the Balance Sheet highlighted by parentheses.)

10.  Compression Code

1 alphabetic character.  This field displays one of the following:

N              =              No compression

D              =              Date compression

P              =              Period compression

S              =              Date compression within source

X              =              Period compression within source

This code is accessed by the Compress General Ledger Trx File application.  Refer to the Application Overview of that application for more information.  When the compression application is run, transactions for a given account will be consolidated into a single transaction for each day or each period or will not be consolidated at all depending on the entry for the compression code.

11. Ratio Type

Ratio Type (continued)

P              =              Payables

R              =              Receivables

RE            =              Retained Earnings

S              =              Sales

S              =              Common/Preferred Stock