Hi @roger.chu91 ,
The cash flow forecast is designed to look at your annual cash flow. It uses this annual number as a base to calculate future years. If you only count a shorter budget period, your future year calculations may not be based on accurate information.
However, this date range can be overridden in the hidden part of the Cash Flow forecast sheet. The Start and End Months for the initial Budget calculations are editable in cells AF5 and AF6. See the notes about the Date Range Priority in AE13.
Note that if you pick a time frame that’s less than 12 months, the Cash Flow sheet will annualize the budget for a 12 month period, so it matches future full years. I guess you could remove the annualizing calculation by setting AF9 to 1. But I’m not sure that will make your projections accurate.
Does this help?
Jon