Contents
Trial Balance
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
Advanced 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
• 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
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.
