Establishing a 13-Week Rolling Cash Flow Forecast in Xero

A 13-week rolling cash flow forecast tracks your actual bank balance plus expected weekly customer receipts minus planned supplier bills, wages, and statutory obligations across a full quarter. This workflow gives Australian business owners immediate visibility over short-term liquidity without complex financial engineering. By grounding every number in reconciled accounting records, you know exactly how much cash sits in your bank account today and where your balance will land 90 days from now.

This analysis on establishing a practical, data-driven workflow for bookkeepers and business owners to extract actuals, align short-term accounts payable and receivable cycles, and maintain an accurate 13-week rolling cash position without complex modelling is written by Graham Chee, FCPA, CPA — Fellow of CPA Australia since November 2005, continuous CPA member since 1986, and principal of Local Knowledge.

Whether you run a plumbing trade across the Inner West, a busy cafe in Surry Hills, or a growing startup in South Sydney, cash flow worry usually strikes when due dates creep up unnoticed Sydney accounting specialists. When your day-to-day bookkeeping is systematised, you never have to guess whether you can cover Friday's payroll, next month's Business Activity Statement (BAS), or your quarterly superannuation. Here is how to keep it simple, stay on top of your obligations, and build a forecast you can rely on.

Most business owners look at their bank app in the morning and see an artificially inflated balance. For example, a local electrical contractor might see $65,000 in their everyday operating account and think cash is healthy. However, that figure does not reflect $18,000 of materials due to trade suppliers on the 20th, an upcoming $12,000 quarterly superannuation payment due on the 28th, or a $16,000 wages run next Thursday. Without a rolling forecast, that money gets spent on new equipment, leaving the business owner scrambling when the direct debits bounce.

A practical 13-week forecast avoids this trap by dividing the financial quarter into 13 manageable weekly buckets. In our principal-led practice, established in Mascot in 2003, we teach business owners to run this rhythm weekly. You extract your opening reconciled cash balance from Xero proactive financial planning and liquidity management. Then, you review your aged receivables to enter real collection expectations—adjusting for slow-paying commercial clients. Next, you plot planned supplier disbursements, factoring in your payment terms. Finally, you slot in fixed statutory overheads: your monthly PAYG instalment, quarterly GST from your BAS, and rent on your commercial lease. By mapping these out week by week, you spot an upcoming cash dip six weeks before it happens, giving you ample time to collect outstanding invoices or adjust discretionary spending.