Contact Us

3 Methods of Automating Cash Flow in OneStream XF Software

Corporate planning is not one size fits all — organizations have a variety of techniques to choose from today based on their specific needs and strategy. Typically, modern planning processes include:

  • Seeding from other scenarios (such as actuals)
  • Combining scenarios for forecasts (i.e. actual and forecast)
  • Driver-based planning
  • Allocations of global expenses for profitability
  • “What if” scenario gaming/modeling
  • Machine learning

These processes can work in tandem with or within OneStream Software. To have a successful implementation with the OneStream Software planning module, first, you need to understand your processes and which specialty planning solutions can help you improve those processes.

There are many other aspects you must consider during your implementation to make your life easier in the long run. In this blog post, we’ll specifically look at considerations for Cash Planning with OneStream Software.

Download the OneStream Product Sheet

With OneStream's Cash Planning solution, you can model the changes to your cash flow to understand the impact of all cash sources, including payables, receivables, investments, capital expense, and financing. Cash Planning gives you a lot of powerful functionality — like the ability to model your investments and see the expected returns. You can also gain more visibility into your credit position and see the impact of any changes. 

The Cash Planning solution is a truly powerful tool, that also allows you to automate your cash flow. The methods of automating cash flow in OneStream XF are balance sheet constraints, rules, and mapping.

Method 1: Balance Sheet Constraints

If you’re using the flow dimension for your balance sheet, you’re able to make balance sheet accounts children of cash flow accounts. These cash flow accounts need to have constraints defined only for their activity.

The Pros:

  • Being part of the data unit aggregation, the calculation is “free”

The Cons:

  • Most balance sheets do not provide the detail to support this method, so additional rule creation is needed
  • Breaking outflow can be difficult

Method 2: Rules

The approach of using rules for your cash flow automation is popular with the OneStream crowd because of the flexibility. Additionally, OneStream has drill-down functionality, allowing you to display anything that explains the cash flow.

The Pros:

  • Flexible and adaptable for client requirements

The Cons:

  • Increased maintenance and support

Method 3: Mapping

With the mapping approach, you have almost no rules. Mapping assumes that you will build the cash flow as a part of the original project.

The Pros:

  • Rules aren’t needed — there are only a few exceptions
  • It creates the best reporting because the cash flow is seen by expanding the account by a UD dimension

The Cons:

  • Another entity is required for Parent cash flow adjustments or data entry occurring at the parent
  • You might need to change your flow to better support this approach
  • Adding accounts may require reloading data

For more on OneStream's Planning solutions, download the eBook...




US-Analytics is a full-service OneStream consulting firm. To ensure end-to-end coverage of your technology, we provide a complete range of services: process and advisory, infrastructure, implementations, upgrades and migrations, training, and managed services.

New call-to-action

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk