Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Assistance Needed with Operational Cash Flow KPI Calculation in NSAW
Hi Team,
We are currently working on calculating the operational cash flow KPI in NSAW, using the following formula:
Operational Cash Flow = Net Income + Changes in Working Capital
The breakdown for each component is as follows:
- Net Income is calculated as:
Net Income = Income Account Type - COGS Account Type - Expenses Account Type - Working accurately - Changes in Working Capital is determined by:
Changes in Working Capital = (Current Assets + Current Liabilities){2024} - (Current Assets + Current Liabilities){2023}
For a more detailed view, the calculation for changes in working capital includes:
Year 2024 ((AR + Bank + Other Current Assets) + (AP + Credit Card + Other Current Liabilities)) - Year 2023 ((AR + Bank + Other Current Assets) + (AP + Credit Card + Other Current Liabilities))
Tagged:
0