New Cash Flow Forecast Sheet

Spreadsheets Sheets Templates
5

@bbruck Projecting Cash Flow is very important to me as well, especially the forecasted running cash flow. Like you, I started to add into the Yearly Budget worksheet but didn’t like the format. So, I have created a couple of worksheets that you may find useful…

  1. Expected End of Year Cash - This shows your cash flow by Group and Category through the month you choose (only through completed months for current year) and remaining year budget. You can also choose beginning of year to see what your Cash Flow was expected to be for the year.

  2. Cash Flow by Month Chart - Same concept as 1, but summarizes total cash flow by month- actuals for months completed then budget forcasted for remaining months of year. This one can also show monthly Expenses or Income vs Budget and choose specific Groups or Categories. This got posted today.

Let me know if you have any questions or comments.

Thanks.

1 Like