Cash Flow Forecasting: How to Predict Your Business Cash Flow

Cash flow forecasting is the process of estimating how much money will come into and leave your business over the next several weeks or months. It is the single most effective way to avoid running out of cash, because it turns “I hope we can cover payroll” into “I know exactly when we’ll be tight, and here is the plan.”

If you have ever been surprised by an empty bank account despite having plenty of invoices out, you already understand why forecasting matters. This guide walks you through everything: the three main forecasting methods, a step-by-step process for building a 13-week forecast, a worked example with real numbers, and the common mistakes that trip up most small business owners.

Why Cash Flow Forecasting Matters for Small Businesses

According to a U.S. Bank study, 82% of small businesses that fail cite cash flow problems as a primary factor. Not lack of revenue. Not bad products. Cash flow timing.

Here is the thing about running a business: money doesn’t move in a smooth, predictable stream. Clients pay late. Expenses cluster together. Tax bills hit all at once. A cash flow forecast gives you the ability to see these collisions before they happen.

What forecasting actually does for you:

• Prevents overdrafts and missed payments. You’ll see a shortfall two or three weeks out instead of the morning it happens.
• Improves borrowing decisions. If you need a line of credit, you’ll know exactly how much and for how long — and your banker will be impressed that you have the numbers.
• Supports growth planning. Want to hire someone? Launch a marketing campaign? Your forecast tells you whether the cash is there.
• Reduces stress. Uncertainty is what makes business finances exhausting. A forecast replaces anxiety with information.

If you’re not yet clear on the difference between cash in the bank and profit on paper, our guide on cash flow vs. profit explains why profitable businesses still run out of money.

Three Cash Flow Forecasting Methods

There isn’t one right way to forecast cash flow. The best method depends on your time horizon and how granular you need to be.

1. Direct Method (Short-Term, Transaction-Level)

The direct method lists out every specific cash receipt and cash payment you expect in a given period. You are literally forecasting individual line items: “Client A will pay $4,500 on March 24” and “Rent of $2,200 is due April 1.”

Best for: Weekly or monthly forecasts covering 1 to 13 weeks.

Pros: Very accurate in the near term. Easy for small business owners to understand because it mirrors real bank transactions.

Cons: Gets less accurate the further out you project, because you can’t predict every individual transaction months in advance.

This is the method we’ll use in the step-by-step section below, and it is the one most small businesses should start with.

2. Indirect Method (Medium-Term, Accounting-Based)

The indirect method starts with your net income from the profit and loss statement, then adjusts for non-cash items (like depreciation) and changes in working capital (like increases in accounts receivable or accounts payable).

Best for: Monthly or quarterly forecasts covering 3 to 12 months.

Pros: Ties directly to your cash flow statement, making it easy to compare forecasts against actual results. Works well for businesses with complex accounting.

Cons: Less intuitive for non-accountants. Requires accrual-based financial statements to work properly.

3. Rolling Forecast (Ongoing, Always-Current)

A rolling forecast is not really a separate method — it is a discipline. Instead of forecasting a fixed period (like Q2), you always maintain a forecast that looks a set number of weeks ahead. Each week, you drop the completed week, add actuals, and extend the forecast by one week.

Best for: Any business that wants to stay continuously informed about its cash position.

Pros: Never goes stale. Builds forecasting into your weekly routine. Gets more accurate over time as you learn your business’s patterns.

Cons: Requires weekly maintenance (though this takes just 15 to 20 minutes once you have the template set up).

Our recommendation: Use the direct method in a 13-week rolling format. You get the accuracy of transaction-level forecasting with the always-current advantage of a rolling approach.

How to Build a 13-Week Cash Flow Forecast: Step by Step

The 13-week cash flow forecast is the gold standard for small businesses. It covers roughly one quarter — enough time to see seasonal swings and plan for big obligations, but short enough that your projections stay reliable.

Step 1: Set Up Your Forecast Template

Create a spreadsheet (or use a tool like BookkeepingFlow that generates this automatically) with these elements:

