A Detailed Guide to Cash Flow Forecasting

21 May, 2020
Michael Wark

Michael Wark

6 minutes
person on ipad

While it’s impossible to predict the future with 100% certainty, a cash flow forecast will help you estimate how much cash will be moving in and out of your business for a set period. Not only does this give you a better picture of where your company is financially, but it will help you prepare for a variety of potential scenarios.

In this guide, we’ll cover how cash flow forecasting works, the benefits and challenges of using it, and tips to help you manage healthy cash flow in your own business.

What is cash flow forecasting?

In a nutshell, cash flow forecasting helps you plan for the future. It is a process that estimates your business’s future financial position and ensures you have the necessary amount of cash to meet future obligations and better manage working capital. 

First things first, you need to know what a cash flow forecast is. 

In a nutshell, cash flow forecasting helps you plan for the future. It is a process that estimates your business’s future financial position and ensures you have the necessary amount of cash to meet future obligations and better manage working capital. 

The old adage goes that you’ve got to plan for the worst but expect the best. 

Cash flow forecasting lets you prepare for a variety of favorable or challenging scenarios by focusing on the revenue you expect to collect and the expenses you expect to pay. 

A typical cash flow forecast should include three essential pieces:

  • Beginning cash balance: The total cash on hand you expect to have at the beginning of the month.
  • Cash inflows: The sources of cash you have coming in each month. This could include cash sales, online sales revenue, or receivables collections.
  • Cash outflows: The expenses your business will incur during the period, including utilities, loan payments, rent, or payroll.

What are the benefits? 

Cash flow forecasting can benefit all businesses, not just large, established companies. It’s an essential process to help with the following:

  • Plan for the future: As you evaluate trends and potential situations, this helps you visualise what an increase or decrease in sales will look like on your cash balances. This helps plan your staff hires, owners pay levels and amount available for marketing. 
  • Predict potential problems: Cash forecasting allows you to predict shortages and surpluses in the upcoming months. You can predict short months to an extent and plan for those months by establishing a line of credit, or enforcing receivable collections to help avoid these issues.
  • Decrease reliance on loans and credit card debt: When you have a grasp of your cash flow situation, you can confirm that you’ll have enough money in the bank to meet payroll, pay suppliers, and cover expenses without relying on debt. 

Build out different cash flow scenario models 

When you are first starting out, we recommend creating three different financial scenarios: the best case, moderate, and worst-case models. 

During uncertain times, working out multiple scenarios in a cash flow forecasting model comes in handy. For example, you could use the model to predict what needs to happen if your business revenue shrinks by 50%. You could include a best case, moderate case, and worst-case scenario for reducing labor costs. In the worst-case scenario, you evaluate the impacts of laying off several team members. The moderate may involve reducing hours to three days a week. And, the best case could be if you don’t lay off anyone at all.

Using cash flow forecasting, you could see the financial impact of all three scenarios. You may have thought you needed to lay off your team, but instead find that your business can sustain the reduced hours of the moderate scenario instead.

Pro Tip: During times where variables are shifting quickly like during a recession, you should be updating or reviewing cash flow forecasts on a regular basis – at least monthly but preferably weekly. When you are frequently monitoring your cash flow forecast, it will help you look for warning signs like downward trending revenue or increasing expenses.  

When you are first starting out, we recommend creating three different financial scenarios: the best case, moderate, and worst-case models. 

Understanding cash flow forecasting challenges 

Cash flow forecasting can be extremely beneficial for the businesses that utilize it, but it comes with its own set of challenges. Here are some of the challenges you may run into with this type of forecasting:

  • Uncontrollable external factors: Forecasts are predictions and at the mercy of unforeseen factors, like a slow down in the economy or public health emergencies. These unpredictable factors can significantly impact expected cash flow, and that means companies need to adapt and adjust to current market dynamics. 
  • Limited or inaccurate data: Your forecasts are only as good as your bookkeeping reports and financial data. For example, If you haven’t updated your books in 6 months, then your ability to create forecast models will be limited.  
  • Analysis paralysis: Cash flow forecasting can give business owners more information than they can process at one time. Instead of using this data to make business decisions, they get overwhelmed and do nothing with it. 

    This is why it can be helpful to work with an advisor or bookkeeper you trust and has a great understanding of the nuances of your business.  

