Small businesses do not usually fail because they are unprofitable. They fail because on a particular Tuesday there is not enough money in the account to cover payroll, and there is no time left to do anything about it.
The frustrating part is that this is almost always predictable. The information needed to see a cash squeeze six weeks out sits in your invoicing system, your bank account, and your own head. What is missing is a routine that pulls it into one place regularly enough to be useful.
This is a practical system for a small team: a rolling thirteen-week forecast, updated weekly, that takes about half an hour once it is set up. It does not require accounting software, a finance hire, or forecasting expertise. It requires a spreadsheet and the discipline to open it on the same day every week.
Why profit and cash keep diverging
Profit is an opinion about a period. Cash is a fact about a moment. The gap between them is where most small businesses get caught.
Your profit and loss statement records revenue when you earn it and costs when you incur them. Your bank account records money when it actually moves. A business can invoice a large amount in March, book the profit, and not see the money until June, while paying its suppliers and staff every fortnight in between. On paper the quarter looks excellent. In practice the business is scraping.
Several ordinary things widen the gap. Customers pay late, and the bigger the customer the more likely this is. Inventory ties up cash before it produces any. Tax payments arrive in lumps that bear no relation to the month’s trading. Annual software renewals and insurance land all at once. Growth itself consumes cash, because you pay to deliver before you get paid for delivering.
Profit tells you whether the business model works. Cash flow tells you whether the business survives long enough to find out.
None of this is exotic. It is just invisible unless you deliberately look at money on a timeline, which is exactly what a forecast is.
The shape of a useful forecast
The version that works for small teams is a rolling thirteen-week cash forecast. Thirteen weeks is one quarter, which is far enough ahead to act on a problem and near enough that your estimates are grounded in things you actually know about.
Rolling means that every week you drop the week that just finished and add a new week at the far end, so the horizon never shrinks. This is the detail that makes the difference. A forecast built once for the next quarter is useless by week six. A rolling one is always looking the same distance ahead.
The structure is simple. Weeks run across the top. Down the side you have opening cash, money coming in, money going out, net movement, and closing cash. Closing cash for one week becomes opening cash for the next.
| Row | What it holds |
|---|---|
| Opening balance | Actual bank balance at the start of the week |
| Customer receipts | Invoices you expect to be paid, by expected date |
| Other inflows | Loans, refunds, grants, owner contributions |
| Payroll and contractors | Net pay, taxes, and freelancer invoices on their dates |
| Suppliers and stock | Purchase invoices due that week |
| Fixed costs | Rent, software, insurance, utilities |
| Tax and one-offs | Scheduled tax payments, annual renewals, equipment |
| Closing balance | Opening plus inflows minus outflows |
That is the whole model. Resist the urge to add detail. A forecast with forty rows takes an hour to update, which means it will not be updated, which means it has no value regardless of how elegant it is.
Building the first version
Start from the bank, not the books
Open with your actual cleared bank balance today, minus anything already committed that has not landed, such as a payment you have authorized. Do not start from an accounting system balance, which may include amounts that are not yet real cash.
If you hold money that is not yours to spend, such as sales tax collected on behalf of the authorities, either exclude it or show it as a scheduled outflow on the date it is due. Treating tax you are holding as available cash is one of the most common and most damaging errors in small business finance.
Forecast receipts by when customers actually pay
Take every outstanding invoice and place it in the week you genuinely expect payment, not the week the terms say. For each customer, look at their last several payments and count the average days between issue and receipt. That number, not your terms, is your forecasting assumption for them.
For work not yet invoiced, add expected invoices in the week you will raise them, then apply the same payment delay. For new business that is not yet won, use a deliberately conservative figure or leave it out entirely. Optimistic pipeline in a cash forecast is how businesses talk themselves into commitments they cannot fund.
Get outflows exactly right, because you can
Outflows are the easy half and the half most people rush. Payroll dates are known. Rent is known. Software renewals are on your card statement. Loan repayments are scheduled. Spend an hour going through twelve months of bank transactions and list every recurring payment with its date and amount, including annual ones.
Those annual payments are the ones that ambush people. Insurance, professional fees, domain and certificate renewals, equipment refreshes, and tax instalments each individually look small in a yearly context and each individually can be uncomfortable in the week it lands.
Build three versions of the receipts line
Keep one forecast, but hold three assumptions about money coming in: everything arrives as expected, everything arrives two weeks later than expected, and the largest customer pays a month late. Toggling between them takes seconds and tells you where your genuine vulnerability is. Most small businesses discover that their entire cash position depends on one or two customers behaving well.
The weekly routine
The forecast is worth nothing without the ritual. Pick a fixed slot, ideally the same morning each week, and protect it.
- Update actuals. Enter what really happened last week: real receipts, real payments, real closing balance.
- Compare against what you forecast. Note the two or three largest differences and why they happened. This is the step that teaches you to forecast better.
- Roll the window. Drop the completed week, add week thirteen, and fill in known items for the new week.
- Re-date the receipts. Move any invoice that did not arrive to a realistic new week rather than leaving it where it was.
- Scan for the low point. Find the lowest closing balance in the next thirteen weeks and note which week it falls in.
- Decide one action. If the low point is uncomfortable, do something this week rather than noting it for later.
Step two matters more than it looks. After a couple of months of comparing forecast to actual, you develop a calibrated sense of how your customers really pay and how your costs really behave. That instinct, more than the spreadsheet, is the asset you are building.
Reading the forecast properly
A forecast is not a set of numbers to admire. It is a set of signals, and a few are worth watching specifically.
- The trough, not the average. A quarter that ends comfortably can still contain a week where the balance goes below zero. Only the low point matters for survival.
- Weeks of cover. Divide your cash by average weekly outflow. This single figure tells you how long you could operate with no receipts at all, and it is the most honest measure of resilience a small business has.
- Concentration. If more than a quarter of forecast receipts come from one customer, their payment behavior is your cash flow strategy whether you like it or not.
- The stretch pattern. If your own payments to suppliers are drifting later month after month, you are financing the business on supplier goodwill, which is a limited and non-renewable resource.
- Growth drag. Rising revenue with a falling trough means growth is consuming cash faster than it generates it. This is common, survivable, and dangerous if unnoticed.
When the forecast goes red
Seeing a negative week eight weeks out is the system working. You now have eight weeks to act, which is a completely different situation from finding out on the day.
Act on receipts first, because that is where the most movement usually is. Call about overdue invoices personally rather than sending another automated reminder; a direct conversation with the person who approves payment routinely moves money that three emails did not. Offer a modest early payment discount where the margin allows it. Ask new clients for a deposit before work starts, which is normal in most industries and simply requires asking.
Then work on timing rather than amounts. Move a discretionary purchase two weeks later. Ask a supplier for extended terms on one specific invoice, well before it is due rather than after. Shift a subscription from monthly to annual, or annual to monthly, depending on which direction helps that particular week.
Arrange credit facilities before you need them, not during the squeeze. Lenders are considerably more willing when the forecast shows a temporary dip you have anticipated than when the conversation starts with an emergency. Bringing a thirteen-week forecast to that conversation changes how you are perceived, because very few small businesses have one.
Cutting costs is the slowest lever and often the least effective in a thirteen-week window, since most meaningful reductions carry notice periods or exit costs. Use it for structural problems, not for timing problems.
Frequently Asked Questions
Do I need accounting software to do this?
No. A spreadsheet with thirteen columns and eight rows is sufficient, and many small teams run this successfully for years without anything more. Accounting software helps by making outstanding invoices and recurring costs easier to pull, and some tools will generate a basic forecast automatically, but automated forecasts tend to assume customers pay on terms, which is exactly the assumption that causes the problem. Whatever the source, apply your own judgment to the payment dates.
How accurate should a thirteen-week forecast be?
The first two or three weeks should be close to exact, because almost everything in that window is already known. Weeks four to eight will be reasonably good once you have calibrated how your customers actually pay. The final weeks are a directional estimate and should be treated that way. Accuracy is not really the goal; the goal is seeing a problem early enough to have options, and a roughly right forecast does that just as well as a precise one.
What is the right amount of cash to hold?
This depends heavily on the business, and it is a question worth discussing with a qualified accountant who knows your circumstances. As a general operating principle, many small teams aim to hold enough to cover several weeks of total outflows, with more cover where revenue is lumpy, customers pay slowly, or a single client represents a large share of income. The weeks-of-cover figure from your forecast is the number to track, and the direction it moves over a quarter tells you more than any single target.
The real benefit is not the spreadsheet
Teams that run a weekly cash forecast describe the same change, and it is rarely about a crisis averted. It is that decisions stop being anxious.
When you can see thirteen weeks ahead, hiring becomes a calculation rather than a leap. You know which week the new salary starts biting and whether the trough still holds. Taking on a large project with slow payment terms becomes a deliberate choice about financing rather than an accident you discover later. Even saying no gets easier, because you can point at the specific week where the commitment would not work.
The system also removes a particular kind of low-grade dread that many owners carry without naming it: the background uncertainty about whether everything is fine. Checking a forecast weekly replaces that feeling with a number. Sometimes the number is uncomfortable, but a known problem eight weeks away is an entirely different thing from a vague worry with no shape.
Set the spreadsheet up this week. Give it half an hour every week after that, on the same day, without exception. Within a quarter it will be the most useful document in the business.
