Has anyone created a sheet that would provide multi-year comparisons at the category level? (ie a chart that shows $ by category for 2020 thru 2025). I saw one person posted a query to get that info - but I wasn’t able to make it work.

Rember that queries directly referencing cells or columns will break if the order changes. Good job finding what you are looking for. Have you tried @Cowboy13 Annual Comparison- up to 10 Years This might be useful to you!

I LOVE AI. I just ran the original query thru AI and asked it whats wrong. It gave me the fix. Then I asked it to extend the query so it broke it down by Category. Here is the result for anyone interested: =QUERY( { Transactions!B2:B, Transactions!D2:D, Transactions!E2:E, ARRAYFORMULA(IF(T…

I made something I think is what you’re looking for: [image] Does this fit the bill for you? I can try to find a way to make it available for you if it is.

This ( @Cowboy13 Annual Comparison) is perfect - thank you!!

Thank you @staceyb Let me know if you see any issues or have suggestions.

You could maybe also like the simple P&L sheet Using the Simple P&L Template | Tiller Help Center Learn more about the Simple P&L template for tracking your business cash flow.

Is this template in the Community Solutions? If not, how can I get it?

You can download it from here… [image] Annual Comparison- up to 10 Years gSheets Templates Overview Now that I have multiple years of transactions in my Tiller sheet, I want to be able to see my annual Income and Expenses for multiple years on one page and wan…

It’s not in Community Solutions at this time, though I am looking into submitting it. Try this and see if you can access it: YOY Analysis Clean This Sheet is private If it doesn’t work, let me know and I’ll see if I can get it to work.

Mulit-year over year comparisons

Conversation Ask Anything

Cowboy13 January 24, 2026, 2:30am 9

You can download it from here…

Topic		Replies	Views
Year over year templates Ask Anything	5	839	January 7, 2026
Annual Comparison- up to 10 Years gSheets Templates showtell-votes	67	970	May 15, 2026
Year over Year Comparisons gSheets Templates	2	177	April 18, 2026
Annual aggregation of expenses and YoY Comparison Ask Anything	10	845	September 23, 2022
Is there a multi year SS w each spending category in the A column and the different years in rows? I want to compare YoY spending in categories in 1 SS. Thanks Microsoft Excel tcs-yearly-insights	3	58	February 24, 2026

Mulit-year over year comparisons

Related topics