Armanino Blog
Article

Cash Flow Forecasting With Workday Adaptive Planning

April 02, 2020

Cash flow forecasting has become a necessary activity in this current environment. Many of our clients have monthly financial planning models but they are not sure how to convert from a monthly view to a daily view when it comes to cash flow planning. Here are some step-by-step instructions with screen shots to show you how you can do cash flow forecasting in Adaptive Insights either on an indirect, direct or daily basis.

Step 1: Plan Your Balance Sheet

Most clients have a good set of models for their income statement, but some have not spent a lot of time on planning their balance sheet. Basic balance sheet planning includes, at a minimum, assumptions and drivers for receivables and payables. Utilize days sales outstanding to project your accounts receivable and days payable outstanding for accounts payable, among others. Assumptions for a balance sheet might look like this below.

Step 1: Plan Your Balance Sheet

Step 2: Plan Your Indirect Cash Flow

The easiest and fastest way to begin cash flow forecasting is to create an indirect cash flow forecast. In Adaptive Insights, we plan our balance sheet accounts and create attributes for each one and put them into the proper cash flow categories including changes in operating, investing and financing activities. Once these attributes are in place, formulas can be used in custom accounts to create the following indirect cash flow statement.

Step 3: Plan Your Direct Cash Flow

Direct cash flow takes a different approach than indirect cash flow by detailing the sources and uses of funds. In the example below, customer receipts are recognized in the sources section with uses including payroll and other operating expenses.

Step 4: Break Down Your Cash Flow Forecast into Days

In Adaptive Insights, we can take either one of these cash flow statements and break them down into more granular time periods such as days or weeks. In the example below, I have taken the direct cash flow on a monthly basis as a starting point to create a daily cash flow. The estimated revenue receipts by customer are shown in the sources section. For uses, assumptions have been added for the number of days in the month and the payday. Similar assumptions can be made for other expense accounts. This can be a starting point for daily cash flow forecasting including supporting schedules for loans, pre-paids, etc. Actual daily direct cash flow results can provide a foundation for better forecasting as you build your expertise.

Did you miss it? Check out this blog on how to Reforecast for Sudden Changes Using Adaptive Insights.

Have questions or need some help? Don't hesitate to reach out to our experts. For the latest regulatory updates and more information on keeping your business running through disruption, visit our COVID-19 Resource Center.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
Maximize Your New ERP System ROI
Once you have an ERP in place, phase two is your chance to maximize the software and unlock the next level of growth.

December 06, 2022
Workday Adaptive Planning 2022 R2 Release
Webinar
Learn about Workday’s newest features and enhancements.

August 30, 2022 | 10:00 AM - 11:00 AM PT
Empower Your Nonprofit with a Financial Planning & Analysis Solution
Checklist
Identify the key features in an FP&A tool that can make your nonprofit more efficient and strategic.

August 01, 2022