fbpx

Tags Report for Tiller Spreadsheets

Add a Tags column to your Tiller-powered Google Sheets to organize your transactions with greater precision.

About the Tags Report for Google Sheets

The tags report:

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

Tagging Transactions in Tiller Spreadsheets

  • 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.
  • 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.

Support & Documentation

FAQ

This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar.

This template for Excel works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.

Leave a Reply

Start Your Free Trial

Keep a clear, confident view of all your money in one place, with flexible templates, powerful privacy, and top-rated support

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023