Sage 100 ERP Demo of the General Ledger Tasks – View GL Reports, Module Options and Sage 100 Support Overview Information

Bisness Information Systems is a Sage Authorized Partner, Sage Reseller, Sage Certified onsultant, support and solution provider for the sage 100 erp general ledger module

Sage 100 ERP GL – General Ledger Demo & Overview

Introduction to Sage 100 ERP General Ledger Module

Sage 100 ERP Demo of the General Ledger Module Web Browser Edition – BIS Virtual Tour Navigator

This page includes overview information about each menu task in the General Ledger module that is accessible from the Sage 100 ERP main explorer menu and aided by an interactive virtual demo; Business Information Systems’ Virtual Tour Navigator. Clicking the thumbnails in each section opens the Sage 100 ERP virtual tour navigator. The clickable blue highlighted rectangles allows you to navigate to related screen panes in each General Ledger task in which you can experience what the Sage ERP accounting software suite is all about.

About Sage 100 ERP General Ledger Accounting Tasks

…about this..

sage 100 erp general ledger module features and benefits General Ledger Features & Benefits

for quetions and more information on the sage 100 erp general ledger module's features and benefits contact business information system a sage authorized partner reseller and software support providerQuestions? Contact BIS

For questions and more information on the Sage 100 ERP General Ledger module’s features and benefits, contact Business Information System – a Sage Authorized Partner, Reseller, Software Support, and Solution Provider.


Sage 100 ERP General Ledger Module Overview Support Information for the Main Menu Tasks

Details of Sage 100 General Ledger Main Menu

…about this…

sage 100 erp accounting software program general ledger main menu account maintenance taskGeneral Ledger Account Maintenance

The General Ledger Account Maintenance Task is used to create a new account number by entering a combination of existing main and subaccounts defined in Main Account Maintenance and Sub Account Maintenance.

sage 100 erp general ledger account maintenance task user options User Options

  1. Account Maintenance allows you to view and compare a combination of budgets and actual activity from any fiscal year, and maintain multiple budgets on an account-by-account basis by launching Budget Maintenance.
  2. You can also calculate variances for comparison between a particular fiscal year and budget activity, view summary activity for each account for a prior, current, or future fiscal year, and view transactions posted to an account. You can also print the Chart of Accounts from this screen.

click to view the sage 100 erp demo of the general ledger account maintenance task View the Sage 100 ERP Demo of the General Ledger Account Maintenance Task.

Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Account Maintenance Task.

sage 100 erp accounting software program general ledger main menu account inquiry taskGeneral Ledger Account Inquiry

The General Ledger Account Inquiry Task is used to view General Ledger Account Maintenance.

click to view the sage 100 erp demo of the general ledger account inquiry task View the Sage 100 ERP Demo of the General Ledger Inquiry Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Account Inquiry Task.

sage 100 erp accounting software program general ledger main menu allocation entry taskGeneral Ledger Allocation Entry

The General Ledger Allocation Entry is used to define and maintain allocation distributions from a source account to multiple destination accounts.

sage 100 erp general ledger allocation entry task user options User Options

  1. You can select percentage, quantity, or basis as the method of allocation. A basis method allows you to calculate distribution amounts based on the current activity, prior activity, beginning balance, ending balance, prior year activity, or budget of destination accounts.
  2. The basis calculation can also be linked to the current activity, prior activity, beginning balance, ending balance, prior year activity, or budget of another account.
  3. You can also select whether the allocation is to be posted manually using General Journal Entry, or if prompted, you can select to post allocations during period-end, quarter-end, or year-end processing.

sage 100 erp general ledger allocation entry task setup and integration optionsSetup & Integration Options

  1. Account masks provide more flexibility in assigning distribution accounts for allocation entries. You can use wildcard and template characters to specify account masks for destination accounts.

click to view the sage 100 erp demo of the general ledger allocation entry task View the Sage 100 ERP Demo of the General Ledger Allocation Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Allocation Entry Task.

sage 100 erp accounting software program customer relationship main menu general journal entry taskGeneral Ledger Journal Entry

The General Ledger General Journal Entry is used to enter and post journal entries that consist of details closely related to a single purpose, as well as adjustments and miscellaneous entries. If batch processing is enabled, you can enter journal entries in batches.

sage 100 erp general ledger journal entry task user options User Options

  1. You can create journal entries from existing standard journals or posted journals, and create multiple standard journals for each source journal.
  2. You can also allocate an amount from one account to another based on a predefined allocation.
  3. Any journal entered, but not yet updated, can be displayed and maintained when necessary.

sage 100 erp general ledger journal entry task setup and integration optionsSetup & Integration Options

  1. If the Track Deleted Journals check box is selected in the General Ledger Options window, deleted journals will display.
  2. If Batch Processing is enabled for General Journal Entry, the Batch Selection window appears. You can create a new batch or select an existing batch. A selection must be made before the General Journal Entry window is available.
  3. If other modules are integrated with the General Ledger module, daily postings from these sources are updated to the general ledger when the Daily Transaction Register is updated. For more information, see Daily Transaction Register.
  4. If other modules are not integrated with the General Ledger module, General Journal Entry is the primary window for entering and posting journal entries.

click to view the sage 100 erp demo of the general ledger journal entry task View the Sage 100 ERP Demo of the General Ledger Journal Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Journal Entry Task.

sage 100 erp accounting softwareprogram accounting and finance general ledger main menu general journal taskGeneral Ledger General Journal Pre-Update Register

The General Ledger General Journal is an accounting report register that is used to print the information after it has been entered or generated in the corresponding journal entry window and is used to review transactions prior to posting and updating the General Ledger.

Journal and registers provide a recap of transactions entered or generated in a data entry window or batch selection windows.

sage 100 erp general ledger important information prior to updating the journal to the genernal ledger Important Information

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals and registers, you are prompted to update which clears the file and updates the transactions to the general ledger and posts the transaction amounts to the corresponding G/L account.
  2. The Journal and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

click to view the sage 100 erp demo of the general ledger general journal pre-update register report task View the Sage 100 ERP Demo of the General Ledger General Journal Pre-Update Register Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger General Journal Pre-Update Register Report.

sage 100 erp accounting software program general ledger main menu recurring journal entry taskGeneral Ledger Recurring Journal Entry

General Ledger Recurring Journal Entry is used to enter journal entries of fixed amounts that repeat each period, such as depreciation and amortization.

sage 100 erp general ledger recurring journal entry task user options User Options

  1. You can create recurring journal entries by entering the accounts, amounts, and frequency that entries are posted.
  2. You can also select a group of recurring journal entries to post at one time.
  3. You can post journal entries to the general ledger by printing the Recurring Journal.

click to view the sage 100 erp demo of the general ledger recurring journal entry task View the Sage 100 ERP Demo of the General Ledger Recurring Journal Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Recurring Journal Entry Task.

sage 100 erp accounting software program general ledger main menu recurring journal taskGeneral Ledger Recurring Journal Pre-Update Register Report

The General Ledger Recurring Journal is an accounting report register that is used to print the information after it has been entered or generated in the corresponding journal entry window and is used to review transactions prior to posting and updating the General Ledger.

Journal and registers provide a recap of transactions entered or generated in a data entry window or batch selection windows.

important information prior to updating the journal to the general ledger Important Information

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals and registers, you are prompted to update which clears the file and updates the transactions to the general ledger and posts the transaction amounts to the corresponding G/L account.
  2. The Journal and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

click to view the sage 100 erp demo of the general ledger recurring journal pre-update register report task View the Sage 100 ERP Demo of the General Ledger Recurring Journal Pre-Update Register Report Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Recurring Journal Pre-Update Register Report Task.

sage 100 erp accounting software program general ledger main menu transaction journal entry taskGeneral Ledger Transaction Journal Entry

Transaction Journal Entry is used to for posting transactions such as cash disbursements, bank transfers, and cash receipts to general ledger accounts.

