|
|
|
|
|
This page allows you to create a layout for the financial statement. Tell me more.
Select the “Create Financial Statement Layout” link under the “Financial Statement Layout” business component.
The “Create Financial Statement Layout” page appears.
Enter the following fields:
|
Layout No |
A unique number identifying the layout (Alphanumeric, 18). Mandatory. |
Note: The layout number must be unique for the “Book Type” and the “Finance Book”.
|
Layout Description |
A textual description of the layout (Alphanumeric, 100). Mandatory. |
|
Zoom facility available | |
|
Layout Classification |
Use the drop-down list box to select the category in which the layout is to be classified from “Balance Sheet”, “Income Statement” or “Cash Flow Statement”. The system displays "Income Statement" by default on launch of the page. |
|
Book Type |
Use the drop-down list box to select the type of finance book for which you want to create a layout. The types of finance books that have been deployed in the login organizational unit will be available for selection in the ascending order. You can select from “Posting finance book”, “Posting tax book”, “Main finance book”, “Main tax book”, or “Consolidation finance book”. |
|
Finance Book |
Use the drop-down list box to select the code identifying the finance book for which the layout is being created. All the “Active” finance books that are of the book type selected and that have been deployed in the login organization unit will be available for selection in the ascending order. |
|
Chart of Accounts ID |
Use the drop-down list box to select code identifying the operative chart of account. All the chart of accounts that are present in the selected finance book will be available for selection. |
Note: If "Main Finance Book” or “Main Tax Book” is selected in the “Book Type” field all the "Industry Specific" and "Country Specific" chart of accounts will be available for selection.
If "Posting Finance Book” or “Posting Tax Book” is selected all the "Operative" chart of accounts will be available for selection.
If "Consolidation Finance Book” or “Consolidation Tax Book” is selected all the "Consolidation" chart of accounts will be available for selection.
The system display the following:
|
Description |
The description of the chart of accounts ID. |
|
Chart of Accounts Type |
The type of the chart of accounts. |
Enter the following fields in the “Search Criteria” group box to search for the schedule numbers that are to be mapped to the layout:
|
Option |
Use the drop-down list box to select whether you want to retrieve all the schedules that have been created for the finance book or not. You can select from “All Schedules” or “Unmapped Schedules”. |
| |
| |
|
The system displays “All Schedules” by default on launch of this page. | |
|
Schedule Description |
A textual description of the schedule (Alphanumeric, 100). You can enter the description in full or specify it partially using the “*” character. The system retrieves all the schedule numbers that have descriptions similar to the value entered here. |
|
Schedule No From |
The starting number in the range of schedule numbers that you want to retrieve to add to the layout (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the schedule numbers that are similar to the value entered here. |
Note: The number entered in this field must be the same or before the number entered in the “To” field.
|
To |
The ending number in the range of schedule numbers that you want to retrieve to add to the layout (Alphanumeric, 18). You can enter the number in full or specify it partially using the “*” character. The system retrieves all the schedule numbers that are similar to the value entered here. |
Click the “Search” pushbutton to retrieve the search results.
Note: If "Unmapped Schedules" has been selected in the "Option" field the system retrieves schedules that have not been mapped to an "Active" layout. The account codes, which have been grouped under the schedules, must be available in the selected finance book.
The system displays the following in the “Search Results” multiline based on the search criteria entered:
|
Line No |
The number identifying the row. This number is generated sequentially by the system. |
Enter the following fields in the “Search Results” multiline:
|
Include |
Use the drop-down list box to select whether you want to include the schedule number in the layout. |
| |
| |
|
The system displays “No” by default on launch of the page. |
Note: At least one schedule number must be selected for inclusion in a layout.
The system displays the following:
|
Schedule No |
The number identifying the schedule. |
|
Description |
A textual description of the schedule. |
Enter the following fields in the “Search Results” multiline:
|
Sequence No |
A sequential order in which the schedule must be available in the layout (Integer). |
Note: If this field is left blank, the system generates the sequence number when the layout is saved.
|
Add / Subtract |
Use the drop-down list box to set whether you want to add or subtract the balances of the accounts in a group based on their "Dr / Cr" identifiers. You can select from “Add” or “Subtract”. The system displays “Add” by default at the launch of the page. |
Enter the following fields in the “Group Schedule” group box to assign schedules to groups:
|
Line No From |
The starting line number in the range of line numbers that you want to assign to a group (Integer). The line number must be greater than zero. |
Note: The line number entered must be before the number entered in the “To” field.
|
To |
The ending line number in the range of line numbers that you want to assign to a group (Integer). |
Note: The line number entered must be the same or less than the number of schedules retrieved for grouping under the layout.
All the line numbers that fall within the range must have “Yes” selected in the “Include” field.
|
Group Heading |
A unique textual description of the group heading (Alphanumeric, 120). Mandatory. |
|
Zoom facility available | |
|
Total Description |
A textual description of the schedules that have been grouped (Alphanumeric, 40). Mandatory. |
|
Zoom facility available |
Note: The classifications of the schedule, book type, finance book and the account codes must be the same as that of the layout.
Click the “Assign Group” to assign the selected schedule numbers to a group.
The system generates a unique group ID is for the group. The group details are saved temporarily till the final “Create Layout” is executed.
Note: If the layout has been classified as “Balance Sheet” or “Income Statement” then all the schedules that have been mapped to it must also be classified as “Balance Sheet” or “Income Statement”.
Click the “Create Layout” pushbutton to create the layout details.
The system updates the status of the layout as “Active”.
The system displays the following:
|
Created By |
The login ID of the user who created the layout. |
|
Created Date |
The date on which the layout was created. |
To proceed, carry out the following
Select the “View Layout” link at the bottom of the page to view the layout details.
Select the “Copy Layout” link at the bottom of the page to copy the details of the layout.
Select the “View Unmapped Account / Schedules” link at the bottom of the page to view the details of the unmapped account codes or schedule numbers.
Creating layouts – An overview
|
|
You can define a layout number that is unique for the type of finance book and the finance book for which the layout is being created. You can also describe the layout in detail. A layout can be classified for usage in a “Balance Sheet”, “Income Statement” or the “Cash Flow Statement”. A layout can be used as per the classification made.
You can carry out a search to retrieve schedules that have been created earlier. You can search by specifying a range of schedule numbers or by giving the description of the schedule that you want to retrieve. This page also gives you the facility to carry out the search to retrieve all the “Active” schedules that are available in the selected finance book. This facility also allows you to retrieve all the schedules that remain unmapped to any layout.
You can select the schedule numbers that have been retrieved based on the search criteria to include them in the layout. You can map multiple schedules to a layout. You can also indicate the sequence in which the schedules must figure in the layout.
This page also allows you to group schedules under a layout. You can enter a unique heading and description for the group. A unique number is also generated for the group.
The status of the layout is updated as “Active” when it is created newly. The system stores the login user ID and the system date along with the creation details.
"Finance Book" must have been defined in the "Create Finance Book" activity of the "Organization Setup" business component.
"Financial Calendar" must have been defined in the "Create Calendar" activity of the "Accounting Setup " business component.
"Chart of Accounts ID" must have been defined in the "Create Operative Chart of Accounts" activity of the "Accounting Setup" business component.
“Schedules” must have been created in the “Create Schedule” activity of the “Financial Statement Layout” business component.
Classify layouts for different financial statements
Set the schedule groups that require to be totaled
Classify layouts for different financial statements
You can classify layout during the creation process for specific financial statements. A layout thus classified cannot be used for generating another financial statement.
Set the "Layout Classification" field to "Balance Sheet" to classify the layout for a balance sheet.
Set the "Layout Classification" field to "Income Statement" to classify the layout for an income statement.
Set the "Layout Classification" field to "Cash Flow Statement" to classify the layout for a cash flow statement.
You can retrieve schedules irrespective of whether they have been mapped to "Active" layouts or not.
Set the "Option" field to "All Schedules" to retrieve all the "Active" schedules that are available in the finance book.
Set the "Option" field to "Unmapped Schedules" to retrieve all the "Active" schedules that have not been mapped to any "Active" layout.
You can create sub groups of schedules under a layout. A unique group ID is generated for any newly created group.
Enter the necessary information in the "Group Schedule" group box.
Click the "Assign Group" pushbutton.
A unique group ID is generated by the system.
Set the schedule groups that require to be totaled
You can set the groups that require to be totaled based on their "Debit / Credit" identifiers.
