How to Add Category Groups in Tags Report?

Google Sheets
1

Hello,

What is the most preferred way to add a “Groups” column in the Tags Report worksheet? I have the categories by default, but want to use the Category Group to make life easier for my tax person (we use conflicting category names, but the groups align).

Thanks!
-Phillip

2

Hi @pcmccollum ,

Sorry for the delay here.

I’m not totally sure on how to add groups to the Tags report, but you might consider adding Tags to the Categories sheet and then use the Category Rollup report for the tax reporting.

I just did a webinar on this which you can review the resources for here

And here is a most streamlined version:

1 Like
3

You could add a lookup from your Tags Report through the selected category (in the Transactions sheet) back to the category-group from the Categories sheet, but this approach isn’t really that sound since tags can be applied to multiple categories— essentially, a single transaction tag could map to multiple category groups.

In the end, I think @heather has the right approach, @pcmccollum.

1 Like
4

Thank you both for the suggestions. I was unaware of the Category Rollup report which is fantastic in its own right. Appreciate it!

1 Like