• Columns: One for each of the next 13 weeks, labeled by date range (e.g., Mar 23-29, Mar 30-Apr 5, etc.)
• Rows (Cash In): Customer payments, recurring revenue, other income, loan proceeds, refunds expected
• Rows (Cash Out): Payroll, rent/lease, supplier/vendor payments, loan payments, taxes, insurance, utilities, subscriptions, owner draws, other expenses
• Summary rows: Total cash in, total cash out, net cash flow (in minus out), opening balance, closing balance

The closing balance of each week becomes the opening balance of the next week. That chain is the backbone of the whole forecast.

Step 2: Enter Your Starting Cash Balance

Open your bank account and record your current balance. If you have multiple accounts, sum them. This is your Week 1 opening balance.

Be honest about this number. Don’t include money that is earmarked for something specific (like sales tax you’ve collected but haven’t remitted yet) unless you’re also including that outflow in the forecast.

Step 3: Forecast Your Cash Inflows

Go through each of the 13 weeks and estimate what cash will come in:

• Accounts receivable. Check your outstanding invoices. When are they due? Be realistic — if a client regularly pays 10 days late, forecast the payment for when they’ll actually pay, not when the invoice says “due.” For more on managing payment timing, see our guide on Net 30 payment terms.
• Recurring revenue. Subscription fees, retainers, or contracts that bill on a regular schedule. These are your most predictable inflows.
• Expected new sales. Be conservative. Only include deals you’re highly confident will close, and forecast the payment for when you’ll actually receive the cash (not the signing date).
• Other income. Tax refunds, insurance claims, asset sales, interest income.

Rule of thumb: For uncertain income, discount it by 25 to 50%. If you think you’ll close a $10,000 deal but it’s only 60% likely, enter $6,000 — or leave it out entirely and treat it as upside.

Step 4: Forecast Your Cash Outflows

Now map every dollar going out:

• Payroll. Wages, employer taxes (FICA, FUTA, state unemployment), and benefits. Payroll is typically the largest single outflow for service businesses. Include the exact pay dates.
• Rent or lease payments. Fixed and predictable — easy to forecast.
• Supplier and vendor payments (Accounts Payable). Check your AP aging report. What bills are due in each of the next 13 weeks?
• Loan and debt payments. Monthly loan payments, credit card minimum payments, lines of credit. Include interest.
• Taxes. Quarterly estimated tax payments (mark April 15, June 15, September 15, January 15), sales tax remittances, and payroll tax deposits.
• Insurance. Monthly premiums or annual/semi-annual lump sums — make sure you have these in the right weeks.
• Utilities, subscriptions, and recurring expenses. Software, phone, internet, marketing tools.
• Owner draws or distributions. What you take out for personal income.
• Seasonal adjustments. If you know Q2 requires a large inventory purchase, or summer means higher cooling bills, put those in now.

Step 5: Calculate Net Cash Flow and Running Balance

For each week:

1. Total cash in minus total cash out equals net cash flow for that week.
2. Opening balance plus net cash flow equals closing balance.
3. Carry the closing balance forward as the next week’s opening balance.

Scan the closing balance row. Any week where it dips below your comfort threshold (for most small businesses, that means one to two months of operating expenses) is a red flag that needs a plan.

Step 6: Update Weekly

Every Monday (or whatever day you choose), do the following:

1. Replace last week’s projections with actual numbers.
2. Note the variance — were you off? By how much?
3. Adjust future weeks based on what you’ve learned.
4. Add a new Week 13 to the end so you always have a full quarter of visibility.

This weekly rhythm is what separates businesses that manage cash proactively from those that react to crises.

Worked Example: 4-Week Cash Flow Forecast

Let’s say you run a small marketing agency. You have two employees, a handful of clients, and monthly revenue around $38,000. Here is what a 4-week forecast might look like:

