CF Monthly - Forecast vs Actual Template
Use this unique forecast versus actual Excel template to create a monthly cash flow forecast for any 36 month period and compare the cash flow forecast to actual account balances. Cash flow forecast is created in the same way as in the Monthly Cash Flow Projection template. Actuals need to be entered and the management report can be used to compare the forecasted and actual account balances.
- Includes 36 monthly periods
- Suitable for service and trade based businesses
- Reporting periods based on a single user input cell
- Cash flow forecast automated based on series of assumptions
- Actual balances can be copied from our accounting templates
- Expense accounts can be customized and more accounts added
- Includes income statements, cash flow & balance sheets
- Management report for comparing forecasted and actual results