Cash Flow Forecasting Basics for Small Business Owners

Profit and cash are not the same thing. A business can be profitable on paper and still struggle to make payroll, because the money from last month’s sales has not arrived yet while this month’s bills are due now. A cash flow forecast is the simplest tool for seeing that gap before it arrives.

What a cash flow forecast is

A cash flow forecast is a week-by-week estimate of the money coming into your bank account and the money going out. It starts with the cash you have today and rolls forward, so you can see your expected balance at the end of each week.

That is all it is. It does not need accounting software or special training. A spreadsheet works fine.

Why 13 weeks

Thirteen weeks is one quarter. It is long enough to see problems coming in time to do something about them, and short enough that your estimates stay reasonably accurate. Beyond about three months, the numbers become guesses. Inside three months, most of what will happen is already visible in your sales pipeline, open invoices and regular bills.

How to build one

Set up a spreadsheet with one column per week for the next 13 weeks, and these rows:

Starting cash. For week one, the actual balance in your business accounts today. For each later week, the ending cash from the week before.

Cash coming in. Break this into a few lines that match how you actually get paid:

• Payments on invoices already sent. Use your accounts receivable list and, importantly, when customers really pay, not when the invoice says they should.
• Expected new sales, based on your pipeline and past patterns. Be conservative.
• Any other receipts, such as deposits or refunds.

Cash going out. List the payments you know about and when they leave the account:

• Payroll and payroll taxes, on the actual pay dates
• Rent and utilities
• Supplier and inventory payments
• Insurance, subscriptions and other regular bills
• Estimated tax payments
• Any one-off payments you know are coming, such as equipment or annual renewals

Ending cash. Starting cash, plus cash in, minus cash out.

Many owners also add a line for the minimum cash balance they want to keep as a cushion, so it is easy to see which weeks fall below it.

How to use it

A forecast is only useful if it is updated. Once a week, which takes about thirty minutes once it is set up:

1. Replace last week’s estimates with what actually happened.
2. Add a new week at the end, so you always see 13 weeks ahead.
3. Look for any week where ending cash drops below your cushion.

When you see a tight week coming, you have options that do not exist when the problem is already here: following up on a large overdue invoice, asking a customer for a deposit, timing a supplier payment differently, delaying a purchase or adjusting hiring plans.

Common mistakes

Using invoice terms instead of real payment habits. If your terms are 30 days but a major customer always pays in 50, forecast 50.

Forgetting irregular payments. Annual insurance, quarterly taxes and yearly software renewals are the usual surprises. Go through last year’s bank statements to find them.

Being optimistic about new sales. Forecast what is likely, not what you hope for. It is better to be pleasantly surprised.

Building it once and never updating it. A forecast that is two months old is worse than none, because it gives false confidence.

How AI can help

AI tools are good at the tedious first steps: categorizing a year of bank transactions to find regular payments, working out how long each customer really takes to pay, and flagging unusual items. They can also run quick what-if scenarios, such as what happens if your largest customer pays three weeks late. You still need to review the results and make the judgment calls, but the setup goes much faster.

Where to start

Build a rough version this week, even if some numbers are estimates. Update it next week. After a month, the forecast will be accurate enough to rely on, and you will understand your cash cycle better than most owners do.

If you would like help setting one up, or connecting it to a budget and a pricing review, see our Financial Planning and Analysis service. This is advisory work: we help you plan and understand your numbers.