G.L. Trial Balance Report

The General Ledger Trial Balance report lists debit, credit and balance totals for specified General Ledger accounts for a final period.

This report includes totals for selected periods, year to date and future periods. Or it can be run as a detailed Trial Balance.

Users can report in base currency or foreign currency.

When the report is output to to View, PDF or CSV file the information available within the generated report is the:

  • Period
  • Currency
  • Branch
  • Department
  • Account
  • Description
  • Debit
  • Credit
  • Balance
  • YTD Credit
  • YTD Balance
  • Future Debit
  • Future Credit
  • Future Balance

The report can be generated with the following parameters:

  • Show Details or Totals
  • Report Currency (Base, Branch or Foreign Currency)
  • Skip Nil Balances (Yes or No)
  • Show Future Balances (Yes or No)
  • Consolidate Currencies in Base Currency (Yes or No)
Example Trial Balance Report

Generate a General Ledger Trial Balance

  1. From the Home menu, select .
    1. Click the Reports menu to expand it:

    2. Click the Financial Reports menu option to expand it:

    3. Click GL Trial Balance to go to the GL Trial Balance parameters screen:

  2. On the blank GL Trial Balance Parameters screen, the Balance Tab will open. Select the required parameters for the GL Trial Balance Report.
  3. Check the completed screens.
  4. Click on the Other Tab. Select how the results are to be ordered and filtered in the report from the drop down selections or check boxes available.
  5. Select how the report is to be displayed.
    1. To view the report, click .

    2. To Download the report to a PDF file, click .

    3. To Download the report to a CSV file, click .

    4. To print from NX, click .

About GL Trail Balance Parameters

Balance Tab

Period From and To - General Ledger Posting Period Range.

Account Code From and To - Transaction General Ledger Account.

Branch - Multi select Transaction GL Branch check boxes.

Department - Multi select Transaction GL Department check boxes.

Currency - Multi select GL Transaction Currency check boxes.

Other Tab

Report Order By- GL Trial Balance Parameters allow the two order by options:

  • Branch, Department (system default)
  • Account

Detailed or Totals - Selection of detailed or totals only.

Report Currency - Selection of Base, Branch or Foreign currencies can be selected. (Defaults to Base).

Skip Nil Balances - Check box (default is checked).

Show Future Balances - Check box (default is checked).

Consolidate Currencies in Base - Check box to consolidate currencies in base currency. (Default un-checked).