Acute Data Systems

How to create or change a General Ledger Account Group in Sage 100

Module: Sage 100 General Ledger

Resolution

Use Account Group Maintenance to create and maintain groups of main accounts. Default account groups with predetermined group code ranges are initially created during new company setup using the General Ledger Setup Wizard, but you can further maintain these account groups and also create new account groups. You can create either numeric or alphanumeric account groups. A numeric account group applies to all main account numbers between the beginning number of the account group to, but not including, the beginning number of the next account group.

Each account group is assigned a category, which defines a collection of accounts of the same type. Account categories are predefined in the General Ledger module and include the following types: assets, liabilities, equity, revenue, cost of sales, expenses, other income and expense, income tax, and non-financial. Each category also includes a set of predefined account types and cash flow types that you can select to further define the group. This information determines how each account is handled for reports, subtotals, and the year-end balance, and the account group description is used as a heading on various reports, such as the Trial Balance and Financial Reports.

Important Notes

  • The information you enter for an account group determines how each account is handled for reports, subtotals, and the year-end balances.
  • When printing financial reports, a subtotal is printed for each account group within each account category. Alpha account groups print in alphabetical order within each account category, and numeric account groups print in ascending numeric order within each account category. When creating account group codes, keep this information in mind to make sure that account groups within each account category print in the order you want on financial reports.

Add a New Account Group

  1. Open General Ledger, Setup, Account Group Maintenance
  2. On the last line type the new Account Group Code and Description, then select appropriate Account Type and Account Category, Cash Flow Type is optional. 
    • Example: If you want accounts starting with 550 to be included in this group by default type 550 as the Account Group Code
  3. Click Accept

Change an Account Group assigned to existing Main Account

If you have accounts that need to be changed to show/be sub-totaled on your financial reports in different account group, do the following:

  1. Open General Ledger, Setup, Main Account Maintenance
  2. Select applicable Main Account from look up
  3. Select applicable Account Group from look up
  4. Click Accept

Reminder: Accounts can only be changed if they are within the same account types:

  • Assets, Equity, or Liabilities
  • Revenue, Operating Expenses, Cost of Sales, Income tax or Other income and expense
  • Non-financial.
Sage 100
Request Support