Disclaimer: The information provided in this blog is for general informational purposes only and does not constitute legal, tax, or accounting advice. Nothing on this site should be relied upon as a substitute for professional advice from a licensed attorney, CPA, or financial advisor. Please consult a qualified professional before making any financial or legal decisions.
Cash flow forecasting is the process of estimating the money that will come into and go out of a business over a future period, so you can see shortfalls and surpluses before they happen. It matters because a business can be profitable on paper and still be unable to make payroll next Friday.
This guide explains how a forecast differs from profit reports, budgets, and cash flow statements, what goes into one, and how to build one in a spreadsheet. It also covers the two main forecasting methods, the mistakes that make forecasts useless, how to keep one current, and the signs that it is time to bring in a CPA or bookkeeper.
Cash Flow Forecasting vs. Profit, Budgets, and Cash Flow Statements
Several reports get confused with a forecast, and each answers a different question.
Profit versus cash. Profit is an accounting measure. It counts revenue when you earn it, even if the customer has not paid, and it deducts non-cash items such as depreciation. Cash is what is actually in your bank account. The two can diverge sharply, which is why a profitable business can still run out of money. This difference comes down to accrual accounting, which records revenue and expenses when they are earned or incurred rather than when cash moves.
Forecast versus cash flow statement. A cash flow statement looks backward. It reports what happened to your cash over a finished period, as covered in this cash flow statement explained guide. A forecast looks forward and estimates what is expected to happen. One is a record, the other is a planning tool.
Forecast versus budget. A budget is a spending plan and a target: what you intend to spend and earn. A forecast is your best estimate of what will actually occur, and it gets revised as reality changes. If a big customer delays payment, your budget stays the same but your forecast should change immediately.
Here is a simple illustration with made-up numbers. Suppose a company invoices $40,000 for a project in March, on net-60 terms, meaning the customer has 60 days to pay. In March it still pays $28,000 in supplier bills and payroll. Its March income statement shows a $12,000 profit, but its bank balance has dropped by $28,000, because the customer's money will not arrive until May. If the opening balance was only $20,000, the company is short before the customer ever pays.
That gap is exactly what a forecast is built to reveal. It also resolves a common misconception: a forecast does not need to be exact. It needs to be good enough to show you when trouble is likely and how large it might be.
The Building Blocks: Cash Inflows, Cash Outflows, and Opening Balance
Every cash flow forecast, whatever its format, is built from the same three pieces. The opening cash balance is the money you have at the start of a period. Expected inflows are the cash you anticipate receiving during it. Expected outflows are the cash you anticipate paying out. Opening balance plus inflows minus outflows gives the closing balance, which becomes the next period's opening balance. The difference between inflows and outflows in a single period is your net cash flow.
Inflows to list
- Customer payments. Time these by when customers actually pay, not by invoice date.
- Loan proceeds, such as a term loan or a draw on a line of credit.
- Owner contributions, if you plan to put in personal funds.
- Asset sales, such as selling old equipment or a vehicle.
- Tax refunds, entered only when you have good reason to expect them and a realistic date.
Outflows to list
- Payroll, including employer taxes and benefits
- Rent or lease payments
- Supplier and inventory payments
- Loan principal and interest repayments
- Estimated tax payments
- Insurance premiums
- Annual or quarterly bills that are easy to forget, such as licenses, software renewals, and professional fees
Accountants group cash flows into three categories. Operating flows come from running the business day to day. Investing flows involve buying or selling long-term assets. Financing flows involve borrowing, repaying, and owner contributions or withdrawals. Most small business forecasts can start with operating items alone, then add investing and financing lines as they become relevant, for example when you plan an equipment purchase or a loan payment schedule begins. If you are still wrestling with the basics, this guide to taking back control of cash flow management is a good companion.
How to Build a Cash Flow Forecast Step by Step
A spreadsheet is enough to start. You do not need specialized software to get real value from a forecast, and you can move to accounting-software tools later if the spreadsheet becomes unwieldy. If you do outgrow it, see these financial forecasting solutions for small businesses.
- Choose the horizon and interval. A 13-week forecast with weekly columns suits near-term liquidity management: it shows exactly which week the account gets tight. A 12-month forecast with monthly columns suits planning, such as hiring or seasonal swings. The tradeoff is detail versus reach. Weekly columns are more precise but harder to project far out; monthly columns are easier to maintain but can hide a mid-month crunch. Many businesses keep both.
- Set the opening balance from the bank reconciliation. Use the reconciled figure, not memory or the number on your banking app, which may not reflect outstanding checks or pending deposits.
- Project inflows. Start with your receivables aging report, which lists unpaid invoices by how overdue they are. Apply your historical days-to-pay, the average time customers take to settle an invoice. Then add expected sales from your pipeline, delayed by the same payment lag.
- Project outflows. Enter fixed commitments first (rent, loan payments, insurance), then variable costs (materials, commissions, utilities), then one-time items (equipment, repairs, annual fees). For estimated tax payments, confirm current due dates and amounts with a CPA or the IRS, as rules and deadlines can change. A quarterly tax payment calculator can help you estimate what to set aside.
- Calculate net cash flow and closing balance for each period. Then choose a minimum cash buffer, an amount you never want to drop below, perhaps enough to cover a few weeks of fixed costs. Highlight every period where the closing balance falls under it.
A basic layout looks like this, with rows down the side and periods across the top:
- Opening balance
- Cash in: customer payments, other receipts, total inflows
- Cash out: payroll, rent, suppliers, loan payments, taxes, other, total outflows
- Net cash flow (total inflows minus total outflows)
- Closing balance (opening plus net cash flow)
- Minimum buffer and a flag for any shortfall
Direct vs. Indirect Forecasting Methods
The steps above describe the direct method, but there is a second way to arrive at a forecast.
The direct method forecasts actual cash receipts and payments: what customers will pay and when, what you will pay and when. It mirrors your bank account, so it is the better choice for short-term, weekly liquidity management. Its weakness is that it takes more effort to maintain over long horizons, because every receipt and payment needs its own estimate.
The indirect method starts from projected net income and adjusts it to arrive at cash. You add back non-cash items such as depreciation, then adjust for changes in working capital: an increase in receivables or inventory consumes cash, while an increase in payables preserves it. This approach ties directly to your projected income statement and balance sheet, which makes it better for longer-range planning, loan applications, and investor conversations.
Which fits depends on your business. A seasonal retailer that buys inventory ahead of a peak and watches its bank balance week by week will usually get more from the direct method. A firm with long customer payment terms, like the net-60 example earlier, may use the direct method to manage the next quarter and the indirect method to see how growth will strain cash over the next year, since growing sales on slow terms ties up more money in receivables. Techniques for working capital optimization can help free up that tied-up cash.
If both methods are built from the same assumptions, they should reconcile: the closing cash balance should come out the same either way. When they do not match, one of the assumptions differs, or something has been missed or double-counted. That makes reconciling the two a useful error check, not just a technical exercise.
Common Forecasting Mistakes and How to Avoid Them
Most forecasts fail in predictable ways. Watch for these.
- Assuming customers pay on time. If your terms are net-30 but customers average 45 days, your forecast is 15 days too optimistic on every invoice. Calculate the actual average days-to-pay from your past invoices, ideally by customer or customer type, and use that.
- Forgetting irregular costs. Quarterly estimated taxes, annual insurance premiums, license renewals, and equipment repairs do not show up every month, so they slip out of mind. Review last year's bank statements line by line to catch them, and confirm current tax payment timing with a CPA or the IRS, since deadlines can change.
- Building one optimistic scenario. A single forecast gives a false sense of certainty. Run at least three: a base case with your most realistic assumptions, a downside case (sales fall by a set percentage, or your largest customer pays 30 days late), and an upside case. The downside case is the most useful, because it tells you how much cushion you really have.
- Never comparing the forecast with actuals. A forecast you set once and ignore becomes fiction within weeks. Each period, compare forecast against actual cash, note the biggest variances, and ask why. Over time this teaches you where your assumptions are weak.
- Confusing when an expense is incurred with when it is paid. A bill dated in March but due in April is an April cash outflow. A forecast tracks the payment date, not the date the cost was recorded. The same applies in reverse for customer invoices.
None of these requires sophisticated tools to fix. They require discipline about using real payment data and revisiting the numbers on a schedule. Many of these errors are the same ones behind broader cash flow management problems.
Keeping Your Forecast Useful and Knowing When to Get Help
A forecast earns its keep through upkeep. For a 13-week forecast, update it weekly: replace last week's estimates with actuals, then add a new week at the end so the horizon always stays 13 weeks. For a 12-month forecast, roll it forward monthly in the same way. Each update is also a chance to compare forecast to actual and adjust your assumptions, such as days-to-pay or seasonal sales patterns.
Once the forecast is reliable, it supports concrete decisions:
- Timing a hire or equipment purchase for a period when cash can absorb it, instead of when it merely feels affordable.
- Deciding whether to seek a line of credit early. Lenders generally respond better to a business that asks while its finances are healthy than to one in the middle of a shortfall. A forecast showing a dip months ahead gives you time.
- Setting collection policies, such as shorter terms, deposits, early-payment discounts, or a firm follow-up schedule for overdue invoices, based on how much slow payment is actually costing you.
Some situations call for a CPA or bookkeeper. Consider involving one if you have complex tax obligations, carry significant inventory, operate multiple entities, or are preparing a financing application where lenders will scrutinize your projections. If forecasting is becoming a regular strategic need, fractional CFO services can provide senior financial guidance without a full-time hire. A professional can also check that your assumptions are sound and that tax payments are timed correctly under current rules. This article is general information, and decisions about taxes, legal structure, or financing should rest on advice specific to your business.
Start With One Spreadsheet This Week
A cash flow forecast is a simple, regularly updated view of the money you expect to receive and spend. It does not have to be precise to be valuable. It only has to be honest enough to warn you about a shortfall while you still have time to act.
Open a spreadsheet this week and set up either a 13-week or a 12-month forecast. Start with your reconciled bank balance, add your known fixed costs, and enter receivables using how long customers really take to pay. Then review it on a fixed schedule. When your situation involves taxes, financing, or anything beyond the basics, have a qualified accountant look at your specific numbers.
Schedule a call and discover how we can help your business grow.