Transaction Tracker for Google Sheets

Overview

The Transaction Tracker is a place where you can filter your transactions by a multitude of criteria without having to switch sheets. All filters are optional and as you input multiple filters, your transactions are filtered to that granular level.


In addition, there is a grouping option to the right, where you can group transactions by different categories, such as Description, Category, Group and Account.

Installation

Go to my shared Transaction Tracker and copy it to your existing Tiller sheet. (make sure you copy the Transaction Tracker sheet and not any other sheets that are there.)

Usage

All filters are optional, and you can use pre-selected dates or enter your own custom dates, both for “from” and “to.”

Permissions

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

Things to remember

Please note that the “Type” filter does not filter the transactions. It is only used to help in the filtering of the filters. Selecting a Type filter, will narrow down the Cat/Group filter.

Inspiration

Thanks to jpfieber and his Transaction Comparison for the idea.

I love the idea of this tracker. I copied into my Tiller sheet and have a reference error in cell A13 - Error Function ARRAY_ROW parameter 6 has mismatched row size. Expected: 5972. Actual: 1.

Any thoughts to help? Would appreciate it!
Thanks.

Also like the idea of this sheet but it doesn’t seem to fully work for me. Its feeding all of my transactions correctly, but the Type, Group, and Category filters don’t filter anything. The Tag filter works but then I can’t remove the Tag once I put it in the filter.

Could be user error but doesn’t seem like it.

Can you try copying it again from the template to your sheet? I just tried and it is working for me. It could be the tag column, if you don’t have one in your Transaction sheet. If that’s the case, you can simply add a column called Tags to your transaction sheet. If it still doesn’t work, let me know.

To get rid of the Tag filter, you can just press Delete and the filter would reset.
The Group and Category works together, and the Type doesn’t filter the data, but lets you filter to the right Group.
Please try again and let me know if you are having problems and paste a screenshot so I can try to troubleshoot.

Tags is column AA. I have no ideas. thx.

Ha. Yes, the Delete key worked. Should have been obvious to me. Kept using backspace for some dumb reason.

However, I’m going to reload the sheet because the Type, Group, and Category fields just don’t filter.

Great tracker! The Category and Account filters work great. However, the Type and Group don’t seem to.
I have errors In M20 and N20 for Group where the range is "Transactions’!$A2:A and also in N28 Groups. The error is “Did not find value ‘Group’ in Match Evaluation”.
Do you have a GROUP column on your Transactions sheet? I love being able to filter for Accounts and Category without having to always filter my transactions sheet.
Thanks

Thanks! I am hoping you don’t have a GROUP column in your TRANSACTIONS sheet. If that is the case, can you try it after adding and populating a group column? See here for how to do it: Add a Group column to the Transactions Sheet | Tiller Help Center
Also, the Type filter just filters the GROUP/CATEGORY filters, not the transactions.

Thank you, adding the group column to the TRANSACTIONS sheet fixed it. Again, great sheet that will help a lot.

This is awesome! I’ve been a heavy user of the Category Report and Category Rollup Report as a quick check to see why my spending in a particular category was unusual. This seems to be a nice complement to them.

2 Likes

Updated the sheet and added a grouping table to the right, where you can get some more details at a glance.