accounting

5 Steps to Preparing a Cash Flow Forecast

An accurate cash flow forecast is a critical tool that reveals the real-time financial health of your business. It measures vital metrics, like how much cash is coming in? How much money is going out? Are expenses creeping up? How accurate is your projection? A comprehensive and precise forecast can answer these questions and more.

Discover the best cash flow software for your business.


1. Don’t Confuse Small Business Cash Flow with Revenue

Both of these terms are key performance indicators used to evaluate your company’s financial health. Revenue illustrates how effective your company is when it comes to sales and marketing, but cash flow is more an indicator of your overall liquidity. Your small business cash flow includes revenue, but also sources of money outside your day-to-day sales. Your company often makes money in several ways that don’t rely on how you conduct your operations.

Revenue only measures the amount of money coming into your business with nothing else factored in. Cash flow measures this also, but it also measures cash that flows into or out of your doors for other reasons. It is different from revenue because there’s the potential for your cash flow figures to result in a negative value.

A primary reason why cash flow is so important is that it’s a key indicator of your company’s functionality – if you suddenly lost a significant client tomorrow, would you still be able to keep your doors open? Having a sufficient amount of cash means that short-term obstacles won’t get in the way of long-term goals.

2. Identify What’s Coming In and What’s Going Out

While this might be obvious, you can’t run an accurate cash flow forecast without knowing the figures. This forecast details your company’s position in relation to what you have coming in versus what you have going out. To begin, figure the amounts of cash coming in for the time frame you’re forecasting. Where is it coming from? In this equation, you’re not thinking how much you’re able to produce, but instead the payments you foresee collecting for your products or services.

Looking at past years’ numbers for the time frame you’re forecasting is an excellent starting point – but don’t forget to take into account various factors, such as buyer confidence during that past period, as well as confidence in small business, especially if you’re reliant on business-to-business sales. As a small business owner, you know sales aren’t consistent. Opening up lines of communication with other small business owners can help you better gauge these levels of confidence giving you valuable insight into aspects of your company that can impact your figures, negatively or positively.

In your forecast, allow flexibility for any one-off payments that might come up down the road. These figures can include:

  • Purchases of business equipment
  • Training for new hires
  • Annual bonuses
  • Loan setup fees

If you’re unsure if any of these expenses might show up, it’s better to use your business savvy and include them as a safety precaution. This aspect of your cash flow forecast can also include surprise inflows of cash you weren’t expecting. A detailed estimation of your incoming cash flow might consist of:

  • Rebates and refunds
  • Additional capital from partners
  • Approved grants
  • Loans you gave are paid back
  • Sale of an asset
  • Royalties
  • Other miscellaneous fees

Once you prepare all the necessary data and decide on the time frame for your forecast, you need your beginning bank account balance for that period. This amount is also known as cash on hand. Next, add all the projected inflows of capital and subtract the projected outflows. If you have a positive number, great. If not, you might have to readjust your planning for that period.

At the end of the period you forecasted, review your estimate against your actual cash flow. If anything in your forecast didn’t measure up, this gives you a vibrantly clear picture as to why.

3. Create Scenarios

When you’re forecasting your future cash flows, imagining different scenarios can be incredibly helpful. For example, in 2018, Canada levied a tariff on steel products coming from the United States in response to a proposed 25% tariff on all Canadian automobiles coming into the United States. Is your industry one that could experience the imposition of taxes soon? What would happen to your company if it did?

Say you’re the owner of a lumber mill and there’s a wildfire in the forests surrounding your area. That not only means you can’t cut any more wood until the fires have been put out but depending on your local zoning and proximity to the fire, you may not even be able to operate your mill. Scenarios like these happen every day to unsuspecting businesses.

Forecasting a cash flow model that includes unforeseen circumstances can help you avoid a reactionary scramble later down the line.

4. Gather the Right Input from the Right People

Asking for advice from other small businesses like yours is one of the best ways to discern what changes need to be made to your current cash flow forecasting model. Sometimes, what you’re already doing requires a bit of tweaking to ensure your forecast numbers are as accurate as possible. Some of the aspects of your current forecasting methods may be returning incorrect figures concerning:

  • Amount of data
  • Fluctuations in payables and receivables
  • Slow pay-offs
  • An unusually high amount of inventory

Not enough data

Like many small business owners, your time is probably split half-and-half – ensuring your customers are happy and making sure your staff is on the ball. Juggling these two aspects of your business continually means you might let your financial management fall to the wayside. But the only way you’re going to have accurate outcomes of your cash flow forecasts is by keeping track of your historical financial data. What happens to your business in the summer? What happens around the holidays? Do you have a track record of purchasing too much inventory in the hopes of fantastic sales, only to have much of that stock remaining long after the holidays have passed? If you don’t keep track of this historical information, projecting anything for the future can be difficult. Even just one year of data can suffice in most cases.


Fluctuations in payables and receivables

If you base your forecasting on the average number of days it usually takes for each client to pay you, what happens if that client suddenly begins paying later than usual? It can wreak havoc on your figures. If you have large accounts that you count on for much of your cash flow, it’s essential to monitor these clients more often than others.

The same can be said in reverse, as well – what if you usually pay your suppliers every 15 days, but you decide to let a couple slide for just a bit? This can have an impact on your outflows and temporarily, aesthetically boost your numbers.

