|
|
|
|
The trial balance is an account statement, which shows the account balances of a finance book at a given point of time. Tell me more.
Select the “Report On Trial Balance” link under “Reports – Book keeping” business component.
The “Trial Balance” page appears.
Enter the following field in the “Print Criteria” group box:
|
Report Basis |
Use the drop-down list box to select the basis on which the report is to be generated. The combo is loaded with "Finance Book Based" and "Structure Based". If the login company is a Parent company the combo will also be loaded with " Segment Based". |
|
Reporting Structure |
The Reporting structure ID created in FB Consolidation Component to extract the report based on the structure ID created. |
|
Book Type |
Use the drop-down list box to select the type of finance book for which you want to view the trial balance. All the types of finance books that have been deployed in the login organization unit will be available for selection in the alphabetical order. You can select from “Consolidation Finance Book”, “Main Finance Book” or “Posting Finance Book”. |
Note: If tax books have been deployed in the login organization unit, the types of the tax book will also available for selection. It could be “Posting Tax Book” or “Main Tax Book”.
|
Business Unit |
Use the drop-down list box to select the business unit for which you want to view the trial balance. All the business units that have been mapped to organization units in which a “Report – Book Keeping” and a “Finance Book Processing” business component has been deployed will be available for selection in the ascending order. |
Note: “Blank” will be available for selection if “Main Finance Book”, “Consolidation Finance Book” or “Main Tax Book” is selected in the “Book Type” field.
|
Finance Book |
Use the drop-down list box to select the finance book for which you want to view the trial balance. All the finance books that have been mapped to organization units for the selected business unit and the book type of finance book in which a “Report – Book Keeping” and a “Finance Book Processing” business component has been deployed will be available for selection in the alphabetical order. |
|
Currency |
Use the drop-down list box to select the currency in which you want to view the trial balance. You can select from “Base Currency”, “Parallel Base Currency” and the “Account Currency”. The system displays “Base Currency” by default on launch of the page. |
Note: “Parallel Base Currency” will be available for selection only if it is applicable for the company.
|
Chart Of Account ID |
Use the drop-down list box to select the chart of accounts Id in which you want to view the trial balance. All the operative chart of accounts ID, the reporting chart of accounts ID and the consolidation chart of account ID will be available for selection in the ascending order. |
Note: “Consolidation Chart of Account” will be available for selection if a “Consolidation Finance Book” has been deployed in the organization unit.
|
Account Level |
Use the drop-down list box to select the level of the accounts in the reporting chart of accounts structure for which you want to view the trial balance. All the levels that have been defined for the selected reporting chart of account id will be available for selection in the ascending order. The system displays “Blank” by default on launch of the page. |
|
As On Date |
The date for which you want to view the trial balance (Date Format). The date entered in this field must be before the system date. The system date is displayed by default on launch of the page. |
Note: This field must not be left blank if the “Simulation Run No” field is left blank.
|
Comparison Date |
The date for which you want to compare the trial balance details (Date Format). The date entered in this field must be before the date entered in the “As on Date” field. |
Note: The date entered in this field must be before the system date if a run number has been entered in the “Simulation Run No” field.
|
Year To Date |
Check the box if you want to retrieve the balances from the beginning of the financial year within which the system date falls. |
Note: If this field is not checked the balances are taken from the beginning of the financial period within which the system date falls will be retrieved.
|
Amount In |
Use the drop-down list box to set whether you want to view the trial balance figures in “Billions”, “Millions” or “Thousands”. The system displays “Blank” by default on launch of the page. |
|
Include Vouchers |
Use the drop down list box to select the voucher amount to include in trial balance. The combo would be loaded with "Memorandum", "IFRS Adjustments" and "All". |
|
Upto Run No. |
Use the drop down list box to launch the Trial Balance based on provisional Run No. The Transactions created after provisional closure upto the selected Run No. will be considered for launching the report. The transactions created after the selected Run No. is not considered in the report The combo would be loaded with Provisional Run NO. available for the period in which the as on date lies. |
Note: The combo would be visible only for the Report Basis - Finance Book Based, Book Type - Posting FB, and Finance Book - Specific Finance Book.
Click the “Print Summary TB” push button to print the summary of the trial balance.
The system retrieves and displays the closing debit balance and the closing credit balances of the account codes for a selected date for the selected finance book. The system also retrieves the closing debit and credit balances for the date with which we want to compare the new trial balance.
Click the “Print Detail TB” push button to print the details of the trial balance.
The system retrieves and displays the opening debit balance and credit balance of the account for a selected date for the selected finance book. The system also retrieves and displays period debit and period credit balances along with the closing debit balance and credit balance of the account for a selected date for the selected finance book. The system also retrieves and displays the opening, period and closing debit and credit balances of the account for the date with which we want to compare the new trial balance.
Click the “Extract To Excel” push button to extract the details of the trial balance to excel.
The system retrieves the opening debit balance and credit balance of the account for a selected date for the selected finance book in a MS-Excel sheet. The system also retrieves and displays the closing debit balance and credit balance of the account for a selected date for the selected finance book. The system also retrieves and displays the opening and closing debit and credit balances of the account for the date with which we want to compare the new trial balance.
Report on Trial Balance – An overview
The trial balance contains the debit / credit balances of the various accounts available in a finance book. A summary or a detail trial balance can be printed for a date. The memorandum journal vouchers that have been created to simulate certain journal entries can also be included while generating the trial balance of a finance book. A trial balance can be generated in the base currency of the company and in the account currency. If a parallel base currency is available for a company, the trial balance can also be generated in the parallel base currency. The details of the generated trial balance can be viewed before being printed as a report. The trial balance can also be generated and viewed in a MS-Excel work sheet.
This page allows you to set the criteria for generating a trial balance for individual finance book. You can generate a trial balance for a “Main”, “Posting” or a “Consolidation” finance book. If a “Tax Book” is maintained for an organization unit, this page also allows you to set the criteria for generation. A trial balance can also be generated for the various levels in a chart of account structure.
This page also retrieves and displays the trial balance for the selected finance book on another date for comparison. You can also set the figures in which you want to view the trial balance.
This page allows you to generate a detail trial balance that would contain the opening and closing debit / credit balances of the accounts in a finance book. The opening debit / credit balances could be from the beginning of the financial period in which the date of the trial balance is available or from the beginning of the financial year in which the trial balance date is valid.
Finance Book Processing” business component must have been deployed in the organization unit.