Oracle

Indirect Cash flow statement in FCCS

There are essentially two types of cash flow statements – Direct and Indirect. In the indirect method, Cash flow is derived from Net Income plus changes in balance sheet accounts that are categorized as Operating Cash flow account, Investing account and Financing accounts.
In the direct method only true cash activities are accounted for whereas indirect method works on accruals. Most of our projects deal with Indirect method of cash flow accounting as it is easier to record and reconcile. In FCCS, you can select to create an out of box Indirect cash flow statement.
FCCS uses movement dimension to calculate roll forwards and generates an automated indirect cash flow statement. As part of the application set up it is required to map each account with the right movement member. Then FCCS calculates the periodic changes in the balance sheet accounts to come up with the corresponding cash flow line. However, a lot of times customers don’t necessarily have all the underlying Balance Sheet accounts identified or broken down into the exact roll ups as needed by the Cash flow statement. Essentially the out-of-box Cash flow satisfies probably 80% of what the customer needs, but they still want to be able to make top side adjustments to the FCCS calculated Cash flow.

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

In such a scenario, there are two options
1) Either change the accounts to record each transaction the way it impacts cash flow line.
2) Or allow top side adjustments to the calculated cash flow in FCCS
Option 1 requires the customers to change the way they are currently recording the transactions in the ERP system. Option 2 seems to require fewer changes from the back end. In this blog, we’ll talk more about option 2.
Business Case – Create a cash flow statement that is built using indirect method in FCCS and also allows for top side adjustments to the cash flow without impacting the underlying Balance sheet/P&L Accounts.
Design – Identify the accounts that need to impact the cash flow lines. All these accounts should be mapped to the regular movement members that are either created manually or out of box. For all other BS/P&L accounts that should not impact the Cash flow, create a member under Movement dimension that is part of FCCS_Movements Subtotal, but does not roll under FCCS_Cashflow. See below a snapshot of the member we created – Mvmts_NonCash. In this way, Opening Balance can be calculated for these accounts without affecting the CashFlow statement.

Mvmt

Movement

Now create your Cash flow hierarchy as shown below : You can add input statistical type of accounts for each category that will allow for adjustment on top of what FCCS Calculates as shown below.
Acct1

Next create a form to allow users to adjust the cash impacting lines like the CF_AcctPayable_Input. The form should allow for input at these statistical input accounts and Mvmts_NonCash member. Now when we pull CF_AcctPayable account, it will show the total of what FCCS calculated based on movements of the accounts that were tagged with mvmt_AccountPayable plus the adjustment that was made.
Now on the cash flow report, pull this cash flow account rollup along with the Movement cash flow hierarchy to display a Cash flow report that has calculated indirect cash flow along with topside adjustment.

About the Author

Nandini Nehru is a Sr. Solutions Architect at Perficient in the Oracle EPM group. She has worked for ten plus years on various projects performing analysis, design, development, configuration and testing of applications. She has implemented Oracle Hyperion planning, HFM and Essbase applications for various industries like Healthcare, Public sector, Manufacturing and Oil and gas. She is a certified Oracle Trainer for Oracle Hyperion Financial reports, Planning Create and manage and Administrator class. She is also Oracle Hyperion Planning 11 Certified Implementation Specialist and Oracle Enterprise Planning and Budgeting Cloud Service 2017 Certified Implementation Specialist. Nandini works closely with the financial planning team at her clients across different industry verticals and implements IT solutions to meet their financial planning and budgeting needs. Nandini holds an honors degree in Bachelor of Engineering in Information technology and an MBA in Finance from Rice University. She was also a recipient of the renowned Jones Scholarship at Rice University, Houston.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up