sage 100 erp general ledger transaction journal entry task user options User Options

  1. When accessing a journal task that has Batch Processing enabled, the Print Batch window appears automatically.
  2. Each journal entry distribution can reference a check number or other document number such as a deposit slip number or bank transfer number, a unique transaction date such as the check date, or a detail comment such as the customer name.
  3. Each line distribution can be posted to the general ledger account number entered. Offsetting posting to a cash account or other account number is performed automatically based on the account entered in the Offset Account Number field on the Transaction Journal Entry Header tab.

sage 100 erp general ledger transaction journal entry task setup and integration optionsSetup & Integration Options

  1. If Batch Processing is enabled for Transaction Journal Entry, the Batch Selection window appears. You can create a new batch or select an existing batch. A selection must be made to access the Transaction Journal Entry window.
  2. If the Bank Reconciliation module is integrated with General Ledger, all check, deposit, bank transfer, and adjustment transactions entered in Transaction Journal Entry are updated to the Bank Reconciliation module.

click to view the sage 100 erp demo of the general ledger transaction journal entry task View the Sage 100 ERP Demo of the General Ledger Transaction Journal Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Transaction Journal Entry Task.

sage 100 erp accounting software program general ledger main menu transaction journal taskGeneral Ledger Transaction Journal

The General Ledger Transaction Journal is an accounting report register that is used to print the information after it has been entered or generated in the corresponding journal entry window and is used to review transactions prior to posting and updating the General Ledger.

Journal and registers provide a recap of transactions entered or generated in a data entry window or batch selection windows.

sage 100 erp general ledger transaction journal task user options User Options

  1. You can use Print Batch to select all batches with the status of Available for printing or updating.
  2. The Select All button is available only for batches with a status other than Interrupted.
  3. Select the Refresh button to clear the Print check box and update totals or other changes made to the batch information.
  4. Review the journal or register for accuracy before updating.

sage 100 erp general ledger transaction journal pre-update register report task setup and integration optionsSetup & Integration Options

  1. Batch Processing is available if the Batch Processing check box is selected in the General Ledger Options window.
  2. This task is available only in some modules.

important information prior to updating the journal to the general ledger Important Information

  1. Printing the journals or registers does not automatically update to the general ledger. After you print the journals and registers, you are prompted to update which clears the file and updates the transactions to the general ledger and posts the transaction amounts to the corresponding G/L account.
  2. The Journal and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.

click to view the sage 100 erp demo of the general ledger transaction journal pre-update register report task View the Sage 100 ERP Demo of the General Ledger Transaction Journal Pre-Update Register Report Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Transaction Journal Pre-Update Register Report Task.

sage 100 erp accounting software program general ledger main menu daily transaction register taskGeneral Ledger Daily Transaction Register

The General Ledger Daily Transaction Register is use to update journal or register information entered in the corresponding data entry window to the general ledger. The journal and registers provide a recap of debit and credit transactions entered and/or generated in the (batch’s) selection window.

important information prior to updating the journal to the general ledger Important Information

  1. Printing the journal or register does not automatically update to the general ledger. After you print the journal or register, you are prompted to update it, which clears the transaction file and updates the information to the general ledger.
  2. The journal or register is printed by Document Date the document date will affect the grouping of data in the report if the document date for an transaction occurs in a different period or month other than what is entered in the the Posting Date Update field in the Register Update window.
  3. The Journal and/or Document Date should fall into the Current General Ledger fiscal or calendar year for which you are updating. Review the transaction register for accuracy before updating the the General Ledger.
  4. For more information, see Update FAQs.

click to view the sage 100 erp demo of the general ledger daily transaction register task View the Sage 100 ERP Demo of the General Ledger Dily Transaction Register Report Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Daily Transaction Register Report Task.

Sage 100 ERP General Ledger Module Overview Support Information for the Reports Menu Tasks

Details of Sage 100 General Ledger Reports Menu

…about this…

sage 100 erp accounting software program general ledger reports menu chart of accounts reportGeneral Ledger Chart of Accounts

The General Ledger Chart of Accounts Report is a complete listing of all accounts that comprise the general ledger.

sage 100 erp general ledger chart of accounts report user options User Options

  1. You can print the account type, cash flows type, account status, account group, account category, start date, end date, and clear balances.
  2. You can also print the rollup codes and rollup types associated with each account.
  3. These options can be printed for active accounts, inactive accounts, deleted accounts, or all accounts.
  4. You can enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, rollup codes, and user-defined fields to print. By entering these selections, you can obtain a listing of accounts that allows you to identify pertinent information.

click to view the sage 100 erp demo of the general ledger chart of accounts report View the Sage 100 ERP Demo of the General Ledger Chart of Accounts Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Chart of Account Report.

sage 100 erp accounting software program general ledger reports menu general ledger worksheet reportGeneral Ledger Worksheet

The General Ledger Worksheet is a tool for recording period-end and year-end adjustments to the general ledger. Before period-end processing is performed, manually enter adjustments to the general ledger on the General Ledger Worksheet and then in General Journal Entry. After entering adjustments, print the General Journal Register and update the General Journal to the general ledger.

General Ledger Worksheet Task User Options:

sage 100 erp general ledger worksheet report user options User Options

  1. You can print the General Ledger Worksheet by fiscal year and accounting period, define the line spacing, and determine whether to print account descriptions and accounts with a zero balance.
  2. You can also enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, rollup codes, and user-defined fields to print. By entering these selections, you can obtain a worksheet that allows you to make appropriate adjustments to the general ledger.

click to view the sage 100 erp demo of the general ledger worksheet report View the Sage 100 ERP Demo of the General Ledger Worksheet Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Worksheet Report.

sage 130 erp accounting software program general ledger reports menu general ledger trial balance reportGeneral Ledger Trial Balance

The General Ledger Trial Balance is a summarized listing of account activity for the accounting period. The beginning balance, summarized activity in the form of a debit or credit balance, and an ending balance are listed for each account in the chart of accounts.

sage 100 erp general ledger trial balance report user options User Options

  1. Accounts with a zero balance can also be included. You can print this report for a defined fiscal year or for a range of periods. When printing the Trial Balance over a range of periods, you can include the activity for each account for each period.
  2. You can enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, rollup codes, and user-defined fields to print by account activity.

sage 100 erp general ledger trial balance report setup and integration optionsSetup & Integration Options

  1. The General Ledger Trial Balance is commonly used to check the balances of all accounts in the general ledger. “Out of Balance” prints on the report when debit and credit amounts on the Report Total line do not match.

click to view the sage 100 erp demo of the general ledger trial balance report View the Sage 100 ERP Demo of the General Ledger Trial Balance Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Trial Balance Report.

sage 130 erp accounting software program general ledger reports menu financial reports reportGeneral Ledger Financial Reports

The General Ledger Financial Reports is used to select and define standard financial reports to print. Within each report group, you can define new financial reports using the Financial Reports Wizard.

sage 100 erp general ledger financial reports user options User Options

  1. You can drill down to view information about an individual report setting and a list of the groups it belongs to. By default, the Standard financial report group includes the Standard Income Statement, Standard Balance Sheet, and Standard Statement of Cash Flows reports. The Standard report group cannot be modified or deleted.

sage 100 erp general ledger financial reports setup and integration optionsSetup & Integration Options

  1. A report can be printed after it is defined in the Financial Reports Wizard.
  2. Use the Financial Reports Wizard to define settings for each financial report, and assign it to a report group. The report can be or based on an Income Statement, Balance Sheet, Quarterly Statement, Trend Report, or Statement of Cash Flows.
  3. You can also create and maintain groups using Financial Report Group Maintenance. Reports can be assigned to multiple groups, and a report can be listed more than once in a single group.

click to view the sage 100 erp demo of the general ledger report View the Sage 100 ERP Demo of the General Ledger Account Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Financial Reports.

sage 130 erp accounting software program general ledger reports menu general ledger detail reportGeneral Ledger Detail Report

The General Ledger Detail Report is an auditing tool that prints each account’s beginning balance, net postings, ending balance, postings by date, and reference numbers for the period. The balance of an account cannot be changed without the change being recorded on this report. You can also print a summarized version of the report.