Category	Week 1 (Mar 23-29)	Week 2 (Mar 30 - Apr 5)	Week 3 (Apr 6-12)	Week 4 (Apr 13-19)
CASH IN
Client A — retainer	$4,500	—	—	$4,500
Client B — project payment	—	$8,200	—	—
Client C — retainer	—	$3,000	—	$3,000
Client D — final invoice	$6,000	—	—	—
Ad-hoc consulting	$1,200	—	$800	—
Total Cash In	$11,700	$11,200	$800	$7,500
CASH OUT
Payroll (2 employees)	$5,400	—	$5,400	—
Payroll taxes & benefits	$1,350	—	$1,350	—
Office rent	—	$2,200	—	—
Software subscriptions	$680	—	—	—
Contractor (freelance designer)	—	$2,500	—	—
Utilities & internet	—	$290	—	—
Quarterly estimated tax	—	—	—	$4,800
Insurance premium	—	—	$450	—
Owner draw	—	—	$4,000	—
Miscellaneous / supplies	$200	$150	$100	$200
Total Cash Out	$7,630	$5,140	$11,300	$5,000
Net Cash Flow	+$4,070	+$6,060	-$10,500	+$2,500
Opening Balance	$12,000	$16,070	$22,130	$11,630
Closing Balance	$16,070	$22,130	$11,630	$14,130

What this forecast tells you:

• Week 3 is a problem week. Cash out exceeds cash in by $10,500, mostly because of payroll, the owner draw, and insurance hitting in the same week — while very little client cash comes in. The closing balance drops to $11,630.
• But it is survivable. Because Weeks 1 and 2 build up the balance to $22,130, the business can absorb the Week 3 dip. Without the forecast, though, you might have taken a larger owner draw in Week 1 and found yourself short.
• The Q1 estimated tax payment in Week 4 is a big-ticket item. Without it in the forecast, you’d be blindsided on April 15.
• Action item: Could you move the owner draw to Week 4 (after Client A and C payments land) to keep the Week 3 balance higher? That kind of decision is exactly what a forecast enables.

This is a simplified example. Your real forecast might have 15 to 20 line items on each side. The key is that every known inflow and outflow has a home in a specific week.

What to Include in Your Forecast (Complete Checklist)

Don’t rely on memory. Use this list every time you build or update your forecast:

Cash inflows:

• Accounts receivable (outstanding invoices with expected payment dates)
• Recurring revenue (retainers, subscriptions, membership fees)
• New sales or contracts (signed, with expected payment schedule)
• Refunds or rebates expected
• Loan proceeds or credit line draws
• Tax refunds
• Asset sales
• Interest or investment income

Cash outflows:

• Payroll (gross wages for all employees)
• Employer payroll taxes (Social Security, Medicare, FUTA, state unemployment)
• Employee benefits (health insurance, retirement contributions)
• Rent or mortgage
• Supplier and vendor payments (accounts payable)
• Loan repayments (principal plus interest)
• Quarterly estimated income tax payments
• Sales tax remittances
• Insurance premiums (monthly, quarterly, or annual)
• Utilities (electric, gas, water, internet, phone)
• Software and subscriptions
• Marketing and advertising spend
• Contractor and freelancer payments
• Equipment purchases or lease payments
• Vehicle expenses
• Travel and entertainment
• Professional fees (accountant, attorney)
• Owner draws or shareholder distributions
• Seasonal inventory purchases
• One-time or irregular expenses (license renewals, annual fees, repairs)

Missing even one large recurring outflow can throw off your entire forecast. The most commonly forgotten items are quarterly tax payments, annual insurance premiums, and seasonal inventory purchases.

Common Cash Flow Forecasting Mistakes

Being Too Optimistic About Timing

The number-one mistake. You forecast that Client B will pay on the due date, but they regularly pay 15 days late. Always forecast based on actual payment behavior, not invoice terms. If your clients are habitually slow, our guide on improving cash flow has specific tactics to speed up collections.

Forecasting Revenue Instead of Cash

Revenue is when you earn it. Cash is when you collect it. If you bill $20,000 in March but your client pays in May, that $20,000 goes in the May column, not March. This distinction is critical — and it is the same reason cash flow and profit are different things.

Forgetting Irregular Expenses

