Cash Flow Forecast for Small Business: A Practical Guide

Few things frustrate a business owner more than seeing a profit on the P&L and struggling to meet payroll in the same month. There is no contradiction here. Profit is an accounting measure. Cash is what is actually in the bank.

A cash flow forecast bridges that gap. It shows in advance when money will come in, when it will go out and where a shortfall is likely, so you have time to respond. This guide covers how to build one, what data it needs and how to use it to manage cash with confidence.

Why profitable businesses still run out of cash

Revenue is recorded when you issue an invoice, but cash arrives only when the customer pays. On 60 or 90 day terms, you are effectively financing your customers. Meanwhile, suppliers, salaries and tax payments must be paid on time.

Growth also consumes cash. You buy more inventory, hire ahead of revenue and extend credit to new customers. That is why fast-growing companies are often the ones that hit a cash crunch.

• Profit: revenue minus expenses under accounting rules, including non-cash items such as depreciation and provisions.
• Cash flow: money actually received and paid out, including loan repayments, capital spending and inventory purchases.

Direct vs indirect method

There are two common ways to present and plan cash flow, and each has its own job.

The direct method lists expected receipts and payments by source: customer collections, supplier payments, payroll, taxes and loans. It is best for short-term forecasting because it mirrors what actually happens in your bank account.

The indirect method starts from net profit and adjusts for changes in working capital, depreciation, investment and financing. It suits longer-range planning and links your budget, balance sheet and cash flow together.

The 13-week rolling forecast

Thirteen weeks is roughly one quarter. It is short enough to be accurate and long enough to see trouble coming and act before it arrives. That balance is why the 13-week forecast is a favourite tool of finance managers.

1. Start with the actual cash balance across all bank accounts.
2. Map expected receipts for each week, customer by customer for your largest accounts.
3. Map expected payments: suppliers, payroll, taxes, rent and loan repayments.
4. Calculate net cash flow and the closing balance for each week.
5. Every week, compare forecast to actual, update it and add a new week at the end.

Alongside it, keep a monthly forecast for the next twelve months that is linked to your budget and balance sheet. Use that one for bigger decisions such as investment and financing.

What goes into the forecast

Cash inflows

• Customer collections based on when customers actually pay, not the invoice date.
• VAT or tax refunds, if expected.
• Loan drawdowns, credit facilities or equity injections.
• Asset sales and other one-off receipts.

Cash outflows

• Supplier payments according to agreed terms.
• Payroll and related costs, which are usually concentrated early in the month.
• VAT, tax advances and other payments to authorities according to your filing schedule.
• Rent, insurance, subscriptions and other fixed costs.
• Loan repayments, interest and capital expenditure.

The link to receivables aging and collections

Inflows are the hardest part to predict. An accounts receivable aging report shows how much each customer owes and for how long. A customer who usually pays two weeks late should appear in the forecast that way, not on the due date printed on the invoice. A disciplined collections process is therefore both a lever for better cash flow and a prerequisite for a reliable forecast.

A practical tip: group customers by payment behaviour, for example on time, consistently late and at risk. Apply a different expected payment date to each group, and consider leaving very old balances out of the base forecast altogether.

Example: a 4-week cash forecast

The table below is an illustrative example only, showing how a problem can surface well in advance:

In this example the month ends with a healthy balance, yet the account dips below zero in week 3. Spotting that three weeks ahead gives you options: chase an early payment from a large customer, agree a new payment date with a supplier or arrange a credit line.

Early warning signs and scenarios

• Average days to collect keep getting longer.
• A growing share of receivables sits in the older aging buckets.
• Inventory is growing faster than sales.
• You lean on your overdraft or credit line even in good months.
• One or two customers account for a large share of collections.

Beyond the base forecast, run at least one downside scenario. What if your largest customer pays a month late, or sales dip next quarter? Scenarios like these show how much headroom you have and which decisions to make now.

Useful scenarios to test include delayed payments from key customers, a drop in sales, higher input costs, hiring earlier than planned or a large equipment purchase. For each one, decide your response in advance, such as which costs can be deferred and where extra financing would come from.

Practical ways to improve cash flow

A good forecast tells you where the problem is. The improvement itself comes from your processes. These are the main levers available to almost any business:

1. Collections: invoice immediately on delivery, set reminders before and after the due date and assign a clear owner to every overdue account.
2. Payment terms: review credit terms for new customers and consider deposits on large projects or incentives for early payment.
3. Suppliers: negotiate terms that fit your collection cycle and schedule payments according to the forecast.
4. Inventory: identify slow movers, reduce excess stock and align order quantities with real demand.
5. Procurement: time large purchases and investments for strong cash weeks, not just before payroll or tax dates.
6. Financing: arrange a credit facility in advance, while things are going well, not at the last minute.

How Simplogic helps

Simplogic combines an AI-powered FP&A platform with ERP-grade accounting, including collections and receivables, bank reconciliation, procurement and inventory. That means rolling forecasts and scenarios are built on the data in your books, and you can ask the AI questions about your financial position and get answers grounded in that data.