Download free templates in Excel and Google Sheets formats, and learn how to create a cash flow forecast. That's where a detailed AR template comes in.It records and tracks all customer invoice information, improves organization, and simplifies financial reporting. Our free template includes several essential components that can help keep you organized and make it easy to manage your receivables. This sheet will populate based on information in the year 1 Sales Forecast. Summarizing total outstanding AR amounts; Forecasting future cash flow based on payment history. Accountants use Excel all the time. Click on Download Details, Open this will open up an excel spreadsheet for the days activity. The District has taken a cautious approach in the event that funded. COLAs do not materialize in the out-years.