Thirteen-Week Rolling Cash Budget

A thirteen-week rolling cash budget is a short-term liquidity management tool that shows, for roughly the next three months, how much cash inflow the business will generate each week, which payments it must meet, and when a possible financing need may arise. In manufacturing firms, raw-material purchases, energy costs, payroll, tax and social-security payments, loan instalments, and capital spending often cluster in different weeks, while customer collections may not follow the same rhythm. A monthly cash budget can therefore hide some critical squeezes; a weekly view reveals the timing of a cash shortfall earlier.

The model is 'rolling' in the sense that the budget is updated every week. When week one is complete, actual collections and payments drop out of the budget, a new week fourteen is added, and the view is rolled forward to thirteen weeks again. The budget thus ceases to be a one-off forecast and becomes a continuously refreshed early-warning system.

Assume the example company is a mid-sized industrial firm producing metal parts. At the start of the model, available cash is 4.0 million TL, the minimum cash buffer management wishes to preserve is 1.5 million TL, and the usable revolving credit limit is 8.0 million TL. Customer collections for the next thirteen weeks are built from open-account receivables, cheques, and confirmed project milestones; cash outflows from supplier terms, payroll, tax/social security, energy, loan principal and interest, maintenance, and investment plans.

The reliability of each line should also be flagged. Confirmed bank instalments, payroll, and contractual payments are highly reliable; collections confirmed by the customer but not yet in the account are highly probable; sales not yet converted to orders or investments subject to management approval should be treated as conditional items. Management can then see not only the total cash forecast but also how much of it is genuinely reliable.

The minimum cash buffer is a safety level set by management so daily operations can continue without interruption. It is not the same in every company; it should reflect payroll intensity, raw-material supply terms, availability of bank limits, and volatility of collections. If cash inflows and outflows are tracked not only in total but also by customer, supplier, and payment type, the real cause of an approaching squeeze becomes easier to identify. Management can then take more targeted measures—speeding collections or rescheduling specific payments—rather than drawing credit by default.

Example thirteen-week cash view

The consolidated table shows, from each week's opening cash, the effect of collections and payments, pre-financing closing cash, and—where needed—the actual closing balance after new credit use. A week's post-financing closing cash is the next week's opening cash. (Amounts in million TL)

Week	Opening Cash	Collections	Payments	Net Flow	Pre-Fin. Closing	New Credit	Post-Fin. Closing	Surplus/(Gap) vs Buffer
1	4.00	4.00	3.25	0.75	4.75	0.00	4.75	3.25
2	4.75	4.10	6.10	-2.00	2.75	0.00	2.75	1.25
3	2.75	4.75	2.55	2.20	4.95	0.00	4.95	3.45
4	4.95	3.25	3.35	-0.10	4.85	0.00	4.85	3.35
5	4.85	4.80	0.90	3.90	8.75	0.00	8.75	7.25
6	8.75	2.40	6.45	-4.05	4.70	0.00	4.70	3.20
7	4.70	5.20	2.32	2.88	7.58	0.00	7.58	6.08
8	7.58	3.60	4.30	-0.70	6.88	0.00	6.88	5.38
9	6.88	2.30	3.60	-1.30	5.58	0.00	5.58	4.08
10	5.58	2.80	7.65	-4.85	0.73	0.77	1.50	0.00
11	1.50	3.20	1.61	1.59	3.09	0.00	3.09	1.59
12	3.09	2.00	2.30	-0.30	2.79	0.00	2.79	1.29
13	2.79	3.70	4.32	-0.62	2.17	0.00	2.17	0.67
TOTAL	—	46.10	48.70	-2.60	—	0.77	2.17	0.67

Weeks 1–5

The company starts with 4.00 million TL opening cash; despite a 2.00 million TL negative net flow in week 2, it does not need financing thanks to cash accumulated in the prior week. By the end of week 5, cash reaches 8.75 million TL—the strongest level in the period.

Week 6

Payroll, tax/social-security, and raw-material payments clustering in the same week produce 4.05 million TL of negative net cash flow. Even so, closing cash is 4.70 million TL because of the high balance carried over from week 5.

Week 8

Maintenance/capital spending of 2.20 million TL lifts weekly payments to 4.30 million TL. If capital spending depends on management approval, deferrable items should be flagged separately during cash-squeeze periods.

Week 10

This is the critical week of the period. Raw materials, payroll, and tax/social-security payments falling in the same week raise total payments to 7.65 million TL. Against 2.80 million TL of collections, net cash flow is -4.85 million TL. Pre-financing closing cash falls to 0.73 million TL; to preserve the 1.50 million TL minimum buffer, 0.77 million TL of new credit is drawn.

Weeks 11–13

After credit use, cash recovers and post-financing closing cash at week 13 is 2.17 million TL. Over the period, collections total 46.10 million TL, payments 48.70 million TL, and pre-financing net cash movement -2.60 million TL.

Preparing the budget alone is not enough. Each week, actual cash flows should be compared with planned amounts; delayed collections should be rolled to later weeks, new orders and supplier terms added, and used credit limits and bank balances updated. The view is thus continuously rebuilt.

When a cash gap appears in a given week, the first option should not automatically be to draw credit. Collection acceleration, customer advances, early collection against discount, extending supplier terms, deferring non-essential investment, or rescheduling stock purchases should be considered first. By contrast, payroll, tax/social security, and critical production inputs—payments where delay carries high risk—should be treated as priority.

The reliability of a rolling budget depends on a regular weekly close routine. For example, on Friday the finance team may close bank balances and actuals while sales updates customer payment confirmations and purchasing updates new orders and supplier terms. On Monday the CFO can share the revised thirteen-week view with management, explaining the lowest cash level, credit need, and variances versus the prior week. Base and stress scenarios for collection delays, cost increases, or FX-driven payment pressure also help liquidity resilience to be seen in advance.

A thirteen-week rolling cash budget answers the question of which week cash will tighten, why, and what can be done about it today. Applied well, it is a powerful management tool that brings collection, payment, credit, and working-capital decisions together in one table.