13-Week Cash Flow Forecast: A Practical Guide

A 13-week cash flow forecast projects expected cash receipts and payments by week over roughly one quarter. It starts with available cash and shows how customer collections, payroll, vendor payments, taxes, and financing activity affect the balance. The goal is practical: identify when cash may become tight and decide what to do before the shortfall arrives.

The 13-week window captures recurring payment cycles while keeping the focus on near-term decisions. It complements your annual budget by translating operating plans into expected cash movements. It helps answer a question a profitable income statement cannot answer on its own: will the business have enough available cash to meet its obligations each week?

Why forecast cash receipts and payments directly?

The direct method forecasts cash coming in and going out by category and expected payment date. Instead of starting with accounting profit, it focuses on customer collections, payroll, vendor payments, and other cash movements. That detail helps management understand which receipts and payments drive a potential shortfall.

Compare the forecast with your monthly financial plan to check that the assumptions align. Differences may reflect collection timing, inventory purchases, capital spending, or other cash movements. Investigate those differences so the budget and cash forecast provide a consistent view of the business.

Structure of the forecast

Use a consistent layout with one column for each week. Separate operating receipts, operating payments, investing activity, and financing so readers can understand what is changing cash.

Receipts

• Collections from existing accounts receivable, using customer payment history and current collection expectations.
• Collections from new sales, allowing for billing dates and realistic payment timing.
• Other receipts, such as tax refunds or insurance proceeds, shown separately.

Operating disbursements

• Payroll, payroll taxes, benefits, and commissions scheduled when cash will leave the business.
• Inventory and material payments based on purchasing plans and supplier terms.
• Rent, utilities, insurance, and other operating expenses.
• Vendor payments supported by accounts payable records and agreed payment arrangements.
• Applicable tax payments scheduled for their expected payment dates.

Investing, financing, and separately tracked items.

• Capital expenditures and proceeds from asset sales.
• Borrowings, principal repayments, and equity contributions or distributions.
• Interest payments, shown consistently and separately from principal.
• Significant one-time payments, including transaction or restructuring costs where applicable.

Liquidity summary

Show beginning cash, total receipts, total payments, and ending cash for each week. If the business has a credit facility, show remaining borrowing availability separately, after expected draws, repayments, and applicable lending limits. Compare available liquidity with the minimum cash needed to operate, and identify weeks requiring action.

Building it step by step

1. Establish opening cash using reconciled balances, accounting for outstanding payments, deposits in transit, and restrictions on use.
2. Review accounts receivable and assign expected collections to specific weeks.
3. Add collections from forecast sales without duplicating amounts already included in receivables.
4. Schedule payroll, payroll taxes, and benefits using actual payment calendars.
5. Schedule vendor payments using accounts payable records, supplier terms, and agreed payment plans.
6. Add other operating payments, taxes, capital spending, and financing activity.
7. Calculate weekly ending cash and remaining borrowing availability, where applicable.
8. Flag potential shortfalls and document assumptions, actions, and the person responsible for each follow-up.

Compare the forecast with actual results each week.

Each week, replace the completed week’s forecast with actual receipts and payments. Explain significant differences and distinguish timing changes from changes in the total amount expected. Use those findings to update the remaining weeks rather than carrying outdated assumptions forward.

• Review weekly and cumulative differences against a defined forecast version.
• Reschedule delayed receipts and payments so timing changes appear in the correct future week.
• Revise expected amounts when sales, costs, or collection expectations change.
• Add a new thirteenth week to maintain the rolling forecast.
• Track recurring forecasting errors and assign follow-up actions.

Using the forecast with lenders and the board.

A consistent cash forecast gives lenders and board members a clearer view of expected liquidity, key assumptions, and management’s planned actions. When external reporting is required, confirm the format, delivery schedule, and any variance or liquidity tests specified in the relevant agreement. Present the updated forecast alongside explanations of significant changes.

• Weekly delivery of an updated forecast and a variance report, often by a set day each week.
• Permitted variance covenants, commonly testing cumulative receipts and disbursements over a rolling period.
• Minimum liquidity tests based on the forecast's ending cash and availability.
• Approval rights over material deviations, such as unbudgeted payments or professional fees.

A useful cash forecast connects expected cash movements with decisions, owners, and deadlines.

Mistakes that undermine the forecast

• Spreading monthly budget amounts evenly across weeks instead of using expected cash dates.
• Assuming customers will pay on time despite a history of delays.
• Double-counting collections from existing receivables and forecast sales.
• Missing annual premiums, tax payments, bonuses, or other irregular expenses.
• Treating restricted cash or unavailable credit as spendable liquidity.
• Changing categories without explaining how the new version compares with prior forecasts.
• Leaving sales, operations, and purchasing teams out of the assumptions.

Keep the model simple enough to maintain. A consistent weekly update with clear assumptions is more useful than a detailed forecast that quickly becomes outdated.

Turning the forecast into action

When the forecast shows a shortfall, identify specific actions and their expected cash impact. Options may include following up on overdue receivables, resolving billing issues, negotiating supplier payment arrangements, adjusting purchasing, or deferring discretionary spending. Assign each action to someone and track it in the next update. Discuss financing needs early enough to evaluate available options.