Reviewing Financial Statements

Reviewing financial statements

Select the “Review Financial Statements” activity under the “Finance Book Processing” business component.

The “Review Financial Statements” page appears.

Click “Trial Balance” tab to review Trial Balances.
Click the “Balance Sheet” tab to review Balance Sheet .
Click the “Income Statement” tab to review Income Statements.
Click the “Income Statement (MAC)” tab to review cost center profitability output.
Click the “Adhoc” tab to review a particular account code or cost center / combination of both.

To review Trial Balance

In this section the system displays the trial balances by default on launch of this page. This is based on the default search criteria which can be further changed by the user

Enter the following fields:

Company	Use the drop-down list box to select the login OU for which Trial Balance records are retrieved in the multiline. The system displays ‘login OU” by default in this field.
Finance Book	Use the drop-down list box to select the code identifying the finance book for the selected Entity. All the “Posting” finance book that have been defined for the selected company and that are in the “Active” status will be available for selection in the ascending order.
Period Horizon	Use the drop-down list box to select the period for which you wish to view the Trial Balance records. The system lists the current year along with the immediately preceding four years. The system displays “the current year” by default in this field.
As On / Month ends	Use the drop-down list box to specify the month-end date based on which you wish to retrieve Trial Balance records in the multiline. The system lists all the preceding month- end dates for the given Period Horizon. Based on the given date, the Trial Balance records for that period retrieved. The system displays “As On” by default in this field.
	The date falling within the period and month-end date specified for which you wish to retrieve Trial Balance records in the multiline. Based on date specified, the Trial Balance records falling on that date is retrieved in the multiline.

Enter the following fields in the “Additional Display Option” group box:

Group By

Use the drop-down list box to select the basis on which you wish to group the Trial Balance records. The system displays the following options:

Annual
Semi Annual
Quarters
Months

The system displays “Annual” by default in this field.

Net Balance

Check the checkbox if you wish to retrieve net balances for the Trial Balance records.

Leave this checkbox unchecked if you wish to retrieve Trial Balance with the “Debit” and “Credit” balances separately.

The system leaves this field unchecked by default.

Click the “Show Details” pushbutton to retrieve the search details.

Note: The system will retrieve the Trial Balance as on the given date, in the base currency of the login OU.

To review balance sheet

This section enables the review of Balance Sheets. Based on the balance sheet layout ID and other search options specified. The system displays balance sheet in tree format at a Schedule level. On further expanding of ‘Schedule’ Account Codes mapped to it will be displayed. The Amount link against account code will be enabled on click of it account inquiry within the same screen is launched. Enter the followings fields:

Entity	Use the drop-down list box to select the login OU for which Balance Sheet to be retrieved in the multiline. The system displays ‘login OU” by default in this field.
Finance Book	Use the drop-down list box to select the code identifying the finance book for the selected Entity. All the “Posting” finance book that have been defined for the selected company and that are in the “Active” status will be available for selection in the ascending order. The system displays ‘All PFB” by default in this field.
Period Horizon	Use the drop-down list box to select the period for which you wish to view the balance sheetThe system lists the current year along with the immediately preceding four years. The system displays “the current year” by default in this field.
As On	The current date based on which you wish to retrieve Balance Sheet in the multiline. The system displays the current date adjacent to this field.it is display only control
	Use the drop-down list box to specify the month-end date based on which you wish to retrieve Balance Sheets in the multiline. The system lists all the preceding month- end dates for the given Period Horizon. Based on the given date, the Balance Sheets for that period is retrieved. The system displays “As On” by default in this field.
Layout ID	Use the drop-down list box to select the code identifying the layout in the finance book. The system lists all the User Defined and Predefined Layout ID’s. defined in the ‘Financial Statement Layout ' activity of the same business component. The system displays the first Layout ID defined for the Balance Sheet in the 'Financial Statement Layout ' activity of the same business component. Note that the balance sheet structure changes as per the Layout ID selected.
Schedules / Groups	Use the drop-down list box to select a specific schedule or group based on which you wish the Balance Sheet to be retrieved in the multiline. The system lists all the Schedules / Groups applicable to the specified Layout ID. The system displays “All” by default.

Enter the following fields in the “Additional Display Option” group box:

Group By

Use the drop-down list box to select the basis on which you wish to group the Balance Sheet records. The system displays the following options:

Annual
Semi Annual
Quarters
Months

The system displays “Annual” by default in this field.

Comparison

Use the drop-down list box to specify the basis on which you want the financial statements to be compared. The system lists the following options:

Previous Year - Select this option to indicate that you wish to compare financial data relating to the reporting period range with the data relating to the same period range of the previous year.
Previous Periods - Select this option to indicate that you wish to compare financial data relating to the reporting period range with the data immediately preceding the period range.

YTD

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.

Click the “Show Details” pushbutton to retrieve search details in the multiline.

Note: The system retrieves all the Balance Sheet records as on the given date as per the specified layout in the base currency of the login OU.

To review income statement

This section enables the review of Income Statements. Based on the balance sheet layout ID and other search options specified the system displays the Income Statements in tree format at a schedule level. Further expanding schedule level provides the associated account codes that are mapped. Also, the hyperlinked ‘Amount’ against the Account Codes launches the Account Inquiry popup.

Enter the followings fields:

