Note: this is available for Tiller powered Google Sheets only.
One of our favorite power-features that’s built into Google Sheets is the QUERY formula. We use QUERY formulas extensively throughout our finance spreadsheet templates to provide concise reports based on the transaction and balance data that Tiller is automatically feeding into your spreadsheet each day.
Here's what a QUERY against expenses categorized as "Stuff" in a Transactions sheet by month looks like:
=QUERY(Transactions!A:Z, "
SELECT O, -1 * SUM(E)
WHERE D LIKE 'Stuff'
AND B > DATE '2024-06-01'
AND B < DATE '2024-09-01'
GROUP BY O
LABEL -1 * SUM(E) 'Monthly Stuff'
FORMAT O 'yyyy-MMM',
-1 * SUM(E) '$#,##0.00'
")
Where you will adjust the columns as it relates to your sheet. Here's the mapping for the example above:
O - Week column
E - Amount column
D - Category column
B - Date column
And here's the output in a new blank sheet:
Get started using this query by
Add a new sheet to your Tiller Sheet (hint: click the plus sign in the lower left corner)
Copy the query above & paste this query into A1 (the first cell in this new sheet)
Change the word "Stuff" in the QUERY to whatever category you'd like to see in your output sheet.
Change the date range in the QUERY to pull in only the data from the time period you want to see.
Press enter or click in another cell.
Ta da!
Now you have your very own QUERY pulling in your spending by month for a select category.