sage 100 erp general ledger detail report user options User Options

  1. You can print the date and user logon associated with journal updates, and any comments entered for each journal.
  2. You can enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, source journals, journal and register numbers, posting comments, transaction amounts, rollup codes, and user-defined fields to print. By entering these selections, you can obtain a listing of journal postings that allows you to identify pertinent transactions.
  3. The General Ledger Detail Report can be printed at any time, but it should be printed immediately before period-end processing and prior to year-end processing as an audit tool.

click to view the sage 100 erp demo of the general ledger detail report View the Sage 100 ERP Demo of the General Ledger Detail Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Detail Report.

sage 130 erp accounting software program general ledger reports menu general ledger detail by source reportGeneral Ledger Detail by Source

The General Ledger Detail by Source provides a recap of general ledger transactions sorted by source journal and posting date. You can select to print journals posted in General Ledger, journals posted in other modules, or both. The account number, account description, and posting amount print for each account. A subtotal is provided for each source journal.

sage 100 erp general ledger detail by source journal report user options User Options

  1. You can select to print comments entered on the Lines tab in one of three formats.
  2. You can enter a selection of source journals, journal and register numbers, posting dates, and source modules to print. By entering these selections, you can obtain a listing of journal postings that allows you to identify pertinent transactions.

click to view the sage 100 erp demo of the general ledger detail by source report View the Sage 100 ERP Demo of the General Ledger Detail by Source Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Detail by Source Report.

sage 170 erp accounting software program general ledger reports menu exception reportGeneral Ledger Exception Report

The General Ledger Exception Report is used to provide a listing of accounts that meet certain criteria or exceptions for a selected period. The exceptions include debit accounts with a credit balance, credit accounts with a debit balance, inactive accounts that have transactions, deleted accounts that have transactions, accounts with specified ending balances, accounts for which changes exceed a specified amount or percentage, or accounts for which the variance between the budget and actual postings exceeds a specified amount or percentage.

sage 100 erp general ledger exception report user options User Options

  1. The report prints the account number, account description, and account category. You can print the report by fiscal year and accounting period.
  2. You can enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, rollup codes, and user-defined fields to print.
  3. By entering these selections, you can obtain a listing of exceptions that allows you to identify pertinent transactions.

click to view the sage 100 erp demo of the general ledger exception report View the Sage 100 ERP Demo of the General Ledger Exception Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Exception Report.

sage 170 erp accounting software program general ledger reports menu reprint journals reportGeneral Ledger Reprint Journals

Reprint Journals is used to reprint the original journals entered in General Journal Entry, Recurring Journal Entry, or Transaction Journal Entry. Each journal includes information entered on the Header and Lines tabs during original data entry.

sage 100 erp general ledger reprint journals reporting user options User Options

  1. You can enter a selection of source journals, journal and register numbers, and posting dates to print.
  2. By entering these selections, you can obtain a listing of journals that allows you to identify pertinent transactions.

click to view the sage 100 erp demo of the general ledger reprint journals report View the Sage 100 ERP Demo of the General Ledger Reprint Journals Reporting.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Reprint Journals Reporting.

sage 130 erp accounting software program general ledger reports menu source journal history reportGeneral Ledger Source Journal History Report

The General Ledger Source Journal History Report provides information on source journals updated from General Ledger and registers updated from subsidiary modules. The report prints the source journal, source journal description, source module from which the journal or register was updated, journal or register number, posting date, date of the update, user logon used for the update, and the amount.

sage 100 erp general ledger source journal history report user options User Options

  1. You can enter a selection of source journals, journal and register numbers, posting dates, and source modules to print.
  2. By entering these selections, you can obtain a listing of source journals that allows you to identify pertinent transactions.
  3. You can also print deleted journals. “Out of Balance” prints on the report when credit and debit amounts do not match.

click to view the sage 100 erp demo of the general ledger source journal history report View the Sage 100 ERP Demo of the General Ledger Source Journal History Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Source Journal Report.

sage 130 erp accounting software program general ledger reports menu general ledger graphics reportGeneral Ledger Graphics

General Ledger Graphics is used to view general ledger data in graphical form. Graphs can display the account summary, account detail, income, expense, or profit for the selected accounts.

sage 100 erp general ledger graphics report user options User Options

  • You can enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, rollup codes, and user-defined fields to graph.
  • By entering these selections, you can obtain a graph of account data that allows you to identify pertinent information.
  • You can select one of the following formats to graph your data:
    1. Two-dimensional bar.
    2. Two-dimensional column.
    3. Two-dimensional line.
    4. Two-dimensional area.
    5. Three-dimensional bar
    6. Three-dimensional column
    7. Three-dimensional line.
  • You can compare the activity or balance of the selected accounts in order to display changes over time or changes over a period. You can graph the actual figures or budget of the selected accounts for up to four fiscal years.
  • A sample graph in the General Ledger Graphics window allows you to preview your selections.

click to view the sage 100 erp demo of the general ledger graphics report View the Sage 100 ERP Demo of the General Ledger Graphics Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Graphics Report.

sage 130 erp accounting software program general ledger reports menu general ledger analysis reportGeneral Ledger Analysis

The General Ledger Analysis is used to produce a management report consisting of a summarized Income Statement and a Balance Sheet. The Income Statement lists company revenue, cost of sales, gross income, expenses, and net income. The Balance Sheet lists company assets, liabilities, and equity as of the date of the report. The Income Statement and Balance Sheet reflect the current period, prior period, and year to date, along with the percentage of change from the prior period and prior year to date.

sage 100 erp general ledger analysis report user options User Options

  1. The General Ledger Analysis provides a list of 13 important financial ratios, which provide a quick recap of your company’s financial condition. Financial ratios are calculated based on the account type information defined for each account.

click to view the sage 100 erp demo of the general ledger analysis report View the Sage 100 ERP Demo of the General Ledger Analysis Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Analysis Report.

sage 130 erp accounting software program general ledger reports menu budget and history reportGeneral Ledger Budget and History Report

The Budget and History Report is a detailed listing of selected current, revised, and user-defined budget information, and current and prior-year actual amounts for each accounting period.

sage 100 erp general ledger budget and history report user options User Options

  1. You can select up to five columns of information to print from any defined budget or actual postings for a fiscal year.
  2. You can also include the accounts for which actual postings and budgets for all periods of the fiscal year are zero. In addition, you can print only the totals for budgets, or only the ending balance for actual postings.
  3. You can enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, rollup codes, and user-defined fields to print.
  4. By entering these selections, you can obtain a listing that allows you to identify pertinent budget and posting information.

click to view the sage 100 erp demo of the general ledger budget and history report View the Sage 100 ERP Demo of the General Ledger Budget and History Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the Budget and History Report.

sage 130 erp accounting software program general ledger reports menu budget and history by period reportGeneral Ledger Budget and History by Period Report

Budget and History Report by Period is a detailed listing of selected current, revised, and user-defined budget information, and current and prior-year actual amounts for each accounting period.

sage 100 erp general ledger budget and history by period report user options User Options

  1. You can select up to 99 rows of information to print from any defined budget or actual postings for any defined fiscal year.
  2. You can also include, exclude, or print only actual postings and budgets with zero amounts for all periods. In addition, you can print only the totals for budgets, or only the ending balance for actual postings.
  3. You can enter a selection of account numbers, account descriptions, main accounts, defined segments, account group codes, rollup codes, and user-defined fields to print.
  4. By entering these selections, you can obtain a listing that allows you to identify pertinent budget and posting information.

click to view the sage 100 erp demo of the general ledger budget and history report by period View the Sage 100 ERP Demo of the General Ledger Budget & History by Period Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Budget and History by Period Report.

sage 130 erp accounting software program general ledger reports menu account audit reportGeneral Ledger Account Audit Report

Account Audit Report is used to audit any changes, deletions, or additions to accounts. This report prints changes to fields, changes made on the fly, and the date. If security is set up, the report also prints the user logon. If security is not set up, the report prints the workstation name.

