Sage 300 – General Ledger

General Ledger

The General Ledger module is the foundation of your accounting system, with flexibility that meets the current and future financial management requirements of organizations of all types and sizes. It provides a robust feature set designed to handle your most demanding budgeting and processing needs. General Ledger fully integrates with all modules and is the key to maximizing the efficiency and accuracy of your financial data.

General Ledger Capabilities

  • Create alphanumeric account numbers as long as 45 characters.
  • Create Summary level accounts to group posting accounts.
  • Flag General Ledger accounts as inactive to stop using them, but retain them in the system for historical and reporting purposes.
  • Maintain separate periods for adjusting and closing entries.
  • Assign different retained earnings accounts to different account segments.
  • Set up and schedule recurring journal entries for transactions that are processed on a regular basis.
  • Drill down to the originating journal entry and transaction from transaction history.
  • Lock budgets to prevent unauthorized changes.
  • Limit the batches shown in the Batch List window to only those from a single sub-ledger.
  • Automatically create budgets using prior year information or choose from seven other computation methods.
  • Create analytical reports, spreadsheets, graphs, and charts, and update budgets automatically through full integration with Microsoft® Excel.
  • Produce fast, flexible, customized financial statements through full integration with Microsoft® Excel.
  • Print consolidated statements or statements for any accounting division represented by an account number segment code.
  • Auto-reverse entries to eliminate manual accrual tracking and specify the period for the reversal.
  • Reverse a posted transaction.
  • Drill down from a journal entry to the originating transaction.

Account Code Change

Included with the General Ledger module, Account Code Change provides a simple way to quickly and easily change, combine, or copy your important business data. Efficiently replace outdated information with a few keystrokes to remain current with elements critical to your business. Account Code Change also includes the ability to modify segment delimiters and the account segment length.

  • Ease system management by deleting, maintaining, and renumbering your GL account numbers.
  • Import multiple changes, copy, and combine from one external file.
  • Access multiple change features with the easy-to-use toolbar buttons.
  • Use Change by Example to make multiple changes from one example entry.
  • Works with General Ledger, GL Security, Accounts Receivable, Accounts Payable, Inventory Control, Order Entry, Purchase Orders, Project and Job Costing, Common Services.

G/L Security

Included with the General Ledger module, the G/L Security module enables organizations to control which users can view or use certain general ledger accounts based on segment validation in G/L Security settings.

  • Control access to any account in your general ledger by segment. This allows you to limit user activity to a prescribed set of accounts, blocking sensitive or confidential accounts from being seen or changed.
  • Tailor access to accounts for each Sage 300 (Accpac) user or group of users.
  • Set access rights for single or multi-segment validation or for single or multiple account validation.
  • Restrict users from viewing batches containing accounts from which they are prohibited.
  • Restrict users to adding accounts only to segments to which they have access.
  • Add or remove user restrictions at any time in response to staffing changes, changes to your account structure, or as security concerns arise.
  • Restrict financial reports only to valid accounts

    Standard Reports

    • Batch Listing
    • Batch Status
    • Chart of Accounts
    • Comparative Balance Sheets
    • General Ledger Options
    • General Ledger Transactions Listing
    • Income Statements
    • Posting Journals
    • Trial Balance

    Your General Ledger is the foundation of your accounting system

    Sage 300 General Ledger is the foundation of your accounting system. Its built-in flexibility meets both the current and future financial needs of organizations of all types and sizes. It provides a robust feature set designed to meet even the most demanding budgeting and processing needs. You can customize General Ledger by using the many tools inherent in the system, including a built-in financial report writer that provides you with a timely picture of your company’s fiscal activities. General Ledger fully integrates with all Sage 300 modules and is the key to maximizing the efficiency and accuracy of your financial data. Advantage Series also runs through a standard Web browser, so you can design and view financial statements – anytime, anywhere – using an Internet browser.

    Highlights

    • Flexible account structure

    • Powerful budgeting capabilities

    • Extensive comparative and historical data

    • Financial reporting

    • Multi-currency support using the Multi-currency module

    • Ability to drill down to originating transaction in other modules

    • Integrates with Microsoft® Office

    • Pure Web-based or traditional desktop interface

    Flexible Account Structure and Account Processing

    • Create alphanumeric account numbers as long as 45 characters.

    • Use segments to represent cost centres, departments and divisions.

    • Flag general ledger accounts as inactive to stop using them but retain them in the system for historical and reporting purposes.

    • Tailor your processing needs through high-level control over transaction entry, subledger batch editing, listing and posting.

    • Post transactions provisionally to the general ledger to see the effect on financial statements.

    • Post transactions to any past year for which you maintain data.

    • Consolidate transactions for selected accounts during posting, or consolidate on an as-needed basis.

    • Enter transactions from an Internet browser.

    • Allocate an account balance to multiple accounts using specified percentages.

    • Maintain separate periods for adjusting and closing entries.

    • Assign different retained earnings accounts to different account segments.

    • Post transactions from multiple subledgers to a single control account.

    • Drill down to the originating journal entry and transaction from transaction history.

    • Set up and schedule recurring journal entries for transactions that you process on a regular basis.

    • Drill down from unposted transactions to originating subledger transactions.

    • Use the Reminder List capabilities in System Manager to remind staff to process recurring entries.

    • Maintain quantities for each General Ledger account.

    Powerful Budgeting Features

    • Store different sets of budget figures to project future needs and compare projections.

    • Lock periods to prevent unauthorized changes.

    • Automatically create budgets using prior-year information, or choose from seven other computation methods.

    Integration with Microsoft Office

    • Create analytical reports, graphs and charts in Microsoft Excel using information from General Ledger.

    • Update budgets automatically from Microsoft Excel.

    • Create spreadsheets in Microsoft Excel showing actuals, budgeted and variance.

    Powerful, Customisable Financial Reporting

    • Integrate powerful financial diagnostic and strategic analysis tools with Sage Intelligence (BI).

    • Use the flexibility of Microsoft Excel and the Sage 300 Financial Reporter to produce financial statements.

    • Print consolidated statements, or print statements for any accounting division represented by an account number segment code.

    • Run provisional reports for a financial snapshot prior to posting.

    • Create a separate worksheet for each code in a specific segment to view financial information specific to each segment code.

    • Produce monthly, quarterly, semi-annual and annual comparative statements with any number of columns.

    • Send financial statements via e-mail.

    • Print financial statements by running Advantage Series on the company intranet or using the Internet from any company location.

    Multi-currency Support Using the Multi-currency Module

    • Enter, import and post transactions in all the currencies you use. General Ledger maintains functional currency balances as well as balances of all other account currencies.

    • Automatically revalue selected accounts as exchange rates fluctuate.

    • Use an unlimited number of currencies for each General Ledger account.

    Data Entry Made Easy

    • Specify non-monetary amounts in journal entries such as square feet and number of employees.

    • Auto-reverse entries to eliminate manual tracking of accruals.

    • Use the advanced macro facility to automate repetitive procedures such as batch processing, month-end processing and printing reports.

    • Use the segment validation tables to reduce data entry errors.