A 13-week cash flow forecast gives treasury a weekly liquidity view

A 13-week cash flow forecast is a rolling, week-by-week view of expected cash receipts and disbursements over roughly one quarter. It begins with cash on hand, adds expected collections and other inflows, subtracts planned payments, and shows the expected cash balance at the end of each week. Its purpose is practical: to identify whether cash should cover payroll, suppliers, taxes, debt service and other near-term obligations early enough for management to address timing gaps.

The forecast uses the direct method, meaning it follows expected receipts and disbursements. That differs from an indirect cash flow statement, which starts with net income and adjusts for non-cash items and balance-sheet movements, typically after an accounting close. A 13-week model is a management forecast rather than an audited financial statement. Working-capital timing can affect whether a profitable business has sufficient cash in a particular week.

What belongs in a 13-week cash flow forecast

Use one column for each week and keep the layout consistent from one update to the next. The basic cash bridge is:

Ending cash = beginning cash + cash receipts − cash disbursements

Ending cash in one week becomes beginning cash in the next. Where relevant, a separate line can show available capacity under a revolving credit facility, rather than treating undrawn borrowing capacity as cash.

Recommended weekly layout

• Beginning cash: the cash balance available at the start of the week.
• Receipts: customer collections, cash sales and expected financing receipts.
• Operating disbursements: supplier or accounts-payable payments, payroll and wages, rent, insurance, taxes, capital expenditure and other operating costs.
• Financing and other disbursements: loan payments, interest, fees and other non-operating items.
• Net cash movement: receipts less all disbursements.
• Ending cash: beginning cash plus net cash movement.

Separating payroll, taxes, debt service and supplier payments can make the forecast more useful for weekly liquidity decisions.

How to build a 13-week cash flow forecast

1. Set the cash baseline. Reconcile the opening cash position to bank or cash records.
2. Map receipts to expected collection dates. Start with accounts receivable and known customer-payment information. The forecast should reflect expected receipt timing rather than booked revenue, because a sale does not add cash until payment is collected.
3. Load the near-term payment calendar. Scheduled supplier payments are a starting point for the first weeks. Add approved invoices with expected payment dates, then use modeled timing for invoices still in approval. Pull payroll, rent, tax and debt-service amounts from their respective calendars.
4. Model the later weeks explicitly. Later weeks have less confirmed information. Use recurring-payment registers, known commitments, purchase orders and category run rates, allowing for seasonality where the business has evidence for it. Converting a purchase order into a cash forecast requires an assumption about when it becomes an invoice and when that invoice will be paid. Label it as an assumption.
5. Calculate the weekly cash bridge. Add receipts, subtract operating and financing disbursements, and carry the resulting ending cash balance into the next week.
6. Assign accountability. Practitioner guidance calls for one owner of the full model and named contributors for key inputs, such as receivables, payables, payroll and debt. Record the source and timing assumption behind material forecast lines.

A simple weekly cash bridge

Consider a hypothetical first week. Beginning cash is $500,000. Expected customer collections total $220,000 and a financing receipt is $30,000. Planned supplier payments are $180,000; payroll is $140,000; rent and taxes total $45,000; and interest is $15,000.

• Total receipts: $220,000 + $30,000 = $250,000
• Total disbursements: $180,000 + $140,000 + $45,000 + $15,000 = $380,000
• Net cash movement: $250,000 − $380,000 = negative $130,000
• Ending cash: $500,000 − $130,000 = $370,000

The result is not a judgement on profitability. On these assumptions, cash falls by $130,000 during that week. Management can then test the inputs and review the expected timing of collections, payments and funding.

Run the weekly control loop

A useful forecast is maintained, not produced once. At the end of each week, replace the prior forecast with actual cash activity and compare each material line with what had been expected. Explain meaningful differences: a customer may have paid late, an invoice may have been approved earlier than assumed, or a tax payment may have landed in a different week.

Then revise timing assumptions, move every remaining forecast column forward by one week and add a new week 13. This creates the rolling horizon. A threshold-based review can focus the team on material misses rather than treating every small deviation as equally significant.

Read the result with the right degree of confidence

Forecast quality changes across the horizon. The nearest weeks can draw on scheduled payments, known receipts and fixed calendars, while later weeks rely more heavily on assumptions about purchase orders, recurring spend, approval lags and collection behaviour. A forecast should distinguish confirmed items from modeled commitments and preserve the assumptions used.

The model has long been associated with restructurings, liquidity crunches and lender requests. It is also used as a regular liquidity-management discipline: to spot a payment-week gap, assess cash available for debt service, and improve visibility over receivables and payables. Regular forecast-versus-actual review can identify timing assumptions that require adjustment.

Controls that keep the model decision-ready

• Reconcile beginning cash to bank records each refresh.
• Keep actual results separate from forecast assumptions.
• Use dedicated calendars for payroll, taxes and debt payments.
• Document timing assumptions for purchase orders and unbilled commitments.
• Review material variances by line item and update the underlying driver.
• Maintain a stable layout so weekly work is a data refresh and review, not a rebuild.

A spreadsheet can be suitable while one person can maintain the model and assemble the required data in the weekly cycle. Practitioner guidance indicates that automation can become more relevant when entity count, transaction volume, multiple stakeholders or key-person dependency make assembly the bottleneck. The governing requirement is a reliable process for gathering cash data, challenging assumptions and updating the rolling view.

Frequently asked questions

What is the difference between a direct cash flow forecast and an indirect cash flow statement?

A direct forecast starts with expected cash receipts and cash payments, then calculates the resulting cash balance by week. An indirect cash flow statement starts with net income and adjusts for non-cash items and balance-sheet changes. The direct approach is used for forward-looking liquidity management, while the indirect approach is generally prepared as part of periodic financial reporting.

How do you update a 13-week cash flow forecast each week?

Replace the completed week's forecast with actual cash results, then compare forecast and actual figures by material line item. Explain significant variances, revise timing assumptions, shift the remaining weeks forward and add a new thirteenth week. This preserves a rolling quarterly view.

What line items should be in a 13-week cash flow forecast?

The core lines are beginning cash, customer collections and other receipts, operating payments, financing or other payments, net cash movement and ending cash. Common disbursements include supplier payments, payroll, rent, insurance, taxes, capital expenditure, loan payments, interest and fees. A company may separately show available revolving-credit capacity where applicable.

Sources

• What Is a 13-week Cash Flow Model? A Key Leadership ... — www.cbh.com
• What is a 13-week cash flow forecast, and why 13 weeks? — www.stampli.com
• 13-Week Cash Flow Model (TWCF) - Financial Edge Training — www.fe.training
• What is the 13-week cash flow forecast? - Intuit Enterprise Suite — erp.intuit.com