How to Build a Four-Week Cash-Flow Forecast for a Small Business

A business can be profitable on paper and still have too little cash for next week’s bills. A four-week cash-flow forecast is a simple way to see that risk before it becomes an emergency.

It is not a promise about sales. It is a short list of the money you expect to reach your bank account and the money you expect to pay out. The key word is when.

You can make the first version in a spreadsheet in under an hour. Start with real dates, keep the lines plain, and update it each week.

Start with the cash you have today

Put today’s cleared bank balance at the top of the first week. Do not add an invoice just because it has been sent. Add it in the week you think the money will actually clear.

This is the practical difference between profit and cash flow. Profit records income and costs for a period. Cash flow tracks the date the money moves. The British Business Bank makes the same point in its cash-flow guidance: income belongs in the forecast when clients will pay or bank payments will clear.

Use one row for each large payment or one row for each group of smaller payments. If a date is not certain, mark it as a question rather than quietly treating it as cash you already have.

List money in by date, not by hope

Start with signed work, recurring charges, and invoices that have already been sent. Next, add likely income only if you can explain why it should arrive in that week.

A good label can stop a bad decision. Use “sent invoice”, “contracted”, “likely”, or “possible” beside a large payment. If a customer usually pays 30 days after an invoice, do not place the money in next Friday’s column because you need it there.

This is where a simple sales forecast helps. The sales forecast shows what you may sell. The cash forecast converts the most realistic sales into dates when cash may arrive.

List money out before it surprises you

Add fixed costs first: payroll, rent, loan payments, insurance, software, and regular supplier bills. Then add costs that rise when you sell more, such as materials, delivery, commissions, or subcontractors.

Do not forget the costs that arrive only a few times a year. A licence renewal, annual insurance bill, tax payment, repair, or equipment deposit can turn a healthy month into a tight week.

Keep direct costs separate from overhead. That makes it easier to see whether an increase is caused by more work or by a cost you may be able to change. Our guide to gross margin for a service business explains why that distinction matters.

Calculate the running balance

For each week, add the expected money in, subtract the expected money out, and carry the balance into the next week. The lowest number is often more useful than the month-end number because it shows the moment you may need to act.

For example, a studio starts with $8,000 or £8,000. It expects $5,000 in Week 1, but must pay $7,000 in payroll and suppliers. The balance falls to $6,000. In Week 2, a $9,000 invoice is due but has not been confirmed. If the invoice moves to Week 3, the forecast should move with it.

The aim is not to make the numbers look cheerful. It is to make the next choice visible while you have options.

Use the forecast to make one calm choice

A low point does not always mean the business is in trouble. It means you need to check the next decision. You might send an invoice sooner, confirm a payment date, delay a non-essential purchase, ask for a deposit, or speak with an accountant or adviser.

Clear payment terms can reduce avoidable delays. If late payment is a pattern, review your invoice process and see our guide to payment terms that protect cash flow. Do not make a funding or tax decision from one spreadsheet alone; use qualified advice where it is needed.

Update it every week

Set aside ten minutes at the same time each week. Replace estimates with what happened, move any delayed payment, add new bills, and extend the view by one more week.

• A customer pays late: move the cash to the later week and check the new low point.
• A bill changes: update the amount and keep a short note about why.
• A sale is not signed: move it from likely to possible, or remove it from the plan.

The U.S. Small Business Administration’s small-business finance guidance also stresses recording assumptions and comparing projections with actual results. That habit matters more than any template.

Make the forecast a decision tool

A forecast becomes useful when it changes a decision before a payment problem grows. It can help you choose the order of spending, the timing of a purchase, or the moment to contact a customer.

Keep the detail proportional to the size of the business. A one-person consultancy may need only a bank balance, five invoices, payroll, tax, and a few regular costs. A shop with stock may need separate supplier deliveries and card-payment settlement dates.

Write down the assumption behind every important number. For example, note that a retainer normally clears on the third working day, or that a supplier gives seven days after delivery. This makes a later update faster and helps another person understand the plan.

Use a second, cautious version when one delayed payment would make the balance uncomfortable. Move uncertain income one week later and ask what changes. That small scenario can show whether you need a deposit, a payment reminder, or a delayed purchase.

The forecast cannot guarantee an outcome. It can give you a clearer view of the choices available today, which is often the most useful form of financial planning.

Understand the cash cushion

A cash cushion is the money that remains available after the ordinary payments already due in the next few weeks. It is not the same as a sales target, a profit figure, or an invoice that has not cleared.

Some advisers call this working capital, which simply means the money a business can use for its normal day-to-day operations. It pays for supplies, payroll, delivery, rent, and other routine commitments while customers are still making payments.

Every business has a different level of variability. A consultant with monthly retainers may have predictable receipts, while a seasonal retailer may have uneven deliveries, supplier invoices, and card settlements. The forecast helps both businesses identify their particular low point.

Do not choose a cushion by copying another company. Consider the payment cycle, the reliability of customers, the time required to reorder materials, and the effect of an unexpected repair. A qualified accountant can help assess this in the context of your business.

The useful result is not a magic number. It is an operational picture that helps you decide when the balance is becoming too low for comfort.

Keep the first version small

Do not build a 12-month model before you can keep a four-week model up to date. A short forecast can show the current cash cycle, make missed dates visible, and give your business a calmer starting point.

A budget sets a broad plan. A cash forecast asks a more urgent question: what will be in the bank before the next bill is due? Use both. The budget gives you direction; the forecast gives you timing.

If you need a starting check, read our piece on why cash flow can hurt a profitable business. Then make the first four-week view with the records you already trust.

Frequently asked questions

What belongs in a four-week cash-flow forecast?
List the opening bank balance, each expected payment by the week it should clear, each bill by its due week, and the closing balance. Add a note where a date is uncertain.

Is a cash-flow forecast the same as a profit forecast?
No. Profit shows income and costs for a period. A cash-flow forecast focuses on timing: when money is likely to reach or leave the bank account.

How often should I update a cash-flow forecast?
Update it once a week and whenever a large payment date changes. Replace guesses with real dates as invoices are sent, paid, or delayed.