Cash Flow Forecast for Small Business: A Simple 13-Week Method (Free Calculator)

Category: BusinessLast updated: November 20268 min read

A cash flow forecast lists the money you expect to come in and go out, week by week, so you can see a shortfall before it happens. For most small businesses, a rolling 13-week forecast updated every Monday is the simplest version that actually works.

Plenty of profitable businesses still run out of cash. A big customer pays 60 days late, a tax bill lands in the same week as payroll, or a supplier wants payment up front. On paper the business is fine; in the bank account it isn’t.

Also readBefore You Touch FOGO, There’s One Thing New Crypto Users Should Do First

A cash flow forecast fixes that blind spot. This guide walks through the 13-week method step by step, shows what to include, and gives you a free calculator to test your own numbers. If you’re just starting out, our checklist of legal mistakes small businesses make is worth reading alongside it.

What Is a Cash Flow Forecast?

A cash flow forecast is a simple table of expected cash in and cash out over a set period. It isn’t the same as a profit and loss statement.

• Profit tells you whether you earned more than you spent over a period.
• Cash flow tells you whether you’ll have enough money in the bank on a given day.
• Timing is the difference: a sale you invoice today might not turn into cash for 30, 60 or 90 days.

Weekly, Monthly or Yearly: Which Forecast Should You Use?

How to Build a 13-Week Cash Flow Forecast

1. Start with today’s real bank balance

Use the actual cleared balance across your business accounts, not what your accounting software says you’re owed.

2. List expected cash in, week by week

Add customer payments by the week you realistically expect them, based on how each customer actually pays, not your invoice terms. Include card settlements, financing drawdowns and any grants.

3. List expected cash out

Payroll, rent, suppliers, finance repayments, software subscriptions, VAT or sales tax, and owner drawings. Put each in the week it will leave the account.

4. Work out the closing balance for each week

Opening balance plus cash in, minus cash out, equals closing balance. That closing figure becomes next week’s opening balance.

5. Roll it forward every Monday

Replace last week’s estimates with what really happened, add a new week thirteen at the end, and note anything that surprised you.

What Should You Include?

• Regular income: retainers, subscriptions and repeat orders.
• One-off income: large projects, asset sales and tax refunds.
• Fixed costs: rent, salaries, insurance and software.
• Variable costs: stock, packaging, delivery and commissions. Our guide on packing food items for small businesses shows how quickly these add up.
• Lumpy payments: quarterly tax, annual renewals and equipment.

Free 13-Week Cash Flow Calculator

Enter your typical weekly figures. The calculator projects your balance for the next 13 weeks and flags the first week you would fall below your safety buffer.

How to Fix a Cash Gap Before It Hits

• Invoice faster: send invoices the day work is done, not at month end.
• Shorten terms: move new clients from 60 to 30 days, or ask for a deposit.
• Make paying easy: add card and bank transfer links to every invoice.
• Talk to suppliers early: many will agree to split a bill if you ask before it’s due.
• Line up a backstop: arrange an overdraft or credit line while things are good, not in a crisis.

Who Benefits Most From a Cash Flow Forecast?

• Freelancers: income arrives in lumps, while rent and bills don’t wait.
• New founders: it shows how many months of runway are really left. Founders like Myra Ahmad talk about learning business skills that their first careers never taught them; this is one of them.
• Shops and restaurants: stock, wages and seasonal swings make timing critical.
• Agencies and service firms: long payment terms from bigger clients create gaps.

Pros and Cons of the 13-Week Method

Pros: it’s short enough to be accurate, gives about three months’ warning of problems, and banks and finance providers recognise it.

Cons: it takes a little time each week and depends on honest estimates of when customers really pay. It also won’t replace a yearly budget for bigger decisions.

Common Mistakes to Avoid

• Using invoice terms instead of real payment habits: if a client always pays in 45 days, plan for 45.
• Forgetting tax: set aside VAT, sales tax and income tax as they build up.
• Mixing personal and business money: it hides the real picture.
• Never updating: a forecast from three months ago is a guess, not a tool.

Where Cash Flow Planning Is Heading

Accounting tools such as QuickBooks, Xero and many bank apps now draft forecasts automatically from connected accounts and past invoices, and some add AI suggestions about likely late payers. These are helpful starting points, but you still know things the software doesn’t, like a client who is about to sign or a quiet month ahead.

Getting Started Today

1. Note your real bank balance and your safety buffer.
2. List every invoice you’re waiting on and the week you expect payment.
3. List every bill, wage run and tax payment due in the next 13 weeks.
4. Calculate weekly closing balances and highlight any week below your buffer.
5. Take one action for the first risky week, then review again next Monday.

Frequently Asked Questions

Final Thoughts

• Profit and cash are different; timing is what catches businesses out.
• A rolling 13-week forecast gives you early warning of shortfalls.
• Base it on when customers really pay, not when invoices are due.
• Review it every Monday and act on the first risky week.

Explore More on BusinessToMark

• Legal Mistakes Small Businesses Should Avoid
• Myra Ahmad on Product Thinking
• How to Pack Food Items: A Guide for Small Businesses