sage 100 erp general ledger adit report user options User Options

  1. You can enter a range of user codes or workstation names and transaction dates to print.

sage 100 erp general ledger account audit setup and integration optionsSetup & Integration Options

  1. This report is available only if All, Deletions, Additions, or Changes is selected in the Account Changes to Track field in the General Ledger Options window.

click to view the sage 100 erp demo of the general ledger account audit report View the Sage 100 ERP Demo of the General Ledger Account Audit Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Account Audit Report.

sage 130 erp accounting software program general ledger reports menu account memo printing reportGeneral Ledger Account Memo Printing

Account Memo Printing is used to print a listing of all account memos created in the General Ledger module. The memo code, memo description, memo date, expiration date, reminder start and end dates, and auto display setting print on the report.

sage 100 erp general ledger account memo printing report user options User Options

  1. You can also print memo text and overridden auto display settings, and insert page breaks between memos.
  2. You can enter a selection of account numbers, memo codes, memo descriptions, memo dates, expiration dates, reminder start dates, and reminder end dates to print.
  3. By entering these selections, you can obtain a memo report that allows you to identify pertinent information.

click to view the sage 100 erp demo of the general ledger account memo printing report View the Sage 100 ERP Demo of the General Ledger Accouont Memo Printing Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Account Memo Printing Report.

sage 130 erp accounting software program general ledger reports menu main account memo printing reportGeneral Ledger Main Account Memo Printing

General Ledger Main Account Memo Printing is used to print a listing of all main account memos created in the General Ledger module. The memo code, memo description, memo date, expiration date, reminder start and end dates, and auto display setting print on the report.

sage 100 erp general ledger main account memo printing report user options User Options

  1. You can also print memo text and overridden auto display settings, and insert page breaks between memos.
  2. You can enter a selection of main accounts, memo codes, memo descriptions, memo dates, expiration dates, reminder start dates, and reminder end dates to print.
  3. By entering these selections, you can obtain a memo report that allows you to identify pertinent information.

click to view the sage 100 erp demo of the general ledger main account memo printing report View the Sage 100 ERP Demo of the General Ledger Main Account Memo Prnting Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Main Account Memo Printing Report.

Sage 100 ERP General Ledger Module Overview Support Information for the Budgets Menu Tasks

Details of Sage 100 General Ledger Budgets Menu

…about this…

sage 130 erp accounting software program general ledger budget menu budget maintenanceGeneral Ledger Budget Maintenance

The Budget Maintenance Task is used to view and compare any combination of budgets and actual activity from any fiscal year, and to maintain multiple budgets on an account-by-account basis.

sage 100 erp general ledger budget maintenace task user options User Options

  1. You can select multiple budgets to display such as your original budget and revised budget for the current fiscal year, your original budget from the past fiscal year, and the actual posting activity for the current fiscal year. While viewing these selected budgets and activity, you can manually edit budget amounts. You can also clear any budget column to zero.
  2. You can apply various change budget calculations that affect all budget amounts in a budget column. For example, you can use change budget calculations to automatically increase or decrease budget amounts by a cumulative or percentage.
  3. In addition, you can use the Calculate Budgets Wizard to revise a specific budget for the selected general ledger account in Budget Maintenance based on another source budget or activity.
  4. You can revise a budget by copying source budget or activity, or by adjusting the source budget or activity by a percent or an amount.

click to view the sage 100 erp demo of the general ledgerbudget maintenace task View the Sage 100 ERP Demo of the General Ledger Budget Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Budget Maintenance Task.

sage 130 erp accounting software program general ledger budget menu budget reportGeneral Ledger Budget Report

The Budget Report is used to to print any combination of original, revised, and user-defined budgets created in Budget Maintenance.

sage 100 erp general ledger budget report  user options User Options

  1. This report can be sorted based on account number or any defined account segment. In addition, you can select whether budgets with zero amounts and only totals for all periods print.
  2. The standard report shows the original and revised budget for the current fiscal year, and also the default budget defined in General Ledger Options, if the default budget is not the original or revised budget.
  3. This report is available for all or for a selected range of general ledger accounts. Selections can include ranges of account numbers, main accounts, other defined account segments, group codes, and rollup types.

click to view the sage 100 erp demo of the general ledger budget report View the Sage 100 ERP Demo of the General Ledger Budget Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Budget Report.

sage 130 erp accounting software program general ledger budget menu budget revision entryGeneral Ledger Budget Revision Entry

The Budget Revision Entry is use to revise to select the budget to revise based on another existing budget and to select additional options that determine how the budget revisions are calculated.

sage 100 erp general ledger budget revision task user options User Options

  1. Budget revisions can be calculated by entering a percentage or an amount that the original “based on” budget will be increased or decreased by. The percentage or amount entered is applied automatically to selected periods of the fiscal year for all or a selected range of accounts.
  2. Budget revisions can also be calculated by copying the budget information from the selected “based on” budget or by entering a replacement value to be copied to the budget being revised.
  3. Budget revisions can be calculated for all or for a selected range of general ledger accounts. Selections can include ranges of account numbers, main accounts, other defined account segments, group codes, and rollup codes.

click to view the sage 100 erp demo of the general ledger budget revision entry task View the Sage 100 ERP Demo of the General Ledger Budget Revison Entry Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Budget Revision Entry Task.

sage 130 erp accounting software program general ledger budget menu budget revision registerGeneral Ledger Budget Revision Register

The General Ledger Budget Revision Register is used to immediately print the register, preview the register, or click Setup to modify the default print parameters.

sage 100 erp general ledger budget revision register report user options User Options

  1. In any task window that allows you to print a register, change the selection criteria as needed and click the Print button. In the register dialog box that appears, click Print.

click to view the sage 100 erp demo of the general ledger budget revision register View the Sage 100 ERP Demo of the General Ledger Budget Revision Register Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Budget Revision Register Report.

sage 130 erp accounting software program general ledger budget menu automatic budget copyGeneral Ledger Automatic Budget Copy

The General Ledger Automatic Budget Copy is used to quickly determine figures for one budget by copying and changing information from another source budget.

sage 100 erp general ledger automatic budget copy task user options User Options

  1. The source budget figures can be copied, increased or decreased by either an amount or a percentage, or replaced with an entered value to the “copy to” budget.
  2. You can also copy budget figures for selected fiscal year periods. In addition, you can determine all or a selected range of general ledger accounts for copying budget figures. Selections can include ranges of account numbers, main accounts, divisions, departments, group codes, and rollup codes.

sage 100 erp general ledger automatic budget copy setup and integration optionsSetup & Integration Options

  1. Automatic Budget Copy updates budgets immediately.
  2. Unlike Budget Revision Entry, Automatic Budget Copy does not produce an audit trail for budget changes.

click to view the sage 100 erp demo of the general ledger automatic budget copy task View the Sage 100 ERP Demo of the General Ledger Automatic Budget Copy Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Automatic Budget Copy Task.

Sage 100 ERP General Ledger Period End Menu

Overview of General Ledger Period End Tasks

…about this…

sage 130 erp accounting software program general ledger period end menu allocation selectionGeneral Ledger Allocation Selection

General Ledger Allocation Selection is used to select allocation entries for posting before completing period-end or year-end processing. You can select the fiscal year, period, and posting date for the allocations to post. You can also enter separate source journals for financial and nonfinancial allocation postings

sage 100 erp general ledger allocation selection task user options User Options

  1. Allocation entries assigned to period-end cycles in Allocation Entry are selected at the end of each period.
  2. Entries with a quarterly cycle are selected at the end of periods 3, 6, 9, and the final period of the fiscal year.
  3. Entries with the annual cycle code are selected only at year end.

sage 100 erp general ledger allocation selection setup and integration optionsSetup & Integration Options

  1. Manual allocations must be selected using General Journal Entry on the Main menu.
  2. Allocations can only be posted to open periods.

click to view the sage 100 erp demo of the general ledger allocation selection task View the Sage 100 ERP Demo of the General Ledger Allocation Selection Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Allocation Selection Task.

