A profitable month can still leave you short of cash on Friday. The customer invoice may not be due for another 30 days, while wages, supplier accounts and a BAS payment are due now. That is why a cash flow forecasting guide matters: it helps you see what will be in the bank before commitments fall due, rather than finding out when the balance is already tight.
For small businesses, cash flow forecasting does not need to be complicated. It needs to be current, based on sensible assumptions and reviewed often enough to support decisions. A clear forecast gives you time to chase overdue invoices, delay a non-essential purchase, arrange funding or simply make a decision with confidence.
What a cash flow forecast actually shows
A cash flow forecast is a forward-looking estimate of money entering and leaving your bank account over a set period. Most small businesses benefit from a weekly forecast for the next 13 weeks, supported by a monthly view for the next 6 to 12 months.
The key word is cash. This is different from your profit and loss report. A profit and loss report records income when it is earned and expenses when they are incurred. A cash forecast records when money is expected to move. You may make a sale in June, issue an invoice in July and receive payment in August. Your accounts can show a profit in June, but the bank balance will not benefit until August.
A useful forecast starts with your opening bank balance, adds expected receipts, subtracts expected payments, and shows the estimated closing balance for each week or month. The result is not a promise. It is a working plan that makes timing visible.
Cash flow forecasting guide: start with real bank movements
The most common forecasting mistake is starting with a sales target and hoping the rest will work itself out. Start with what is already known.
Check the balances of your operating account, savings accounts used for tax, loan accounts and any accounts that are genuinely available to support the business. Then review unpaid customer invoices. List each expected payment in the week you realistically expect it to arrive, not simply on its invoice due date.
If a customer normally pays 10 days late, use that pattern in the forecast. If a large contract is still subject to approval, do not treat the full amount as certain. You might include it as a separate possible receipt, but it should not be the money you rely on to pay wages.
Next, enter committed payments. This includes rent, wages, superannuation, supplier bills, loan repayments, software subscriptions, insurance, vehicle costs and regular owner drawings. Include GST, PAYG withholding and income tax instalments on the dates they will actually leave the account. These payments are often large enough to create pressure even when day-to-day trading looks healthy.
For businesses using Xero, clean bank feeds, up-to-date reconciliations and correctly entered bills make this process far more reliable. Forecasting cannot fix incomplete records. Tidy systems come first.
Build the forecast in the right order
A simple spreadsheet can work well, particularly for a sole trader or a business with a manageable number of transactions. A Xero-based reporting process may be more suitable where there are regular invoices, payroll and multiple suppliers. The tool matters less than the quality of the information going into it.
1. Choose a sensible timeframe
A 13-week rolling forecast is usually practical because it shows the next quarter in enough detail to manage immediate pressure. Use weekly columns where payments are frequent or cash is tight. A hospitality venue, trade business or NDIS provider with regular payroll may need this level of detail.
A monthly forecast can be enough for a stable business with predictable receipts and lower transaction volumes. It depends on how quickly your cash position changes. If one delayed payment could affect payroll or a supplier relationship, weekly is the safer choice.
2. Separate certain, likely and possible income
Not all expected income deserves the same level of confidence. Invoices already issued to reliable customers are generally more certain than quotes awaiting acceptance. Recurring service income may be likely, while a major new project could be possible but unconfirmed.
This distinction prevents a forecast from becoming overly optimistic. Some business owners keep a base forecast using only certain and likely receipts, then maintain a second view that includes possible work. That approach shows the minimum position you need to manage and the upside if planned work proceeds.
3. Include every meaningful outgoing
Small recurring costs can be easy to miss, but a forecast should also capture irregular commitments. Annual licences, quarterly insurance, equipment repairs, vehicle registration, seasonal stock purchases and tax payments all affect the bank account.
For staff, include the full employment cost. Wages are only part of the picture. Allow for superannuation, PAYG withholding, workers compensation and any leave payments that may arise. If you pay subcontractors, use their agreed payment terms rather than assuming every invoice will be paid at the end of the month.
4. Calculate the closing balance each period
For each week, use a simple calculation: opening balance plus cash in, less cash out, equals closing balance. The closing balance then becomes the opening balance for the following week.
This is where the useful information appears. A negative projected balance in week eight is not necessarily a crisis. It is an early warning. You now have time to act before it becomes an urgent problem.
Use the forecast to make decisions earlier
The value of forecasting is not the spreadsheet itself. It is what you do with the information.
If the forecast shows a shortfall, first look at receivables. Could invoices be issued sooner? Are customers being followed up promptly? Would staged deposits or progress claims improve the timing of cash for future work? In many service businesses, improving collection habits has a greater effect than cutting small office costs.
Then review outgoings. You may be able to negotiate supplier terms, split a planned purchase, use existing stock more carefully or delay a discretionary expense. Be careful with delaying payments that have penalties or could damage an important supplier relationship. The aim is to manage cash responsibly, not shift pressure from one party to another.
The forecast can also show when you have capacity. A healthy projected balance may support a new staff member, replacement equipment, a vehicle deposit or a marketing campaign. Even then, leave a buffer. A growing business often needs more working cash, not less, because wages and supplier costs can rise before customer payments catch up.
Review it often enough to trust it
A forecast prepared once a year quickly becomes outdated. Sales timing changes, customers pay late, costs increase and unexpected repairs happen. Review a weekly forecast every week, ideally at the same time you review overdue invoices and upcoming bills.
Compare what you predicted with what actually happened. If receipts are consistently later than expected, change the assumptions. If fuel, materials or payroll costs have increased, update future periods. This is not about getting every number perfect. It is about improving the quality of your decisions as new information becomes available.
It also helps to compare your forecast with the bank balance and your management reports. If the figures do not make sense together, investigate the difference. It could be an invoice not yet entered, a bill coded incorrectly, a duplicated transaction or an expense that has not been included in the plan.
Watch for these warning signs
Certain patterns deserve attention before they become routine. Repeatedly using GST or PAYG funds to cover operating costs is a sign that the business needs a clearer cash plan. So is relying on a single large customer payment to meet wages, carrying old unpaid invoices, or having no allowance for tax and equipment replacement.
Another warning sign is confusing an available overdraft or credit card limit with spare cash. Finance can be useful when it supports a clear purpose and repayment plan. It is less helpful when it repeatedly covers a timing issue that has not been addressed.
Set aside tax funds separately where possible. A dedicated account does not change the tax amount, but it makes the money harder to accidentally spend and makes upcoming obligations easier to see.
Keep the forecast practical
A good cash forecast should be easy to update, easy to explain and detailed enough to guide the next decision. Do not build a complex model that no one has time to maintain. Start with the next 13 weeks, use actual customer and supplier behaviour, and add detail where it affects cash.
For many small businesses, regular bookkeeping and clear reporting are the foundation. Once the records are current, a forecast turns those numbers into a practical view of what is ahead. Venables Accountants can help business owners put the right reporting rhythm in place, particularly where Xero data needs to become clearer day-to-day decisions.
The best time to look at cash is before you need it. A forecast gives you that breathing room: enough visibility to protect the commitments that matter and enough control to move forward with purpose.
