Tags Report v2 with Multi-level Tag Support


If you, like me, use tags to label transactions for more precise categorization and deeper search capabilities, then this is for you! With this updated Tag Report template, you can easily determine how much you’ve spent on specific items up to 3 levels deep. For instance, find out exactly how much you spent on souvenirs during a New York trip with tags such as Travel,New York,souvenirs.

2023-08-07 10.30.53


This uses the same dependencies as Tag Report meaning you need to have an existing column in your Transactions sheet labeled Tags

Go ahead and take this link and copy the Tag Report template to your sheet and it should work out of the box.


No real setup needed. Just start tagging!


To utilize this report:

  1. Begin as you would with the standard Tag Report: filter by either All Time or a specific date interval. This will display your list of tags on the left.
  2. Use the first dropdown to choose the primary tag you wish to filter by.

What sets this report apart:

  • You aren’t obligated to use all three tag levels. An adjustable dropdown labeled No. of Tags lets you determine the depth of your search.
  • For the 2nd and 3rd levels, dropdown options only appear based on transactions that match the preceding tag(s). For instance, after selecting the 2nd tag, the 3rd dropdown will display options relevant to further refine your search, based on the tags already chosen.


Is it ok for others to copy, use, and modify your workflow? Sure!


I have some data validation added to this template to show which tags are being used in the search (green) and which are not (red).


Is there any scripts? No! This is all formula based. You can see the formulas on the hidden right side.

wow. this is VERY cool. thank you!


Killer! Have wanted to tag my specific vacation trips for easier reference in the future. Helps minimize the main list of tags to keep things cleaner


This is amazing. Great enhancement! Need to go back and rethink my tagging!

1 Like

@mar5 I was wrong on the assumption that only the first tag would show up under the tag list. I was going to re-organize my tagging to follow more of a waterfall strategy to start broad (ie: travel) and then drill down from there (ie: location name, or purpose, etc.)

I don’t suppose it would be possible to code it accordingly? In relation to your example, only “Travel” would show up on the 1st dropdown box. Then whatever one would decide to use as their second tag, only those options would show up for the 2nd dropdown box, etc. etc.

I realize this may be more of a personal preference but figured I would ask in case others are thinking the same thing!

That is a great upgrade! Would be good if it there was a total of the filtered transactions. Thank you!

1 Like

Hey @mar5 - any thoughts on my previous comment? Would be great functionality being able to organize tags like this!

Slice and dice! :hocho: :kiwi_fruit:

This is a great tool for power users who want to go super granular with their tracking and analysis, @mar5. Super cool!

The build quality is solid and I like the way you’ve added additional filters like date-range and number of tags. It’s a nice touch how you report on tagged transactions at global and detailed levels.

We are super excited to award our first 2022 Microsoft Excel Builders Challenge spot award, a $200 gift certificate.

:clap: :trophy:

P.S. Sorry I was a little late to see this. :slightly_frowning_face:

1 Like

Hi! This can be easily added! I had thought about this as well. I’ll add it soon!

Just so I understand you mean you’d prefer the list on the left to have a list of tags after the first drop-down has been applied?

Thank you! I greatly appreciate it!

Yeah! Basically following the sequence of tags that you input. So, for example, if I tagged a few transactions with: “Travel,Mexico Trip '23” and a different one with “Travel, San Francisco '22” then the first dropdown in the Tags Report would only let me select “Travel” while the second dropdown would then let me select from the various trips I have tagged. It would be a way to help minimize the long list of tags for the first dropdown while still being able to drill down deeper.

Let me know if that makes sense / is even possible!

Can i easily change the report to reference a different column on my transactions sheet instead of “Tags”? love the functionality, but i think it would helpful if i could do this with my “Who” column which i use to designate between myself and my wife for spending. already using my tags column as more of a sub catgeory setup currently so dont want to alter that but would be useful if i could repurpose this report for my needs. hopefully that makes sense and any help is appreciated. thanks!