Add the Tags Report for Transaction Tagging

[heather]

Overview

Tags are a great way to organize your financial data. You can easily add the Tags Report sheet with a few manual steps.

The Tags Report:

1. Lists the tags you’re using on your Transactions sheet.
2. Shows you the sum amount for transactions that use that tag.
3. Gives a total count of the transactions using that tag.
4. Offers a tag dropdown to show you transaction details for a specific tag.
5. Provides a summary of the categories where that tag is used for a transaction.
6. Shows the total count of transactions using the selected tag organized by category.
7. Offers custom date range tag review

How to Get the Tags Report

1. Install the Tiller Labs Solutions add-on
2. Open the add-on and choose “Add a Solution”
3. Click on Tags Report
4. Choose “Add to spreadsheet”

The Tiller Labs add-on will add the Tags column to your Transactions sheet to the far right (scroll right horizontally) and add the Tags Report sheet.

Tip: You can click the column letter and drag the column to the left to rearrange it so it’s closer to the Category & Description columns.

Tagging Transactions

The Tags Report comes to life after you start tagging transactions on the Transactions sheet. The Tags on the Transactions sheet are distinct from those you can also use on the Categories sheet.
Read more about using Tags on categories.

You can use a single tag or multiple tags for a transaction.

To use multiple tags for a single transaction simply separate each tag with a comma with no space in between the tags.

How to use the Tags Report

After you’ve tagged some transactions you can start building analysis on the Tags Report sheet. You should see the list of tags you’ve used so far populate into the All Tags list starting in cell A9.

You can then select a tag from the dropdown list in the middle of the Tags Report to review all transactions associated with your selected tag and get a summary of the total amounts and counts of the tag used organized by category.

Customize the date range if you only want to view data for a specific time range or you can choose “All Dates” to see all tagged transaction data.

[jonorlin]

Some additional notes about the Tags report:

Tags can be used for lots of purposes. You can tag business-related transactions with a business tag. If you have just 1 food category, you could tag food transactions with Dinner or Breakfast or Coffee etc. If you have 1 travel category, you could add a tag with the name and date of the Trip such as Seattle July 2019.

You could also tag transactions with the word Follow Up and quickly get a list of which transactions you want to follow up on.

If you manage properties, you could use tags for the addresses of each of your rentals.
See here for more.

The possibilities are endless. Share below how you use tags. It might help others.

Also, this new Tags Report fixing a problem that was in the prior version. In the past, if you used the tag NY, the details report would also include any cases where you used a tag like NY June. This doesn’t happen anymore. Only exact tags are matched.

If you want to use tags in your use reports, check out the formulas in A9, E9 and J8. If interested, I can provide more info on how they work.

[heather]

One way I’ve started using this new tags report is for reimbursements. I am often reimbursed for work related expenses so I used “paid” or “unpaid” as a tag that quickly helps @Janelle identify which transactions for which I’ve already been reimbursed and which are outstanding.