How to Build a 13-Week Cash-Flow Forecast

Shaikh, Nadeem Academy, September 2026. A 13-week cash-flow forecast is one of the most practical financial tools available to a business owner. Unlike annual budgets that become outdated quickly, a rolling 13-week forecast gives you a near-term, week-by-week view of your cash position. It tells you precisely when money is expected to come in, when it will go out, and whether you will have enough cash to cover your obligations. It is especially useful during periods of rapid business growth, cash pressure or tight liquidity, fundraising or debt negotiations, business restructuring, and seasonal trading patterns. Why 13 weeks? Thirteen weeks represents one quarter, long enough to reveal meaningful trends and anticipate problems before they become crises, but short enough that the data is reliable and actionable. How to build it step by step: Step one is to set up your spreadsheet with row labels, columns for Week 1 to Week 13, a Total column, and an Actual column. Split into three sections: Cash Inflows, Cash Outflows, and Net Cash Position. Step two is to list all cash inflows including customer payments based on your invoicing and payment terms, advance payments or deposits, loan drawdowns, tax refunds, asset sale proceeds, and investment receipts. Important: use the date the cash will actually arrive in your bank account, not the invoice date. Step three is to list all cash outflows including payroll and employer costs, rent and utilities, supplier payments, loan repayments and interest, tax payments, software subscriptions, insurance premiums, and capital expenditure. Step four is to calculate opening and closing cash balance: opening balance plus total inflows minus total outflows equals closing balance. The closing balance of Week 1 becomes the opening balance of Week 2. Step five is to identify problem weeks where cash goes negative or drops below a safe minimum. Plan ahead by bringing forward a customer payment, delaying a supplier payment, or drawing on a credit line. Step six is to update weekly, replacing Week 1 with actuals and adding a new Week 13. Common mistakes to avoid: using revenue instead of cash receipts, forgetting irregular payments like annual insurance premiums, not updating weekly, and being overly optimistic about customer payment timing. Book a Free Fractional CFO Consultation at https://nadeemacademy.com/contact/ This article is for informational purposes only and does not constitute regulated financial or tax advice.

Leave a Comment