Cash-flow forecasting for tiny businesses

Here's the paradox that kills small businesses: you can be profitable on paper and still bounce payroll. Profit is an accounting concept measured over months; cash is what's actually in the bank on Thursday when the software subscription auto-renews and the client who owes you $8,000 hasn't paid. For a freelancer or tiny business, the single most useful financial tool isn't a fancy accounting package — it's a 13-week cash-flow forecast in a plain spreadsheet.

Why 13 weeks

Thirteen weeks — one quarter — is the sweet spot: long enough to see a crunch coming while you can still do something about it, short enough that your estimates stay honest. Forecasting a year ahead is fiction for a small business. Forecasting a week ahead is too late to act. At 13 weeks, you can see that week 9 is a problem and spend weeks 1 through 8 fixing it — chasing an invoice, delaying a purchase, or lining up a bridge before you need one.

Building it: one row per week, three sections

1. Start with today's actual bank balance across your business accounts. Not what QuickBooks says you've earned — what the bank says you have.
2. Cash in, by week: list each expected payment in the week you'll actually receive it. A net-30 invoice sent today lands in week 5 at best — and if that client historically pays in 45 days, put it in week 7. Forecast from behavior, not from terms.
3. Cash out, by week: rent, software, subcontractors, loan payments, insurance, your owner pay, and — the one everyone forgets — quarterly estimated taxes, which land as a boulder four times a year.
4. Bottom row: running balance. Each week's ending cash = last week's ending cash + cash in − cash out. Any week that goes negative, or below your minimum comfort floor, gets highlighted red.
5. Update it every Monday in 15 minutes: replace estimates with actuals, add the new week 13. The forecast is a living document, not a one-time report.

The moves the forecast makes possible

• Accelerate cash in: invoice the day work ships (not month-end), take deposits of 30–50% up front, offer small early-payment discounts, and switch chronic slow-payers to card-on-file or prepayment.
• Slow cash out: time big purchases for fat weeks, ask vendors for net-30 (many extend it to anyone who asks), and match your own pay to the business's rhythm.
• Build the buffer: the forecast tells you your worst-week depth. Your business emergency fund should cover it comfortably — for most solo businesses, 2–3 months of operating costs in a business savings account.
• Arrange credit before you need it: a business line of credit costs nothing to have and everything to lack. Banks lend umbrellas on sunny days; apply during a strong quarter.

The bottom line

Profit tells you whether the business model works. Cash flow tells you whether the business survives long enough to prove it. Build the 13-week sheet this weekend, update it every Monday, and you'll join the minority of tiny businesses that see their crunches coming — which is most of what it takes to outlive them.

A sample four-week snapshot

Notice what the table makes impossible to ignore: week 3 dips to $4,700 even before the tax boulder in week 8. A spreadsheet this simple — four columns, thirteen rows — is doing the job that a $50,000-a-year finance hire does in bigger companies. The discipline is not in the formulas, which are one addition and one subtraction. It is in updating the sheet every Monday and believing what it says over what you hope.

Common forecasting mistakes

• Forecasting from invoice dates instead of expected payment dates. The forecast tracks when cash moves, not when you earned it — a net-30 invoice to a slow payer belongs six or seven weeks out.
• Leaving out the quarterly tax payments. They are the largest single outflows most tiny businesses face, and forgetting one is the classic self-inflicted crunch.
• Updating the sheet only when things feel tight. By the time things feel tight, half your options are gone; the Monday ritual exists precisely for the weeks when everything feels fine.
• Treating the forecast as a budget. A budget is what you plan to spend; the forecast is what will actually happen to the bank balance. They answer different questions and you need both.
• Building it in an accounting package instead of a spreadsheet first. Tools like Float or Fathom are great later, but the spreadsheet forces you to understand every number in the model.

If thirteen weeks still feels like overkill for your situation, start with four. A one-month rolling view catches the majority of crunches for a business with fast-paying clients, and the habit of updating it weekly matters more than the horizon. Most owners who start with four weeks extend to thirteen within a quarter anyway — once you have seen one problem coming in advance, flying blind stops being tolerable.