Rising sales or a profitable income statement do not necessarily mean a business has enough cash available every week. Late customer payments, shorter supplier payment terms, or several large expenses falling within the same period can put pressure on daily operations. A 13-week cash flow forecast makes these timing differences visible by mapping expected cash receipts and payments across approximately three months.
The preparation process starts with establishing the opening cash balance, assigning receipts and payments to the weeks in which they are expected to occur, and calculating each week’s closing balance. The value of this exercise extends beyond producing a projection. When regularly compared with actual cash movements, it reveals changing assumptions and helps management assess collection priorities, payment commitments, and funding requirements earlier.
What Is a 13-Week Forecast, and Why Use 13 Weeks?
This forecast is a short-term planning tool that tracks a business’s expected cash movements over thirteen consecutive weeks. It focuses on when money is expected to enter or leave the business, rather than when revenue or expenses are recognized in the accounts. This approach allows credit sales, supplier payments, and recurring operating expenses to be assessed against the cash available during the same period.
Thirteen weeks cover approximately one quarter while preserving enough detail for weekly planning. This makes temporary cash shortages easier to identify than they would be in monthly totals. For example, a business expecting a positive month-end balance could still face a significant payment shortfall in the second week. The thirteen-week period is a practical planning horizon rather than a mandatory or universally applicable standard.
What Information Is Needed to Prepare the Forecast?
The first step is to establish the cash available on the forecast’s starting date. Cash on hand and bank balances should be checked, with restricted or blocked funds separated from amounts available for use. Undrawn credit facilities should not be included in opening cash. Customer receivables, supplier liabilities, payroll, rent, tax and social security payments, loan instalments, and other anticipated cash movements should then be collected from the relevant teams.
Amounts alone are not sufficient. Each item should include an expected receipt or payment date, its currency, and the assumptions supporting its inclusion. Preparing a cash flow forecast requires accounting records to be assessed alongside current information from sales, purchasing, and operations. Overdue receivables, committed expenditure that has not yet been invoiced, and one-off expenses deserve particular attention to prevent missing or duplicated entries.
How Do You Build a Weekly Cash Flow Table?
The columns should represent thirteen weeks, while the rows show opening cash, cash receipts, cash payments, and closing cash. Clearly stating each week’s start and end dates helps prevent transactions from being assigned to the wrong period. A weekly cash flow table should provide enough detail to support decisions without becoming difficult to maintain because of excessive categories that add little practical value.
Receipts and payments should appear in separate sections, and financing movements should be distinguishable from operating cash flows. Transfers between the business’s own accounts should not be counted as additional receipts when both accounts are included in the forecast. Where several currencies are involved, conversion assumptions should be documented. One person should coordinate the forecast, with clear responsibilities for data providers and an agreed weekly update schedule.
Which Dates Should Be Used for Receipts in a Weekly Cash Flow Forecast?
Receipts should be assigned to the week in which payment is expected, rather than the week of the sale or invoice date. Contractual payment terms provide a starting point, but customer payment patterns, unresolved account discrepancies, and current payment commitments should also be considered. Overdue receivables should not automatically be placed in the first week. For card sales, use the expected settlement date when the funds become available in the business’s bank account.
How Should Payments Be Scheduled in a Weekly Cash Flow Forecast?
Payments should be assigned to the weeks in which cash is expected to leave the business. Supplier due dates, payroll dates, loan instalments, and other payment obligations should be checked individually. Distinguishing between committed payments and provisional expenditure makes the forecast easier to interpret. A planned payment deferral should not be treated as agreed until the relevant party has accepted it. Check that the same liability does not appear in both an invoice schedule and another payment category.
How Are Weekly Opening and Closing Cash Balances Calculated?
Each week’s closing cash balance is calculated by adding total cash receipts to opening cash and subtracting total cash payments. That closing balance becomes the following week’s opening balance. Consequently, a change in the timing or amount of a receipt or payment affects both the relevant week and subsequent balances. The first week’s opening figure should come from verified available cash on the starting date, rather than an estimated amount.
For example, a business starting the week with TRY 500,000, expecting receipts of TRY 300,000 and payments of TRY 450,000, would close with TRY 350,000. The next week would begin with that amount. Receipts and payments must be recorded consistently for this calculation to remain reliable. Loan drawdowns and repayments should be shown explicitly so that management can understand which movements produced the resulting balance.
How Do You Identify a Cash Shortfall in the Weekly Forecast?
A cash shortfall arises when available cash and expected receipts cannot cover a week’s anticipated payments. However, reviewing negative closing balances alone is not enough. A business should also establish the minimum cash balance needed to support its daily operations. Even a positive closing balance may require attention if it falls below that level, particularly when there is limited flexibility over payment dates or uncertainty around receipts.
Weekly totals do not always reveal the order of transactions within the week. A large payment due on Monday cannot necessarily be covered by a receipt expected on Friday, even if the weekly closing balance appears adequate. Critical weeks may therefore require a daily breakdown. Once the amount, timing, and duration of a shortfall are understood, management can assess collection actions, expenditure timing, and funding options. Unconfirmed solutions should not be treated as secured cash.
How Should Delayed Customer Payments Be Reflected in the Forecast?
If a customer payment is expected to arrive late, remove it from the original week and move it to the revised expected collection week. Leaving the amount in both periods overstates available cash. If a reliable new date cannot be established, flag the uncertainty and assess the funding requirement if the payment does not arrive within the forecast period. Receipts representing a substantial share of expected inflows require particular attention.
A 13-week cash flow plan can include an adverse collection scenario alongside the base forecast. For example, management can assess which weeks would fall below the minimum cash balance if a major customer paid two weeks late. The reasons for scenario adjustments should be clear, and assumptions should be applied consistently. The purpose is to understand the potential impact of a delay and the time available to respond.
How Should the Forecast Be Updated Each Week?
The forecast should be refreshed using an agreed weekly cut-off date. Verify the completed week’s bank and cash movements, compare actual results with expectations, and update assumptions for the remaining weeks. Changing the closing balance alone is insufficient. Delayed collections, earlier payments, new orders, and cancelled expenditure should also be reflected in the relevant periods so that the forecast continues to represent the business’s current position.
Keeping a copy of the previous forecast makes changes easier to trace. From STB CPA Turkey’s perspective, the exercise is most useful when accounting information is considered alongside current collection and payment expectations. Defined responsibilities, consistent data preparation, and explanations for significant variances help management interpret the figures more clearly. Each update should identify the most pressing cash requirements and the actions that need to be monitored during the following week.
How Should Differences Between Forecast and Actual Weekly Cash Flow Be Reviewed?
Separate changes in amounts from changes in timing. A payment postponed until the following week does not mean the expense has disappeared. Similarly, an early customer payment does not necessarily indicate higher sales. Significant variances should be discussed with the responsible team, and recurring differences should inform future assumptions. This makes the review useful both for understanding past movements and for improving the reliability of subsequent forecasts.
How Do You Remove the Completed Week and Add a New Forecast Week?
Archive the completed week with its actual figures, remove it from the active forecast period, and add a new week at the end. Reconcile the new opening balance with actual available cash. Prepare the additional week’s receipts and payments using current due dates, contracts, and operating plans. Check for seasonal or period-specific differences instead of simply copying the previous final week. This rolling approach maintains a forward-looking thirteen-week view after every update.
