Cash Reporting and Forecasting Excel Templates

Cash flow reporting spreadsheets.xls (daily and monthly) - combines up to five individual revenue centers into one overall report. Daily cash receipts, expenses by categories, capital expenditures, loan and lease payments. Daily closing cash balances for p/l centers and combined.

Cash Flow forecasting.xls (100 days ahead forecasting)- forecasts closing cash balances up to 100 days ahead by taking receivables and payables list and calculating the banking day of receipt or payment. Input any number of days ahead for a quick snapshot of closing daily cash balance at any future date.

                                                                        

CURRENCY > You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel.

The download ZIP file contains: Cash Flow Reporting 3.0 templates.xls, and Cash Flow Forecasting 3.2 templates.xls plus demo with examples and instructions. After downloading locate the zipped file and unzip first of all before you try to run in Excel. Use the Save As button when you download not the Open button. There are three separate files contained within the download file.