My monthly budget sheet suddenly stopped working. All my transactions are properly dated and correct on the transactions sheet and the budget sheet says that all transactions have been categorized, but the budget sheet says there are no actuals for this period.
I looked back at previous months on the budget sheet and all of the data there has been wiped clean.
All my other sheets seem to be working fine.
Any ideas on how I might fix this?
Hi @shantellekotowich…welcome back!
Sometimes when I have been experimenting with other time periods to look ahead or back I have had similar experiences that sound like this.
One thing to check is on your Categories Sheet, are the columns that appear blank assigned to the current year or a different year? I have other years on my Categories sheet that are experimental or not complete, and I often forget to bring the current years’ columns with data back into view.
Similarly, is the time period the Monthly Budget sheet is reporting 2021 or another time period that truly doesn’t have any actuals yet, like 2022?
Let me know.
Another option is to try and Restore the template using the Tiller Community Solutions add-on. If you use the Yearly Budget template you will need to restore that one as well (after) since they are interlinked.
Most likely you’re missing a header (row 1) in the Categories sheet for the word Category, Group, or Type or you’re missing a header (row 1) on the Transactions sheet for Category or Amount.