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:

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".
Segment	The Segment ID based on which the report needs to be extracted.
	Help Facility Available

Note: Report can be launched for a segment only if the Login Company is a Parent Company and Report basis is Segment Based. This control will be visible only when the Report Basis is selected as “Segment Based".

Reporting Structure	The Reporting structure ID created in FB Consolidation Component to extract the report based on the structure ID created.
	Help Facility Available

Note : This control will be visible only when the Report Basis is selected as “Segment Based”.

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 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”, “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.
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.
Report Format	Use the drop down list box to select the Report format to launch the Balance Sheet. You can select from New and Old. The system displays New by default on launch of the page.

Note: The Report format control will be visible based on the base currency of the login company. When the base currency of the login company is ‘Indian Rupees’ and the first financial calendar start date with legacy option as No before 1.4.2011.then this control will be visible..

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.

Upto Run No.

Use the drop down list box to launch the Income Statement 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.

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 Vouchers	Use the drop down list box to select the voucher amount to include in balance sheet. The combo would be loaded with "Memorandum", "IFRS Adjustments" and "All".

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.

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.

Click the "Schedules to Balance Sheet” pushbutton to print the Schedule details of the balance sheet..
Click the "Sub Schedules to Balance Sheet” pushbutton to print the Sub Schedule details of the balance sheet.
Click the "Print Layout Based Balance Sheet” pushbutton to print the Layout Based Reports of the Balance Sheet.

The system retrieves and displays the balance sheet details under different headings in the selected layout no for a selected date for the selected finance book.

If the Finance Book is selected as Consolidated, the balances for the account codes included in the given layout of all the finance Books loaded in the finance book combo would be consolidated and displayed in the report. Similarly results are displayed for comparison date.

Note : If the PPS parameter "Allow Usage of Layout No. Across finance Book is set to Yes" then for the given layout no. though the layout no does not belong to the selected Finance Book, the balances for those account codes included in the given layout pertaining to selected Finance Book would be displayed in the report

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.