13-Week Cash Flow Forecast Template: Rolling Liquidity Management Guide

Why 13 Weeks?

The Case for 13-Week Forecasting

Why Not Monthly?

• Monthly forecasts hide intra-month cash swings
• Payroll, rent, and major payments occur on specific dates
• Cash crunches often happen mid-month

Why Not 52 Weeks?

• Accuracy degrades beyond 13 weeks
• Too much effort to maintain weekly detail
• Weekly accuracy matters only for short-term

Why 13 Weeks Specifically?

• Covers one full quarter (good planning horizon)
• Aligns with quarterly board reporting
• Standard for lender covenant reporting
• Manageable to maintain weekly
• Long enough to identify and address gaps

When You Need a 13-Week Forecast

13-Week Cash Flow Framework

Direct Method vs. Indirect Method

Direct Method (Recommended for 13-Week):

• Forecasts actual cash receipts and disbursements
• More accurate for short-term
• Requires detailed transaction data
• Standard for liquidity management

Indirect Method:

• Starts with net income, adjusts for non-cash
• Better for longer-term forecasting
• Used in financial statements
• Less granular for weekly use

Forecast Structure

13-WEEK CASH FLOW FORECAST STRUCTURE

OPENING CASH BALANCE
├── Bank accounts
├── Money market
└── Restricted cash (separate)

(+) CASH RECEIPTS
├── Customer collections
├── Cash sales
├── Other receipts
└── Financing proceeds

(-) CASH DISBURSEMENTS
├── Payroll & benefits
├── Vendor payments
├── Rent & facilities
├── Debt service
├── Capital expenditures
├── Taxes
└── Other disbursements

(=) NET CASH FLOW

(=) ENDING CASH BALANCE

AVAILABLE LIQUIDITY
├── Ending cash
├── Revolver availability
└── Other credit lines

Building Your 13-Week Forecast

Step 1: Establish Your Starting Cash Position

Opening Balance Components:

Bank Reconciliation Template:

OPENING CASH RECONCILIATION

Bank Statement Balance                 $1,250,000
(+) Deposits in Transit                   $45,000
(-) Outstanding Checks                   ($82,000)
= Book Cash Balance                    $1,213,000

Accounts:
├── Operating Account 1                  $850,000
├── Operating Account 2                  $325,000
├── Money Market                         $38,000
└── TOTAL AVAILABLE CASH              $1,213,000

Restricted Cash (not available):
├── Security Deposit                     $50,000
├── Escrow                               $25,000
└── TOTAL RESTRICTED                     $75,000

Step 2: Forecast Cash Receipts

Customer Collections Forecasting:

Aging-Based Collections Example:

COLLECTIONS FORECAST - AGING METHOD

Current AR by Age:
├── 0-30 days:     $500,000
├── 31-60 days:    $200,000
├── 61-90 days:    $75,000
└── 90+ days:      $25,000
    TOTAL AR:      $800,000

Historical Collection Rates:
├── 0-30 days:     80% collected within 30 days
├── 31-60 days:    70% collected within 30 days
├── 61-90 days:    50% collected within 30 days
└── 90+ days:      20% collected within 30 days

Week 1-2 Expected Collections:
├── From 0-30 days:    $500K × 40% = $200,000
├── From 31-60 days:   $200K × 35% = $70,000
├── From 61-90 days:   $75K × 25%  = $18,750
└── From 90+ days:     $25K × 10%  = $2,500
    TOTAL WEEKS 1-2:              $291,250

Collections Worksheet:

Other Receipt Categories:

Step 3: Forecast Cash Disbursements

Payroll and Benefits:

Payroll Calendar (Bi-weekly):

Vendor Payments:

AP Payment Schedule:

VENDOR PAYMENT FORECAST

MAJOR VENDORS (Track individually):
├── Vendor A: $50,000 due Week 2
├── Vendor B: $35,000 due Week 3
├── Vendor C: $45,000 due Week 4
└── Subtotal: $130,000

OTHER VENDORS (Terms-based):
├── Net 30 AP: $200,000 → Weeks 3-4
├── Net 15 AP: $80,000 → Weeks 1-2
└── Subtotal: $280,000

TOTAL AP PAYMENTS: $410,000 over 4 weeks

Fixed Disbursements Calendar:

Tax Payments:

Step 4: Assemble the Forecast

Complete 13-Week Template:

(Amounts in $000s)

Managing Cash Variability

Identifying Cash Gaps

Early Warning Indicators:

Gap Analysis Template:

CASH GAP ANALYSIS

Week 8 shows cash deficit of $40,000

CAUSES:
├── Quarterly tax payment: $50,000
├── Large vendor payment: $35,000
├── Below-normal collections: ($20,000) vs plan
└── Total stress: $105,000 additional outflow

