Cash Flow Forecasting for Small Business: A Plain Guide

Short answer: Cash flow forecasting for small business means estimating, week by week or month by month, how much cash will come in, how much will go out, and what will be left in the bank. It is not a budget and not a promise. It is your best estimate from what you know today, updated as you learn more, so a shortfall shows up weeks before it arrives.

It is Thursday, payroll runs Friday, and your largest customer has not paid. A cash flow forecast exists so that week shows up on paper a month or two ahead, while there is still time to act. A business can be profitable and still miss payroll, because profit and cash move on different timelines, as we explain in why profitable businesses run out of cash.

Below: what a forecast is, why it is hard, the common mistakes, and a 13-week method.

What a Forecast Is and Is Not

A forecast estimates future cash and results from what you know today: invoices sent, bills owed, payroll dates, loan payments and the sales you reasonably expect.

A budget is a target: what you intend to earn and spend. A forecast is a best estimate that you update as facts change. When the two disagree, the budget tells you what you hoped for and the forecast tells you what now looks likely.

Cash flow forecast vs profit forecast

• A profit forecast asks whether the business will make money over a period. Revenue counts when it is earned and expenses when they are incurred, as our guide to the profit and loss statement explains.
• A cash flow forecast asks whether there will be enough money in the bank on each date that matters. It counts money only when it moves, the same distinction the cash flow statement guide draws on your past results.

A business can pass the first test and fail the second. If your question is "can we make payroll in March," you need the cash forecast.

Loading sample forecast chart

Line chart of annual revenue for a fictional landscaping company. Actual: 2021 $94,750, 2022 $100,300, 2023 $107,908, 2024 $115,050, 2025 $221,243. Forecast, revenue growing by a twentieth each year: 2026 $232,305, 2027 $243,920, 2028 $256,116.

The dashed line is not a prediction. It assumes the 2025 level holds after revenue nearly doubled, then grows by a twentieth a year. If 2025 was a one-off, the starting point is wrong, not only the rate.

What Small Businesses Use Forecasting For

• Covering payroll and rent in the coming weeks and months.
• Timing a hire, a purchase or a lease, to see whether the business can carry it through a slow stretch, not only in a good month.
• Planning for seasonality, so you know how much cash to hold going into the thin months.
• Asking for credit at the right time, before you need it, with a forecast that shows a lender the gap and your plan.
• Setting money aside for taxes, including quarterly estimates, so large and predictable payments stop being surprises.
• Buying inventory and supplies, which often leave the bank weeks before the related sales come back as cash.
• Testing "what if" questions: a price change, a fully booked crew, or losing your biggest customer.
• Planning owner pay, since draws come out of the same cash as everything else.

Why Forecasting Is Hard for Small Businesses

• Little history, or revenue that swings. A young business has few months to learn from, and a project business can see revenue double or halve from one month to the next.
• Cash timing is not invoice timing. Customers pay late, in pieces, or all at once.
• Books that are behind. A forecast built on unreconciled, uncategorized actuals inherits the mess.
• No one owns the sales numbers, so the revenue line becomes a guess.
• Built once, never updated. A spreadsheet made for a loan application and then forgotten is a snapshot.
• Fear of being wrong. Every forecast is wrong in the details. Owners who expect precision often skip forecasting and end up with no early warning instead of an imperfect one.

What Most People Get Wrong

Forecasting profit when the question is cash

Profit can look healthy while the bank account drains. Fix: if the decision depends on having money on a date, forecast cash.

Using one number instead of a range

One number suggests a certainty nobody has. Fix: build three cases. The base case uses your best estimates, the low case assumes customers pay later and a deal slips, and the high case assumes the contract you are negotiating signs. Plan your actions around the low case.

Setting revenue from hope

"Sales will grow by a fifth" is a goal, not a forecast. Fix: build revenue from signed work, your pipeline weighted by how often similar deals have closed, and what your people and equipment can deliver.

Ignoring collection and payment timing

Fix: if customers usually pay 40 days after the invoice, put the cash 40 days after the invoice. Do the same for when you pay suppliers.

Forgetting irregular expenses

Insurance premiums, quarterly taxes, license renewals and repairs do not arrive monthly. Fix: read last year's bank statements and list every payment that did not repeat each month. Most will recur.

Leaving out owner draws and debt payments

Loan principal is not on the profit and loss statement and draws are not an expense, but both leave the bank. Fix: put each one in the week it happens.

Too much detail

Eighty expense lines take so long to update that nobody updates them. Fix: forecast the lines that move cash most, usually receipts, payroll, rent, major suppliers, taxes and debt, and group the rest.

Never comparing the forecast with what happened

Fix: once a month, compare forecast and actual for each main line. Within a few months you will know which line you tend to get wrong.

Treating the forecast as a promise or a target

A forecast that becomes a target gets adjusted to look good and stops warning you. Fix: keep the budget for targets and keep the forecast honest.

Having no decision triggers

Fix: write the trigger down in advance, for example, with a hypothetical figure: "If forecast cash falls below $10,000 in any week, we pause the owner draw and call the bank about the credit line." Deciding while calm beats deciding in the week cash runs short.

A Practical Method You Can Start This Week

A rolling 13-week cash forecast covers about one quarter: close enough that most amounts are known, far enough ahead to act. For a fuller walkthrough with a sample layout, see how to build a 13-week cash flow forecast.

1. Start from actual bank cash, not the profit figure from your reports.
2. Set up four rows for each week: beginning cash, expected receipts, expected payments (payroll, rent, suppliers, taxes, debt and owner draws), and ending cash.
3. Roll the balance forward. Ending cash equals beginning cash, plus receipts, minus payments, and it becomes next week's beginning cash.
4. Work out your runway: cash on hand divided by average monthly net cash burn, where net burn is payments minus receipts. It shows how many months the business could last at the current pace.
5. Update it every week. Replace the week that ended with what actually happened, move any dates that changed, and add a new week at the end.

