Which Excel cash flow template do you need?
All six cash flow templates turn a few assumptions into a full 3-way forecast: an income statement, cash flow statement and balance sheet that stay in balance. Working capital, sales tax, income tax, payroll accruals, dividends and loan repayments are calculated for you.
Two questions decide which one fits: how far ahead and in how much detail you need to forecast, and whether you also want to compare actual results with the forecast.
Quick answer: which template should you choose?
- Cash Flow Projection - Weekly Template: choose it if you manage cash week by week or need a rolling 13-week cash flow forecast.
- Cash Flow Projection - Monthly Template: choose it if you need a month-by-month forecast for up to 3 years.
- Cash Flow - Business Plan Forecast Template: choose it if you are writing a business plan and need 12 monthly periods followed by 5 annual periods.
- Cash Flow Projection - Annual Template: choose it if you only need annual figures for the next 5 years.
- CF Weekly - Forecast vs Actual Template: choose it if you forecast weekly and want to compare actual results with the forecast.
- CF Monthly - Forecast vs Actual Template: choose it if you forecast monthly and want to track actual results against the forecast.
Feature comparison
| Feature | Cash Flow Projection - Weekly | Cash Flow Projection - Monthly | Cash Flow - Business Plan Forecast | Cash Flow Projection - Annual | CF Weekly - Forecast vs Actual | CF Monthly - Forecast vs Actual |
|---|---|---|---|---|---|---|
| Forecast periods | 52 weeks | 36 months | 12 months + 5 years | 5 years | 52 weeks | 36 months |
| Income statement, cash flow statement and balance sheet | ✓Yes | ✓Yes | ✓Yes | ✓Yes | ✓Yes | ✓Yes |
| Working capital, sales tax, income tax and payroll accruals | ✓Yes | ✓Yes | ✓Yes | ✓Yes | ✓Yes | ✓Yes |
| Loan and lease repayments | ✓Yes | ✓Yes | ✓Yes | ✓Yes | ✓Yes | ✓Yes |
| Compare actual results with the forecast | –No | –No | –No | –No | ✓Yes | ✓Yes |
| Forecast vs actual management report | –No | –No | –No | –No | Weekly, quarterly and year-to-date | Monthly and year-to-date |
The templates in detail
Cash Flow Projection - Weekly Template
Weekly cash flow forecast with reports for 52 weeks.
- Best for:
- Businesses that need a rolling 13-week or full 52-week cash flow forecast
- Not suitable for:
- Comparing the forecast with actual results (use Cash Flow Weekly - Forecast vs Actual)
View the Cash Flow Projection - Weekly template
Cash Flow Projection - Monthly Template
Monthly cash flow projections with reports for 36 months.
- Best for:
- Businesses forecasting cash flow month by month for up to 3 years, with a full income statement and balance sheet
- Not suitable for:
- Comparing the forecast with actual results (use Cash Flow Monthly - Forecast vs Actual)
View the Cash Flow Projection - Monthly template
Cash Flow - Business Plan Forecast Template
Business plan forecast with 12 monthly and 5 annual periods.
- Best for:
- Start-ups and business plans that need 12 monthly and 5 annual periods for lenders or investors
- Not suitable for:
- Annual-only forecasts (use Cash Flow Projection - Annual) or monthly forecasts beyond 12 months (use Cash Flow Projection - Monthly)
View the Cash Flow - Business Plan Forecast template
Cash Flow Projection - Annual Template
Annual cash flow forecast with reports for 5 years.
- Best for:
- Business plans and lenders that need a 5-year annual forecast with an income statement, cash flow statement and balance sheet
- Not suitable for:
- Monthly or weekly forecasts (use Cash Flow Projection - Monthly or Weekly) or comparing forecasts with actual results
View the Cash Flow Projection - Annual template
CF Weekly - Forecast vs Actual Template
Weekly forecast vs actual results over a 1 year period.
- Best for:
- Businesses that forecast weekly and compare actual results with the forecast
- Not suitable for:
- Forecast-only projects (use Cash Flow Projection - Weekly) or monthly tracking (use the monthly version)
View the CF Weekly - Forecast vs Actual template
CF Monthly - Forecast vs Actual Template
Monthly forecast vs actual results over a 3 year period.
- Best for:
- Businesses that forecast monthly and track actual results against the forecast over 3 years
- Not suitable for:
- Forecast-only projects with no actual results to compare (use Cash Flow Projection - Monthly) or weekly tracking (use the weekly version)