OPTIONS TO ADDRESS:
1. Delay vendor payment to Week 9 (+$35,000)
2. Accelerate Week 7 collections (+$25,000)
3. Draw on credit line (+$50,000)
4. Defer CapEx (+$20,000)

RECOMMENDED ACTION:
- Accelerate collections (call top 5 customers)
- Negotiate vendor payment split
- Result: Gap closed without credit line draw

Stress Testing Scenarios

Scenario Framework:

Stress Test Example:

Levers for Cash Management

Accelerate Receipts:

Delay Disbursements:

Increase Liquidity:

Weekly Forecast Maintenance

Update Process

Weekly Cadence:

Weekly Update Checklist:

13-WEEK FORECAST WEEKLY UPDATE

DATE: ___________

☐ ACTUALS
  ☐ Record actual opening cash (bank confirmed)
  ☐ Record actual receipts by category
  ☐ Record actual disbursements by category
  ☐ Calculate actual vs. forecast variance

☐ WEEK 1-2 FORECAST (High confidence)
  ☐ Verify known receipts (scheduled payments)
  ☐ Confirm disbursement timing (checks cut)
  ☐ Update for any new information

☐ WEEK 3-4 FORECAST (Medium confidence)
  ☐ Review AR aging for collections
  ☐ Review AP aging for payments
  ☐ Incorporate new sales/commitments

☐ WEEK 5-13 FORECAST (Lower confidence)
  ☐ Apply standard collection patterns
  ☐ Apply standard disbursement patterns
  ☐ Add known large items
  ☐ Add new week 13

☐ ANALYSIS
  ☐ Calculate forecast vs. forecast variance
  ☐ Identify cash gaps
  ☐ Prepare variance commentary
  ☐ Recommend actions if needed

Variance Analysis

Forecast vs. Actual:

Variance Commentary Template:

WEEKLY VARIANCE COMMENTARY

WEEK ENDING: January 10, 2025

SUMMARY:
Net cash flow was $17,000 below forecast due primarily to
slower-than-expected customer collections.

KEY VARIANCES:

COLLECTIONS ($15,000 unfavorable)
- Customer ABC delayed $25,000 payment (now expected Week 2)
- Offset by early payment from Customer XYZ (+$10,000)
- Action: Contacted ABC, confirmed payment this week

VENDOR PAYMENTS ($7,000 unfavorable)
- Expedited payment to Vendor 123 per negotiated discount
- No concern - planned acceleration

IMPACT ON OUTLOOK:
- Week 2 now shows higher expected collections
- No change to 13-week cash outlook
- Minimum cash position unchanged

Forecast Accuracy Tracking

Accuracy Metrics:

Accuracy Dashboard:

FORECAST ACCURACY SCORECARD

                      Wk 1    Wk 2-4   Wk 5-8   Wk 9-13
Receipts Accuracy      97%      92%      85%      78%
Disbursements Acc.     98%      95%      88%      82%
Net Cash Flow Acc.     94%      88%      76%      68%

TARGET                >95%     >90%     >80%     >70%
STATUS                 ✓        ✓        ✓        ✓

IMPROVEMENT AREAS:
- Collections forecast: Implement customer-level tracking
- Tax payments: Add to calendar with exact dates
- CapEx: Improve project milestone tracking

Stakeholder Reporting

Board/Leadership Report

Executive Cash Summary:

13-WEEK CASH FLOW SUMMARY
Report Date: January 15, 2025

═══════════════════════════════════════════════════════════

CURRENT POSITION
                        This Week    Prior Week    Change
Cash Balance            $1,213,000   $1,195,000   +$18,000
Revolver Available        $500,000     $500,000        -
Total Liquidity         $1,713,000   $1,695,000   +$18,000

═══════════════════════════════════════════════════════════

13-WEEK OUTLOOK
                        Total         Avg/Week
Cash Receipts          $2,652,000      $204,000
Cash Disbursements    ($2,804,000)    ($216,000)
Net Cash Flow          ($152,000)     ($12,000)

Ending Cash (Week 13)    $545,000
Minimum Cash (Week 4)    $360,000
Minimum Target           $300,000
Cushion                   $60,000

═══════════════════════════════════════════════════════════

KEY OBSERVATIONS

✓ Cash position adequate for 13-week horizon
✓ Minimum cash stays above $300K target
! Week 4 cushion is tight ($60K) due to tax payment

ACTIONS UNDERWAY
1. Accelerating Q1 collections (target +$50K)
2. Negotiating vendor payment timing
3. Deferring non-critical CapEx

═══════════════════════════════════════════════════════════

RISKS & SENSITIVITIES

If collections decline 10%:
- Week 4 minimum drops to $290K (below target)
- Mitigation: Draw $50K from revolver

If major customer delays 30 days:
- Cash impact: ($75,000)
- Mitigation: Customer confirmed payment timing

Lender Reporting

Many credit agreements require regular cash flow reporting:

Covenant Compliance Template:

CASH FLOW CERTIFICATE

