Cash Flow Forecasting: A How-To Guide (With Templates)


Janet Berry-Johnson, CPA


Reviewed by


May 30, 2023

This article is Tax Professional approved


Most small business owners just want their accounting done so they can focus on doing what they love. But tracking and forecasting cash flow—despite the time and effort required—is essential for starting, operating, and expanding a business.

What's Bench?
Online bookkeeping and tax filing powered by real humans.
Learn more
Friends don’t let friends do their own bookkeeping. Share this article.
Tired of doing your own books?
Try Bench

In 2018, CB Insights analyzed 101 failed startups and found that running out of cash was the second most common cause of failure, impacting 29% of businesses.

To avoid that fate, you need a cash flow forecast to help you estimate how much your cash outflows and inflows will affect your business.

What is a cash flow forecast?

A cash flow forecast (also known as a cash flow projection) is like a budget, but rather than estimating revenues and expenses, it estimates cash coming in and going out based on past business performance.

It’s not uncommon for a business to experience a cash shortage, even when sales are good. This usually happens when customers are allowed to pay after the product or service is delivered. In cases like these, a business owner must plan how they will cover costs before receiving the payment.

For example, say Hana Enterprises ships $50,000 worth of security products to customers in January, along with invoices that are due in 30 days. The company will have $50,000 of revenues for the month but won’t receive any cash until February. On paper, the business looks healthy, but all of its sales are tied up in the accounts receivable. Unless Hana Enterprises has plenty of cash on hand at the beginning of the month, they will have trouble covering their expenditures until they start receiving cash from clients.

With a cash flow forecast, you ignore sales on credit, accounts payable, and accrued expenses, instead focusing on the revenue you actually expect to collect and the expenses you actually expect to pay during a given period. You can also use the information provided on past cash flow statements to estimate your expenses for the period you’re forecasting for.

(If you just want to dive into cash flow forecasting, check out our free cash flow forecast template.)

The benefits of cash forecasting

Cash forecasting may sound like something boring that accountants do in big companies. Not so! It’s absolutely essential for every single business. Here’s why:

  • It helps you identify potential problems. Cash forecasting can help you predict the months in which you’re likely to experience a cash deficit and make necessary changes, like changing your pricing or adjusting your business plan.
  • It decreases the impact of cash shortages. When you can predict months in which you might experience a cash shortage, you can take steps to plan for them. You might save more in months where you have a surplus, step up your receivables collection efforts, or establish a line of credit with your bank to guarantee enough working capital to last the period.
  • It keeps suppliers and employees happy. Late payments and missing paychecks damage your reputation with suppliers and employees. When you can predict how much money you’ll have on hand in any given month, you can confirm that you’ll be able to meet your payroll obligations and pay suppliers by the due date.

Free cash flow forecast template

To make this a lot easier, we’ve created a business cash flow forecast template for Excel you can start using right now.

Access Template

The template has three essential pieces:

  1. Beginning cash balance. This is the actual cash you expect to have on hand at the beginning of the month. It should include bank accounts, PayPal, Venmo, anything you use that’s currently holding just business funds. This information can be found on your balance sheet.
  2. Sources of cash. These are all of your cash inflows each month. It can include cash sales, receivables collections, repayments from money you’ve loaned out, etc.
  3. Uses of cash. This is every expense your business may incur, including payroll, payments to vendors, utilities, rent, loan payments, etc.

Here’s an example of a completed cash flow projection for a three month period:

Hana Enterprises, Inc.

Cash Flow Projection

January to March 2022

January February March
A. Operating Cash, Beginning 9,000 24,000 2,000
Sources of Cash:
Receivables collections 60,000 50,000 55,000
Customer deposits 10,000 3,000 5,000
B. Total Sources of Cash 70,000 53,000 60,000
Uses of Cash:
Payroll and payroll taxes 20,000 20,000 20,000
Vendor payments 12,000 15,000 18,000
Rent 8,000 8,000 8,000
Equipment loan payments 5,000 5,000 5,000
Purchase of computers 0 15,000 0
Other overhead payments 10,000 12,000 13,000
C. Total Uses of Cash 55,000 75,000 64,000
D. Change in Cash During the Month (B - C) 15,000 (22,000) (4,000)
Ending Cash Balance (A + B) 24,000 2,000 (2,000)

As you can see from the example above, Hana Enterprises expects to have a cash shortage in March. This results from a negative net cash flow (when more cash goes out than comes in). Knowing that information ahead of time, the company can take steps to prevent the shortage from occurring.

Hana Enterprises has several options to avoid this shortage in March. They might secure a line of credit from the bank, purchase fewer computers in February, negotiate longer payment terms from vendors, contact late-paying customers to speed up the collection of receivables, or take other cost-cutting measures to reduce their overhead expenses.

When you’re ready to get started, download your copy of the cash flow forecasting sheet here.

How Bench can help

Use Bench’s simple, intuitive platform to get all the information you need to project your cash flow. Each month, your transactions are automatically imported into our platform then categorized and reviewed by your personal bookkeeper. Bench helps you stay on top of your business’s top expenses so you can make informed budgeting decisions on the fly. Explore our platform with a free tour today.

Tips for improving your cash flow spreadsheet

Keep in mind: a cash flow forecast isn’t something you create once a year and never look at again. It’s a living, breathing business tool you should review and update on a monthly basis.

Though projections are helpful, they can’t perfectly predict the future. As the months pass, you should expect to see that your projections aren’t quite matching up with your actual results. That means it’s time to re-run your forecast to take into account these differences.

To improve the accuracy of your cash flow worksheet, consider the following:

  • Account for extra pay periods. If you pay employees bi-weekly, make sure your projection takes into account any months with three payrolls.
  • Remember annual payments. If certain insurance policies, subscriptions, or other expenses are paid annually rather than monthly, be sure to include them in your spreadsheet.
  • Remember estimated tax payments. For most calendar-year businesses, estimated tax payments are due on April 15th, June 15th, September 15th, and January 15th.
  • Don’t forget about savings. Try to allocate a portion of any cash surpluses to save for lean months.
  • Identify seasonal fluctuations. If you’re expecting a period of time with lower sales, make sure your forecast reflects this so you can have enough cash on hand to ramp up when business picks up again.
  • Don’t forecast too far out. Creating a rolling 12-month cash flow forecast that you update at the end of each month can help you identify issues before your business faces financial troubles, but don’t try to forecast more than 12 months out. The longer the reporting period you want to forecast, the more likely you’ll end up spending a lot of time creating a cash flow projection that doesn’t provide any useful information.

Your cash flow forecast is key to good cash flow management. Try to account for all cash sources and uses in your projection and maintain an emergency fund or backup plan to ensure you don’t get sidelined by slow-paying customers or unexpected expenses. When you do, this simple but valuable tool can help you keep an eye on cash and ensure you don’t compromise growth or put your business in jeopardy.

This post is to be used for informational purposes only and does not constitute legal, business, or tax advice. Each person should consult his or her own attorney, business advisor, or tax advisor with respect to matters referenced in this post. Bench assumes no liability for actions taken in reliance upon the information contained herein.
Friends don’t let friends do their own bookkeeping. Share this article.

Join over 140,000 fellow entrepreneurs who receive expert advice for their small business finances

Get a regular dose of educational guides and resources curated from the experts at Bench to help you confidently make the right decisions to grow your business. No spam. Unsubscribe at any time.