Features Added in General Ledger 5.5

Sage ERP Accpac General Ledger 6.0

Features Added in General Ledger 5.5

The following points summarize the new or changed features in General Ledger 5.5:

  • We introduced the most sophisticated treatment of currency revaluation on the market.

    With this version, exchange gains and losses are treated as permanent or temporary, depending on the exchange Gain/Loss Accounting Method specified for your Sage ERP Accpac system in the company profile.

    Under the Recognized Gain/Loss accounting method, fluctuations in exchange rates are considered to be permanent. Exchange gains and losses are recognized when foreign currency monetary items are revalued or settled using the exchange rate in effect.

    The Revaluation process:

    • Calculates new functional-currency values for each specified source currency using the specified exchange rates.

    • Creates a batch with revaluation transactions that will adjust the original functional-currency values to new functional-currency values for the specified account(s).

    • Uses posting dates to select open documents for revaluation, so that revaluation adjustments are posted to G/L accounts in the correct fiscal year/period.

    Note that exchange gains and losses are included in the determination of net income for the current period. They appear on the income statement, and they are taxable immediately. They are not automatically reversed in the next fiscal period.

    When you select the Recognized Gain/Loss method, new labels for G/L account fields appear on the G/L Revaluation form, as follows:

    • Unrealized Exchange Gain Account changes to Exchange Gain Account.

    • Unrealized Exchange Loss Account changes to Exchange Loss Account.

    Note that to revalue a G/L account, you must assign revaluation codes for each currency used in the account.

    • Before upgrading to version 5.5, or later, from an earlier version, you should process and post your revaluation batches prior to upgrading General Ledger. You cannot activate General Ledger if you have unprocessed revaluation transactions.

    • If you decide to switch to the Recognized Gain/Loss accounting method, later, you should post any batches you created under the Unrealized and Realized Gain/Loss accounting method.

    For steps for changing the accounting method, see Switch the Accounting Method for Foreign Currency Translation.

  • With this version, we increased the number of segments, account structures, budgets, and years of history you can keep:

 

Sage ERP Accpac 100

Sage ERP Accpac 200

Sage ERP Accpac 500

Account Segments

up to 3 account segments

up to 4 account segments

no change

Account Structures

up to 3 account structures

up to 4 account structures

no change

Budgets

up to 2 budgets

up to 3 budgets

no change

Years of history

keep 7 years of history

keep 7 years of history

no change

  • Sage ERP Accpac 100 lets you define custom account groups. This feature was previously supported in the 200 and 500 editions only.

  • You do not need a separate license for G/L Security. Since version 5.5, it is installed with General Ledger and is activated when you activate General Ledger. (To use G/L Security, select the Use G/L Security option on the Account tab of G/L Options, then close and reopen your company database. You can then use the Account Permissions icon, which becomes available in the G/L Accounts folder, to assign permissions.)

  • If you use Sage ERP Accpac 500 ERP, you can designate an account as a rollup account to which you can add member accounts. You can create multiple levels of account relationships.

You can print rollup information for certain reports, and you can use rollup features in Financial Reporter. You can also view rollup amounts in several inquiry forms.

  • Chart of Accounts

  • The Rollup Accounts report is an additional selection in the Report Format field on the Chart of Accounts report; it displays all rollup accounts and their directly-related rollup member accounts.

  • The Rollup Accounts/Rollup Accounts report on the Chart of Accounts report displays the member accounts only if it has parent rollup accounts.

  • The Fiscal Set Comparison Report has an option to include rolled up amounts.

  • Transactions Listing report

  • Trial Balance report

  • Rollup commands in FRAMT, FRAMTA, FRDEBIT, FRCREDIT. The rollup command has a prefix of R (for example, FRAMT("RBALP").

  • New consolidation switch: RD (for rollup account detail) to show only the top-level rollup accounts within the selected range.

For instructions on creating rollup accounts, see To add a rollup account.

  • Sixteen new FR reports are available.

Balance Sheet summaries

  • Balsum01.xls: a summary of the balance sheet as amounts and as a percentage of total assets/liabilities, printed on separate pages.

  • Balsum02.xls: summary of the balance sheet as amounts and as a percentage of total assets/liabilities, with a graph on a separate page.

  • Balsum03.xls: summary of the balance sheet for the period specified.

  • Balsum04.xls: summary of the balance sheet for the current and previous years.

  • Balsum05.xls: summary of the actual and budgeted balance sheet for the current year.

See Financial Reports for further information about these new reports.

Financial Analysis statements

  • Finratio01.xls: financial ratios for the current period, grouped into five main categories.

  • Finratio02.xls: financial ratios of the company and financial ratios of an average company in the same industry (benchmarks), and variances between those ratios.

  • Finratio03.xls: financial ratios of the company, compares them with benchmarks, and displays the results in graphical format.

  • Finratio04.xls: financial ratios of the company for the current and previous years, and variances between them.

  • Finratio05.xls: financial ratios of the company for the current and previous years, and benchmarks, displayed in graphical format.

See Financial Reports for further information about these new reports.

Forecasting

  • Forecast.xls: allows users to create forecasts and to perform what-if analyses, with a summary of the income statement and balance sheet for the current and previous years.

See Financial Reports for further information about this report.

Income Statement summaries

  • Incsum01.xls: summary of the income statement as amounts, and, on separate pages, displays all amounts as a percentage of sales reveneue.

  • Incsum02.xls: summary of the income statement in the regular format (as amounts), displaying percentages of total revenue in graphical format.

  • Incsum03.xls: summary of the income statement for a specified period.

  • Incsum04.xls: summary of the income statement for current and previous years.

  • Incsum05.xls: summary of the actual and budgeted income statement for the current year.

See Financial Reports for further information about these new reports.

  • We have also enchanced multi-user entry and posting.

    • Batches are not allowed to be posted if it is being edited by someone or if data is being poured into it (import, generation).

    • Batches can be posted concurrently.

    • Multiple users can now enter entries in the same batch. If both of them add the same entry at the same time, the program will attempt to assign the other entry to a different one.

  • Create Recurring Entries Batch has been enhanced to include options for creating the recurring entries in a new batch or appending to an existing batch.

  • Dashboard security permission lets you customize the dashboard Web site. If you have access to G/L Dashboard, you can access any dashboard pages that are based on data stored in General Ledger. See the System Manager online help for information about using dashboards.

See also