Cash Flow Forecasting for Small Businesses

Profit and cash are different things, and the gap between them is where many healthy businesses get into trouble. You can be profitable on paper and still miss payroll because customer payments arrive three weeks after the bills do. A cash flow forecast makes that timing visible.

The 13-week forecast is a favorite among finance people for a practical reason: a quarter is long enough to see patterns and short enough to be reasonably accurate. You do not need special software. A spreadsheet and an honest hour with your bank statements will get you most of the way.

What a 13-week forecast is

It is a week-by-week table of the cash you expect to receive and the cash you expect to pay out, for the next 13 weeks. Each week starts with an opening balance, adds expected inflows, subtracts expected outflows and ends with a closing balance that becomes the next week's opening.

Unlike an income statement, it records when cash moves, not when a sale or expense is earned. A big invoice counts in the week you expect to collect it, and an annual insurance bill counts in the week it is paid.

Gather your starting inputs

Start with real data rather than hopes. Pull the last three to six months of bank statements and your accounts receivable and payable lists. These tell you your typical weekly deposits, your recurring bills and what is owed to and by you right now.

• Current bank balance across all business accounts
• Open invoices with due dates and each customer's typical payment delay
• Recurring costs: payroll, rent, utilities, insurance, software, loan or advance payments
• Inventory or materials purchases and vendor terms
• Known one-time items: taxes, equipment, annual renewals

Build it step by step

Set up columns for weeks one through thirteen and rows for each inflow and outflow category. Then fill them in methodically.

1. Enter your opening cash balance in week one.
2. List expected collections by week, based on when customers actually pay, not when invoices are due.
3. Add other receipts, such as card settlements, which usually arrive a day or two after sales.
4. Enter payroll and payroll taxes in the exact weeks they hit.
5. Add rent, loan payments and vendor bills on their due dates.
6. Include periodic items like sales tax, quarterly estimates and insurance.
7. Calculate net change and closing balance for each week and roll it forward.

A quick worked example

Say a contractor starts week one with $18,000. Expected collections are $12,000, payroll is $14,000 and other bills total $5,000. Closing balance for week one is $18,000 plus $12,000 minus $19,000, or $11,000. In week two, a large customer pays late, so collections are only $4,000 while costs of $17,000 hit. The balance falls to negative $2,000. These numbers are hypothetical.

The point is not accuracy to the dollar. It is that on day one you can see the shortfall coming in week two, which gives you time to chase the invoice, delay a purchase, negotiate terms or arrange funding, instead of discovering it when a payment bounces.

Make it useful, not just correct

Update the forecast weekly. Replace the past week's estimates with actuals, add a new week 13 and adjust upcoming numbers as you learn. Over time you will see where your guesses run high or low, particularly in how fast customers really pay.

Build three scenarios if it helps: a base case, a conservative case with slower collections and a stronger case. The conservative view is the one that tells you how much cushion you need. If it shows a recurring shortfall, you can plan a response early.

Common forecasting mistakes to avoid

Besides assuming customers pay on time, a few errors recur. People forget payroll taxes, which can add a meaningful amount on top of wages. They treat owner draws as optional when they are really recurring. They ignore the delay between card sales and settlement, or the timing of sales tax remittances. And they stop updating after a few weeks. Keep the model simple enough that you will maintain it, label every assumption, and review it with a bookkeeper if you have one. A modest forecast updated weekly beats an elaborate one that goes stale.

When the forecast shows a gap

Not every shortfall requires outside money. Faster invoicing, deposits on large jobs, shifting a vendor payment or trimming a purchase can close small gaps. If the gap is real and temporary, such as waiting on a large receivable, working capital funding may be a reasonable bridge, and having a forecast in hand makes that conversation much easier.

A Fidelity Funding specialist will often ask when cash comes in and when it goes out, because the answer guides which products and payment schedules might fit. Showing a forecast helps them see the shape of your business and recommend structures that match, rather than a one-size-fits-all offer. Funding is never guaranteed, but clarity improves the discussion. For tax questions that touch the forecast, check with your CPA.

This article is for general information only and isn’t financial, legal or tax advice. Funding approval, amounts and terms are set by funding partners and depend on underwriting.