Cash Reporting and Forecasting Excel Templates

Cash Flow Forecasting – 150 days ahead, 12 Month Cash Operating Plan, Customer Credit Control, Daily Cash Consolidations, Scheduling Payments - Five new Excel workbooks for better cash management during 2009.

Cash Flow Forecasting 150 days.xls - Forecast 150 days ahead. List current receivable and payable accounts by date, set target payable and receivable days, generate overdue and late account lists, generate daily, weekly and monthly cash flow forecasts, set targets, analysis variances.

Individual (linked) spreadsheet by tabs > Guide, Targets, Accounts Register, Daily balance forecasts, Monthly forecasts, Create Lists.

The workbook provides daily closing cash balances for the entire 150 day period, summarizes late payers, week end and month end forecast balances.

                                                                        

Cash Operating Plan.xls - 12 month sales and expenses plan spreadsheet links to the working capital spreadsheet where the user enters monthly targets for days sales outstanding, percentage payable to sales, days inventories outstanding to monthly cash forecast spreadsheet presented as Operating and working capital monthly changes -capital requirements – loan balances requirements – ending as changes in monthly cash.
Individual (linked) spreadsheet by tabs > Start & Summary, Monthly P_L Budget, Working Capital, Monthly Cash Changes Forecast.

Customer Credit Control.xls – This workbook alerts managers up front if customers will exceed their credit limits if an order is processed using Excel. Incorporates current credit limit values per customer, accepted order values pending, and net credit positions. Posts STOP each order before output costs are incurred.
Individual (linked) spreadsheet by tabs > Guide, Product List, Customer Credit Status, Order Control, Sales Running Rates.

Daily Cash Consolidation.xls – When you have different operating divisions reporting different daily income, expenses and capital expenditures on a cash accounting basis, this workbook will consolidate all daily cash in and out reports into combined totals and compare actuals to the overall budget on a monthly basis.
Individual (linked) spreadsheet by tabs > Set up Income-Expense Categories – Monthly P_L Budget – Divisions 1-12 Daily Reports – Month to Date & Variances – Daily Consoldations.

Scheduling Payments.xls – Everyone has to schedule who to pay and when. This workbook makes that task easier. Enter all your receivables (or forecast receivables) into the Receivable register in simple Excel list format with the amounts, invoice dates and target (or average) days collection. This page will display alerts when each receivable account is overdue. List payable accounts in the Schedule Payments spreadsheet with amounts and due dates. Adjust payment dates so that you do not exceed daily credit limits which are calculated 150 days ahead in the Rescheduled Balances & Credit Available (summary) spreadsheet. Make cash scheduling more effective and manages daily credit forecasting.
Individual (linked) spreadsheet by tabs > Set Bank Holiday Dates – Receivable Register – Schedule Payables – Rescheduled Balances & Credit.