About:

 

 

Financial Layouts in Interprise Suite are used as views in the chart of accounts to let you review, and analyze and print your accounts in a financial statement layout. The default financial layouts are Balance Sheet and Profit and Loss.

 

 

Note: If you choose to copy account codes from a template to create your chart of accounts, Interprise Suite will fill in the financial layouts with the copied accounts codes. If you choose to define your own account codes, you would have to define your own financial layouts. You can create as many financial statement layouts as required by the company. Financial Layouts in Interprise Suite are used as view options in the Chart of Accounts to let you review, and analyze your accounts in a financial statement layout. The default financial layouts are Balance Sheet and Profit and Loss.

 

 Steps:

 

 

Construct a New Financial Statement Layout

 

1. Go to the Accounting module.
2. Select Financial Layout under the Setup menu. The Financial Statement Layout form will appear.

 

Note: Listed are the default financial layouts for balance sheet and profit and losses that you can copy and modify to create your own financial statements e.g. use the profit and loss layout to create an income statement layout. You can use the default financial layout as it has already assigned most of the accounts from your chart of accounts (if you choose to create the chart of accounts from a template). You can check for accounts that had not been reported through the in the Check Duplicate facility in the Financial Layout.

a. Copying from a financial layout template

1. To copy from existing financial layout templates, select the layout to copy from the Layout Type column.
2. Enter the preferred Layout Name or accept the default. Click on the Copy button inside the Layout Type column to display the Financial Layout form.
3. You may rearrange the lines in the financial statement layout or add new ones.
4. For each line in the layout, you can select four different Line Types. See the Line Types discussed in option b. creating a financial layout from scratch.
5. Check if there are repeated accounts in the layout. Click on the Check Duplicates option from the row of buttons in the upper right of the form and the Check Accounts form will display the list of any duplicated accounts and the area of duplication. Likewise, it has an “unreported account” check facility that lets you know of any account codes that are not included in the layout. In the same form, click on the Accounts Not Reported tab to view the list of any account that was not included in the layout.
6. Save the details before closing the Financial Layout form.
   

b. Creating a financial layout from scratch

1. To create financial layout from scratch, select which layout type to copy. Then click on the Copy button beside the Layout Type column.
2. Enter the preferred Layout Name or accept the default. Drill down on the layout name to display the Financial Layout form.
3. For each line in the layout, you can select four different Line Types. The line types are as follows:
   
   • Text Line – for header, subheadings and separator symbols. You do not need to enter a Sum Level for this line or indicate if left or right, debit or credit.
   • Account Type – to group accounts by account type and include them in the layout. You can select and list accounts included in the account type by clicking on the Node button next to the Account Type line. You do not need to enter a Sum Level for this line. Indicate if Debit or Credit if the account balance is usually a credit or debit. Indicate if Left or Right for the system to place the account balances when printing.
   • Summary – for summing up the line numbers in the Sum Level column. Enter the line numbers (separated by a comma) of the Account Type lines you want to sum up. Instead of entering summary lines for each account type, you can use the indent button to arrange the accounts to sum up. The Indent button is found in the upper right of the form.
   • PNL Summary – for summing up the Profit and Loss accounts. This line should appear once and only in the Balance Sheet Layout. The system will prompt if selected twice. This line automatically sums up the Profit and Loss amounts form the accounts in the balance sheet layout.
4. As you enter each line, a Line Number is generated. The line number will allow you to sort the lines properly or sum up lines in a Summary line type.
5. Check if there are repeated accounts in the layout or unreported accounts. Click on the Check Duplicates option from the row of buttons in the upper right of the form and the Check Accounts form will display the list of any duplicated accounts and the area of duplication. In the same form, click on the Accounts Not Reported tab to view the list of any account that was not included in the layout.
6. Save the details before closing the Financial Layout form.

 

 How To:

Apply the layout to the Chart of Accounts

Maintain the Financial Statement Layouts

Print the Financial Statements

 

 

 

---

© 2008 Interprise Software Solutions, Inc. All rights reserved.