A worked example with hypothetical numbers

Every number below is hypothetical, made up for a fictional cleaning company to show the arithmetic.

The company starts with $40,000 in the bank. Over 13 weeks it expects $140,000 from customers, between $7,000 and $15,000 a week, and these payments:

• Payroll of $14,000 in weeks 1, 3, 5, 7, 9, 11 and 13: $98,000.
• Rent of $4,000 in weeks 1, 5 and 9: $12,000.
• Suppliers of $2,500 every week: $32,500.
• A quarterly estimated tax payment of $6,000 in week 3.
• An annual insurance premium of $5,000 in week 8.
• Loan payments of $1,500 in weeks 2, 6 and 10: $4,500.
• Owner draws of $3,000 in weeks 4, 8 and 12: $9,000.

Payments total $167,000. Week by week:

• Week 1: $40,000 plus $12,000, minus $20,500, leaves $31,500.
• Week 2: $31,500 plus $9,000, minus $4,000, leaves $36,500.
• Week 3: $36,500 plus $14,000, minus $22,500, leaves $28,000.
• Week 4: $28,000 plus $8,000, minus $5,500, leaves $30,500.
• Week 5: $30,500 plus $11,000, minus $20,500, leaves $21,000.
• Week 6: $21,000 plus $9,000, minus $4,000, leaves $26,000.
• Week 7: $26,000 plus $15,000, minus $16,500, leaves $24,500.
• Week 8: $24,500 plus $7,000, minus $10,500, leaves $21,000.
• Week 9: $21,000 plus $12,000, minus $20,500, leaves $12,500.
• Week 10: $12,500 plus $10,000, minus $4,000, leaves $18,500.
• Week 11: $18,500 plus $13,000, minus $16,500, leaves $15,000.
• Week 12: $15,000 plus $8,000, minus $5,500, leaves $17,500.
• Week 13: $17,500 plus $12,000, minus $16,500, leaves $13,000.

To check: $40,000 plus $140,000 minus $167,000 is $13,000, the same as week 13.

The low point is week 9, at $12,500, when payroll and rent land together. The business never runs out of cash, but it ends the quarter $27,000 lower than it started. Treating 13 weeks as three months, that is a net burn of $9,000 a month, so the runway at the end of week 13 is $13,000 divided by $9,000, about 1.4 months. The forecast shows the slide a full quarter early.

The low case: customers pay two weeks late

Now suppose every customer pays two weeks later than planned. The $12,000 expected in week 1 arrives in week 3, and so on. Weeks 1 and 2 bring in nothing, and the $20,000 expected in weeks 12 and 13 slips past the end of the forecast. Payments do not change, so the quarter ends at $40,000 plus $120,000 minus $167,000, which is $7,000 below zero. Cash drops to $5,000 in week 3, goes below zero in week 8, and bottoms at minus $8,000 in week 11.

Same sales, same costs; only the timing changed. With the trigger written in advance, the owner acts in week 3, not week 8. Pausing the three draws helps but still leaves cash at minus $2,000 in week 11, so collecting late invoices sooner or arranging credit early has to cover the rest.

How Often to Update and Who Should Be Involved

• Weekly for the 13-week view, at a fixed time, changing only what moved.
• Monthly for a 12-month view, which shows seasonality, hiring plans and financing needs that one quarter cannot. Our post on why a trend line is not a cash flow forecast covers building that view from drivers.
• The owner owns it.
• Your bookkeeper or accountant supplies current actuals and the timing of tax payments.
• Whoever manages sales supplies likely deals and when their cash would arrive.

Where Software Helps

Your bookkeeping system is the record of what already happened. QuickBooks® accounting software, for example, holds the invoices, bills and bank transactions every forecast starts from. Keeping those books current and reconciled does more for forecast quality than any formula.

Software helps with the next step: turning that record into a forward view you can test. 2diff Business connects to your accounting data and projects your profit and loss, balance sheet and cash flow by year, quarter or month. Its drivers method builds the projection from inputs such as revenue growth, cost of goods sold, operating expenses, and the days customers take to pay you and you take to pay suppliers. You set a minimum cash balance, and the forecast shows any Needed Financing when cash would fall below it. It reads your reports and never writes to your books. It does not build the weekly 13-week sheet described above; you keep that one yourself, alongside the longer view.

Summary

• A forecast is a best estimate you update, not a budget and not a promise.
• Forecast cash when the question is cash, with a base, low and high case.
• Put receipts in the week customers actually pay, and include irregular payments, debt and owner draws.
• Keep a rolling 13-week view from actual bank cash, update it weekly, and compare it with actual results every month.
• Write your decision triggers down before you need them.

Start this week: enter today's bank balance and list the next 13 weeks of payments you already know about. A rough first version beats a perfect one you never build. To see a longer forecast built from a full set of books, you can try the demo with sample data without connecting any accounts, or compare plans.

Related Reading

• Why a Trend Line Is Not a Cash Flow Forecast: Forecasting from drivers and reading a 12-month view
• How to Build a 13-Week Cash Flow Forecast: The week by week method, with a worked example and a sample layout
• Why Profitable Businesses Run Out of Cash: Why profit and cash move on different timelines
• Understanding Your Cash Flow Statement: A detailed look at the three sections of the Cash Flow Statement
• Understanding Your Profit and Loss Statement: How revenue, costs and profit are reported

---

This post is for informational and educational purposes only. It does not constitute tax, accounting, or financial advice. Consult a qualified professional about decisions specific to your business.