# Monthly Analysis/Categories Template

**URL:** <https://community.tiller.com/t/monthly-analysis-categories-template/31226>\
**Category:** Ask Anything\
**Tags:** google-sheets\
**Created:** [March 17, 2025, 9:45pm UTC](https://community.tiller.com/t/monthly-analysis-categories-template/31226 "2025-03-17T21:45:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ronhadsall](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/ronhadsall/32/9050_2.png) [@ronhadsall](https://community.tiller.com/u/ronhadsall)\
**Post date:** [March 17, 2025, 9:45pm UTC](https://community.tiller.com/t/monthly-analysis-categories-template/31226/1 "2025-03-17T21:45:59Z")

</div>

When I run the Monthly Analysis, at the top of each column it reads “No Budget Found”. I think it might have something to do with the way I tried to update the Categories Budget Template for 2024 because that’s when the error began occurring. I’m not sure I did it correctly.  
How can I be sure the Categories Template was done correctly?  
If not how can I repair it?  
How can I be sure if this is the real problem with the Monthly analysis?  
Thanks for your help.

---

<div class="post-metadata">

**Author:** ![TillerAlice](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tilleralice/32/21042_2.png) [@TillerAlice](https://community.tiller.com/u/TillerAlice)\
**Post date:** [March 18, 2025, 2:43am UTC](https://community.tiller.com/t/monthly-analysis-categories-template/31226/2 "2025-03-18T02:43:18Z")

</div>

Hello @ronhadsall, I also have broken my spreadsheet formulas at times. Thank goodness for Control Z and version history.

I do not have a “Monthly Analysis” in my Tiller spreadsheet. Do you mean the Monthly Budget View sheet?

 ![Monthly Budget View](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/3X/d/5/d5d41b53e381654db691fa05148e5781cd3b842d.png)

I’d recommend reaching out to our support team via the chat window in the lower right corner of the Console at [https://my.tiller.com/](https://my.tiller.com/) to check on how to fix a template. They are fantastic.

-Alice  
Tiller Evangelist

---

<div class="post-metadata">

**Author:** ![Mark.S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/mark.s/32/14650_2.png) [@Mark.S](https://community.tiller.com/u/Mark.S)\
**Post date:** [March 18, 2025, 2:05pm UTC](https://community.tiller.com/t/monthly-analysis-categories-template/31226/3 "2025-03-18T14:05:03Z")

</div>

Check out the [Multi-year Budgeting in the Tiller Foundation Template](https://help.tillerhq.com/en/articles/3549551-multi-year-budgeting-in-the-tiller-foundation-template) for the steps in how to add a new year worth of budgets.

I suspect your Category sheet row 1 dates are text when they should be dates (formatted as mmm yyyy) and that’s why Monthly Analysis cannot find them.

---

<div class="post-metadata">

**Author:** ![bentyre1](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/bentyre1/32/8130_2.png) [@bentyre1](https://community.tiller.com/u/bentyre1)\
**Post date:** [March 19, 2025, 3:57am UTC](https://community.tiller.com/t/monthly-analysis-categories-template/31226/4 "2025-03-19T03:57:19Z")

</div>

Like what Mark said check your categories sheet for an error in the month place or text instead of a date formatting and this should fix your error,

If not hit the unhide button at the top right of your sheet and see what is showing in the hidden area of the sheet, you should have some N/A errors in the Q and R column that would point you in the right direction of where the error is in your sheet