If you end up having an unforeseen expense before paying these suppliers, it can mess with your bottom line.

Small business payroll

Another aspect of these types of fluctuations can occur within your small business payroll. For instance, labour expenses during the holiday months may be higher than usual, with employees working longer hours to accommodate holiday shoppers. Just one or two team members going into overtime can mean a higher output of cash come payday. Using an online payroll system can ease some of the stress during the holidays, and throughout the year.

Slow return on investment

There are many ways you can invest in your company, from purchasing new equipment to hiring new employees. The idea is that after a certain period, this investment pays for itself, and then begins to earn more money for the company. Sometimes it doesn’t work that way. New investments sometimes are very slow to generate returns, and some don’t ever entirely pay off the way you expected. Be wary when including these types of figures in your cash flow forecasts.


An unusually high amount of inventory

This can happen for a variety of reasons, not the least of which is an overabundant purchase just before the holidays in hopes of making a killing. If these products don’t sell, though, you’re left with stock that could drain your cash flow. Reviewing your inventory trends throughout the year can help you better analyze the amount you need at any given time of the year. While it’s better to have too much rather than not enough, finding a happy medium can help your business thrive.

5. Monitor, Adapt, and Pivot – Direct and Indirect Cash Flow Forecasting

Direct cash flow forecasting

This method of cash flow forecasting lets you manage your liquidity in the short term. This method aims to illustrate how your cash moves into and out of your company at specified future dates. To run this forecast, you typically enter payments and receivables as occurring on a specific day, or during a particular week or month. Then the figures are combined to cover the length of time for which you’re running your cash flow forecast. For this method to be useful, your time frame should be 90 days or less, though some companies can successfully project as far out as one year.

Indirect cash flow forecasting

The indirect method is used when you create your budget as part of your planning stage. You use figures from income statements, balance sheets, and other essential accounting documents to project your future cash flows. There are three different ways you can use indirect cash flow forecasting:

  • Adjusted Net Income (ANI): Calculates your projected cash flows from operating income figures with balance sheet changes and accounts payable and receivable factored in.
  • Balance Sheet (PBS): Use the ending data from a predicted balance sheet to calculate your cash balance for a future date; if all other accounts have been appropriately projected, your cash account is, as well.
  • Reversed Accrual Method (RAM): A hybrid of the above two methods that uses statistics to calculate the figures from both, reversing substantial accruals, thereby calculating how your cash flows in one specific period.


The Best Cash Flow Forecasting Software

QuickBooks

You might want to look at how QuickBooks cash flow forecasting features empower you to make detailed projections based on your revenue and expenses. QuickBooks Online allows you to generate cash flow reports, make smarter decisions, spend your time more wisely, and help your company perform better. Ranked as the #1 category leader in Billing & Invoicing by GetApp, the Quickbooks mobile app lets you create and send invoices and track expenses from anywhere so that you’re always on top of these key cash flow drivers.

Pulse

Pulse cash flow projection software application integrates with QuickBooks seamlessly. You can connect your QuickBooks Online account to track your cash on hand every day, week, or month and make accurate financial projections. Pulse lets you organize your income and expenses by account, project, category, or company. A feature allowing you to attach material such as a contract or an invoice to individual income or expense items enhances your document organizing and simplifies tax time. Your transactions post in real time, giving you up-to-date data for your calculations. Whether you own a small business or are an accountant with small business clients, this cash flow software might improve your business’s operation efficiency.

PlanGuru

PlanGuru lets you take a proactive stance in your analytics, cash management, and budgeting responsibilities. This cloud-based financial forecasting software for small business offers analysis from 20 different forecasting methods. You can customize the software, analytics, and system reports for your type of business, and import up to five years of data from QuickBooks to fine-tune your calculations based on past results. Security features allow you to set four data access levels, giving you greater control in protecting your information,

Forecasting your cash flows might not be the most fun task to perform, but it is vital. This process illustrates how much you’re likely to generate and whether funding future expansions is a good idea. Your cash flow forecasts aren’t going to be spot-on, but over time you’ll notice patterns and be able to predict your company’s future with increasing accuracy. Using an accounting system, such as QuickBooks Online, you can generate a Profit and Loss statement automatically. Learn how today.


Related Articles

Your privacy

We collect data when you use our website to improve its performance. Doing so also helps us provide a secure, personalized experience. Select 'Accept cookies' to agree or 'Cookies settings' to choose which cookies we use. You can change your preferences anytime by clicking the 'Manage cookies' link in the footer.

Choose your cookie preferences

Some cookies are needed to make our website work and can't be turned off. But we need your consent to use others that are not essential. You can make your choices below and update them at any time using the 'Manage Cookies' link. To find out more, visit our Cookies Policy.

These cookies are necessary for the site to function. They also help us keep your data safe.
These cookies allow us to enhance your experience and remember your preferences, region or country, language, and accessibility options.
These cookies tell us how customers use our website. We study and organize this data to help us optimise our content and provide you with personalised experiences.
These cookies help us provide you with relevant communications and ads in our products and on other sites.

Looking for something else?

Get QuickBooks

Smart features made for your business. We've got you covered.

Firm of the Future

Expert advice and resources for today’s accounting professionals.

QuickBooks Support

Get help with QuickBooks. Find articles, video tutorials, and more.