Borrower: [Company Name]
Period: Week Ending January 10, 2025
Credit Agreement Dated: [Date]

LIQUIDITY COVENANT
Minimum Cash + Availability Required:    $500,000
Actual Cash + Availability:            $1,713,000
Compliance:                             ✓ YES

CASH FLOW COVENANT
13-Week Projected Net Cash Flow:       ($152,000)
Minimum Required:                      ($300,000)
Compliance:                             ✓ YES

CERTIFICATION
The undersigned hereby certifies that:
(a) The attached 13-week cash flow forecast was prepared
    in accordance with the Credit Agreement
(b) No Event of Default exists
(c) All representations remain true and correct

Signed: _________________
Title:  CFO
Date:   January 15, 2025

Integration with Treasury Management

Cash Positioning

Daily Cash Positioning:

Working Capital Optimization

Cash Conversion Cycle:

CASH CONVERSION CYCLE ANALYSIS

Days Inventory Outstanding (DIO):     45 days
Days Sales Outstanding (DSO):         52 days
Days Payable Outstanding (DPO):       38 days
────────────────────────────────────────────
Cash Conversion Cycle:                59 days

IMPACT ANALYSIS:
Each day of DSO = $33,000 cash tied up
Each day of DPO = $22,000 cash freed

IMPROVEMENT TARGETS:
- Reduce DSO by 5 days → Free $165,000
- Extend DPO by 5 days → Free $110,000
- Net working capital improvement: $275,000

Working Capital Initiatives:

Credit Line Management

Revolver Utilization Tracking:

Common Pitfalls and Solutions

Pitfall 1: Stale Data

Problem: Forecast based on outdated AR/AP information.

Solution:

• Daily bank reconciliation
• Weekly AR/AP aging refresh
• Automated data feeds from ERP
• Clear ownership for data updates

Pitfall 2: Missing Large Items

Problem: One-time payments surprise the forecast.

Solution:

• Maintain calendar of known large items
• Tax payment calendar
• Debt service schedule
• CapEx project timeline
• Annual contracts and renewals

Pitfall 3: Over-Optimistic Collections

Problem: Assuming customers pay on time.

Solution:

• Use historical collection patterns
• Customer-specific assumptions for large accounts
• Build in collection buffer
• Track and adjust based on actual experience

Pitfall 4: Ignoring Float

Problem: Not accounting for check clearing time.

Solution:

• Use bank balance, not book balance for opening
• Track checks issued but not cleared
• Account for deposit processing time
• Consider moving to electronic payments

Pitfall 5: No Ownership

Problem: Forecast falls through the cracks.

Solution:

• Assign single owner (typically Treasury or Controller)
• Weekly update cadence on calendar
• Clear stakeholder distribution list
• Accountability in management meetings

Implementation Checklist

Week 1: Setup

• Define forecast structure and line items
• Establish opening cash position methodology
• Create template in Excel or planning tool
• Identify data sources for each line item
• Set minimum cash target

Week 2-3: Build

• Load historical data for pattern analysis
• Build receipts forecasting methodology
• Build disbursements calendar
• Create first complete 13-week forecast
• Stress test with scenarios

Week 4: Launch

• Establish weekly update process
• Train team on procedures
• Create reporting templates
• Distribute to stakeholders
• Begin accuracy tracking

Ongoing

• Weekly forecast updates (every Monday-Wednesday)
• Monthly accuracy review
• Quarterly methodology refinement
• Annual process improvement

Templates and Resources

Building a 13-week cash flow forecast requires the right tools. Our toolkit includes:

• 13-Week Cash Flow Template - Complete Excel model
• Cash Flow Dashboard - Executive reporting
• Working Capital Calculator - CCC analysis
• Treasury Management Template - Cash positioning

Additional Resources:

• Financial Forecast Guide - Comprehensive forecasting methodology
• Department Budget Template Guide - Expense planning
• Revenue Forecasting Guide - Sales and pipeline forecasting
• Financial Planning Hub - All financial planning resources

Conclusion

The 13-week cash flow forecast is your early warning system for liquidity issues and your roadmap for cash management. Unlike annual budgets that become stale within months, this rolling forecast provides the real-time visibility needed to avoid cash crunches, optimize working capital, and maintain stakeholder confidence.

Key Takeaways:

1. Use direct method - Forecast actual receipts and disbursements
2. Update weekly - Accuracy depends on fresh data
3. Track accuracy - Improve your methodology over time
4. Stress test - Know your cushion and breaking points
5. Manage actively - Use levers to address gaps before they become crises
6. Report clearly - Keep stakeholders informed and confident

Next Steps:

1. Download 13-Week Cash Flow Template →
2. Review Financial Forecast Guide →
3. Explore Financial Planning Hub →
4. Browse Financial Planning Templates →

Start building your 13-week forecast today. The visibility you gain will transform how you manage cash and make decisions.