A 13-week cash flow model is a weekly cash forecast designed to anticipate liquidity pressures and make decisions with adequate lead time. Thirteen weeks represent a particularly useful horizon: they cover an operational quarter and allow hypotheses to be reviewed and adjusted with agility. For an SME, it tends to be more practical than a monthly forecast, as cash shortfalls arise in specific weeks and it is worth identifying them before they occur.
- The structure is straightforward: opening cash for the week, expected receipts, expected payments, net weekly result, and closing cash. To turn it into a genuine decision-making tool, a minimum cash buffer should be added — that is, the level below which the company enters a risk zone, for example to ensure payroll, taxes, and other critical payments can be met.
- Minimum template (weeks 1 to 13): each week should record the opening cash; receipts (sales according to the actual customer payment calendar, advances or extraordinary income, VAT refunds where applicable); payments (suppliers according to due dates, payroll and social security contributions, rent and utilities, taxes such as VAT and withholdings, debt repayments including principal and interest, and capital expenditure only if already committed); the net weekly result; the closing cash; and an alert if the closing balance falls below the established buffer.
- How to implement it without complications: First, work with actual receipt and payment dates, not on an accrual basis. Second, distinguish between certain and probable items: if a receipt depends on an acceptance, approval, or milestone, flag it as probable and do not include it in the base forecast. Third, avoid excessive aggregation: break down by categories that allow action to be taken (for example, key suppliers, taxes, or payroll). Finally, update the model every week in two steps: replace the forecast with actuals for the closed week, and roll the horizon forward by adding a new week at the end.
For it to truly work, it must become a routine: weekly close, review of alerts, and decision-making with defined owners and deadlines. In this way, cash management ceases to be a source of uncertainty and becomes a measurable action plan, week by week.
Taking the next step is easier with specialised support. The Oficina Económica de Galicia supports you with personalised advice and free resources to help your business grow.
