13-Week Cash Flow Forecast Template
A weekly cash forecast for seeing liquidity pressure before it becomes an emergency.
This free Excel model helps finance teams forecast receipts and disbursements over the next 13 weeks, monitor ending cash, and identify when cash could fall below a minimum operating threshold.
What the template helps you see
- Beginning and ending cash by week
- Expected cash receipts
- Payroll, vendor, debt, and other disbursements
- Minimum cash threshold
- Weeks that may require management action
- The timing difference between an accounting result and actual liquidity
How to use it
- Start with actual available cash rather than the bank balance alone if some cash is restricted or committed.
- Enter expected receipts in the week they are realistically expected to clear.
- Enter disbursements using actual payment timing, not merely the month in which the expense is recorded.
- Update the forecast each week with actual results and revised assumptions.
- Use the minimum-cash line as an early-warning threshold, not as a target balance.
No payment. No email gate. Use the model as a starting point and adapt the categories and timing to your own organization.
Related analysis
A Balanced Budget Can Still Hide a Cash Crisis →
Get new finance tools and analysis
Subscribe to Numbers & Judgment for practical finance, forecasting, governance, and decision-making ideas.
This template is provided for general educational purposes. Review formulas and assumptions for your own circumstances before relying on it for financial, legal, tax, lending, or investment decisions.
Numbers & Judgment 