In this video, I share another unique way to analyze your transactions data with the powerful Google QUERY function. The Ultimate Transactions QUERY Builder (UTQB) for Google Sheets is a template and tool to create queries using selection boxes and drop downs. Well suited for both novice and advanced Google Sheets users. Get your copy of the builder at the following link: https://pages.sheetstopia.com/products/ultimate-transaction-query-builder The payment model is a "pay what you like" style. If you try it for free and later decide it is worth a financial contribution, feel free to donate a tip via my tip jar: https://pages.sheetstopia.com/products/sheetstopia_tipjar Visit https://sheetstopia.com for more spreadsheet tips, templates, and tutorials. 0:00 Introduction 0:50 Step One - Define your source sheet 2:00 Step One - Set the GID 2:45 Step Two - Set the Data Range and WHERE Clause Items 9:50 Defining Presets 14:15 Step Three - Applying a LIMIT, preset, and Date filtering 17:10 SORT the output 18:20 Selected Transaction sub panel 21:15 Future Idea 22:35 Wrap-up