How to Build a 13-Week Cash Flow Forecast Before Your Business Runs Short of Cash
Your business can be profitable on paper and still struggle to pay its bills. Sales may be increasing, customers may be placing orders, and the profit and loss statement may look healthy. Yet, when wages, supplier invoices, rent and tax payments fall due, the money available in the bank may not be enough. This usually comes down to timing. Customer payments may arrive later than expected, while business expenses still need to be paid on schedule. Without a clear view of upcoming cash movements, business owners often discover a shortage only when it becomes urgent. A 13-week cash flow forecast helps prevent this situation by showing how much money is expected to come into and leave the business over the next quarter.
Instead of relying only on the current bank balance or last month’s financial reports, you get a week-by-week picture of what your cash position could look like. For Australian businesses, this can make financial planning more practical, particularly when managing payroll, supplier payments, GST obligations, seasonal trading patterns and other regular operating costs.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a rolling financial projection that estimates a business’s cash receipts and payments for the next 13 weeks. It usually starts with the cash currently available, adds expected customer receipts and other income, then deducts payments scheduled during each week.
The result is an estimated closing cash balance for every week of the forecast period.
Unlike a traditional annual budget, which looks at expected income and expenses over a longer period, a 13-week forecast focuses on the timing of actual cash movements. This makes it useful for identifying when the business might experience a shortage, even when its overall revenue and profitability appear stable.
For example a business might be expecting $80,000 in customer payments during a particular month. Still, if most customers are likely to pay in the final week while wages, rent and supplier invoices fall due earlier, the business could face a temporary cash shortage.
A weekly forecast helps reveal that gap before it affects daily operations.
Why Businesses Need Cash Flow Forecasting
Managing cash flow is not just about knowing how much money is in the bank today. It is about understanding what is likely to happen next. A business may have enough money to cover this week’s expenses but face a much tighter position three or four weeks later. A large supplier payment, delayed customer invoice, tax obligation or unexpected repair can change the financial picture quickly.
Cash flow forecasting gives business owners more time to respond. It helps identify payment cycles, seasonal patterns and potential shortages so that financial decisions can be made before a problem becomes urgent. The Australian Government’s business guidance also recommends using cash flow statements to identify seasonal trends, anticipate shortages and plan for upcoming payments.
For small businesses, this can help with day-to-day financial control. For medium-sized companies, it provides better visibility over payroll, supplier commitments and operating expenses. Larger organisations can use cash flow projections to monitor multiple departments, locations and major payment obligations.
The value is not simply having another spreadsheet. It is having a clearer view of when money will actually be available.
How to Build a 13-Week Cash Flow Forecast
1. Start With Your Actual Bank Balance
Begin by recording the available cash balance at the start of the forecast. Use current bank information and reconcile it against your accounting records so that the opening figure reflects the actual financial position. Where a business operates through multiple bank accounts, include the relevant balances and clearly identify funds that are restricted, reserved or committed to particular purposes.
Just in case, collected for GST or amounts set aside for payroll obligations should not automatically be treated as freely available operating cash. The forecast should make these commitments visible so management can understand how much cash is genuinely available for everyday spending. Your opening balance is important because every future week’s closing balance depends on it.
2. Estimate Customer Payments and Other Cash Coming In
The next step is to identify when money is realistically expected to reach the business. Start with outstanding customer invoices. Review their due dates, payment history and current status. An invoice due on the 15th does not necessarily mean the money will arrive on that date. If a customer regularly pays two weeks late, your cash flow forecast should reflect a more realistic collection date.
Also include regular sales receipts, recurring contracts, deposits, grants, refunds or other expected income where applicable. Businesses with irregular sales should avoid relying entirely on optimistic sales projections. A more useful approach is to compare historical performance with current trading conditions and separate confirmed receipts from uncertain opportunities. This distinction matters. A forecast built around money that might arrive can give a misleading picture of the cash available to pay bills.
3. Record Every Important Business Payment
Once expected income is mapped out, list the payments the business will need to make during the 13-week period. These may include employee wages, superannuation payments, supplier invoices, rent, utilities, insurance, loan repayments, software subscriptions, marketing expenses and equipment purchases.
Australian businesses should also account for relevant tax and reporting obligations, including GST, PAYG withholding and other payments that apply to their circumstances. Use the actual applicable payment dates rather than simply spreading these amounts evenly across the forecast. The same principle applies to supplier payments. If an invoice is due in Week 3, record it in Week 3. Moving it into Week 4 just to make the forecast balance would hide the real cash requirement. A reliable cash flow forecast should reflect the dates on which money is expected to leave the bank account.
4. Organise the Forecast Into 13 Weekly Periods
Create 13 columns, with each column representing one week. Your rows should show opening cash, expected receipts, total cash inflows, planned payments, total cash outflows and closing cash. The basic calculation is:
Closing Cash Balance = Opening Cash Balance + Cash Inflows − Cash Outflows
The closing balance of one week becomes the opening balance of the following week. Repeat this calculation across all 13 weeks.
For example, imagine a business starts with $45,000 in available cash. It expects $32,000 in receipts during the week and has $39,000 in scheduled payments. Its estimated closing balance would be:
$45,000 + $32,000 − $39,000 = $38,000.
The next week begins with that $38,000 balance. The calculation continues until the forecast covers the full 13-week period. This simple structure makes it easier to identify which weeks are likely to be tight and whether the business has enough cash to meet its commitments.
5. Identify Weeks Where Cash Could Run Low
Once the calculations are complete, review every weekly closing balance. Do not focus only on the final balance at the end of Week 13.
A business might finish the quarter with a positive cash balance but still run short of money during Week 5 or Week 8. That temporary gap can create problems with payroll, suppliers or other essential payments.
Pay particular attention to weeks where several large payments fall close together. A tax payment, supplier invoice and payroll run within the same few days can place considerable pressure on available funds.
It is also useful to establish a minimum operating cash buffer. This is the amount the business would prefer to retain for routine expenses and unexpected needs. A projected closing balance above zero does not automatically mean the business is financially comfortable.
The aim is to identify pressure points early enough to take action.
6. Prepare Different Cash Flow Scenarios
A single forecast is based on assumptions, and business conditions can change. Customer payments may be delayed, sales may fall below expectations, or an unexpected expense may arise. For this reason, it is useful to prepare at least three scenarios.
A base-case forecast reflects what the business reasonably expects to happen. A conservative forecast assumes slower customer collections, lower sales or higher expenses. An optimistic forecast considers stronger sales and faster collections. Comparing these scenarios helps management understand how sensitive the cash position is to changes in income and costs.
For instance, a company might appear comfortable under its base-case forecast but experience a shortage if two major customers delay payment by a fortnight. Knowing this in advance creates an opportunity to review spending, follow up overdue invoices or arrange funding before the situation becomes critical.
7. Update the Forecast Every Week
A 13-week cash flow forecast should not be prepared once and left untouched. Its value comes from regularly comparing expected results with what actually happened.
At the end of each week, replace the previous week’s estimates with actual receipts and payments. Investigate significant differences, update future customer collection dates and include new supplier commitments or expenses. Then add another week to the end of the forecast so that the business always has 13 weeks of forward visibility. This rolling process helps keep the forecast relevant as trading conditions change.
It can also reveal recurring problems. If customer receipts consistently arrive later than expected, the business may need to review its credit terms, invoice follow-up process or customer payment procedures.
Common Mistakes That Make a Cash Flow Forecast Unreliable
Even a well-structured cash flow forecast can produce misleading results if the underlying information is inaccurate.
One common mistake is confusing profit with cash. Revenue recorded in the accounting system does not mean the customer has paid. Similarly, an expense recorded in one accounting period may not be paid until a later date. A cash forecast must focus on when money actually moves.
Another problem is using invoice due dates without considering customer payment behaviour. If customers regularly pay late, using the printed due date can overstate available cash.
Businesses also overlook irregular or less frequent payments. Annual insurance premiums, equipment purchases, tax obligations and scheduled loan repayments can create significant cash requirements that are easy to miss in a monthly review.
Finally, some companies prepare a forecast but never update it. As soon as actual results differ from the original assumptions, the forecast becomes less useful. Regular reviews and realistic adjustments are essential.
How Accounting and Bookkeeping Support Better Cash Flow Forecasting
A reliable forecast depends on reliable financial information. If invoices are missing, bank accounts are not reconciled or expenses are recorded late, the figures used for planning may not reflect the real position of the business.
Accurate bookkeeping creates a stronger foundation for cash flow management. Up-to-date records make it easier to review customer balances, monitor supplier commitments, understand operating expenses and identify upcoming payments.
Cloud accounting platforms such as Xero, MYOB and QuickBooks can help businesses maintain organised financial records and access information for regular reviews. The software alone does not guarantee an accurate forecast, however. The quality of the forecast still depends on realistic assumptions, correct transaction records and consistent monitoring.
For businesses that need more structured financial oversight, budgeting and cash flow management support can also help connect daily financial activity with longer-term business decisions.
When Should a Business Consider Professional Cash Flow Management Support?
A business may benefit from additional financial support when it regularly struggles to predict its bank balance, experiences delayed customer payments, has significant seasonal fluctuations or needs better visibility over future commitments.
The need can become more important as a company expands. More employees, larger supplier commitments, additional locations and higher operating costs can make it harder to manage cash through basic spreadsheets and occasional bank checks.
Eight Nerds provides bookkeeping, budgeting and cash flow management services to businesses with different operational requirements. With accurate financial records and a more structured approach to monitoring cash movements, business owners can make better-informed decisions about spending, growth and future commitments.
Build a Cash Flow Forecast Before Cash Becomes a Problem
A 13-week cash flow forecast gives a business something more useful than a snapshot of its current bank balance. It provides a forward-looking view of expected receipts, upcoming payments and the weeks when cash may become tight.
The process does not need to be complicated. Start with accurate bank balances, estimate customer receipts realistically, record payments on their expected dates and review the closing balance every week. Over time, consistent forecasting can help uncover patterns, improve financial planning and reduce the risk of being caught unprepared.
If your business needs better visibility over its finances, Eight Nerds can help with professional bookkeeping, budgeting and cash flow management support.
All Categories
Recent Posts
How to Build a 13-Week Cash Flow Forecast Before Your Business Runs Short of Cash