sage 130 erp accounting software program general ledger period end menu allocation journalGeneral Ledger Allocation Journal

The General Ledger Allocation Journal is used to view and print a recap of transactions created and/or generated in a Allocation Selection entry window. After transactions have been generated or created, you have the option to update the general journal.

sage 100 erp general ledger allocation journal task importnt information Important Information

  1. The Allocation Journal Posting Date should fall into the Current General Ledger Period for which you are updating. Review the journal for accuracy before updating the General Journal.
  2. After you print the journal, you are prompted to update it, which clears the file and updates the information to the General Journal.
  3. Printing the journal does not automatically update transactions to the general ledger, use the Daily Transaction Register to update to the General Ledger.

click to view the sage 100 erp demo of the general ledger allocation journal task View the Sage 100 ERP Demo of the General Ledger Allocation Selection Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Allocation Journal Task.

sage 130 erp accounting software program general ledger period end menu period end report selectionGeneral Ledger Period End Report Selection

The General Ledger Period End Report Selection is used to select reports and financial report groups to print during period-end or year-end processing.

sage 100 erp general ledger period end report selection task user options User Options

  • You can print the default reports selected in the list, and select additional reports for printing. You can modify the number of copies to print and the printer to use on a report-by-report basis.
  • The reports can be printed and/or exported to Paperless Office, to Data Only, or to paper.
  • The selected reports can be printed in the Period End Report Selection window or in the Period End Reports window during period-end processing.
  • The General Ledger Period End Report Selection Group include:
    1. General Ledger Trial Balance Report.
    2. Financial Reports.
    3. General Ledger Analysis.
    4. General Ledger Detail Report.

sage 100 erp general ledger period end report selection setup and integration optionsSetup & Integration Options

  1. The reports and financial report groups displayed in the Period End Report Selection window must have already been defined.
  2. You can set up a predefined report setting for each report with options and selection criteria that are specifically used for period-end and year-end reporting purposes. For more information, see Create a Report Setting.
  3. In the General Ledger module, you can set up a financial report group in the Financial Report Group Maintenance window. For more information, see Create Financial Report Groups.
  4. This task is available only in some modules.

click to view the sage 100 erp demo of the general ledger period end report selection task View the Sage 100 ERP Demo of the General Ledger Period End Report Selection Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to Demo Sage 100 ERP General Ledger Period End Report Selection Task.

sage 130 erp accounting software program general ledger period end menu period end processingGeneral Ledger Period End Processing

General Ledger Period End Processing is used to automatically perform either period-end or year-end processing based on the period entered in the Current Period field in the General Ledger Options window.

sage 100 erp general ledger period end processing task user options User Options

  1. Period End Processing allows you to close the current period and cycle the accounting period forward to the next period. Period-end processing is usually performed at the end of each accounting period. Year-end processing takes place automatically when period-end processing is performed for the last period of the fiscal year.
The following occurs during General Ledger Period-End or Year-End Processing:
  1. Accounts with a Deleted status can be removed during year-end processing based on activity and the selection to Retain History in General Ledger Options.
  2. Any accounts with no activity are automatically removed.
  3. If the Copy Actual to Default Budget at Year End check box is selected in the General Ledger Options window, the actual amounts for the closed fiscal year are copied to the default budget for the current fiscal year.
  4. Options for resetting journal numbers are performed.
  5. If the Clear Balances check box in Main Account Maintenance is selected for a main account value, balances are cleared for nonfinancial accounts at year end.
  6. If retaining transaction history, all current year transaction information is updated and any transaction history with no current year activity is removed based on the number of Years to Retain History selected in General Ledger Options.
  7. If you have not already posted allocations before performing period-end processing, you are prompted to post them.
  8. If you have not already printed period-end reports, you can do so during period-end processing. You can also select and print period-end reports without accessing Period End Processing by using Period End Report Selection.

sage 100 erp general ledger period end processing setup and integration optionsSetup & Integration Options

  1. Fields in the General Ledger Options window are used to determine the Current Accounting Period and number of Years to Retain History after year-end processing.
  2. IMPORTANT: Backing up your data is an important part of your daily and monthly procedures. Back up all General Ledger data before proceeding.

click to view the sage 100 erp demo of the general ledger period end processing task View the Sage 100 ERP Demo of the General Ledger Period End Processing Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Period End Processing Task.

Sage 100 ERP General Ledger Module Overview Support Information for the Setup Menu Tasks

Details of Sage 100 General Ledger Setup Menu

…about this…

sage 130 erp accounting software program general ledger setup menu general ledger optionsGeneral Ledger Module Options

The General Ledger Options is used to present a series of options allowing you to maintain features most appropriate for your business. Some of these options are defined during new company setup using the General Ledger Setup Wizard, but can be further maintained in this window.

sage 100 erp general ledger module's options user options User Options

  1. The options defined in the General Ledger module have a significant effect on the operation of all other modules.

sage 100 erp general ledger module's options setup and integration optionsSetup & Integration Options

  1. For new companies, you can only access General Ledger Options after completing the General Ledger Setup Wizard.
  2. Only one user at a time can access General Ledger Options. The second user that accesses General Ledger Options will open an inquiry version where fields can only be viewed.

click to view the sage 100 erp demo of the general ledger module options taskView the Sage 100 ERP Demo of the General Ledger Module Options Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Options Task.

sage 130 erp accounting software program general ledger setup menu account structure maintenanceGeneral Ledger Account Structure Maintenance

General Ledger Account Structure Maintenance is used to maintain the account structure by creating account segments and entering the type, size, and description of account segments. Account segments are initially created during new company setup using the General Ledger Setup Wizard, but you can further maintain and create new account segments in this window. You can also maintain the separators used in the account number and account description.

sage 100 erp general ledger account structure maintenace task user options User Options

  1. When changing the account structure, under certain conditions the Account Structure Maintenance Change Wizard appears to assist you in making changes.
  2. When you change the account structure by changing an existing account segment’s size or by adding a new account segment, there is significant impact on the existing main or subaccount values for the changed segment and on existing general ledger accounts.

sage 100 erp general ledger account structure maintenance task setup important informationImportant Information

  1. Before changing the account structure, make sure you understand the rules for creating and maintaining account segments. For more information, see General Ledger Account FAQs.
  2. For new companies, you can only access Account Structure Maintenance after completing the General Ledger Setup Wizard.
  3. Only one user at a time can access Account Structure Maintenance. The second user that accesses Account Structure Maintenance will open an inquiry version in which fields can only be viewed.

click to view the sage 100 erp demo of the general ledger account structure maintenance task View the Sage 100 ERP Demo of the General Ledger Account Structure Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Account Structure Maintenance Task.

sage 130 erp accounting software program general ledger setup menu account group maintenanceGeneral Ledger Account Group Maintenance

General Ledger Account Group Maintenance is used 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.

sage 100 erp general ledger account group maintenance task user options User Options

  • 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 Account Group Category, which defines a collection of accounts of the same type. Account Group Categories are predefined in the General Ledger module and include the following types:
  • For example the Account Group Catagories Include:
    1. Assets.
    2. Liabilities.
    3. Equity.
    4. Revenue.
    5. Cost of Sales.
    6. Expenses.
    7. Other income and expense.
    8. Income Tax.
    9. Non-Financials.
  • and the Asset Account Group Type would include:
    1. Cash.
    2. Net A/R.
    3. Other Receivable.
    4. Inventory.
    5. Prepaid Expenses.
    6. Other Asset.

sage 100 erp general ledger account group maintenance important informationImportant Information

  1. The Account Group and Account Type 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.
  2. For new companies, you can only access Account Group Maintenance after completing the General Ledger Setup Wizard.
  3. Only one user at a time can access Account Group Maintenance. The second user that accesses Account Group Maintenance will open an inquiry version in which fields can only be viewed.

click to view the sage 100 erp demo of the general ledger account group maintenance taskView the Sage 100 ERP Demo of the General Ledger Account Group Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Account Group Maintenance Task.

