A 13-week cash flow forecast is a rolling weekly schedule of beginning cash, expected receipts, expected payments, and ending cash across the next thirteen weeks. It uses actual payment timing rather than income-statement recognition, with customer-level collections and obligation-level disbursements where amounts are material. This is an educational framework, not individualized financial, investment, accounting, legal, or tax advice. Apply it with verified records and obtain qualified help when consequences are material or rules are uncertain.
Who this is for: Owners, finance teams, and operators managing near-term business receipts, payroll, suppliers, financing, and cash commitments.
- Creating a 13-Week Cash Flow Forecast is useful only when definitions, dates, units, and source records are explicit rather than assumed.
- The lowest projected cash point and the assumptions behind it are more informative than a quarter total because obligations occur on specific dates. Treat the conclusion as evidence for a decision, not as certainty about future results.
- The forecast cannot assure liquidity because collections can be late, costs can arise unexpectedly, and financing availability can change. Record uncertainty and the next verification step before anyone acts on the analysis.
Define the measure and its boundaries
A 13-week cash flow forecast is a rolling weekly schedule of beginning cash, expected receipts, expected payments, and ending cash across the next thirteen weeks. It uses actual payment timing rather than income-statement recognition, with customer-level collections and obligation-level disbursements where amounts are material. Label the entity, period, currency, basis, and source so the boundary is clear before making comparisons.
The lowest projected cash point and the assumptions behind it are more informative than a quarter total because obligations occur on specific dates. Compare like with like, connect movements to transactions, and separate observed facts from assumptions.
Build a reviewable process
Reconcile opening cash, schedule receipts from invoice and customer evidence, schedule payroll and other payments by due date, calculate each week, and roll forward regularly. Preserve a reference beside each important input and name the preparer and reviewer so another person can reproduce the work.
Separate confirmed from estimated flows, prevent double counting, reconcile the first forecast week to actual bank activity, and track forecast error by category. Investigate differences rather than forcing agreement, and keep actual records separate from forecast assumptions.
Calculate and interpret carefully
In a hypothetical first week, $25,000 opening cash plus $80,000 receipts minus $92,000 payments equals $13,000 ending cash, which becomes the next week's opening balance. Show formulas, signs, units, and rounding, and label every estimate instead of implying unsupported precision.
The forecast cannot assure liquidity because collections can be late, costs can arise unexpectedly, and financing availability can change. Funds, bonds, diversification, and rebalancing can still lose value, and none assures safety or profit.
Document the decision and revisit it
Keep bank reconciliations, receivable detail, payment calendars, payroll schedules, contracts, confidence labels, weekly variance explanations, and owner sign-off. Identify the owner, review date, open questions, and trigger for updating the analysis when facts change.
Creating a 13-Week Cash Flow Forecast does not produce a universal answer. Keep the work educational and scenario-based, and seek a qualified professional for advice about a specific person or organization.
Hypothetical worked example: 13-week cash forecast
A fictional distributor builds the first week of a rolling forecast before extending the same method across thirteen weeks. Every figure is invented for teaching and is not a forecast, benchmark, recommendation, or description of market behavior.
- Reconcile hypothetical opening cash of $25,000 to bank records and remove any restricted amount from available cash.
- Support $80,000 of expected receipts with named invoices and realistic customer payment dates rather than invoice due dates alone.
- Schedule $92,000 of payments by actual due date and calculate $25,000 plus $80,000 minus $92,000 equals $13,000.
- Carry $13,000 into week two, label uncertain flows, and compare week-one forecast amounts with actual transactions after close.
Rolling cash forecast template
Reuse this review record when applying creating a 13-week cash flow forecast to a new period or hypothetical scenario.
- Opening cash: bank reconciliation, restrictions, available amount, date, and reviewer.
- Receipts: customer, invoice, amount, expected date, confidence, evidence, and owner.
- Payments: payee, purpose, amount, due date, priority, evidence, and approval status.
- Weekly bridge: beginning cash, receipts, payments, ending cash, formula check, and low point.
- Forecast control: actual variance, assumption update, scenario note, action owner, and roll date.
Common mistakes
- Forecasting collections solely from invoice due dates without considering customer-specific evidence and disputes.
- Using quarterly totals that conceal a weekly cash shortfall between receipts and required payments.
- Counting a financing inflow as certain before terms, approvals, conditions, and availability are verified.
Try one
A large customer payment moves from week three to week five. What should change in the forecast and review?
A strong answer moves the receipt to week five, recalculates every intervening ending balance, identifies the new low point, and checks obligations due before collection. It records the evidence and confidence level, assigns follow-up with the customer, and evaluates lawful operational responses without pretending the receipt or outside financing is certain. Later, it compares the revised forecast with actual timing.
Sources
- CFPB Your Money, Your Goals toolkitCFPB worksheets and educational tools for cash flow, savings, bills, and debt choices.
- IRS small business recordkeeping guideIRS guidance on records supporting income, expenses, property basis, returns, and financial statements.