Sheets with "query" and "filter" functions painfully slow.

I am trying to track my finances better this year, and am using google sheets to do so. I have the first sheet that is all my transactions, and then in my overview sheets (Mobile-Overview and Desktop-Overview), I have a couple queries in AA1 and AE1. These queries are currently looking at allllll 50,000 rows in the transactions sheet, and as you'd probably expect, this slows down the sheet AND the browser even though there are nowhere near 50,000 transactions.

So I am looking for recommendations to reduce the computational load so I don't hate using this thing. I'm thinking of replacing the query with a filter, but need a way to create a dynamic range so when I open the overview sheet it's not looking at all 50,000 rows.

I considered just changing the range of the table and deleting the unused rows, but then would the table expand as I added transactions?

Here is a link to the sheet: https://docs.google.com/spreadsheets/d/11kF0oB9tIFWRIaRbahkS1wiMIIljYNiBf3HCWsq_srY/edit?usp=sharing