About the Category Tracker Report
Build a pie chart visualizing your spending and income over a completely customizable date range with the Category Tracker Report for Microsoft Excel.
See the Category Tracker for Google Sheets.
The Category Tracker Template is a powerful yet simple way to understand your spending and cash flow over a configurable time period. It’s one of the most popular Tiller Community templates.
Use this template to build a pie chart visualizing your spending and income in each of your transaction categories over a customizable date range.
The template also lists your category totals, income, expenses, transfers, and net cash flow for your selected time period.
Installation
This template requires a free trial or active subscription of Tiller to try.
- Launch Tiller Money Feeds
- Under Templates near the bottom, click Browse
- Find the template in the list using search or scroll to find it
- Click the template name in the list to expand its card
- Click Install to add the template to your spreadsheet
- Read more in the Tiller help center
How to Use the Worksheet
Most of the improvements are under the hood. Functionally, the new Category Tracker is the same to use as the old one which is documented here.
Support & Documentation
- View documentation for the Category Tracker for Microsoft Excel here in the Tiller Community.
- All Tiller Community Solutions are exclusively supported in the Tiller Community
One thing to verify is if using the “Links” option you can replace the link to the new workbook. That might be a safer option.
In the image below, it’s the first “links” option. This icon won’t show up if your workbook has no links.
I use the search bar to get it, but I’m sure there’s another way.
Hi,
I would love more use of Excel with Tiller solutions!
I tried to insert your v1.50 sheet into my existing Tracker, but it really didn’t work. I had better luck moving my transactions and categories to the v1.50 template. Now it is working fine.
I would really love a Tiller solution of some kind for Envelope budgeting for Excel. I’ve tried this, but I’m not proficient enough with Excel to do it. It became impossible for me because Excel has no easy equivelent to the Sheets Query function. Thanks!
Thanks for the feedback @yossiea and @jemmoa7. I apologize for not getting back to you sooner, but have been working on some other things.
I like your suggestion of using the “Edit Links…” workflow. Unfortunately, I couldn’t get the “Break Link” button to do the trick (it just converted my data to static values) but I was able to get the “Change Source” button to work. I updated the original instructions. Any chance you can try again and let me know if it works for you… or if you have feedback to improve the instructions?
P.S. I hear you, @jemmoa7, on the need for an Envelope Budget in Excel. That is on our roadmap but unfortunately isn’t imminent. For now, I recommend using the Savings Budget in Sheets.
I think you’re right, I just tried it again. I ended up opening up my file from OneDrive and getting the path from Info.
I am though experiencing #N/A errors. See the below screenshot (ignore my chocolate and lottery.
)
I’m not 100% sure about the formula, but based on the template, I think the first column isn’t bringing everything across.
There’s something with the named range, I can’t even edit “Categories”
also, IIRC, you can filter and return more than one column at a time in Excel.
-edit- Actually, the error is in the Group/Type columns. You are filtering on Categories, so hidden stuff still show up because no categories are named “Hidden.” You still need to filter on “Hide From Reports.”