It is 1-1-21. I want to pull a YTD comparison showing all of 2020, but the only YTD comparison is “through present month.” Usually, I have the option of looking at data through previous month. It must have to do with the new year. Please let me know what to do to view 2020.
If you unhide the columns on the right side of the sheet, @Jeff.Held, you will see some hidden controls. You can change the analysis to last year by entering “2020” in cell
Hope this helps.
2020 is already showing. Two rows down it shows “N/A.” On B5, only “Through the present month is available” The YTD Budget column shows all 0s, since I haven’t set that up yet. This still isn’t working.
I am having the same issue. Now that I have grouped transactions from the last few weeks of December, I’d like to review where 2020 ended against budget.
(I am getting the same error on the YTD solution when viewing prior years, but until the issue is resolved, the Yearly Budget is a good option.)
Thank you. Yes, I will use the yearly budget. Will the YTD budget be fixed? I really like the option to categorize variances from high to low. Allows me to see issues right away.
Hi Randy. I tried that but the beginning and ending dates still show 1/1/21 and 1/16/21. Thank you for sharing the hidden columns.
Thanks for flagging this. I just found a bug and published an update.
Let me know if this resolves the problem for you.
We’re getting close. When I change the year in J15 to 2020, the sheet shows actuals from Jan 2020-Nov. 2020, and the full year budget. Please fix this to allow it to show the full year of actuals. Note, “through present month” is the only option given, but it still shows actuals only through November.
Thanks for your help. This is a great one page look at everything!
Thanks for the quick feedback, @Jeff.Held.
I found another bug and republished the template as version 1.09. I’m feeling good about the fix for previous years but I’m nervous that the change could break the functionality in the current year.
Let me know what you find. Thanks.