Improve the accuracy of your cash flow forecasts  

Ultimately, the biggest challenge is that cash flow forecasts are essentially predictions. You are betting on what your business will be like in the future based on historical data. This means that having accurate, historical financial data is critical.  

Cash flow forecasting should be an active document that gets updated regularly. It should be used as a tool for business owners and senior leaders in your organization to use to help predict cash flow and reduce the risk of running out of funds. 

improve the accuracy of your cash flow forecast

Update for your actuals

At week or month end, its critically important to enter your actual results (the cash that was received and cash that left your bank accounts). Entering your actual cash flows for the month just passed, you will see what items you got wrong in your predictions. Assess WHY you got this wrong, it could be more sales (great!) but also could speak to a bigger issue about your assumptions for the future. This analysis will allow you to spot any issues quickly, and make adjustments before they become big problems. 

At your meeting to update the cash flow, first spend 25% of your time assessing your predictions VS actuals, and the remaining 75% of time considering how this looks for the next 12 months..  

Here are some additional tips to help you improve the accuracy of your cash flow forecasts: 

  • Constantly evaluate all of your assumptions, especially when it comes to sales. Just because an assumption is correct now doesn’t mean it will be in the future. For every line item, go through and validate it. 
  • Include any annual payments, estimated taxes, loan payments, and credit card debt payments. 
  • Don’t rely on a forecast any longer than one year out. It is nearly impossible to predict the nuances of your business three years from now. The further out your models go, the more risks and uncertainty you’ll introduce. 

Avoid these 4 cash flow forecasting mistakes 

Here are some of the frequently made mistakes to be wary of when managing cash flow for your business.

1. Assume their business will continue to grow and go up and to the right each month 

Naturally, people don’t want to predict sales declines or negative growth. However, being overly optimistic or aggressive about your assumptions of sales can be a catastrophic mistake. You need to be honest with yourself about future projections and account for scenarios where sales may decline.

One strategy to counter overly optimistic forecast models is to get better at analyzing existing trends in your business.

For example, if you are an eCommerce business that typically does 75% of your annual revenue in Q4 and last year sales were down 10%, you’ll want to adjust your forecasts to this new reality. 

3. Making business decisions based on incomplete financial data  

If you don’t update your projections whenever something happens in your business to affect cash flow, then you won’t be working off of accurate numbers. Reduce the risk of this mistake by staying on top of your bookkeeping on a regular basis (ideally weekly). 

4. Lack of communication among key stakeholders 

When all relevant financial advisors and team members aren’t in the loop, it’s easy to miss important pieces of information that might affect the business in the year ahead. Develop communication channels, such as a weekly or monthly meeting, to keep everyone informed and aligned. 

Whether you’re cutting expenses in survival mode, or predicting your sales in growth mode, it’s important to have a clear picture of the cash in your bank account. Remember, cash is king. Business owners that have a handle on their cash flow are in a better position to make important decisions for the future health of their business.  

Revenue is vanity, profit is sanity, and cash is reality! 

If you need help creating a cash flow forecast for your business, we can help. Simply book a discovery call with a Financial Coach to chat through your current challenges and work out a plan to get you on the right path!

Want to learn more about the top 8 metrics to focus on for growth, how to pay yourself properly, and common mistakes small business owners make with managing finances? Watch our free 50-min video training – Financial Reporting for Agency Owners.

financial reporting for agency owners

Posted By

Michael Wark

Michael Wark

As a VCFO, Michael helps guide entrepreneurs on their journey to grow profitable businesses and have a clear picture of where they are going. Michael brings business owners peace of mind around their business finances through a tested system and a healthy dose of accountability and motivation.

Related Articles