Cash Flow Forecast for Small Business: 13-Week Guide
A healthy sales month does not guarantee that payroll, rent, and taxes will be covered on time. The missing piece is timing. A cash flow forecast for a small business shows the bank balance you are likely to have each week, before a shortage becomes an emergency. This guide explains the simple formula, a useful 13-week format, and the decisions to make when the forecast turns negative.
The short version
Start with the cash actually available today. For each future week, add payments you reasonably expect to receive and subtract every payment due. The result becomes the next week's opening balance. Review the forecast weekly, use conservative collection dates, and act as soon as the lowest projected balance approaches your cash buffer.
What a cash flow forecast tells you
A cash flow forecast is a timeline of expected bank activity. It answers a more practical question than a profit and loss statement: will enough cash be available on the exact day a bill must be paid? That distinction matters when a customer has accepted an invoice but will not pay it for 30 days, while wages are due this Friday.
The forecast also gives every operating choice a visible consequence. You can test whether a new hire is affordable, when to buy equipment, how much inventory to order, or whether a slow-paying client creates a dangerous gap. Intellure can support the incoming side of that plan by answering prospects and following up consistently, but expected sales should enter the forecast only when their timing is defensible.
The cash flow forecast formula
The calculation is simple: opening cash plus cash received, minus cash paid, equals closing cash. Closing cash then becomes the next period's opening cash. The hard part is not arithmetic. It is assigning honest dates and amounts to each line.
| Forecast line | What to include | Timing rule |
|---|---|---|
| Opening cash | Usable checking and savings balances | Use the reconciled bank balance |
| Customer receipts | Card deposits, invoice payments, retainers | Use expected deposit dates, not sale dates |
| Other receipts | Owner funding, loans, refunds, asset sales | Include only committed amounts |
| Operating payments | Payroll, rent, vendors, software, shipping | Use the date cash leaves the account |
| Periodic payments | Taxes, insurance, debt, equipment | Place the full payment in its due week |
| Closing cash | Opening cash plus receipts minus payments | Carry it into the next period |
Build a 13-week cash flow forecast
Thirteen weeks covers roughly one quarter. It is long enough to expose payroll cycles, monthly bills, tax payments, and collection delays, but close enough for useful estimates. A spreadsheet with one column per week and one row per cash category is enough.
Reconcile opening cash
Start with today's usable bank balance. Exclude restricted funds and checks that have not cleared. If the first number is wrong, every projected balance will be wrong.
Schedule cash receipts
List open invoices by the date each customer is likely to pay. Add card settlement delays and recurring revenue. Keep uncertain proposals in a separate scenario until they are committed.
Schedule every payment
Add fixed costs first, then payroll, vendor bills, taxes, debt, inventory, and one-time purchases. Review bank and card statements so annual renewals and small subscriptions are not missed.
Find the low point
Calculate each closing balance and highlight the lowest one. Compare it with the minimum buffer needed to operate safely, not just zero. The first week below that buffer is your action deadline.
Use base, cautious, and strong scenarios
A single forecast can look precise while hiding uncertainty. Keep scheduled costs the same, then vary only the assumptions that can genuinely change. A base case uses the most likely collection and sales pattern. A cautious case delays receipts and reduces uncommitted sales. A strong case includes reasonable upside, not wishful thinking.
For example, a service company might place signed invoices on their normal payment dates in the base case, delay them by one week in the cautious case, and add only high-confidence bookings to the strong case. If all three stay above the cash buffer, the decision is resilient. If only the strong case works, postpone the expense or secure funding before committing.
What to do when the forecast shows a shortfall
A projected shortage is useful because it gives you time. Start with the actions that improve timing without damaging the business: invoice immediately, request deposits for new work, follow up on overdue accounts, offer easier payment methods, and move nonessential purchases. Speak with vendors early if a payment schedule needs to change.
Then protect the sales pipeline. Intellure can answer inquiries across WhatsApp, Instagram, and your website, follow up with leads, and book appointments even when your team is busy. That can make customer response more consistent, but the forecast should still separate booked cash from possible cash. Automation improves execution, not the honesty of the assumptions.
If operational changes are not enough, discuss a line of credit or other financing with a qualified lender before cash is tight. Financing is easier to arrange when records are current and the forecast clearly shows the size and duration of the gap.
Common forecasting mistakes
Do not treat an issued invoice as cash, count the same sale twice, or omit sales tax because it is not revenue. Avoid averaging payroll into smooth monthly amounts when the real payment dates create uneven weeks. Add owner draws, debt principal, equipment purchases, and annual renewals because cash leaves the account even when the profit statement treats them differently.
The final mistake is letting the file go stale. Each week, replace the prior estimate with actual results, move unpaid receipts to realistic dates, extend the forecast by one week, and note why large variances occurred. Over time, your forecast becomes more accurate because it learns how this business actually collects and spends.
Frequently asked questions
What is a cash flow forecast?+
How often should a small business update its cash flow forecast?+
How far ahead should a cash flow forecast look?+
What is the difference between cash flow and profit?+
Should sales tax or loan payments be included?+
The bottom line
A useful cash flow forecast is simple, conservative, and updated every week. It shows the low point early enough to change collection, spending, or financing decisions. Intellure helps keep customer conversations, lead follow-up, and bookings moving 24/7, which supports the receipts side of the plan while you keep full control of the numbers.