How to Build a 13 Week Cash Flow Forecast for a Small Business

A profit and loss statement tells you how last month went. A bank balance tells you how today is going. Neither tells you whether you can make payroll on the 15th of next month, which is the question that actually keeps small business owners awake. The tool that answers it is a 13 week cash flow forecast, and you can build a useful one in an afternoon with a spreadsheet and your last three months of bank statements.

Thirteen weeks is one quarter. It is long enough to see a crunch coming while you still have options, and short enough that your estimates stay grounded in real invoices and real bills instead of hope. Lenders and turnaround consultants use this format for exactly that reason. You do not need to be in trouble to benefit from it. Most owners who keep one say the main payoff is calm: fewer surprises, and earlier, cheaper decisions.

Why Weekly Beats Monthly for Small Businesses

A monthly forecast hides timing. If rent of $4,200 leaves on the 1st and your biggest client pays $9,000 on the 28th, the month looks fine on paper while your account sits near zero for three weeks. Weekly columns expose that gap. They also line up with how cash actually moves for most small firms: weekly or biweekly payroll, card processor deposits every few days, and supplier terms counted in days rather than months.

If you have never thought about the difference between profit and cash, our explainer on why cash flow matters more than profit is worth reading first. The forecast below is the practical follow-through.

Set Up the Spreadsheet in Four Blocks

Create one column for each of the next 13 weeks, starting on a Monday. Then build four blocks of rows, top to bottom.

Opening cash. Week 1 uses your actual bank balance today. Every later week pulls the closing cash from the week before.
Cash in. Customer receipts, card deposits, loan draws, owner injections, tax refunds. One row per meaningful source.
Cash out. Payroll, rent, suppliers, software, loan repayments, card bills, estimated taxes, owner draws.
Closing cash. Opening cash plus cash in minus cash out.

Add one more row under closing cash called "minimum buffer." For most service businesses, a buffer of two to four weeks of fixed costs is a sensible floor. Use conditional formatting to turn any week red when closing cash falls below it. That red cell is the whole point of the exercise.

Forecasting Cash In Without Wishful Thinking

Receipts are where most forecasts go wrong, because owners write down when customers should pay rather than when they do. Pull your last 90 days of invoices and compare due dates to the dates money actually landed. If clients on 30 day terms paid on average in 41 days, use 41.

Work through receipts in three layers:

Invoiced and outstanding. List every open invoice and place it in the week you realistically expect payment, based on that customer's history.
Contracted but not invoiced. Retainers, signed projects and recurring subscriptions. Place them by billing date plus your average delay.
Expected new sales. Use a conservative figure, such as 70 to 80 percent of your trailing weekly average, and only after week 4.

Any invoice more than 60 days overdue should be moved to a separate "at risk" row and excluded from the total. If that row is getting long, our guide on chasing late invoices without losing the client covers polite but firm follow-up.

Forecasting Cash Out Line by Line

Outflows are easier because you control most of them, but they are full of lumpy items that are easy to forget. Go through the last three months of bank and card statements and list every recurring payment with its usual date.

Outflow type	Typical timing	Common mistake
Payroll and payroll taxes	Weekly or biweekly	Forgetting the occasional three-paycheck month
Rent and utilities	Fixed date monthly	Missing annual rent reviews or deposits
Suppliers	Invoice date plus terms	Ignoring early payment discounts you could take
Annual software and insurance	Once a year	Leaving them out entirely
Estimated taxes	Quarterly	Treating tax money as spendable

Owner draws deserve their own row. Mixing them into "miscellaneous" makes it impossible to see whether the business or the owner is the cause of a shortfall.

Reading the Forecast and Acting Early

Once the model is filled in, scan the closing cash row for the lowest point and the week it happens. Suppose your forecast shows closing cash dropping to $1,800 in week 9 against a buffer of $12,000. You now have eight weeks to respond, which is a very different position from finding out on the Thursday before payroll.

Useful levers, roughly in order of cost:

Bring forward invoicing on finished work, or invoice milestones instead of waiting for project end.
Ask one or two large clients for a deposit on upcoming work.
Move a discretionary purchase from week 7 to week 12.
Negotiate 45 day terms with a supplier you have paid reliably for years.
Arrange a credit facility now, while your numbers look healthy. Our explainer on how a business line of credit works covers the details.

Banks are far more willing to lend when you show them a forecast with a dip eight weeks out than when you call them with a dip next Friday.

Keep It Rolling Every Week

A forecast you build once and never update decays within a month. Pick a fixed slot, such as Monday morning, and spend 20 to 30 minutes on three steps. First, replace last week's forecast numbers with actuals from the bank. Second, note any line that was off by more than 10 percent and ask why. Third, delete the old week and add a new week 13 at the end, so you always see a full quarter ahead.

After six to eight weeks of this, your accuracy improves noticeably, because you learn which customers drift and which costs creep. Many owners find their week 1 to week 4 estimates end up within 5 percent of actual results, which is accurate enough to plan hiring and purchasing with confidence.

FAQ

Do I need accounting software to build a 13 week forecast?

No. A plain spreadsheet works well, especially for businesses with fewer than 50 transactions a week. Accounting software can export open invoices and bills to save time, but the logic of the forecast is the same either way.

How is this different from a budget?

A budget sets targets for revenue and spending, usually monthly and on an accrual basis. A 13 week forecast predicts actual cash movements week by week. You can hit your budget and still run short of cash if customers pay late.

What if my income is very irregular?

That is exactly when the forecast helps most. Use only confirmed receipts for the first four weeks, a conservative average after that, and set a larger buffer, closer to six weeks of fixed costs, to absorb the swings.

The Bottom Line

A 13 week cash flow forecast is a short spreadsheet with one job: showing you the lowest point in your bank balance before you reach it. Build it from real payment history, keep owner draws and taxes visible, update it every Monday, and act on red cells while they are still weeks away. That habit turns cash crunches from emergencies into ordinary planning decisions.