Is there any preexisting and automated way to pull annual expense data, aggregate it and compare it year on year? I built a rudimentary spreadsheet but it doesn’t automatically populate and I need to hard code the older years. :

@jpfieber has a Transaction Comparison that might work, or at least give you a great starting point.

Thanks so much. Thats a great tool but I don’t need to see individual transactions and want to compare all categories simultaneously, eg Discretion Expenses and Dining, Groceries, Clothes etc all in one sheet.

OK, there is a solution tool called Period Comparison. Docs: Tiller Community Solutions Add-on - Google Sheets / Show & Tell - Tiller Community (tillerhq.com) you can try. You can add it by the Solutions menu.

This is it! Thank you so much. Works great!

It’s perfect! Well would like more than 2 but pretty awesome! Where can I post a thumbs up!? Thank you

You can see that the dates are specified in AH11:AI16… so you can add ranges or break out of the prepopulating ranges by changing what is there. You should also be able to pull more ranges by copying & inserting new blocks from the N:S range and linking to the new date ranges— the power of spreadsh…

Thanks Randy. Loving this (and I personally find it much more useful when you have years of data to play with).

I’m in middle of adding a third period, I have everything but the “Net Values.” I’ll see if I can get to it this weekend and push it to my shared sheet.

Here’s the link for my modified version of the Period Comparison report. I think I got all the formulas, but let me know if something is missing. Shared Tiller Sheets modified Recurring Expenses Recurring Expenses By @adambecker Learn & Discuss Score,Query Transactions by Description…

Annual aggregation of expenses and YoY Comparison

Conversation Ask Anything

randy September 22, 2022, 5:44pm 6

Does the Period Comparison template help in this context, @jim.pickell?

Topic		Replies	Views
Are there Google spreadsheets already created that can display expenses how I would like Ask Anything google-sheets	4	157	February 6, 2025
Annual Comparison- up to 10 Years gSheets Templates showtell-votes	67	970	May 15, 2026
Year over year templates Ask Anything	5	839	January 7, 2026
Mulit-year over year comparisons Ask Anything	9	101	January 24, 2026
Year over Year Comparisons gSheets Templates	2	177	April 18, 2026

Annual aggregation of expenses and YoY Comparison

Related topics