Quarterly taxes, annual insurance renewals, biannual equipment maintenance, holiday bonuses — these hit hard precisely because they’re easy to forget. Before you finalize any forecast, scan your calendar and your last 12 months of bank statements for big payments that don’t occur monthly.

Building It Once and Never Updating

A forecast you built in January and haven’t touched since is worse than no forecast at all, because it gives you false confidence. Commit to the weekly update rhythm or it will quickly become useless.

Not Stress-Testing the Forecast

What if your biggest client pays 30 days late? What if you lose a client entirely? Run at least one worst-case scenario. If a single delayed payment would put you in the red, you need a bigger cash buffer or a backup plan (like a line of credit).

Ignoring Seasonality

If your business is seasonal — landscaping, retail, tourism, tax preparation — your forecast must reflect that. Use last year’s actual numbers by month as a baseline for seasonal adjustment, then refine based on what you know about this year.

How Often Should You Update Your Cash Flow Forecast?

Weekly is the right cadence for most small businesses. Here’s a simple schedule:

• Monday: Update last week’s actuals, adjust forward projections, extend by one week.
• Monthly: Compare your month’s forecasted totals against actuals. Calculate the variance. Look for patterns — are you consistently overestimating inflows? Underestimating a specific expense category?
• Quarterly: Review the overall accuracy of your forecasting. Adjust your methods and assumptions based on what you’ve learned.

The more you practice, the better you get. Most business owners find their forecasts are within 5 to 10% accuracy after two to three months of weekly updates.

Tools and Templates for Cash Flow Forecasting

You don’t need anything fancy to start:

Tool	Cost	Best For
Google Sheets or Excel	Free	Owners who want full control and are comfortable with spreadsheets
SCORE 13-week template	Free	Plug-and-play starting point (available at score.org)
QuickBooks Cash Flow Planner	Included with QB Online Plus/Advanced	QuickBooks users who want forecasting built into their accounting
Float	From $59/month	Businesses wanting visual cash flow forecasting with accounting integrations
BookkeepingFlow	Under $50/month	AI-powered 90-day forecasting that updates automatically from your bank data

If you’re starting from scratch, a spreadsheet is fine. Set up the structure from the step-by-step section above, plug in your numbers, and you have a working forecast in under an hour.

If you’d rather not maintain a spreadsheet manually, BookkeepingFlow connects to your bank accounts and uses AI to generate a rolling 90-day cash flow projection. It pulls in your real transaction history, identifies recurring patterns, and highlights weeks where your balance is projected to drop below your safety threshold. The forecast updates automatically as new transactions come in, so you’re always looking at current data instead of last week’s best guess.

Making Your Forecast Actionable

A forecast sitting in a spreadsheet tab you never open is just an exercise. Here is how to actually use it:

1. Set a minimum cash threshold. Decide on the lowest balance you’re comfortable with — typically one to two months of fixed operating expenses. Flag any week in your forecast where the closing balance dips below that line.
2. Build a response playbook. If the forecast shows a shortfall in three weeks, what will you do? Options include: accelerating an invoice, offering an early-payment discount, delaying a discretionary expense, drawing on a line of credit, or adjusting the owner draw timing.
3. Share it with your accountant or financial advisor. They can spot issues you might miss and help you plan around tax obligations and seasonal fluctuations.
4. Use it in decision-making. Before approving any significant expense — a new hire, a marketing campaign, an equipment purchase — check the forecast. Can the business absorb the cash impact?

Start Forecasting This Week

You don’t need perfect data to build your first cash flow forecast. You need your bank balance, your outstanding invoices, and a list of your recurring bills. That is enough to build a useful 4-week forecast today and expand it to 13 weeks over the next month.

The businesses that manage cash well aren’t the ones with the most revenue. They’re the ones that know what’s coming. A simple weekly forecasting habit puts you in that group — and once you’ve experienced the confidence of knowing your cash position three months out, you’ll never go back to guessing.

Start with a spreadsheet, or let BookkeepingFlow handle the heavy lifting with AI-powered 90-day forecasting that updates automatically from your real bank data. Either way, the best time to start forecasting is before you need to.