In Transaction Tracker I want to see all expenses for a particular time period. But, when I select Type: “Expenses” and a time “Period” I get all transactions - not filtered by Type. I have checked my Categories sheet and verified all Categories have the correct type assigned.

@SBRocks I see there is a note in the solution instructions about this. 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. The exclude filters, will filter fro…

If you’re willing to modify the formulas, consider making these changes :slight_smile: Google Sheets In cell A12 (note that this includes some other refinements I’ve been using): =QUERY( {INDIRECT(V14),INDIRECT(V15), if(isna(T19),arrayformula(XLOOKUP(INDIRECT(V18),INDIRECT(V16),INDIRECT(V17),"…

Transaction Tracker does not filter when Type dropdown has a type selected

Conversation Ask Anything

Cowboy13 November 10, 2025, 5:40pm 3

@SBRocks

This was something I wanted as well and just recently updated my Account and Category Report to include this and other filter and grouping options. You can get it here- 🏆 Account and Category Report.

Thanks.

Topic		Replies	Views
:trophy: Transaction Tracker for Google Sheets gSheets Templates builder-challenge , tracking , tcs-gallery , tcs-trxn-tracker	158	10998	June 12, 2026
Category tracker - filtering out certain categories as Transfers Google Sheets tcs-categorytracker	4	649	September 9, 2022
Spending Report Based on Account Ask Anything	8	636	July 24, 2022
Category Tracker Report: How Modify to Filter on Accounts Google Sheets google-sheets , how-to , tracking	4	565	December 4, 2022
Category filter Google Sheets tcs-account-filter	2	97	October 21, 2025

Transaction Tracker does not filter when Type dropdown has a type selected

Related topics