When I read Fast Company’s article titled What the hell happened to Mint? I saw a reference to a Mint help article that promised to allow filtering by date range in the transactions view. I clicked in and gave it a test drive. Guess what? It doesn’t work. Clearly, Mint has changed their URL structure since the help content was written.
Fear not, dear reader. Turns out, you CAN do all kinds of cool queries, if you know the proper URL structure. Here goes.
Mint Transactions URL Structure
The structure is simple …
The magical part is QUERY_GOES_HERE, and that’s where we have the syntax for startDate and endDate. For example, for FY2019, use this:
Adding Category, Name, Tag, and/or Notes Queries to the Date Range
If you want to group this with a query by category, transaction name, tag, or the contents of the notes field (this one blew my mind, since I’ve wished for this for awhile), I’ve got you covered.
- category: “query”:”category=:Groceries”
- transaction name (description): “query”:”Wegmans”
- tag: “query”:”tag:strawberries”
- notes: “query”:”notes:lunch with Joe”
- grouping a few together: “query”:”description:Silver Queen Farms, tag:strawberries”
Assuming that the quotes above turn into fancy quotes or some other kind of nonsense, here are functioning links that use this syntax for the examples above. You can hit ’em, modify ’em, and bookmark ’em. Enjoy!