General Ledger

Flexible and Easy to Implement

The adaptable design of the Sage 100 ERP (formerly Sage ERP MAS 90 and 200) General Ledger module allows you to use your current chart of accounts or create a new chart of account structure from over a dozen industry-specific selections, making implementation quick and easy. General Ledger uses our exclusive dual grid entry for quick, efficient, and accurate data entry. The grid entry format allows you to easily customize the data entry screens. Once you have created a transaction, it’s easy to delete a row, move a row up or down, or change a value. You can also use the built-in calculator to easily modify it, or even reset a row or all rows by using the reset feature.

Valuable Business Insights

Ease of use combined with the powerful attributes of the General Ledger module streamlines all bookkeeping and accounting transactions, and the resulting reports provide important business insights. Sage 100 ERP General Ledger offers virtually unlimited financial reporting capabilities. In addition to the standard General Ledger reports, Sage 100 ERP provides the ability to create financial statements such as Income Statements, Cash Flow Statement, Balance Sheet, and Trend reports. All financial reports are created and modified through an easy-to-use wizard so you can simply select formatting options to create a report specific to your business needs. Gaining quick and accurate insight into your business is critical to maintain your competitive edge. Sage 100 ERP General Ledger provides a key method for you to stay on top of your financial information.


Using General Ledger, you can quickly access information in a dual grid format—this example shows information for a payroll account, under the transactions tab, displaying details in the top grid and subtotals in the lower grid.

Features

Flexible Chart of Accounts Structure
Create an account structure to fit your business needs with up to 32 characters and ten segments. Or choose from over a dozen industry-specific charts of accounts.

Account Status
Each general ledger account can be assigned a status—active, inactive, or deleted. Accounts that have an inactive or deleted status prevent you from inadvertently posting to them.

Start/End Dates
Assign starting and ending dates to main or subaccounts to maintain additional control over your chart of accounts structure.

Roll-Up Codes
Create up to four roll-up types and unlimited roll-up codes for additional reporting flexibility outside your chart of accounts.

Budgets
Maintain an unlimited number of budgets. Edit multiple budgets and accounts simultaneously.

Batch Entry
Create public or private batches in General Journal Entry and Transaction Journal Entry for more control over to your general ledger.

Flexible Accounting Periods
Provides up to 13 user-defined accounting periods in each fiscal year. You can specify ending dates for each period.

Transaction Detail Drill Down
Display detailed transactions for an account at any time, and search for transactions by period, source journal inquiry, or comment.

Multiyear History Retention
Retain up to 99 years of transaction history and period summary history. Post to an unlimited number of future fiscal years, or reopen a past year and specify the fiscal year to be used for printing general ledger reports.

Nonfinancial Accounts
Maintain nonfinancial information such as head count, square footage, unit sales, and inventory quantity. Include nonfinancial information on financial reports and in allocation calculations.

Allocation Entries
Automatically post an amount from a single-source account to multiple destination accounts. Calculate the amount to be posted to each of the destination accounts based on a percentage allocation, a quantity (such as headcount or square footage), or based on a value from another destination account.

Financial Statements
Income Statements, Balance Sheet Statements, Cash Flow Statements, and Trend reports can be produced automatically with the easy-to-use Financial Reporting wizard. Include actual budget, budget variance, and prior-year information on standard period-to-date and year-to-date income statements. Select the type of data to be printed for each column. Round dollar amounts, print dollar signs, add, delete, or copy footnotes are just a few of the options for formatting financial statements. Supports values up to $99,999,999,999.99.

Business Intelligence
Business Intelligence empowers you to quickly and easily use the familiar look of Microsoft Excel® to analyze and interpret Sage 100 ERP data. Effortlessly create real-time, automated, and preformatted reports with up-to-date, accurate, and meaningful information.

Account Masterfile Audit
Audit changes, deletions, or additions to the account masterfile using the Account Masterfile Audit report.

Delete Accounts/Change Accounts
Easily delete or change account numbers without having to manually renumber each entry.

One-Step Bank Transfers
Transfer funds between banks in one, easy transaction journal entry when integrated with the Bank Reconciliation module.

Reports

Many robust General Ledger reports are included with your Sage 100 ERP system, and settings can be saved by user. General Ledger reports include:

  • General Ledger Worksheet
  • General Ledger Trial Balance
  • General Ledger Detail Report
  • General Ledger Detail by Source Report
  • Exception Report
  • Reprint Journals
  • Source Journal History Report
  • General Ledger Graphics
  • Budget and History Report
  • Account Audit Report
  • Account Memo Printing

In addition to the Standard General Ledger, Sage 100 ERP includes a powerful Financial Report Wizard enabling you to create additional reports such as:

  • Trend Reports
  • Income Statements
  • Balance Sheets
  • Statement of Cash Flow Reports

Establish Report Groups to easily identify your specific report settings.

General Ledger