# 🏆 Docs: Transaction Tracker (Excel)

**URL:** <https://community.tiller.com/t/docs-transaction-tracker-excel/12921>\
**Category:** Excel Templates\
**Tags:** builder-challenge\
**Created:** [June 4, 2022, 2:09am UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921 "2022-06-04T02:09:07Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 4, 2022, 2:09am UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/1 "2022-06-04T02:09:08Z")

</div>

# Overview

 ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/5/548b340c19577462bc97dfef8bde67d8ae556c83.png)

This is an update to my Excel Transaction Tracker which now doesn’t require any other sheets to run.  
With this tracker, you can select a category and instantly see transactions. Want to refine? Just select another drop down filter. Want to see all transactions for a month, for a specific account? You simply select the month in the drop down and then account. All filters are optional and you can use them in tandem with each other. (Except for the date filter which will have priority over the month filters.)

# Installation

**First, verify Note column exists in Transaction sheet.** Please go to your Transaction sheet and if you don’t have a Note column, please add it to the right of all other columns.

Install this template using Tiller Money Feeds using the following steps:

1. Launch Tiller Money Feeds
2. Under Templates near the bottom, click Browse
3. Find the template in the list using search or scroll to find it
4. Click the template name in the list to expand its card
5. Click Install to add the template to your spreadsheet

