Some of the budgeted amounts in my “Categories” tab are not showing up in the “Monthly Budget” and I have no idea why. The Category and Group show up in the “Monthly Budget” tab, but the budgeted amount shows up as $0 even though I entered an amount in the “Categories” tab. Any idea why this might be happening and how to fix it? Thanks!
Hi Eilean,
Can you please double check the month is selected at the top right of the Monthly Budget sheet and make sure that month has a budget value on the Categories sheet?
Heather
Hi Heather,
Yes to both. The Monthly Budget sheet is set to “September” and there are values filled in under the September column in the Categories sheet.
I think there is some sort of mismatch between the Monthly Budget and Categories sheet. Because when I change the numbers under the October column in the Categories sheet, the budget numbers in the Monthly Budget sheet change to match (even both the Monthly Budget sheet is definitely set to September). What’s the best way to resolve this?
Thank you!
I figured it out! I had added a “Tags” column in the Categories sheet in order to calculate my estimated quarterly taxes in the Est Quarterly Tax sheet. I had added this “Tags” column to the left of the “January 2019” column in the Categories sheet which appears to have thrown off the column counting in the Monthly Budget sheet. I moved the “Tags” column to the right of the “December 2019” column in the Categories sheet and now everything is flowing through correctly to the Monthly Budget sheet.
Not sure if this is already included in the instructions for setting up the Est Quarterly Tax sheet, but if not, you guys may want to let users know they should insert the “Tags” column to the right of the “December 2019” column in the Categories sheet.
1 Like
Mine is between Type and Hide. Yours too? Mine is two columns left of January. Was yours directly left of January? See article below for what I did. I did Tags by itself. I think you got Tags as part of Est Quarterly Tax. Thanks.
1 Like
My Tags column was between Type and Hide on the Categories sheet, but that was causing my Monthly Budget sheet to pull the wrong column (I would select September, but it would show me October’s numbers). I moved my Tags column to the right of the December 2019 and that fixed it!
Thanks, @eilean. I’ll let our template engineers know about this. Hopefully we can fix it so that doesn’t break the Foundation template budgeting sheets.
2 Likes
Thanks for bringing this bug in the Monthly Budget sheet to our attention, @eilean. I was able to reproduce the problem as you described it and implemented a fix to the Monthly Budget solution (now at version 1.61).
If you’d like to update your sheet (so you can position the Tags column wherever you’d like), here are the steps:
- Open the Tiller Labs add-on
- Go to Manage Solutions
- Open the Monthly Budget spinner
- Click Update Sheet
Other than the date configuration settings, there isn’t much data stored in either the Monthly or Yearly Budgets so replacing this sheets shouldn’t cause any problems (unless you have made additions or edits to the base functionality).
At this point, you should be able to drag/reposition the Tags column anywhere you’d like within the Categories sheet.
There is a chance that the restore operation will break your Yearly Budget sheet (which has some cell references back into the Monthly budget). If you see any issues, use the process above to restore/update your Yearly Budget as well.
Thanks for your patience and help in getting the Monthly Budget sheet fixed.
Let me know if this fix works for you.
Randy
1 Like
Hi @randy, I followed your instructions and everything works! Didn’t update the Yearly Budget sheet because it looks to be fine.
I really appreciate you and @heather fixing this issue! I’ve never experienced such excellent customer service. The two of you have made me a loyal Tiller user. Thank you!
2 Likes
Really happy to hear you’re back up and running, @eilean.
Thank your for the appreciation!
Randy
2 Likes
In my opinion, the new Tiller Community has allowed Tiller to ramp up (make better) their already great customer service. I have seen it first hand over the last two weeks. Please keep it up. Thanks, Blake
3 Likes
Hello everyone, I am having the exact same issue. I have checked the spreadsheet and it says its the most current version. I have budgets in my categories tab but it is showing as 0 in the monthly budget. Appreciate help!
Hello - I just created my 2022 budget using the Categories worksheet. However my Monthly Budget and Yearly Budget sheet are not updating. I reviewed the recommended solution in this thread and it did not update. I am running the most current versions of each sheet. Thank you for any guidance.
I was able to repair, please ignore. Thank you!
1 Like
I am still having issues with categories that show on the transactions tab not showing in the monthly budget tab. I tried following the instructions above, but there doesn’t seem to be Monthly Budget 1.61ver on the site to update. Appreciate your help.
Have you tried using the Templates feature in the Tiller Money Feeds add-on to restore the sheet to the latest working version. Using the Tiller Money Feeds Add-on for Google Sheets | Tiller Help Center
Hello
I just signed up to Tiller and assigned transactions to categories but monthly budget template still shows 0?? The categories are not hidden either. What am I doing wrong? Or is this problem not fixed yet?
The first thing i would check is if you have the correct month and year time period selected at the top right of your budget sheet, if that’s the case and still nothing, then have you added the tags like for estimated quarterly taxes like listed above in this thread?
Thank you Ben. I checked that the month/year is accurate and I am not sure what tags one ought to add. My columns are in the same order as default in all the sheets. I feel like I should email the support team. I see a lot of people in the thread have had the same issue.
Definitely reach out to our support team via the chat window in the lower right corner of the Console at https://sheets.tillerhq.com/auth/login
I’m also including our FAQ on most common issues: