How to Create a Cashflow Forecast for Your Business

A profitable month can still leave you short on cash when wages, supplier bills, BAS or a loan repayment all fall due before customers pay their invoices. That is why learning how to create a cashflow forecast is one of the most practical ways to reduce financial stress in a small business. It shows what is likely to happen in your bank account before it happens, giving you time to act rather than react.

For a tradie waiting on progress payments, a café managing weekly suppliers or a growing service business adding staff, cashflow is not an accounting concept on a report. It is the ability to meet commitments, keep work moving and make decisions with confidence.

What a cashflow forecast actually tells you

A cashflow forecast estimates the money expected to enter and leave your business over a set period. It is usually organised by week or month, starting with your opening bank balance and finishing with an expected closing balance.

It is different from a profit and loss report. Your profit and loss shows income earned and expenses incurred in a period, even if the money has not yet changed hands. A cashflow forecast tracks the timing of actual receipts and payments. You might record a healthy sale in June, for example, but if the customer pays in August, it will not help you cover July payroll.

A useful forecast answers straightforward questions: Will we have enough cash for next week’s wages? Can we afford to order stock? What happens if a large debtor pays late? When should we put money aside for BAS and superannuation? These answers are more valuable when they are based on current bookkeeping rather than a rough guess.

How to create a cashflow forecast step by step

The best forecast is not the most complicated spreadsheet. It is one you can understand, update and use. Start with a rolling 13-week forecast if your cash position is tight or variable. This gives you weekly visibility of the next quarter. If your business is more stable, a 12-month monthly forecast is often suitable for planning seasonal revenue, tax obligations and larger purchases.

Start with the real opening bank balance

Use the cleared balance in your business bank account on the day your forecast begins. Do not use the balance from last month’s unreconciled accounts, and do not include funds that are already committed to an upcoming direct debit.

If you operate separate accounts for tax, payroll or savings, include them only if you intend to use those funds for business cash needs. Keeping tax money separate is usually wise, but it still needs to be visible in your wider planning so you do not accidentally treat it as available spending money.

Forecast cash coming in by expected payment date

List each expected receipt in the week or month you genuinely expect to receive it. For invoice-based businesses, look at your accounts receivable report and use realistic payment patterns, not just invoice due dates. If a regular client commonly pays seven days late, forecast the payment seven days late.

For businesses paid at the point of sale, use recent sales data adjusted for known changes. A retailer may expect higher sales before Christmas; an NDIS provider may have payment cycles linked to claiming and plan management; a project business may be relying on a deposit or milestone payment. Include only revenue with a reasonable basis behind it.

It can help to separate receipts into confirmed and unconfirmed amounts. Confirmed receipts may include issued invoices and contracted recurring work. Unconfirmed receipts could be quotes that are likely to convert or a project that has not yet been approved. This avoids relying on optimistic sales to pay bills that are certain.

Add every known cash payment

This is where forecasts often fail. Owners remember rent and wages but overlook annual licences, vehicle registration, insurance, software subscriptions, merchant fees and tax payments. Review your transaction history, bills list and direct debits to identify recurring costs.

Your forecast should normally include:

• payroll, PAYG withholding, superannuation and any contractor payments
• rent, utilities, mobile, software and insurance
• supplier invoices, stock purchases and materials
• loan repayments, equipment finance and credit card payments
• BAS, income tax instalments and other ATO obligations
• owner drawings or distributions where relevant
• planned repairs, marketing campaigns, new equipment and one-off project costs.

Enter each item when the cash will leave the account, rather than spreading it evenly just because it relates to a whole year. An annual insurance premium paid in one month can create a very real shortfall, even though the expense may be apportioned differently in your accounts.

Include GST and tax obligations properly

For a bank-balance forecast, use the actual amounts likely to be paid or received, including GST. However, make the GST component visible rather than treating it as money available to spend. The same principle applies to PAYG withholding and superannuation. These amounts can sit in your account temporarily, but they are obligations, not operating cash.

The timing depends on your reporting and payment arrangements. A quarterly BAS creates larger, less frequent cash outflows than monthly reporting. Superannuation is due quarterly at a minimum, although many businesses pay it more often to avoid a surprise. Confirm your specific due dates with your accountant or bookkeeper and place them in the correct forecast period.

Calculate the running closing balance

For each period, calculate:

Opening balance + cash received – cash paid = closing balance

The closing balance for one week or month becomes the opening balance for the next. This running balance is the part of the forecast that matters most. It reveals whether a payment timing issue will create a gap, even if the business looks profitable across the full quarter.

A simple structure might show weeks across the top and cash categories down the side. Cloud accounting software, reporting apps and spreadsheets can all work. The right tool depends on the complexity of your business and whether your bank feeds, invoices, payroll and bills are kept up to date.

Use scenarios instead of relying on one perfect prediction

A cashflow forecast is an estimate, not a promise. The goal is not to predict every dollar perfectly. It is to understand your likely position and test the decisions that could change it.

Create a base case using your most realistic assumptions. Then test a downside case, such as a major customer paying two weeks late, sales dropping by 15 per cent or a vehicle needing an unexpected repair. You may also want an upside case where a new contract begins earlier than expected.

If the downside case takes your balance below a comfortable minimum, you have useful information. You might follow up debtors earlier, request a deposit before ordering materials, delay a non-essential purchase, negotiate supplier terms or arrange funding before it becomes urgent. Each option has trade-offs. Extending supplier terms can protect cash in the short term, for instance, but should be done respectfully and with clear communication.

Review it regularly and compare forecast with reality

A forecast built once and left untouched will quickly lose value. Update it weekly if your cash position changes frequently, or at least monthly for a stable business. Add new invoices, remove payments that have arrived, move late receipts forward and include new costs as they become known.

Comparing the forecast with actual results is how it improves. If customers are consistently paying later than expected, adjust your assumptions and look at your invoicing process. Clear payment terms, prompt invoicing, automated reminders and regular debtor follow-up can make a material difference to cashflow without increasing sales.

This review also helps you spot patterns. Perhaps wages are rising faster than revenue, certain jobs consume cash before they generate it, or a particular season always requires a larger stock commitment. Those insights can guide pricing, staffing, deposits and purchasing decisions.

Common mistakes that make forecasts less useful

The most common issue is confusing sales with cash received. Another is forgetting irregular costs until they arrive. Businesses can also make a forecast look healthier by including every possible quote while assuming every bill will be paid on time.

Avoid using the forecast as a substitute for accurate bookkeeping. If bank accounts are not reconciled, bills are missing or invoices are not kept current, the starting data will be unreliable. A forecast is only as useful as the information feeding it.

It is also worth setting a minimum cash buffer. The right amount depends on your industry, fixed costs, access to finance and how predictable your income is. A sole trader with low overheads may need a smaller buffer than an employer with weekly payroll and stock commitments. The key is to choose a figure that gives you room to deal with normal delays without immediately putting pressure on the business.

When your books are current, a cashflow forecast turns the bank account from a source of uncertainty into a practical decision-making tool. If you would rather spend your time serving clients, managing jobs or growing your team, GoBookaroo can help turn your day-to-day financial data into clear, useful visibility before the pressure builds.