sage 130 erp accounting software program general ledger setup menu main account maintenanceGeneral Ledger Main Account Maintenance

The Main Account Maintenance Task is used to create and maintain main accounts. The main account is always the first segment in an account, and its size is defined in Account Structure Maintenance. Main accounts are used as the basis for creating a chart of accounts. The combination of a main account and subaccounts creates a general ledger account.

sage 100 erp general ledger account maintenance task user options User Options

  1. Main Account Maintenance allows you to select whether the main account is active, inactive, or deleted.
  2. You can also define start and end dates for the main account which determine when postings to accounts created using the main account can occur.
  3. Rollup codes can be assigned to the main account. Rollup codes are user-defined fields that allow you to group accounts for the purpose of reporting on user-defined classifications without changing the structure of the general ledger account itself.
  4. The options selected for the main account are used as the defaults when creating new accounts based on the main account.

sage 100 erp general ledger main account maintenance setup and integration optionsSetup & Integration Options

  1. For new companies, you can only access Main Account Maintenance after completing the General Ledger Setup Wizard.

click to view the sage 100 erp demo of the general ledger main account maintenance taskView the Sage 100 ERP Demo of the General Ledger Main Account Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Main Account Maintenance Task.

sage 130 erp accounting software program general ledger setup menu sub account maintenanceGeneral Ledger Sub Account Maintenance

Generl Ledger Sub Account Maintenance is used to create and maintain subaccounts for each of the account segments (except the main account segment) defined in Account Structure Maintenance. The main account is always the first segment, and segments 2-10 are used for subaccounts. Subaccounts represent different values within a segment and along with the main account are the basic building blocks of the general ledger account. The combination of a main account and subaccounts creates a general ledger account.

sage 100 erp general ledger sub account maintenance task user options User Options

  1. You can enter a short description for the subaccount that is used as part of the account description, and you can select whether or not you want the subaccount to print on financial reports.
  2. You can also select whether the subaccount is active, inactive, or deleted.
  3. You can optionally define start and end dates for the subaccount that determine when postings to accounts created using the subaccount can occur.

sage 100 erp general ledger sub account maintenance setup and integration optionsSetup & Integration Options

  1. For new companies, you can only access Sub Account Maintenance after completing the General Ledger Setup Wizard.

Sage 100 ERP Interactive ScreenShots of General Ledger Sub Account Maintenance Task:

click to view the sage 100 erp demo of the general ledger sub account maintenance taskView the Sage 100 ERP Demo of the General Ledger Sub Account Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Sub Account Maintenance Task.

sage 130 erp accounting software program general ledger setup menu fiscal year maintenanceGeneral Ledger Fiscal Year Maintenance

The General Ledger Fiscal Year Maintenance Task is use to maintain a number of periods and period-end dates for the current fiscal year and for as many past and future years as needed. The current fiscal year is initially set up during new company setup using the General Ledger Setup Wizard, but you can further maintain the current fiscal year and an unlimited number of future fiscal years in this window.

sage 100 erp general ledger fiscal year maintenance task user options User Options

  • Balance and history information is recalculated depending on the changes made to the fiscal year record:
  • If you change an existing year to have fewer periods, the periods are removed and the first period of the subsequent year is recalculated.
  • If you change a period end date, the recalculation is performed for the two periods that are impacted.
  • If you change the period ending date of the last period, that period and the first period of the next year is recalculated.
  • If you delete a year, the records for the selected year are deleted, and the first period in the next valid year is recalculated.
  • If you add a year, beginning balances and records are created for the new year being added.

sage 100 erp general ledger fiscal year setup and integration optionsSetup & Integration Options

  • An item’s history by period information is only recalculated if Fiscal is selected in the Base Inventory Periods on field in Inventory Management Options.
  • An item’s information on the History tab in Customer Maintenance, Vendor Maintenance, and Salesperson Maintenance is not recalculated.
  • When the Recalculate button is clicked, the item’s history information in the following tasks and reports are affected:
    1. Miscellaneous Item Maintenance.
    2. Item Maintenance.
    3. Inventory Detail Transaction Report.
    4. Item Listing with Sales History.
    5. Inventory Turnover Report.
    6. Inventory Valuation Report by Period.
    7. Miscellaneous Item History by Period.
    8. Miscellaneous Item Listing.
  • The Sales Order recaps will impact the following four reports:
    1. Sales Recap by Product Line.
    2. Sales Recap by Warehouse.
    3. Sales Recap by Warehouse by Product Line.
    4. Sales Recap by Division.
  • The General Ledger posting history by period impacts the following areas and reports:
    1. Account Maintenance History tab.
    2. Budget Maintenance Activity.
    3. General Ledger Worksheet.
    4. General Ledger Trial Balance.
    5. Financial Reports.
    6. General Ledger Detail Reports.
    7. Exception Report.
    8. General Ledger Graphics.
    9. General Ledger Analysis.
    10. Budget and History Report.
    11. Budget and History Report by Period.
  • For new companies, you can only access Fiscal Year Maintenance after completing the General Ledger Setup Wizard.
  • Only one user at a time can access Fiscal Year Maintenance. The second user that accesses this window will open an inquiry version.

click to view the sage 100 erp demo of the general ledger fiscal year maintenance taskView the Sage 100 ERP Demo of the General Ledger Fiscal Year Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Fiscal Year Maintenance Task.

sage 130 erp accounting software program general ledger setup menu source journal maintenanceGeneral Ledger Source Journal Maintenance

Source Journal Maintenance is used to create and maintain source journals and to view source journal history. Each source journal is identified by a source journal code during journal entry, and each module register that posts to the General Ledger module uses a unique source journal code to identify its transactions. In addition, each source journal code is assigned a register number and journal entry number used to identify the register and journal posting to the General Ledger module.

sage 100 erp general ledger source journal maintenance task user options User Options

  1. Source journal history tracks information updated from the General Ledger module and all other modules that update to the General Ledger module using the Daily Transaction Register.
  2. You can also drill down into a source journal to view detailed postings for the journal and/or register.

sage 100 erp general ledger source journal maintenance task setup and integration optionsSetup & Integration Options

  1. Source journals are automatically created when journals are updated from other modules and the required source journal does not exist.
  2. You can add source journals on-the-fly from General Journal Entry, Recurring Journal Entry, and Transaction Journal Entry.
  3. Journal and register entries that are out of balance are indicated by an asterisk (*).

click to view the sage 100 erp demo of the general ledger source journal maintenance taskView the Sage 100 ERP Demo of the General Ledger Source Journal Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Source Journal Maintenance Task.

sage 130 erp accounting software program general ledger setup menu rollup code maintenanceGeneral Ledger Rollup Code Maintenance

General Ledger Rollup Code Maintenance is used to create and maintain rollup codes and to assign the codes to Rollup Types defined in the General Ledger Options window.

sage 100 erp general ledger rollup code maintenance task user options User Options

  1. Rollup codes are user-defined fields that allow you to group accounts for the purpose of reporting on user-defined classifications without changing the structure of the general ledger account itself.
  2. You can print a listing of rollup codes.

sage 100 erp general ledger rollup code maintenance task setup and integration optionsSetup & Integration Options

  1. Only one user can access Rollup Code Maintenance at a time. The second user that accesses this window will open an inquiry window.

click to view the sage 100 erp demo of the general ledger rollup code maintenance taskView the Sage 100 ERP Demo of the General Ledger Rollup Code Maintenance Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Rollup Code Maintenance Task.

sage 130 erp accounting software program general ledger setup menu memo manager maintenanceGeneral Ledger Memo Manager Maintenance

Memo Manager Maintenance is used to view, maintain, and manage memos system-wide.

sage 100 erp general ledger memo manager maintenance task user options User Options

  1. You can define where memos can be displayed or maintained within the software. You can also specify a default setting for the automatic display of memos when accessing certain tasks.
  2. Multiple types of memos can be defined per module.

