The Google Sheets Category Tracker has been our third-most-popular template historically with thousands upon thousands of downloads. The Category Tracker provides a quick & easy way to focus in on custom reporting periods.
In parallel, we had been refining a similar template in Excel called the Tiller Money Tracker. The Excel version included a popular pie chart feature, but lacked the category-rollup-by-description feature in the Sheets version.
We are excited to announce that we have merged these two concepts.
The Sheets Category Tracker version, in an overdue update, now incorporates the customizable pie chart, a period summary, and features a UX similar to its Excel counterpart.
The new Excel build rebrands the template from “Excel Money Tracker” to the Excel “Category Tracker”— the same as its Sheets sibling— and harmonizes it with the popular features in the Sheets version, including the addition of Description totals (the columns at right) for the selected period.
I’m not sure about your specific application, but I’d encourage you to pull in the worksheet, take it for a spin, and build whatever you need on top of it to make it work for you.
Thanks Randy, I like the look of this. I notice that the hidden categories are showing up in the report, is there a way to filter out certain categories from the report?
Separately, would it be possible to add this graph to the Tags Report and then have a checkbox that we could select to control what is in the graph. That would be ideal.
My guess is that the issue is that the SUM() formula is not filtering out categories that are hidden. It is confusing because, if there are hidden categories, the totals will not equal the values below.
Can you confirm, @hbwilliams22, that this is the root of the problem you are seeing? If yes, I can fix it later this week.
@randy I was excited about this update as soon as I saw this post, but I only just got around to trying out the new sheet. I love it! I’ve always found the Category Tracker very useful, but it’s always felt like a very basic tool. This new version really takes it to the next level. I don’t realize how much I would like having the pie chart, but it really helps visualize spending. Thanks!
I have two categories that have an apostrophe. When selected as the category on the right side, the period total is $0 and there are no transactions below. These same categories show the correct amount on the left side.
I assume you are having the apostrophe issue with the Google Sheets version, @ssenneff?
Can you use the Tiller Community Solutions Add-on to make sure you have the latest version (2.53)? I updated the Google template in late June to address that exact issue.
Hi. This is a great option to view an overall summary. I was interested in seeing these totals as a monthly view (mainly monthly expenses) so I copied the numbers down, and divided by the calculated number of months to today so I have 2 charts to view that are very helpful, the total expenses and monthly average expenses. Wondering if that would be useful for others enough to make it part of your work? Thanks.
