Profit does not always mean a business has enough cash to pay suppliers, employees, taxes, rent, or lenders on time.
Revenue may be recorded before customers pay, while many expenses require immediate cash.
A 13-week cash flow forecast tracks expected receipts, payments, and balances each week across roughly one fiscal quarter.
Management can use it to identify cash shortages, plan corrective action, and support discussions with lenders, investors, and creditors.
What Exactly Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a rolling weekly projection of cash inflows and outflows over approximately one quarter.
Once a week ends, actual cash activity replaces the original estimate, and a new thirteenth week is added.
Most models use the direct method. Cash is recorded when it is expected to enter or leave a bank account, not when revenue or expenses appear in accounting records.
Non-cash items such as depreciation, accruals, and provisions are generally excluded.
Thirteen weeks provides enough detail for near-term accuracy while giving management time to respond to future liquidity problems. Weekly periods can also reveal shortfalls that a monthly total may hide.
Why Businesses Use It
A 13-week forecast helps management identify cash shortages before payments become overdue.
When overdue invoices are already affecting liquidity, businesses may work with Summit A*R to support debt recovery and improve the timing of expected cash collections.
Possible actions include:
- Drawing on a credit facility
- Arranging short-term financing
- Accelerating customer collections
- Negotiating supplier payment dates
- Postponing capital spending
- Reducing discretionary expenses
- Adjusting inventory purchases
- Rescheduling intercompany payments
Weekly visibility also improves working-capital decisions by showing when customer receipts, supplier payments, payroll, taxes, and debt obligations are expected.
Debt-related uses include covenant monitoring, debt-service coverage analysis, cash-conversion management, and borrowing-capacity assessments.
Banks, investors, creditors, and board members can use the forecast to review liquidity, financing needs, and payment capacity.
A 13-week period also aligns with quarterly reporting and planning cycles.
What the Forecast Includes
Opening cash is the verified amount available at the start of the forecast. Included bank accounts, legal entities, and business units should be reconciled.
Restricted or unavailable cash should be excluded when it cannot fund normal operations.
Cash inflows
Common inflows include:
- Customer payments
- Accounts-receivable collections
- Loan proceeds
- Intercompany transfers
- Asset-sale proceeds
- Tax refunds
- Insurance proceeds
- Other incoming cash
Receipt dates should reflect actual customer payment behavior, not only invoice due dates.
Cash outflows
Common outflows include:
- Supplier payments
- Payroll
- Rent
- Taxes
- Debt principal and interest
- Capital expenditures
- Utilities
- Insurance
- Professional fees
- Operating expenses
- Intercompany payments
Payments should be entered according to expected bank dates.
Net weekly cash flow
Net weekly cash flow equals total inflows minus total outflows.
Closing cash balance
Closing cash equals opening cash plus net weekly cash flow. Each closing balance becomes the next week’s opening balance.
How to Build a 13-Week Cash Flow Forecast
Now let’s guide you through a step-by-step process on how to build a 13-week cash flow forecast.
Step #1 – Define the purpose and scope
Identify the decisions the forecast must support, such as liquidity management, lender reporting, refinancing, restructuring, covenant monitoring, or operating planning.
Define:
- Included legal entities
- Included bank accounts
- Included business units
- Included currencies
- Treatment of restricted cash
- Treatment of intercompany transactions
- Reporting frequency
- Minimum liquidity thresholds
Step #2 – Design the model
Create 13 weekly columns.
Group cash movements into operating, investing, and financing categories when useful.
Include rows for:
- Opening cash
- Cash inflows
- Cash outflows
- Net cash flow
- Closing cash
- Minimum liquidity requirement
- Available headroom or shortfall
Supporting schedules may cover customer receipts, supplier payments, payroll, taxes, debt, and capital expenditures.
Step #3 – Confirm the opening cash balance
Reconcile all included bank accounts before adding projections.
Remove cash that cannot be used because of legal restrictions, lender requirements, currency controls, subsidiary limits, or minimum balance rules.
Review intercompany cash carefully, since funds held by one entity may not be available to another.
Step #4 – Gather source data
Use current data such as:
- Bank feeds
- ERP records
- Bank statements
- Accounts-receivable aging reports
- Accounts-payable reports
- Payroll schedules
- Tax calendars
- Debt schedules
- Operating budgets
- Capital-expenditure plans
- Sales forecasts
- Purchase orders
- Contract payment terms
Assign responsibility for each input, update, and assumption.
Add manual entries for unusual transactions, settlements, asset sales, financing events, or payments not yet recorded in core systems.
Step #5 – Forecast weekly cash inflows
Assign each expected receipt to the week in which cash is likely to arrive.
Consider:
- Contractual payment terms
- Customer payment history
- Overdue balances
- Customer credit quality
- Billing disputes
- Seasonal collection patterns
- One-time receipts
- Tax refunds
- Financing proceeds
- Intercompany transfers
Review large receipts individually when their timing materially affects liquidity.
Near-term estimates should rely mainly on current invoices, collection schedules, and confirmed payment commitments.
Step #6 – Forecast weekly cash outflows
Schedule each payment according to its expected bank date.
Include:
- Trade suppliers
- Payroll and employee benefits
- Payroll taxes
- Sales taxes
- Income taxes
- Rent and property costs
- Loan principal
- Loan interest
- Lease payments
- Capital expenditures
- Insurance
- Professional fees
- Intercompany settlements
Separate recurring payments from large or unusual items.
Identify discretionary payments that could be delayed, reduced, or canceled during a liquidity shortfall.
Step #7 – Calculate weekly cash balances
Use the formula:
Opening cash + cash inflows – cash outflows = closing cash`
Carry each closing balance into the next week as opening cash.
Add a minimum liquidity threshold based on operating needs, lender requirements, payroll protection, or management policy.
Flag every week in which cash falls below that threshold.
| Cash Flow Item | Week 1 | Week 2 | Week 3 |
| Opening cash | $500,000 | $420,000 | $465,000 |
| Cash inflows | $250,000 | $310,000 | $275,000 |
| Cash outflows | $330,000 | $265,000 | $360,000 |
| Net cash flow | -$80,000 | $45,000 | -$85,000 |
| Closing cash | $420,000 | $465,000 | $380,000 |
Extend the same structure across all 13 weeks.
Step #8 – Add scenarios
Create a base case, downside case, and upside case.
Test changes such as:
- Delayed customer payments
- Lower collections
- Higher supplier costs
- Payroll increases
- Unexpected tax payments
- Financing delays
- Higher interest costs
- Accelerated debt repayments
- Postponed capital spending
- Reduced discretionary expenses
Link each scenario to possible actions. A credit draw may be required if cash falls below a set threshold, while capital spending may be delayed if collections move into a later week.
Step #9 – Update and roll the forecast forward
Replace the completed week’s estimates with actual cash activity.
Add a new thirteenth week.
Refresh bank data, invoice information, payment schedules, operating plans, and financing assumptions.
Weekly updates are standard. Businesses facing severe liquidity pressure may update the model more often.
Review major changes, including:
- Delayed receipts
- Unexpected supplier payments
- New tax obligations
- Payroll changes
- Financing updates
- Capital-spending decisions
- Intercompany funding needs
Document forecast dates, assumptions, owners, and scenario names.
Summary
A 13-week cash flow forecast shows when cash is expected to arrive, when obligations must be paid, and when balances may fall below required levels.
Reliable bank data, invoice records, supplier schedules, payroll dates, tax obligations, debt payments, and capital plans improve forecast accuracy.
Weekly updates, actual-versus-forecast analysis, and current assumptions help management plan operating actions, financing needs, covenant compliance, and stakeholder communication.