sage 100 erp general ledger memo manager maintenance task setup and integration optionsSetup & Integration Options

  1. The auto-display settings defined in Memo Manager Maintenance for the Default role can be overridden for individual memos in Override Auto Display Settings. After a memo is created, any changes made to the auto-display settings for a memo type do not affect the existing memo.
  2. Memos for modules not listed in the Memo Manager Maintenance window in the Module field are maintained in their applicable modules’ Memo Maintenance window.

click to view the sage 100 erp demo of the general ledger memo manager maintenance task View the Sage 100 ERP Demo of the General Ledger Memo Manager Maintenace Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Memo Manager Maintenance Task.

Sage 100 ERP General Ledger Module Overview Support Information for the Utilities Menu Tasks

Details of Sage 100 General Ledger Utilities Menu

…about this…

sage 130 erp accounting software program general ledger utilities menu general ledger exchangeGeneral Ledger Exchange

General ledger Exchange is use to import account, budget, and transaction information from external source files into the General Ledger module, and export information from the General Ledger module to external source files.

sage 100 erp general ledger exchnage utility user options User Options

  1. Before importing information, you can print a Test Import Listing to display the records that will be imported.
  2. After importing, you can print the Import Log, which displays the imported records, as well as records excluded during the import.

sage 100 erp general ledger exchange utility setup and integration optionsSetup & Integration Options

  1. The General Ledger Exchange window appears only if exchange settings have been defined in the General Ledger Exchange Settings Wizard. Otherwise, the Exchange Wizard appears. This window displays a list of defined exchange settings.
  2. An exchange setting must be defined to perform an exchange.
  3. An exchange setting contains selected options for importing and exporting information so that future exchanges can be performed using the same exchange criteria.

click to view the sage 100 erp demo of the general ledger exchange task View the Sage 100 ERP Demo of the General Ledger Exchange Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Exchange Task.

sage 130 erp accounting software program general ledger utilities menu delete accountsGeneral Ledger Delete Accounts

General Ledger Delete Accounts is used to delete accounts from the system. Accounts can be selected by account number, main account, or subaccount.

sage 100 erp general ledger delete accounts utility user options User Options

  1. Accounts with activity or budget data are marked as deleted and removed during year-end processing based on activity and the selection in the Years to Retain General Ledger History field in the General Ledger Options window.
  2. Accounts with no activity or budget data are immediately deleted.
  3. You can print or preview the Delete Accounts Listing before deleting selected accounts.
  4. You can also print a Deletion Log after accounts have been deleted.

sage 100 erp general ledger delete accounts utility setup and integration optionsSetup & Integration Options

  1. The Retained Earnings account cannot be deleted.
  2. Main accounts are only deleted in Main Account Maintenance and sub accounts are only deleted in Sub Account Maintenance.

click to view the sage 100 erp demo of the general ledger delete accounts utility View the Sage 100 ERP Demo of the General Ledger Delete Accounts Utility .

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Delete Accounts Uitlity.

sage 130 erp accounting software program general ledger utilities menu change accountsGeneral Ledger Change Accounts

The General Ledger Change Accounts is used to change an account or to merge or renumber a range of accounts, main accounts, or subaccounts.

sage 100 erp general ledger change accounts utility user options User Options

  1. When changing a subaccount, you must determine the segment that will be affected by the change. You can also change the description of the accounts affected by the change.
  2. You can print the Change Accounts Listing to preview the accounts and ranges that will be affected by the changes, and print a Change Accounts Log after the process is completed.

sage 100 erp general ledger change accounts utility setup and integration optionsSetup & Integration Options

  1. The Retained Earnings account cannot be changed.

click to view the sage 100 erp demo of the general ledger change accounts utility View the Sage 100 ERP Demo of the General Ledger Change Accounts Utility.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Change Accounts Utility.

sage 130 erp accounting software program general ledger utilities menu recalculate account balancesGeneral Ledger Recalculate Account Balances

The General Ledger Recalculate Account Balances is used to recalculate account balances for all fiscal years and to validate the beginning balance period for all accounts.

sage 100 erp general ledger recalculate account balances utility user options User Options

  1. Because detail transaction history and period posting history are closely related, Recalculate Account Balances can be used to recalculate and realign account balances based on transaction data, if for example, the period posting history table becomes damaged.

sage 100 erp general ledger recalculate account blances utility setup and integration optionsSetup & Integration Options

  1. Account Balances will be recalculated for all fiscal years based on transaction date
  2. The process will take several minutes depending on the size of data tables.
  3. IMPORTANT: Recalculating account balances may affect the beginning balance, debits, credits, and ending balances as displayed on the Account Maintenance History tab or various General Ledger reports. It may also affect activity displayed on the Budget Maintenance window.

click to view the sage 100 erp demo of the general ledger recalculate account balances utility View the Sage 100 ERP Demo of the General Ledger Recalculate Account Balances Utility .

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to Demo Sage 100 ERP General Ledger Recalculate Account Balances Utility.

sage 130 erp accounting software program general ledger utilities menu generate accountsGeneral Ledger Generate Accounts

The Generate Accounts Task is used to create new accounts based on existing main accounts and subaccounts.

sage 100 erp general ledger generate accounts utility user options User Options

  1. You can generate up to 100,000 new accounts using the main accounts and segments entered.
  2. Only new accounts are generated.
  3. Generated accounts inherit their default settings based upon the account and subaccount values for each segment.
  4. For each new account, a default description is created that combines all segment short descriptions, separated by the characters defined in Account Structure Maintenance.

click to view the sage 100 erp demo of the general ledger generate accounts utility View the Sage 100 ERP Demo of the General Ledger Generate Accounts Utility .

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Generate Accounts Utility.

sage 130 erp accounting software program general ledger utilities menu purge general ledger historyGeneral Ledger Purge General Ledger History

Purge General Ledger History is used to remove history for any fiscal year, up to, but not including the current fiscal year or future fiscal years.

sage 100 erp general ledger purge general ledger history utility user options User Options

  1. Purging history is useful for storage performance and when your hard disk is nearing its storage capacity limit.

click to view the sage 100 erp demo of the general ledger purge general ledger history utility View the Sage 100 ERP Demo of the General Ledger Purge General Ledger History Utility .

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Purge General Ledger History Utility.

Sage 100 ERP General Ledger Module Overview Support Information for Crystal Reports Custom Reports

Details of Sage 100 General Ledger Custom Reports Menu

…about this…how to…

sage 130 erp accounting software program general ledger custom reports menu createCustom Reports

Use Custom Reports to build custom Crystal Reports.

click to view the sage 100 erp demo of the general ledger crystal reports custom reportsView the Sage 100 ERP Demo of the General Ledger Crystal Reports Custom Reports.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Crystal Reports Custom Reports.

Sage 100 ERP General Ledger Module Overview Support Information for the Sage Payroll Services Menu Tasks

Details of Sage 100 General Ledger Sage Payroll Services Menu

…about this…

sage 130 erp accounting software program general ledger payroll service menu payroll optionsGeneral Ledger Sage Payroll Services Options

The General Ledger Payroll Services Options is used to select the source journal to use when transactions from the Sage Payroll Services Web application are downloaded into General Ledger Transaction Journal Entry. You can also select whether to post transactions to the Bank Reconciliation module.

sage 100 erp general ledger payroll service options services setup and integration optionsSetup & Integration Options

  1. The Bank Reconciliation module can only be integrated with Sage Payroll Services if the Integrate with Bank Reconciliation check box is selected in General Ledger Options.

click to view the sage 100 erp demo of the general ledger sage payroll services options taskView the Sage 100 ERP Demo of the General Ledger Sage Payroll Services Options Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Payroll Services Options Task.

sage 130 erp accounting software program general ledger payroll service menu payroll services gl account selectionPayroll Services GL Account Selections

The General Ledger Payroll Services GL Account Selection is used to select which general ledger accounts are available for use in the Sage Payroll Services Web application. You can select individual accounts or ranges of accounts. If the Bank Reconciliation module is integrated with Sage Payroll Services, you can also select which Bank Codes are used with Sage Payroll Services.