Company	Use the drop-down list box to select the login OU for which income statements are retrieved in the multiline. The system displays ‘login OU” by default in this field.
Finance Book	Use the drop-down list box to select the code identifying the finance book for the selected Entity. All the “Posting” finance book that have been defined for the selected company and that are in the “Active” status will be available for selection in the ascending order. The system displays ‘All PFB” by default in this field.
Period Horizon	Use the drop-down list box to select the period for which you wish to view the income statements. The system lists the current year along with the immediately preceding five years. The system displays “the current year” by default in this field.
	Use the drop-down list box to specify the starting date in the range of dates falling within the Period Horizon selected for which you wish to retrieve income statements in the multiline. The system displays the first month of the year selected as the Period Horizon.
	Use the drop-down list box to specify the ending date in the range of dates falling within the Period Horizon selected for which you wish to retrieve income statements in the multiline. The system displays the last month of the year selected as the Period Horizon.
Layout ID	Use the drop-down list box to select the code identifying the layout in the finance book. The system lists all the User Defined and Predefined Layout ID’s. defined in the ‘Financial Statement Layout ' activity of the same business component. Note that the Income Statement structure changes as per the Layout ID selected. The system displays the first layout ID defined for the Income Statement in the Financial Statement Layout activity.
Schedules / Groups	Use the drop-down list box to select a specific schedule or group based on which you wish the Income Statement to be retrieved in the multiline. The system lists all the Schedules / Groups applicable to the specified Layout ID. The system displays “All” by default in this field.

Enter the following fields in the “Additional Display Option” group box:

Group By

Use the drop-down list box to select the basis on which you wish to group the Income Statements. The system displays the following options:

Annual
Semi Annual
Quarters
Months

The system displays “Annual” by default in this field.

Comparison

Use the drop-down list box to specify the basis on which you want the financial statements to be compared. The system lists the following options:

Previous Year - Select this option to indicate that you wish to compare financial data relating to the reporting period range with the data relating to the same period range of the previous year.
Previous Periods - Select this option to indicate that you wish to compare financial data relating to the reporting period range with the data immediately preceding the period range.

YTD

Check the box if you want to retrieve the Income Statements 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.

Click the “Show Details” pushbutton to retrieve search details in the multiline.

To review income statement (MAC)

This section enables the review of Income Statements for MAC. Based on the CE Structure ID, CC Structure ID and other search options specified, the system displays the Income Statements in tree format at a schedule level. Cost Elements will be displayed vertically in the tree on click of which the ‘Account Inquiry’ screen will be launched. The group CC also passes an input to the ‘Account Inquiry’ screen where the transaction level search will get displayed taking CC also as one of the parameters.

Enter the followings fields:

Company	Use the drop-down list box to select the login OU for which income statement (MAC) is to be retrieved. The system displays ‘login OU” by default in this field.
Finance Book	Use the drop-down list box to select the code identifying the finance book. The system lists all the “active” finance books that have been defined for the login OU company.
Period Horizon	Use the drop-down list box to select the period for which the income statement (MAC) is to be retrieved. The system lists all the active and open periods defined in the MAC calendar.
	Use the drop-down list box to specify the starting date in the range of dates within the Period Horizon selected for which income statement (MAC) is to be retrieved.
	Use the drop-down list box to specify the ending date in the range of dates within the Period Horizon selected for which income statement (MAC) is to be retrieved.
CE Structure ID	Use the drop-down list box to select the code identifying the Cost Element structure. The system lists all the ‘active’ CE Structures defined in the “Create Cost Element Structure” activity of the “Cost Setup” business component.
Schedules / Groups	Use the drop-down list box to select a specific schedule or group for which income statement (MAC) is to be retrieved. The system lists all the Schedules / Groups applicable to the specified CE Structure ID. The system displays “All” by default in this field.
CC Structure ID	Use the drop-down list box to select the code identifying the Cost Center structure. The system lists all the ‘active’ CC Structures defined in the “Create Cost Center Structure” activity of the “Cost Setup” business component. Help facility available.

Click the “Show Details” pushbutton to retrieve search details in the multiline.

To review adhoc

This section enables the use of Adhoc Search to retrieve a wide range of information such as Financial Year, Finance book, Analysis Code, Sub Analysis Code, Amount and so on. A particular/range of ‘Account code’, ‘Cost center’ or combination of both can be specified to retrieve required records alone or information for all account codes can be retrieved by leaving the search criteria blank. Also the “Group By” option in the multiline enables a customized analysis of data with ‘drag and drop’ facility in which columns can be dragged and dropped under the “Group By” which forms a tree of all the data for easy analysis. Example: To analyze Cost Centers along with the relevant data, the column ‘Cost Center’ can be dragged and dropped into the ‘Group By’ field to form a tree which expands to data pertaining to those cost centers.

Enter the followings fields:

Company	Use the drop-down list box to select the login OU for which Balance Sheet records are retrieved in the multiline. The system displays ‘login OU” by default in this field.
Finance Book	Use the drop-down list box to select the code identifying the finance book for the selected Entity. All the “Posting” finance book that have been defined for the selected company and that are in the “Active” status will be available for selection in the ascending order. The system displays ‘All PFB” by default in this field.
Period Horizon	Use the drop-down list box to select the period for which you wish to view the records. The system lists the current year. The system displays “the current year” by default in this field.
	Use the drop-down list box to specify the basis on which you wish to retrieve records in the multiline. You can select from the following options: · For - Select this option if you wish to retrieve records for a particular month. · As On – Select this option if you wish to retrieve records as on a particular date. The system displays “As On” by default in this field.
Account Code Range	The starting code identifying the Cost / Revenue account in the range of codes from which the records must be retrieved in the multiline. Help facility available.
	The ending code identifying the Cost / Review account in the range of codes until which the records must be retrieved in the multiline. Help facility available.
Cost Center Range	The starting code identifying the cost center in the range of cost center codes from which the records must be retrieved in the multiline. Help facility available.
	The ending code identifying the cost center in the range of cost center codes until which the records must be retrieved in the multiline. Help facility available.

Click the “Show Details” pushbutton to retrieve search details in the multiline.