Yearly Budget Sheet Incorrectly Referencing Categories

Hi Folks -

I’ve seen many inquiries in the Tiller Community similar to my inquiry but none of them seem to address my issue. I’ve noticed that my Yearly Budget sheet is picking up an incorrect reference from the Categories sheet but I haven’t been able to nail it down. For example, in the budgeting portion of the Categories sheet, I’ve budgeted two entries for April 2025 - one is an expense, the other is income. The entries are correctly reflected in for April the Monthly Budget sheet, but the Yearly Budget sheet displays them under March 2025. If I modify the Categories sheet by switching the budgeted figures to May 2025, the Yearly Budget sheet will display them under April 2025. Would resetting the Yearly Budget sheet resolve this issue? The cell formula supersedes my basic spreadsheet knowledge, so I’m reluctant to modify the formula without some idea of where to begin. Any assistance is welcome. Thanks.

Yeah, first try restoring the Yearly Budget template to see if that fixes it.

That fixed the issue. Thanks for the feedback.

1 Like