NSPB Income Statement Subsidiary Consolidated

After importing the latest consolidated exchange rates from NetSuite, the consolidated Income Statement can be analysed in reporting currency, across all Subsidiaries. The Actual or Budget amounts can be displayed per year, for one or all periods, by Department and 

Class. 

Steps

1) From the Home page, navigate to Financials > Income Statement.

2) Click the Income Statement Subsidiary Consolidated form.

3) In the Point of View (POV), click Scenario.

4) To display actual values, select Actual or to display budget values select Budget. 

5) Click Years and select the financial year to display.

6) Click Period and select the period to display or select Total to display the year total.

7) Click Currency and select the Reporting Currency in which to display the values.

Note: Although it is possible to select an input currency, values will only display in  subsidiary columns where the input currency is valid. 

8) In Department and Class, select the department and class to display.

9) Optionally, click the [Actions] button and click IS Budget Data Refresh the form with the latest values from the Revenue and OpEx budget forms

Note: The exchange rates can be viewed from FX Rates by Subsidiary > Exchange Rates to Reporting Currency.

10) The values are displayed by subsidiary showing Parent Values and Intercompany Eliminations.

11) Click next to Total Parent to collapse the subsidiaries by Parent Subsidiary.

12) Click next to Company (Consolidated) to collapse the subsidiaries by Company

Leave a comment

Your email address will not be published. Required fields are marked *