Content reviewed and verified by Graham Chee, with FCPA-led practice at Local Knowledge, Mascot NSW. Continuous CPA Australia member since 1986. Prior career at Goldman Sachs, BNP Investment Management and Merrill Lynch.. Last reviewed October 2026. Next review scheduled for December 2026.
TL;DR
Keep your day-to-day cash sorted, see what is coming up, and remove the stress of surprise bills with a simple routine.
Key Takeaways
- Daily bank reconciliation is non-negotiable: An accurate rolling forecast must begin with fully cleared bank balances. Reconciling daily in Xero ensures that your starting figure represents real money, not pending estimates.
- Aged Receivables must reflect real collection habits: While AASB 15 requires recording revenue when earned, your cash forecast only cares about the day customer payments land in your account. Set realistic expected payment dates on invoices rather than relying solely on default 14-day terms.
- Aged Payables must protect trade supplier credit: Supplier bills should be scheduled based on true due dates to preserve credit standing and protect early payment terms under Australian trade terms.
- Fixed compliance deadlines must sit permanently in your calendar: The ATO requires quarterly BAS lodgments by the 28th of the month following quarter-end (such as 28 October for Q1), and superannuation guarantee contributions (currently 11.5% under ATO rules) are payable quarterly by the 28th of the following month. These dates must be locked into your 13-week view.
- Payroll cycles take priority over discretionary expenses: Fair Work National Employment Standards require strict adherence to agreed employee pay frequencies. Your net wages and PAYG withholding liabilities must take immediate precedence in your cash allocations.
Mastering Your 13-Week Rolling Cash Flow in Xero
Clear, practical visibility over your business cash
A 13-week rolling cash flow forecast extracts cleared bank actuals, aged receivables, and aged payables directly from reconciled Xero accounts to track real cash movements across a single calendar quarter. By matching expected customer receipts with strict compliance deadlines like quarterly Business Activity Statements and monthly superannuation, business owners gain an accurate view of their cash balance without complex financial spreadsheets.
Graham Chee, FCPA, CPA, principal of Local Knowledge, writes from a practice that pairs FCPA-grade compliance with Goldman Sachs, BNP Investment Management and Merrill Lynch institutional experience to deliver practical bookkeeping workflows. Many small business owners in suburban Sydney—from electrical contractors in Alexandria to retail cafes in Marrickville and growing teams in Surry Hills—experience anxiety when looking at their bank balances business budgeting and financial forecasting strategies. Seeing cash in the bank today does not guarantee there will be enough to cover wages next Thursday or the quarterly BAS next month. This principal-led guide walks through a reliable routine to stay on top of your bank accounts, clean up overdue invoices, and establish clear visibility week by week.
Core Foundations of a Reliable Rolling Forecast
Key rules to keep your forecast grounded in real-world facts
Daily bank reconciliation is non-negotiable: An accurate rolling forecast must begin with fully cleared bank balances. Reconciling daily in Xero ensures that your starting figure represents real money, not pending estimates.
Aged Receivables must reflect real collection habits: While AASB 15 requires recording revenue when earned, your cash forecast only cares about the day customer payments land in your account. Set realistic expected payment dates on invoices rather than relying solely on default 14-day terms.
Aged Payables must protect trade supplier credit: Supplier bills should be scheduled based on true due dates to preserve credit standing and protect early payment terms under Australian trade terms.
Fixed compliance deadlines must sit permanently in your calendar: The ATO requires quarterly BAS lodgments by the 28th of the month following quarter-end (such as 28 October for Q1), and superannuation guarantee contributions (currently 11.5% under ATO rules) are payable quarterly by the 28th of the following month. These dates must be locked into your 13-week view.
Payroll cycles take priority over discretionary expenses: Fair Work National Employment Standards require strict adherence to agreed employee pay frequencies. Your net wages and PAYG withholding liabilities must take immediate precedence in your cash allocations.
Maintain a 13-week rolling horizon: Every Monday morning, add one new week to the horizon while archiving the week just completed. This ensures you always maintain clear sight across a full business quarter.
How This Works in Real Business Situations
Connecting your daily bookkeeping entries to 90-day cash decisions
Consider a suburban Sydney trade business running three vans. The owner checks Xero and sees $42,000 in the business transaction account. It looks healthy at first glance. However, looking ahead across the next 13 weeks reveals a different picture: $18,000 is due for quarterly BAS to the ATO in three weeks, $9,500 is due for employee superannuation guarantee contributions on the 28th, and trade suppliers have $14,000 in outstanding invoices for materials purchased on 30-day accounts.
Without a structured rolling forecast, that $42,000 can easily be spent on new equipment or discretionary expenses, creating a cash shortfall when ATO and payroll deadlines arrive Sydney accounting specialists. By running a systematised 13-week routine, you export your reconciled bank balance, sync your Aged Receivables and Aged Payables reports from Xero, and map out the timing of cash receipts and cash outflows. When you spot a lean week coming six weeks ahead, you have ample time to follow up slow-paying customers, reschedule non-urgent supplier purchases, or adjust your owner drawings to keep the business stable.
The Step-by-Step Bookkeeping Routine
A repeatable weekly workflow to keep your figures sorted
Reconcile to Zero
Start every Monday morning by reconciling all bank feeds in Xero. Match customer payments, process merchant fees, and ensure your Xero bank ledger matches your online bank balance to the cent.
Clean Up Sales Invoices and Bills
Run the Aged Receivables Detail report. Adjust the Expected Date field on late customer invoices to reflect when funds will realistically clear. Then run the Aged Payables Detail report to verify that trade supplier bills show correct scheduled payment dates.
Map Statutory Obligations
Slot in confirmed payroll obligations and statutory due dates across the next 13 weeks. This includes net wages, monthly or quarterly PAYG withholding, the Superannuation Guarantee (11.5%), and upcoming quarterly BAS lodgments.
Roll the Forecast Forward
Archive the week that just closed, compare your projected cash balance against your actual closing bank balance, and append a new week 13. Note any projected cash dips so you can act weeks before they occur.
Frequently Asked Questions
Straight answers to common cash flow questions
Q.Why is a 13-week forecast preferred over a 12-month budget?
A 12-month budget is an annual plan for overall profitability, whereas a 13-week forecast tracks real cash moving through your bank accounts across a single calendar quarter. It provides direct operational visibility to help you meet immediate commitments such as supplier invoices, payroll, and ATO compliance deadlines. proactive cash management solutions
Q.How often should our Xero cash flow forecast be updated?
The forecast should be updated weekly. The most effective routine is a Monday morning review: complete your bank reconciliations, check customer receipts, update bill payment dates, and roll the schedule forward by one week.
Q.What happens if a customer misses an agreed payment date?
In Xero, update the Expected Date field on that invoice immediately. Your 13-week forecast will shift that expected cash inflow into a later week, immediately highlighting whether you need to follow up the invoice or delay discretionary payments to maintain a healthy cash reserve.
Q.How do superannuation and BAS fit into the weekly forecast?
Superannuation guarantee contributions and Business Activity Statements are non-negotiable statutory payments. By mapping standard quarterly ATO deadlines (such as 28 October, 28 February, 28 April, and 28 July) directly into your weekly calendar, you ensure money is set aside well before lodgment day arrives.
About the Author
Graham Chee, FCPA, CPA, GRCP, GRCA
Principal and Founder, Local Knowledge
Graham Chee is the principal and founder of Local Knowledge, an FCPA-led Australian practice that brings institutional-grade compliance, investment-structure and intellectual-property experience directly to owner-managed businesses. Graham is a Fellow of CPA Australia (FCPA since November 2005, continuous CPA member since 1986) and holds the OCEG Governance, Risk & Compliance Professional (GRCP) and Governance, Risk & Compliance Auditor (GRCA) designations. His prior career includes senior roles at Goldman Sachs, BNP Investment Management and Merrill Lynch. Graham was previously portfolio manager of the Asian Masters Fund (IPO December 2007 – 31 December 2009), which returned +29% in AUD terms versus the MSCI Asia Pacific (ex Japan) benchmark. He signs off on 100% of client files personally.
Areas of Expertise:
Industry-specific insights
This article is especially relevant to these industries. See how we tailor our services for each.
Get Expert Guidance on Your Cash Flow - Speak with an Advisor
This article provides general informational guidance on bookkeeping workflows. Professional advice should be sought for specific business, accounting, or compliance requirements under Australian tax law.
Graham Chee FCPA, CPA, GRCP, GRCA · Principal, Local Knowledge · Mascot NSW · CPA-signed files