Calculating Movements From Closing Balances in Financial Consolidation and Close

Before you begin

This 20-minute hands-on tutorial shows you how calculate periodic movement from closing balance input.

Background

Your business process may require you to load period-end account balances, rather than current period movements. If you enable the Calculate Movements system rule, you can load period end closing balances to the Closing Balance Input member, and the rule will calculate a specified current period movement. The Calculate Movement rule runs during the consolidation process. The existing Closing Balance plus the current entry for the specified movement are subtracted from Closing Balance Input to calculate the current period movement value. It writes the result to a specified movement member, replacing any existing values. After the Calculate Movements rule executes, the Closing Balance member is recalculated using the default consolidation process, and will match the entered closing balance value.

What do you need?

An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.

• Have Service Administrator access to EPM Enterprise Cloud Service. The instance should not have a business process created.
• Upload and import this snapshot into your instance.
  

  For more information on uploading and importing migration snapshots, refer to the Administering Migration for Oracle Enterprise Performance Management Cloud documentation.

• Save and extract this data file locally. You will be importing data using this data file.

Modifying Member Attributes

1. From the Home Page, click Application, then Overview, then Dimensions.

   

2. Select the Movement dimension to open it.

   

3. Locate the member Mvmts_ChangesInBalanceSheet.

   

4. Optional: Select the Member Name column, then click (Freeze). This keeps the Member Name column on the screen as you scroll to the right to locate the Is Default Movement attribute.
5. Select Default_Mvmt_Yes for the attribute Is Default Movement.

   

6. Locate the member Mvmts_ChangesInWorkingCapital.

   

7. Select Default_Mvmt_Yes for the attribute Is Default Movement.

   

8. Click Save, then Cancel.
9. Select the Account dimension to open it.

   

10. Locate the member FCCS_Balance Sheet.

    

11. Optional: Select the Member Name column, then click (Freeze). This keeps the Member Name column on the screen as you scroll to the right to locate the Default Movement attribute.
12. Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInBalanceSheet. Click Save.
13. Locate the member Accounts Receivable Trade.

    

14. Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInWorkingCapital.

    

15. Click Save.
16. Locate the member Obsolete Inventory.

    

17. Click the drop-down list for the attribute Default Movement and select Mvmts_ChangesInWorkingCapital. Click Save, then Cancel.

    

    Note: This attribute can be selected only for “FCCS_Balance Sheet” and level 0 accounts.
18. On the Application page, click Actions, then Refresh Database.

    

19. Click Create, then Refresh Database.

    

20. Click Refresh, then Finish.

    

21. Click Close twice.

Managing Ownership

1. From the Home page, click Application, then Consolidation. Verify the Manage Ownership tab is open.

   

2. Verify the Point of View is Actual, FY18, Jan. Select Actions, then Recompute Ownership Data.

   

3. Verify the POV, then click Recompute.

Importing Data

1. Open the RefApp_MovementsCalc_DataLoadFile_Data.csv file. Note the accounts for which a Closing Balance amount will be loaded in February. They are:
   • Cash
   • Accounts Receivable Trade
   • Other Accounts Receivables
   • Obsolete Inventory

   

2. Navigate to Application, then Overview.
3. From the Actions Menu, select Import Data.

   

4. Click Create. For source file, click Browse, and select the file RefApp_MovementsCalc_DataLoadFile_Data.csv.

   

5. Click Import. Click OK, then click Close twice, and select the Jobs card. Verify the job completed, then click Home.

   

Consolidating Data

1. From the Home page, select Data.

   

2. Expand the Reference_Application folder, then select (to open) the Movement Calculations form.

   

3. Closing balances have been loaded to the Closing Balance - Input member for February (you may need to scroll the columns to see the February data). Select Actions, then Consolidate.

   

4. In the Enter Period field, select Feb, then click Launch.

   

5. Note that the Feb Closing Balance does not yet reflect the Feb Closing Balance Input entries.

   

6. Click Close to close the form, then click Home.

Modifying Calculation Settings

1. From the Home page, select Application, Consolidation, then Consolidation: Process -> Local Currency.

   

2. Select the Calculate Movements row, then enable the Calculation Settings by changing the No to Yes.

   

Reviewing and Reloading Data

1. Re-open the Movement Calculations data form.

   

2. Select Actions, then Consolidate. In the Enter Period field, select Feb, then click Launch.

   

3. Note that the calculated movements for the two level 0 accounts for which a default movement was entered are posted against “Changes in Working Capital” while for the other two the movements are posted to “Changes in Balance Sheet”.

   

4. Manually enter the following data:
   • Cash -> Changes in Balance Sheet = 50 (replacing the existing entry)
   • Accounts Receivable -> Changes in Balance Sheet = 50
   • Other Accounts Receivable -> Changes in Working Capital = 50
   • Obsolete Inventory -> Changes in Working Capital = 50 (replacing the existing entry)

   

5. Click Save.
6. Select Actions, then Consolidate, and in the Enter Period field, select Feb. Then click Launch.
7. Note that the default movement amount is replaced but other data entered is not replaced.

Modifying Calculation Settings

1. From the Home page, select Application, then Consolidation, then Consolidation: Process -> Local Currency. Select the Calculate Movements row.



2. Disable Calculation Settings by changing Yes to No. At the verification screen, click OK.

   

3. Reopen the Movement Calculations form.
4. Enter 400 for Closing Balance Input for all accounts.
5. Click Save. Select Actions, then Consolidate. In the Enter Period field, select Feb, then click Launch.
6. Note that the movements data does not change. All movement amounts are treated as if they had been manually entered, and as a result, the derived Closing Balance no longer matches the entered Closing Balance.