We are trying to keep an accurate forecast of how much money we will have left at the end of the year.
We are trying to find a report that shows us the forecasted annual cashflow (ie savings) based on ACTUAL data from previous months and BUDGETED data for the current and future months. The annual cash flow calculation in the existing YEARLY BUDGET sheet appears to show all budgeted cash flows (past and future), regardless of whether or not actuals were above or below the budgeted amount. It will be more helpful and realistic to utilize actual data from previous months, not budgeted. Is there such a report?