Trial Balance
The Trial Balance is a report showing all individual Account balances. It is mostly used for reconciliation. You cannot alter the definition of the Trial Balance report, but you can determine which Transactions are to be included.
When printed to screen, the Trial Balance has the HansaWorld Enterprise Drill-down feature. Click on the Account Number of any Account in the report to open the Nominal Ledger Report for the same Account and period. When in the Nominal Ledger report, you can click on any Transaction Number to open an individual Transaction record.
The totals of the three columns in the report should each be zero, signifying that in your accounts the total debits and the total credits are equal. If this is not the case, there may be an error in one or more of your Transactions that should be corrected immediately.
Open the 'Reports' list window and double-click 'Trial Balance'. The 'Specify Trial Balance' window is opened.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the period for which you want to produce the Trial Balance. The first period in the Reporting Periods setting is the default value.
- Accounts
- Paste Special
Account register, Nominal Ledger/System module
- Range Reporting Alpha
- Limit the report to a certain Account, or a range of Accounts.
- Object
- Paste Special
Object register, Nominal Ledger/System module
- Indicate an Object to limit the scope of the report.
- VAT Code
- Paste Special
VAT Codes setting, Nominal Ledger
- Enter a VAT Code here to restrict the report to Transactions with a certain VAT Code.
- Currency
- Paste Special
Currency register, System module
- If you enter a Currency here, all amounts in the report will be converted to the specified Currency using the Exchange Rate for the Transaction Date.
- You should only enter a foreign Currency here. To produce a report with figures in Base Currency 1 or 2, leave this field blank and choose which Base Currency is to be used using the Values In options described below.
- Language
- Paste Special
Languages setting, System module
- You can produce the Trial Balance in different Languages: enter the required Language Code here. The appropriate translation for each Account Name will be taken from the 'Texts' card of the Account record.
- If you do not enter a Language here, but you have entered a Language in the Company Info setting in the System module, the report will be produced in that Language if you are using the Account Description in Company Language option in the Transaction Settings setting in the Nominal Ledger.
- Including Simulations
- Check this box to include simulated transactions in the report. Simulation rows of "Invalid" and "Transferred" Status will not be included.
- Used Accounts only
- With this box checked, the report will only show Accounts with Transactions registered during the period, and/or with balances brought forward from a previous period.
- List Transaction Nos
- With this box checked, the Transaction Numbers of all Transactions that fall within the reporting period, together with debit and credit totals, will be listed at the bottom of the report. All Transactions will be listed, irrespective of any restrictions in the scope of the report specified in the fields above.
- Amounts in Currency
- With this option checked, summary totals of each Currency used in the selected Transactions are shown at the bottom of the report.
- Include Turnovers
- The standard version of this report has three columns showing for each Account the balance brought forward, the net change over the report period and the final balance. Check this box if you would like two additional columns to be included, showing the total debit and credit postings to each Account.
- Accounts only
- The standard version of this report gives subtotals for groups of Accounts, grouped using the first character of the Account Code. For example, if your Sales Accounts are in the range 100-199, the report will show figures for each Account and for all Sales Accounts (because they share the same initial character, "1").
- Check this box if you do not want the report to include subtotals for groups of Accounts.
- Values in
- If you are using the Dual-Base system, values in this report can be shown in either Base Currency. Use these options to choose which Currency is to be used on this occasion.
- If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.
- If you enter a foreign Currency in the Currency field above, these options will be ignored and the amounts in the report will be converted to the specified Currency using the Exchange Rate for the Transaction Date.
Introduction to Reports in the Nominal Ledger
