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.

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 Selection window and Extended selection window.

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

Example of the layout codes.

You can use the VIEW icon to see what information is behind each code.

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

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 action.

Trial Balance CSV Report

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

Access the following menu:

General Ledger>GL Enquiries>Trial Balance Report

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 Headings? Y/N - enter a Y for the account headings to be displayed on the report.

Click on 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

Trial Balance - Advanced Reporting

Access the Reporting tile from MyWorkplace.

Access the Repository from the View drop down menu.

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?

GL Enquiries - Account Details

Contact