Forum Discussion
Changing the year on a General Ledger with budget comparsion template
Hi, My question- is it possible to change the year on the General Ledger with budget template? The template is perfect except that our fiscal year (7/1-6/30) is different than the calendar year....
AmyJacob727 Yet another example of a totally useless template. Full with not so clever hidden "features" and ridiculously complicated formulae that are near to impossible to maintain/alter. If you look on the Monthly tab and move the slicer that is above rows 3 and 4 out of the way and set the text color to black, you can see what's underneath. Complete madness. And the formulae in the table below violate all the rules when working with structured references. I changed all of it to make this template work.
Change "2021" in G2 on the YTD tab to "2022" and everything should shift by one year.
See attached and see if it works for you.