Report on Balance Sheet

Report on balance sheet

A balance sheet is a statement that reveals the assets and liabilities of a company as on a particular date. Tell me more.

Select the “Report on Balance Sheet” link under “Reports – Book keeping”.

The “Balance Sheet” page appears.

Enter the following field in the “Print Criteria” group box:

Run Type	Use the drop-down list box and select the type of run that must be used to generate the balance sheet. You can select from “FB Simulation” or “Company Simulation”.
	FB Simulation – indicates the simulation type that has been created for consolidation of “Posting” finance books available in a company.
	Company Simulation – indicates the simulation type run that has been created for consolidation of finance books of child companies or “Posting” finance books available in a business segment or alternate segment.
	The system displays “Blank” by default on launch of the page.
Simulation Run No	A unique number identifying the simulation run (Alphanumeric, 18). The number entered in this field could be a “FB Simulation” number or a “Company Simulation” number.

Note: This field must not be left blank if a run type is selected in the “Run Type” field.

Book Type

Use the drop-down list box to select the type of finance book for which you want to view the balance sheet. 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 FB” or “Posting FB”.

Note: If tax books have been deployed in the login organization unit, the types of the tax book will also be available for selection. It could be “Posting Tax Book”, “Main Tax Book” or “Consolidation Tax Book”.

Business Unit

Use the drop-down list box to select the business unit for which you want to view the balance sheet. 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 balance sheet. All the finance books for the selected business unit and the type of finance book will be available for selection in the alphabetical order.

Reporting Structure

Use the drop-down list box to select the reporting structure in which you want to view the Balance Sheet. The system lists all the reporting structures defined in the “Create Reporting Structure” activity of the “Consolidation” business component if “Main FB” is selected as the “Book Type”.

Note that the system does not list any values in this field if “Posting FB” is selected as the “Book Type”.

By default the system leaves the field blank.

Currency

Use the drop-down list box to select the currency in which you want to view the balance sheet. 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.

Layout No	A unique number identifying the layout of the balance sheet (Integer). The layout number must have already been defined in the “Financial Statement Layout” business component for the balance sheet.
As On Date	The date on which you want to view the balance sheet (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 balance sheet 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.

Amount In	Use the drop-down list box to set whether you want to view the balance sheet figures in “Billions”, “Millions” or “Thousands”. The system displays “Blank” by default on launch of the page.
Include Memorandum Vouchers	Check the box if you want to include the memorandum journal voucher amounts in the balance sheet.
Previous Financial Year Comparison	Check the box if you want to compare with the balance sheet of the previous financial year.

Click the “Print Balance Sheet” push button to print the details of the balance sheet.

The system retrieves and displays the details of the balance sheet for a selected date. The system also retrieves and displays the balance sheet for the date with which we want to compare the new balance sheet.

The system also retrieves and displays the details of the balance sheet for a selected date along with the budget defined for the account codes, if a user defined layout is given. The system also retrieves and displays the balance sheet for the date with which the new balance sheet can be compared.

The system displays the period movement and year to date movement, in terms of both value and percentage.

Click the “Extract To Excel” push button to extract the details of the balance sheet to excel.

The system retrieves and displays the details of the balance sheet for a selected date in a MS-Excel sheet. The system also retrieves and displays the balance sheet for the date with which we want to compare the new balance sheet.

Report on Balance Sheet – An overview

It is basically a statement that takes account of the assets held, liabilities owed and the capital invested in a company as on a particular date. A detail balance sheet can be printed for a date. A balance sheet can be generated in the base currency and the parallel base currency (if applicable) of the company. The details of the generated balance sheet can be viewed before being printed as a report. The balance sheet can also be generated and viewed in a MS-Excel work sheet.

This page allows you to set the criteria for generating a balance sheet for a finance book. You can generate a balance sheet for the “Main”, “Posting” or “Consolidation” finance books. If a “Tax Book” is maintained for an organization unit, this page also allows you to set the criteria and generate a balance sheet for the “Main” and the “Posting” tax books. You can also include the memorandum journal vouchers that have been created while generating the balance sheet. This page also retrieves and displays the balance sheet for the selected finance book on another date for comparison. You can also set the figures in which you want to view the balance sheet.