Running a Trial Balance (GL291)

Use this program to generate a trial balance for your company. You can select one of the following currency options for your trial balance:

Note: To track and balance transactions by transaction currency, you must select Yes in Currency Ledger field onCompany (GL10.1).

  • Base currency only

  • Report currency one only

  • Report currency two only

  • Base currency, report currency one, and report currency two

  • One transaction currency

Follow these steps to generate a trial balance:

  1. Access Trial Balance (GL291).

    Use these guidelines to specify the field values:

    Company / Company Group

    You must select a company or company group. You cannot select both.

    Accounting Units

    You can select up to six accounting units to report on. If you leave these fields blank, then the report includes all accounting units for the company or company group.

    Note: If you select accounting units and a company group, then all the accounting units must be valid for all the companies in the company group.
    Year Code / Year / Period

    • You can select a year code to report on the current, last, or next year. If you select a year code, then the Year field must be blank.

    • If you do not select a year code, then you must specify a year in the Year field.

    • If the year code or year is not the current period, then you must specify the period for the report. If the year code is Next Year, then the period must be 1. If the year code or year is current, then the current period becomes the default value, but can be overridden.

  2. Use the Individual Reporting form tab to select the reporting level. You can run a trial balance for the company you selected and each level within the company. If you leave the level fields blank, then the company consolidation level becomes the default value.
  3. Use the Report Options form tab to select your currency options.

    Use these guidelines to specify the field values:

    Type

    Select A (Amount) to balance by amounts; U (Unit) to balance by units. Select A for currency reports.

    Suppress Zero Accounts

    Select Yes if you want to report only on the accounts that have amounts in them and leave zero accounts out of the report.

    Report Sequence

    Select L (Level) to sort the report by level. Select A (Accounting Unit) to sort the report by accounting unit.

    Report Currency

    Select B (Base) to report in base currency alone; 1 (One) to report in report currency one alone; 2 (Two) to report in report currency two alone; A (All) to generate three reports (base, currency one, and currency 2); and None to report on units, or to report on a transaction currency selected in the Trans Currency field.

    Trans Currency

    Select the transaction currency for which you want to generate a trial balance. If you select a currency in this field, then you should select None in the Report Currency field.

Sample Trial Balance (Transaction Currency)

GL291 - Date 06/13/00                        Company 4321 - LGE Corporation        FRF        Tran Currency   Page    1
        Time 16:23                           Trial Balance                                        Amounts
                                             For Period  1 Ending January 31, 1999            Fiscal Year 1999

Company

Account Nbr Description                      Beginning Balance     Debit Activity       Credit Activity    Ending Balance
----------- ------------------------------ --------------------   --------------------  ----------------  ---------------
 11300-0000 [BS] Cash - Other                              0.00        633.33                                      633.33
 12400-0000 [BS] Unrealized Gain on Curren                 0.00         20.00                                       20.00
 16000-0000 [BS] Prepaid Expense                           0.00                             120.00                 120.00-
 21200-0000 [BS] Accounts Payable                          0.00                             110.00                 110.00-
 41900-0000 [IS] Sales - Other                             0.00                             633.33                 633.33-
 51300-0000 [IS] Vacation & Sick Time                      0.00        100.00               100.00                   0.00
 61000-0000 [IS] Gas & Electric                            0.00         70.00                                       70.00
 80700-0000 [IS] Repairs & Maintenance                     0.00         20.00                                       20.00
 80900-0000 [IS] Travel & Entertainment                    0.00        120.00                                      120.00

*** Totals                                                 0.00        963.33                963.33                  0.00