General Ledger – R12

Overview – General Ledger

The CMiC Enterprise General Ledger (GL) is one of the key financial modules within the system. The General Ledger module not only maintains companies, departments, and accounts, it is fully integrated with the Job Costing, Accounts Payable, Accounts Receivable, and System Data modules to improve efficiency, and to ensure timely and accurate reporting in all modules.

Functionality

The General Ledger is the Master set of accounts which summarize all transactions occurring within the company. Features of this module include:

  • Set up unlimited number of companies.

  • Create and maintain departments, accounts, and budgets.

  • Process opening balances as well as period and year end procedures.

  • Create and allocate cost pools.

  • Create chart codes, business units, company groups, and journal names.

  • Organize account structure.

  • Define General Ledger period dates.

  • Allocate transaction codes and values.

  • Enter General Ledger transactions, accruals, and recurring entries.

  • Allocate interest and bank transfers.

  • Use logs for displaying account balances, period activity, and transaction detail information.

  • Query for account activity, transaction, and activity information.

  • Create financial documents.

  • Run various reports for account and department activity.

  • Reconcile bank account transactions.

  • Recalculate balances.

  • Reinstate posting reports.

Integration

The General Ledger module is integrated with the following modules:

  • Job Costing (JC) – Transaction entry

  • Accounts Payable (AP) and Accounts Receivable (AR) – Reconcile checks, vouchers, and invoices

  • Journal Maintenance – Transaction entry

  • System Data (SD) – Assign company security and maintain user extensions, weight measures (WM), and banking information

Setup Considerations

Prior to initially setting up the GL module, consult with a CMiC consultant to discuss and plan what is required for the implementation of the module.

Below is a short checklist of items that need to be considered before starting to use/setup the General Ledger module:

  • Will the organization be using business units?

  • Will the organization be using consolidation codes?

  • How many tiers of security clearance is required for the organization?

  • How many different weight measures (WM) and currency codes will be required?

  • Will the organization be using transaction allocation codes?

  • Will a foreign exchange (FX) account be required?

  • Are import templates required for sub-ledgers and opening balances?