Design systems

When Revenue Grows but Cash Gets Tight: A 13-Week Forecast for Business Owners

A business can finish a month with a healthy sales report and struggle to cover payroll the following week. A growing wholesale company might need to buy stock before customers pay. A services firm might deliver a large project and wait for sign-off before it can invoice. A 13-week cash forecast helps leadership see when those timing differences become a funding problem and how much room there is to act.

Build the forecast from dates when cash will move

Use one column per week and start with the bank balance available for operating payments. List expected collections and other receipts separately from cash outflows. Give payroll, supplier invoices, rent and scheduled debt payments their own lines. Move each week’s closing balance into the next week’s opening balance.

Enter receivables according to expected payment dates. Check when customers normally pay and whether there are open disputes, missing purchase orders or acceptance milestones. An invoice due in week four may belong in week six if the customer consistently takes two extra weeks. If a payment depends on a customer approval, add an owner and a date to check it. Treat that dependency explicitly in your forecast instead of concealing it within a total.

Track the week’s lowest point

A weekly closing balance can overlook an earlier shortfall. Imagine opening the week with $42,000. Payroll of $28,000 and supplier payments of $19,000 are due Tuesday. A $33,000 receipt is expected Friday. The forecast closes at $28,000, yet the business needs another $5,000 on Tuesday to cover the scheduled outflows. Where receipts and payments are tightly spaced, show the dates for large movements or break the current week into daily columns.

Set an operating cash floor based on the obligations that must be met between reliable receipts and the time needed to act if a payment slips. If a single customer accounts for most incoming cash in a given week, test a scenario where that receipt arrives two weeks later. The point of the scenario is to identify the date by which someone must make a decision.

Match each action to the cash gap

Start by identifying controllable timing changes. Finance might confirm an invoice recipient and approval date. Operations might split a stock order if partial delivery still meets customer needs. A sales lead might agree to milestone billing on upcoming work that involves material upfront expense. Record the amount, responsible person, expected date and dependencies for each action.

Keep tentative actions visible separately until they are confirmed. If the supplier agrees to move a payment, put the revised date in the forecast and check whether a larger payment cluster has formed in the following week. If late receipts recur, review the commercial terms and invoicing process. Consistently carrying a longer collection cycle as sales grow is a different problem from resolving one overdue invoice.

Reconcile the forecast every week

Each Monday, replace the previous week’s forecast with actual movements, review the biggest variances and add a new week at the far end. Classify material variances by what changed. An overdue payment affects timing. A credit affects the amount you can expect to collect. A supplier invoice missing from the forecast points to an intake problem.

Keep inventory purchases and supplier payments connected. If a supplier takes a deposit at order and the remaining balance on dispatch, forecast both payments and check whether each has an owner. Review large orders planned just outside the forecast window as well. Their deposits can fall inside the 13 weeks even when deliveries and associated customer payments are months away.

Ask the same questions at each review. Which week has the lowest available cash? Which receipt or payment could move that balance materially? What decision must be made before the next review? A forecast earns its place in a 2027 operating routine when the team can answer those questions and assign the next action while it still has options.