Money and Profit

How to Build a Weekly Cash Flow Forecast

In brief

Start with your available bank balance, add expected receipts and subtract payments by week. Carry the closing balance forward and flag the first week with a gap or too little room for surprises.

Calendar and a stack of invoices ready for review

Use realistic dates

Put an invoice in the week a customer usually pays or has agreed to pay. Record wages, suppliers and other obligations when money will leave the account. Keep an assumption visible if the timing is uncertain.

Test the risky receipt

If Friday’s forecast shows $3,000 available and includes a $5,000 receipt, a one-week delay puts the balance $2,000 below zero in that example. Flag it now so you can confirm the timing and see what room you have.

See the guide to calculating profit per job to check the numbers behind the decision. For more support, see Get Your Business Sorted.

What you can do today

List four weeks of receipts and mark the largest uncertain payment.

Frequently asked questions

How often should I update the forecast?

Update it at least as often as you make decisions from it, and whenever a large receipt or payment changes date.

Does profit belong in the forecast?

Enter the cash receipts and payments behind the work. Profit and cash can move at different times.

More in this category