[Read more in our help center](http://help.tillerhq.com/en/articles/2283741-using-the-tiller-money-feeds-add-in-for-microsoft-excel#h_3eb6fa26d6)

At this point your new template should be functional and linked to your local workbook’s data.

# Usage

Simply select the filter you wish to use and your data will be reflected below, along with the total amount.  
Two things to keep in mind:

1. If you are putting in a specific date, that will negate the month filter.
2. If you use this sheet on the web, the “Has Note” checkbox won’t work. If you wish to query transactions with a note, just type “True” in the field.

# Permissions

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

-Updated to version 1.04.

---

<div class="post-metadata">

**Author:** ![susandennis](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/susandennis/32/13699_2.png) [@susandennis](https://community.tiller.com/u/susandennis)\
**Post date:** [June 4, 2022, 1:25pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/2 "2022-06-04T13:25:46Z")

</div>

ohhhh i want this for Google sheets!

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 5, 2022, 3:47am UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/3 "2022-06-05T03:47:56Z")

</div>

Here you go 🙂  
[Transaction Tracker](https://docs.google.com/spreadsheets/d/1G_UbifUtU2MlpqN07SGFu0Ym8gReOq3R7B0y9comEmw/edit#gid=1025880160)

---

<div class="post-metadata">

**Author:** ![susandennis](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/susandennis/32/13699_2.png) [@susandennis](https://community.tiller.com/u/susandennis)\
**Post date:** [June 5, 2022, 2:53pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/4 "2022-06-05T14:53:55Z")

</div>

Thank you!! this is amazing. It’s so fast and so good.

I can’t seem to make Type and Group work and would love to add Accounts but I can’t figure out how this amazing thing works. Where are the mechanics?

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 5, 2022, 8:47pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/5 "2022-06-05T20:47:42Z")

</div>

For now, Type just lets you filter the group filter to make it easier but doesn’t filter the results. I can add accounts, and not sure why I missed that. I’ll see if I can do it today.  
But if you want to explore, the query is in B9 and the data comes from the hidden columns.

---

<div class="post-metadata">

**Author:** ![susandennis](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/susandennis/32/13699_2.png) [@susandennis](https://community.tiller.com/u/susandennis)\
**Post date:** [June 5, 2022, 9:07pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/6 "2022-06-05T21:07:05Z")

</div>

ahhh I should have figured out the hidden columns thing.

it’s such a fabulous tool. thank you so very much

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 5, 2022, 9:19pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/7 "2022-06-05T21:19:48Z")

</div>

You’re very welcome. It should be straightforward to add account since it is on the Transactions sheet. Otherwise I’ll get to it later and update. I accidentally submitted two posts but they are stuck in pending mode but I’ll add it to show and tell for Google

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 5, 2022, 11:48pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/8 "2022-06-05T23:48:43Z")

</div>

I fixed the Type filter, I saw what you meant, but it still doesn’t filter the results, just the group/category filters.  
I did add Account to the filter and results.  
[Transaction Tracker - Google Sheets](https://docs.google.com/spreadsheets/d/1G_UbifUtU2MlpqN07SGFu0Ym8gReOq3R7B0y9comEmw/edit#gid=1029214876)

---

<div class="post-metadata">

**Author:** ![susandennis](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/susandennis/32/13699_2.png) [@susandennis](https://community.tiller.com/u/susandennis)\
**Post date:** [June 6, 2022, 12:48am UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/9 "2022-06-06T00:48:33Z")

</div>

ahhh on the type. now i get it and it works great and the account addition is just great.

really thank you for this entire sheet - it’s exactly what I wanted and had no idea.

---

<div class="post-metadata">

**Author:** ![dirk.van.assendelft](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/dirk.van.assendelft/32/8514_2.png) [@dirk.van.assendelft](https://community.tiller.com/u/dirk.van.assendelft)\
**Post date:** [June 7, 2022, 8:02pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/10 "2022-06-07T20:02:48Z")

</div>

> [@yossiea](#):
>
> Recommendation is not to use web based Excel for this

Just curious why you should avoid the web based version? I find that it actually works quite well with the foundation templates.

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 7, 2022, 8:15pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/11 "2022-06-07T20:15:00Z")

</div>

Hi, sorry if I wasn’t clear. I meant for the downloading/updating of the template, not actual usage of the template or Tiller. I found it easier to do upgrades using the program rather the web version.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [June 9, 2022, 6:15pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/12 "2022-06-09T18:15:40Z")

</div>

Thanks so much for this, @yossiea! Your Transaction Tracker is simple but original and super handy. It is the Swiss-army knife of slicing and dicing transactions history. The UX is simple and intuitive. The performance is responsive. Bonus points for knocking it out a [Transaction Tracker sibling in Google Sheets](https://community.tiller.com/t/transaction-tracker-for-google-sheets/12969). Hat’s off.

_We are super excited to award our first 2022 Microsoft Excel Builders Challenge spot award, a $100 gift certificate. 👏_

If you’re open to a little developer-to-developer feedback for a future release, here is what I’ve got:

- The `Category` filter doesn’t seem to be wired in `A10`.
- The sheet doesn’t work great when the `Tags` and/or `Note` are not present. (They are not standard in our Excel Foundation Template.) Is there a way to make the sheet more tolerant of failures to find these columns?
- When no results are found, the user sees a `#CALC` error. Consider wrapping `A10` in an `IFERROR()` function with a “No results” output. (Though this might hide other issues— like columns not being present.)
- Consider changing the user-input fields backgrounds to a light green color to indicate they are user-editable.
- I like the Transaction Tracker name but “Tracker” is such a broad term. This almost feels more like a Transaction Slicer and Dicer. 🔪 🥝

Thanks again for all your hard work and creativity, @yossiea!

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 9, 2022, 6:22pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/13 "2022-06-09T18:22:49Z")

</div>

Thanks for the kind words! I will take a look at your suggestions and see what I can do. I know I was looking at some sort of filter to select which columns to include but not sure if that’s allowed. I think we can somehow figure out the tag/note column.  
Quickly, with regards to the category filter, not sure what you mean since the category selection does filter out the results on my end.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [June 9, 2022, 6:33pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/14 "2022-06-09T18:33:34Z")

</div>

Good point re: the Category filter… I must’ve have damaged the formula somehow in my testing. Just reinstalled and it worked as expected.

Another minor thing… In my sheet, because my Transactions table extended beyond the data, I was getting weird null results at the end of `J4:J`.

![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/d/d8fad9d90d794f51e1907251ed4d3fea72e8b77d.png)

I think you can fix this with a formula like this (which also has the advantage of not using the `Month` column which can be unreliable for manual transactions):  
`=SORT(UNIQUE(FILTER(DATE(YEAR(Transactions[Date]),MONTH(Transactions[Date]),1),Transactions[Month]<>0,FALSE)))`  
You would want to put this in `K4`:  
`=SORT(J4#,1,-1)`

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 9, 2022, 7:02pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/15 "2022-06-09T19:02:03Z")

</div>

Thanks for that pointer, I made the change and also pushed it out to Z.  
I am also thinking of just removing the “note” filter since we don’t really use it and see about putting tags as optional.  
I updated the template and marked it as Version 1.02

For the name, I think that Slicer and Dicer is good but many people might not be aware of what a slicer is. Perhaps Review or Analysis or something similar might work?

-edit- I seemed to have fixed the “tag” column, but can’t 100% confirm since I have tags and it does work when I delete but just want to make sure it works. What I did was put an iferror around the filter for Tags column, so if it’s not there, it’s #ref, which then blanks the column.

---

<div class="post-metadata">

**Author:** ![wegs220](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/wegs220/32/8028_2.png) [@wegs220](https://community.tiller.com/u/wegs220)\
**Post date:** [June 17, 2022, 3:01pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/16 "2022-06-17T15:01:12Z")

</div>

![Screenshot 2022-06-17 105845](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/2/249b3fd89be985bb3bd97413551ba508e222dd42.png)  
I am getting a calc error. see attached screenshot. any ideas?

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 17, 2022, 3:24pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/17 "2022-06-17T15:24:14Z")

</div>

It looks like it’s still pulling from the template and not your sheet. Right now it will show that if there’s no data. I don’t think I put the error wrapper in yet.

---

<div class="post-metadata">

**Author:** ![wegs220](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/wegs220/32/8028_2.png) [@wegs220](https://community.tiller.com/u/wegs220)\
**Post date:** [June 17, 2022, 5:21pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/18 "2022-06-17T17:21:07Z")

</div>

How do I fix it? I get the error when I try to change the source

Regards,

Bob Wegman  
513-404-7623

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 17, 2022, 5:38pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/19 "2022-06-17T17:38:29Z")

</div>

I will work on it. I do see it happening now on my end as well.

 ![3C9763F8606B4CD4BE6423CBAD126842.png](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/f/ffeee1ddf87037f94dd158f88fd9ced464f4be34.png)

---

<div class="post-metadata">

**Author:** ![yossiea](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/yossiea/32/4643_2.png) [@yossiea](https://community.tiller.com/u/yossiea)\
**Post date:** [June 17, 2022, 5:53pm UTC](https://community.tiller.com/t/docs-transaction-tracker-excel/12921/20 "2022-06-17T17:53:30Z")

</div>

I apologize. That was happening due to the Tag field/filter. I removed it since it’s causing issues and it’s not part of the standard Tiller fields. If you try again, it should work.  
Current version is 1.03.

[Next page](https://community.tiller.com/t/docs-transaction-tracker-excel/12921.md?page=2)
