Cash Flow Excel Templates: Cash Flow Budget Forecasting & Cash Flow Reporting

Cash Flow Excel Spreadsheets : Cash Flow Budgeting & Cash Flow Reporting

Excel Templates for cash flow reporting

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 and 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 and 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 and 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 and Credit.

Screenshot

Cash Flow Forecasting

Cash Flow Forecasting 2

System Requirements

Requires Excel 97 / Excel 2000 / Excel XP / Excel 2003 or later or MS Office 97 or later.

Platform : Windows XP/2000/2003 or later or Mac

Order

Please note that you also may want to purchase our 'Financial Excel All Programs Edition' - large collection of financial programs - as it contains this product.

30-day money back guarantee!

Additional Information:
Cash Forecasting, Credit Controls, Scheduling	Buy Online	~~$169.95~~ $69.95
Financial Excel All Programs Edition	Buy Online	~~$450.00~~ $129.95