Cash Flow Forecasting How to Predict Your Business Cash Position Before Problems Arise

Introduction

Profit is an opinion. Cash is a fact.

A business can show a profit on its income statement and still run out of money. This happens when customers pay slowly, inventory absorbs cash, or expenses land before revenue arrives. The income statement records what you earned. The cash flow forecast records what you can actually spend.

This guide walks you through building a cash flow forecast from scratch. It covers the 13-week rolling method used by finance teams, the difference between forecasting and budgeting, and what to do when your forecast reveals a gap. By the end, you will have a practical system for predicting your cash position before problems arise.

What a Cash Flow Forecast Actually Is

A cash flow forecast is a projection of when money will enter and leave your business bank account over a future period. It is not a record of sales or expenses incurred. It is a record of cash movements — actual deposits and actual withdrawals.

The forecast answers three questions:

• How much cash will I have? — the projected balance at any point in the period
• When will it arrive? — the timing of customer payments and other inflows
• When will it leave? — the timing of supplier payments, payroll, taxes, and loan repayments

The US Small Business Administration offers a 12-month cash flow projection workshop built around a one-page spreadsheet, emphasizing that estimates are welcome even without perfect data .

The forecast is a management tool, not a compliance document. Its purpose is to give you visibility. When you can see a cash gap forming three weeks from now, you have time to act. Without a forecast, that gap becomes an emergency.

Forecast vs Budget: The Critical Difference

Budgets and cash flow forecasts are often confused because they use similar data. They are not the same tool.

A practical example makes the distinction clear. If you pay $2,400 in annual accounting fees, your budget shows $200 per month. Your cash flow forecast shows $2,400 in the month the bill is paid. The budget smooths. The forecast captures reality.

Both tools are useful. The budget tells you whether you are on track for profitability. The forecast tells you whether you can pay next week's payroll.

Step 1: Choose Your Forecast Period

Different periods serve different purposes. Most small businesses benefit from running two forecasts simultaneously.

The 13-Week Rolling Forecast

This is the standard for short-term cash management. Thirteen weeks aligns with a financial quarter, giving you a rolling view of near-term liquidity that is close enough to influence decisions. Monthly forecasts are too coarse — a payroll run, a tax payment, and a delayed customer payment can all land in the same week and create a gap that a monthly view would miss.

The 12-Month Forecast

For longer-term planning, a 12-month forecast broken into monthly periods helps you plan tax obligations, time equipment purchases, and identify seasonal patterns. The SBA offers a 12-month cash flow projection template through SCORE that works well for this purpose .

Step 2: Record Your Opening Balance

Your forecast starts with the cash you actually have, not the cash your accounting system says you have.

There is a difference between your book cash balance and your bank balance. Outstanding checks, pending deposits, and automatic payments that have not yet cleared create a gap. For forecasting purposes, use the bank balance — what is actually available to spend .

If you have multiple accounts, consolidate them into a single starting figure. The forecast tracks total liquidity, not account-by-account detail.

Step 3: Estimate Cash Inflows

Cash inflows are money entering your bank account. For most businesses, customer payments are the largest source, but not the only one.

Categories to include:

• Customer payments for sales and services
• Loan proceeds or line of credit draws
• Tax refunds or government rebates
• Sale of assets
• Owner capital contributions

Record payments when you expect to receive them

This is the most important rule in cash flow forecasting. Do not record revenue when you invoice a customer. Record it when you expect the payment to hit your bank account.

If your payment terms are 30 days but your customers typically pay in 45, forecast 45. If your largest customer always pays two weeks late, build that into your assumptions .

Step 4: Estimate Cash Outflows

Cash outflows are money leaving your bank account. They include both regular payments and irregular ones that are easy to forget.

Categories to include:

• Supplier and vendor payments
• Payroll and contractor payments
• Rent, utilities, and insurance
• Loan repayments and interest
• Tax payments
• Software subscriptions and professional fees
• Equipment purchases and capital expenditures

Record payments when you expect them to leave your account, not when you receive the invoice. If you plan to pay a supplier in 30 days, record the outflow in 30 days .

For one-time costs, note them in the month or week they occur. Annual insurance premiums, quarterly tax payments, and equipment purchases can all create spikes in outflows that a smooth monthly average would hide.

Step 5: Calculate Your Running Balance

With inflows and outflows estimated, calculate your projected balance for each period.

The formula for each period:

• Opening balance + Total inflows − Total outflows = Closing balance
• The closing balance becomes the opening balance for the next period

The running balance is where the forecast becomes useful. It shows you not just whether you will have cash at the end of the period, but whether you will have cash in week four, week seven, or week eleven.

A forecast might show a healthy balance at year-end while revealing a two-week gap in March. The annual view hides the problem. The weekly view exposes it.

Step 6: Update and Refine Weekly

A forecast built once and filed away is useless. The value comes from the weekly discipline of updating it.

The rolling process

Each week, drop the completed week from the beginning of your 13-week forecast. Add a new week at the end. Convert last week's forecast to actuals. This keeps your forecast always looking exactly 13 weeks ahead .

Variance analysis

Compare actual cash movements against what you predicted. When they differ, categorize the variance:

• Timing differences — a customer paid in week 5 instead of week 4. These self-correct and need no action.
• Systematic errors — you consistently underestimate collections by 10%. This requires updating your assumptions.
• One-off events — an emergency repair. Document it but do not revise your methodology.

The goal of variance analysis is not perfect prediction. It is understanding where your assumptions are wrong so you can correct them. Forecasts improve with each cycle of predict-compare-adjust.

Real-World Forecast Example

Here is a simplified 4-week cash flow forecast for a small business with irregular customer payments and a quarterly tax payment.

This forecast reveals a pattern. Weeks 1 and 3 are tight because payroll and rent fall in those weeks. Week 4 is tighter because the quarterly tax payment of $7,500 lands alongside supplier payments.

With this visibility, the business can plan. It might schedule supplier payments for week 2 when cash is higher. It might set aside tax money in weeks 1 and 2 rather than facing the full $7,500 in week 4. The forecast enables decisions that would otherwise be reactive.

Use our Cash Burn Rate Calculator to project how long your current cash reserves will last at your current spending rate.

What to Do When Your Forecast Shows a Gap

A forecast showing a gap is not a failure. It is the forecast doing its job. The gap you see today is a problem you can address. The gap you do not see is an emergency.

Options for closing a projected gap:

Accelerate inflows

• Follow up on overdue customer invoices
• Offer early-payment discounts to customers who can pay sooner
• Invoice immediately for completed work rather than at month-end

Delay or reduce outflows

• Negotiate extended payment terms with suppliers
• Defer non-critical purchases and capital expenditures
• Reduce discretionary spending

Access external funds

• Draw on an existing line of credit
• Apply for a short-term business loan
• Use a business credit card for bridge expenses (with caution)

The best option depends on the size of the gap and how long it lasts. A one-week timing difference might need no action. A three-month structural deficit requires a more significant response.

Related Calculators

Use these MoneyTool calculators to model and manage your cash position:

Related Learning Center Guides

Authoritative Resources

For additional guidance from official sources:

• U.S. Small Business Administration (SBA): Manage Your Finances — guidance on bookkeeping, accounting methods, and financial management.
• SCORE (SBA Resource Partner): Cash Flow Projection Model — free detailed spreadsheet template for building cash flow forecasts.
• Federal Deposit Insurance Corporation (FDIC): Money Smart for Small Business — free curriculum including cash flow management modules.

Frequently Asked Questions