One moment please...
 
Exact Synergy Enterprise   
 

Customizing Consolidated Financial Statements

Introduction

At this page, you can customize the sections and fields on the consolidated financial statement page.

Menu path

  • Go to Financial/Reports/Financial consolidation/Consolidated balance sheet, and then click on the title bar.
  • Go to Financial/Reports/Financial consolidation/Consolidated profit and loss statement, and then click on the title bar.

Roles & rights

All users can customize the consolidated financial statement page.

For more details on what you can do with function rights or levels, go to System/Setup/Security/Function rights, select the required module, and then click on the relevant ID. To find out the functions you can perform with a particular role, go to System/Setup/Security/Roles, type in the description, click Refresh, and then click the required link under the Role column.

Button

Save

Click this to save the customized fields settings.

Default

Click this to reset the settings to the default settings.

Close

Click this to exit.

Description

Criteria section

Show: Periods

Select this check box and the check box will appear under the Criteria section of the consolidated financial statements page. If you select this checkbox on the consolidated financial statement page, you can view the consolidated financial amount for each period. For example, if you select this check box and the consolidated financial statement is for Year 2007 Period 1 – 6, the results will show six columns in which each column represents one period. Under each period, you will be able to see the consolidated financial amounts for the G/L accounts.

Categories section

Corporate

Select the active G/L account categories to be used when you view your consolidated financial statements based on the corporate G/L schema. For more information, see Modifying G/L Account Category.

Reporting entity

Select the active G/L account categories to be used when you view your consolidated financial statements based on the reporting entity’s G/L schema. For more information, see Modifying G/L Account Category. The available options of G/L account categories are dependent on the active G/L account categories you have defined for the reporting entity you have selected when you define the criteria to display the overview of the consolidated financial reports. For more information, see Overview of Consolidated Financial Statements.

Note: If you do not define a reporting entity in the consolidated financial statement page, you will not see the G/L account category options in the customization page except for only one category field with the G/L option. This is because without a reporting entity being defined, the system will not be able to refer to a specific reporting entity to display its G/L account categories.

Columns section

Opening balance

Select the 1 Column check box to view the opening balance of the consolidated G/L accounts in one column. To differentiate between the debit and credit balances, user can customize the format at the 1 Column: Number format field. Meanwhile, you can select the Debit / Credit check box to view the opening balances under the Debit and Credit columns.

Debit / Credit

Select the Debit / Credit check box to view the debit or credit consolidated G/L account balances for the defined periods in the consolidated financial statements.

Balance

Select the 1 Column check box to view the closing balances as at the end of the periods in one column. To differentiate between the debit and credit balances, user can customize the format at the 1 Column: Number format field.

1 Column: Number format

This setting determines the display format for the figures shown under the Opening balance and Balance columns in the consolidated financial statements if the 1 Column check box is selected at Opening balance and Balance. Select Amount D / Amount C to display the debit balances with a letter “D” after the amount and credit balances with a letter “C” after the amount. For example, a debit opening balance amount of Euro 200.00 will be displayed as “200.00 D” under the Opening balance column, while a credit closing balance of Euro 5,000.00 will be displayed as “5,000.00 C” under the Balance column.

Include

Select the Zero balances check box to include the consolidated G/L accounts with zero balances in the consolidated financial statements.

Compare with

Select the Difference check box to view the difference of amount in the consolidated G/L accounts when you compare the consolidated financial figures between different periods under the Difference column. In addition, you can also select the Difference % check box to view the percentage of amount difference in the consolidated G/L accounts when you compare the consolidated financial figures between different periods under the Difference % column.

Related document

     
 Main Category: Support Product Know How  Document Type: Online help main
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 15.959.291
 Assortment:  Date: 27-09-2010
 Release:  Attachment:
 Disclaimer