sage 100 erp general ledger payroll service options services general account selection setup and integration optionsSetup & Integration Options

  1. The accounts and bank codes you select are uploaded to Sage Payroll Services during the synchronization process. Any changes to accounts and bank codes since the last synchronization are automatically uploaded to Sage Payroll Services.
  2. Accounts with an Inactive or Deleted status are not uploaded to Sage Payroll Services during synchronization.
  3. Be sure to select all the accounts you will need to have available when using Sage Payroll Services.
  4. Required accounts include:
    1. Taxes Withheld.
    2. Taxes Payable.
    3. Wage Expense.
    4. Employer Tax Expense.
    5. Employer Benefit Expense Accounts.
  5. Only one user at a time can access Sage Payroll Services Account Selection.
  6. The second user that accesses Sage Payroll Services Account Selection will open an inquiry version in which fields can only be viewed.

click to view the sage 100 erp demo of the general ledger sage payroll services general ledger account selection task View the Sage 100 ERP Demo of the General Ledger Payroll Services General Ledger Account Selection Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Sage Payroll Services General Ledger Account Selection Task.

sage 130 erp accounting software program general ledger payroll service menu payroll services synchronization wizardPayroll Services Synchronization Wizard

Payroll Services Synchronization Wizard is use to help with the synchronization of data between the accounting records and Sage Payroll Services online.

sage 100 erp general ledger payroll services  synchronization wizard setup and integration optionsSetup & Integration Options

  1. During each synchronization, a updated listing of the valid general ledger accounts is transfered to Sage Payroll Services.
  2. In return, Sage Payroll Services sendsnew general ledger transactions to the accounting system.
  3. To use this function you must have a company enrolled in Sage Payroll Services.
  4. For more information see Using Sage Payroll Services.

click to view the sage 100 erp demo of the general ledger payroll services synchronization wizard View the Sage 100 ERP Demo of the General Ledger Sage Payroll Services Synchronization Wizard.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Sage Payroll Services Synchronization Wizard.

sage 130 erp accounting software program general ledger payroll service menu sage payroll services activity logSage Payroll Services Activity Log

The Sage Payroll Services Activity Log is used to view a recap of Sage Payroll Services synchronization activity and account selection activity.

sage 100 erp general ledger payroll service activity log report setup and integration optionsSetup & Integration Options

  1. You can enter a selection of activity dates and activity descriptions to print.
  2. You can print the report for either synchronization activity or account selection activity, or for both.
  3. If synchronization activity is selected, the report prints all synchronization information contained in the synchronization log, including details of the success or failure of each step in the most recent synchronization process.
  4. If account selection activity is selected, the report prints detail information for the accounts selected using Sage Payroll Services Account Selection.

click to view the sage 100 erp demo of the general ledger payroll services activity log report View the Sage 100 ERP Demo of the General Ledger Sage Payroll Services Activity Log Report.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Sage Payroll Services Activity Log Report.

sage 130 erp accounting software program general ledger payroll service menu purge sage payroll activity logPurge Sage Payroll Activity Log

The General Ledger Purge Sage Payroll Services Activity Log is used to remove activity records from the Sage Payroll Services Activity Log file. All activity log entries dated on or before the date specified are removed.

click to view the sage 100 erp demo of the general ledger payroll services purge sage payroll activity log task View the Sage 100 ERP Demo of the General Ledger Sage Payroll Services Purge Sage Payroll Activity Log Task.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Sage Payroll Services Purge Sage Payroll Activity Log Task.

Sage 100 ERP General Ledger Module Overview Support Information for the Business Insights Explore Task

Details of Sage 100 General Ledger Business Insights Explore Menu

The Sage 100 ERP Business Insights Explorer Views are predifined data table relationships provide for you to navigate through a module’s data, and preview and drill into related information for a selected row to follow the transactions from beginning to end. Business Insights Explorer provides predefined views of Geeneral Ledger commonly used sets of data, such as; the Account View, Account Transactions View, and Account Budgets View. Explorer Views can be exported to a variety of output types, including Microsoft Excel, Microsoft Access, Microsoft Word, XML, and Web pages.

sage 130 erp accounting software program general ledger explore menu account veiwBusiness Insights Explore General Ledger Account View

Use Account View to navigate through data and explore row data details by drilling-down into the transaction details. The data can be exported to a variety of output types, including Microsoft Excel, Microsoft Access, Microsoft Word, XML, and Web pages.

Business Insights Explorer Account View User Options:
  1. You can use the Navigation pane to explore data related to the selected view. The Navigation pane is located to the left of the main Data View grid in the Business Insights Explorer window.
  2. Data in the Data View grid can be filtered, sorted, grouped, and summarized.
  3. You can also modify the columns in the grid by showing and hiding columns, changing the column order, changing the column names, and formatting the data that appears in the columns.
  4. Changes to the Data View grid can be saved to a setting. The information in the Data View grid can also be printed and saved to a report.

click to view the sage 100 erp demo of the general ledger business insights explore general ledger account viewView the Sage 100 ERP Demo of the General Ledger Business Insights Explore General Ledger Account View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Business Insights Explore General Ledger Account View.

sage 130 erp accounting software program general ledger explore menu account transactions veiwBusiness Insights Explore General Ledger Account Transactions View

Use Account Transactions View to navigate through data and explore row data details by drilling-down into the transaction details. The data can be exported to a variety of output types, including Microsoft Excel, Microsoft Access, Microsoft Word, XML, and Web pages.

Business Insights Explorer Account Transactions View User Options:
  1. You can use the Navigation pane to explore data related to the selected view. The Navigation pane is located to the left of the main Data View grid in the Business Insights Explorer window.
  2. Data in the Data View grid can be filtered, sorted, grouped, and summarized.
  3. You can also modify the columns in the grid by showing and hiding columns, changing the column order, changing the column names, and formatting the data that appears in the columns.
  4. Changes to the Data View grid can be saved to a setting. The information in the Data View grid can also be printed and saved to a report.

click to view the sage 100 erp demo of the general ledger business insights explore general ledger account transactions viewView the Sage 100 ERP Demo of the General Ledger Business Insights Explore General Ledger Account Transactions View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Business Insights Explore General Ledger Account Transactions View.

sage 130 erp accounting software program general ledger explore menu account budgets veiwBusiness Inights Explore General Ledger Account Budgets View

Use Account Budgets View to

Use Account Budgets View to navigate through data and explore row data details by drilling-down into the transaction details. The data can be exported to a variety of output types, including Microsoft Excel, Microsoft Access, Microsoft Word, XML, and Web pages.

Business Insights Explorer Account Budgets View User Options:
  1. You can use the Navigation pane to explore data related to the selected view. The Navigation pane is located to the left of the main Data View grid in the Business Insights Explorer window.
  2. Data in the Data View grid can be filtered, sorted, grouped, and summarized.
  3. You can also modify the columns in the grid by showing and hiding columns, changing the column order, changing the column names, and formatting the data that appears in the columns.
  4. Changes to the Data View grid can be saved to a setting. The information in the Data View grid can also be printed and saved to a report.

click to view the sage 100 erp demo of the general ledger business insights explore general ledger account budgets viewView the Sage 100 ERP Demo of the General Ledger Business Insights Explore General Ledger Account Budgets View.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Business Insights Explore General Ledger Account Budgets View.

Sage 100 ERP General Ledger Module Overview Support Information for the Visual Process Flows Task

Details of Sage 100 General Ledger Visual Process Flows Menu

…about this…how to…

sage 130 erp accounting software program general ledger custom process flows menu createGeneral Ledger Visual Process Flows

Create General Ledger Custom Process Flows.

click to view the sage 100 erp demo of the general ledger visual process flows custom process flowsView the Sage 100 ERP Demo of the General Ledger Visual Process Flows.

Sorry your browser does not support HTML5 Canvas.Sorry your browser does not support HTML5 Canvas.
Click to View the Sage 100 ERP Demo of the General Ledger Visual Process Flows.

Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities. All other trademarks are property of their respective owners.