Contents

Trial Balance

Caroline Buckland Updated by Caroline Buckland

The process

A trial balance is a list of all the general ledger accounts contained in Financials. This list will contain the name of each nominal account and the value of that nominal balance. Each nominal account will hold either a debit balance or a credit balance. The goal is to confirm that the sum of all debits equals the sum of all credits and identify whether any entries have been recorded in the wrong account.

There are several places to access a trial balance in Advanced Financials, read below to understand each.

  • Account Details
  • Trial Balance CSV report
  • Advanced Reporting tool

Financials Trial Balance options

1. Trial Balance - Account Details

Main Menu > General Ledger > GL Enquiries > Account Details

An on-line Trial Balance enquiry is available relating to the groups and categories defined for the company. To get a full company Trial Balance use the Account Details enquiry. If you enter % in the Nominal selection field, you will get a full unfiltered list of all nominal codes.

The current period and year will default, but this can changed from the Calendar/Results format

A default layout will also be used, this will display a list of balance information. There are several Layout codes to use within Financials. You can use the PROMPT action to retrieve a more appropriate code if necessary.

Example of the layout codes.

You can use the Edit: VIEW button to see what information is behind each code.

Use the EXIT button to return back to the list, then use the RETURN button to return the correct layout code to the selection window.

Select the Search button.

The Balances screen displays a list of nominal balances depending on the criteria you select.

The data can be exported to excel by using the download icon.

2. Trial Balance CSV Report

A Trial Balance report is available from the General Ledger Enquiries menu.

Access the following menu:

General Ledger>GL Enquiries>Trial Balance Report

Access the Lines tab and enter the following parameters

  • Company
  • Period From and Period To
  • Year
  • Currency
  • Nominal From / TO – leave this blank to run against all nominals
  • CVS Required – Y will create a CSV file available from the Files Management area
  • CSV Account Heading Y/N - displays the GL account headings

Select Submit.

Followed by Submit again.

The report can be found in the Files Management area of My Workplace and as a text file on the spool.

Select the Download button to retrieve the report.

Example Report

3. Trial Balance - Reporting

Access the Reporting tile from MyWorkplace.

Access the Repository from the View drop down menu.

Select you company followed by General Ledger > Sample Reports > Ad Hoc views and Reports

A lists of sample reports will be retrieved in the right hand panel. Select the Trial Balance hyper link.

There are several filters you can change to focus the report output as required:

You can take a copy, amend the fields and filters, and create a similar report that meets your requirements. Return back to the Sample report list and use the Copy action.

Sample report below.

Was this article useful?

Enquiries Account Details

GL Enquiries - Balance Sheet & Profit and Loss

Contact