How do you see totals by category in a separate sheet? Also, what is then the best way to itemize those expenses into sub categories for taxes?

There are a number of ways to see the category or group totals, but if you’re looking to get into details for taxes, I think the ‘ Transaction Tracker ’ may be most useful for you. You can’t alter the transactions from that sheet, but it does a good job of displaying all the transactions in a category…

I’d really like the same thing. The Category Tracker doesn’t really give me what I want. So maybe a add on question. If I copy my transaction tab to a net new sheet, is it then entirely isolated from Tiller? Can I slice and dice with impunity? I want to have my Tiller sheet untouched by my transa…

Yea, you could either copy the Transactions sheet to another sheet with a different name in the same spreadsheet, or copy it to a completely different spreadsheet. It won’t update anymore, and anything you do to it won’t affect the rest of the template.

Hi @hollyandtudor A couple suggestions: A pivot table The Category Tracker - left side of it will show you total per category for a selected time range For the itemized tax reporting piece, I’d recommend checking out this guide

Does the P&L Report help or am I missing something…?

See Totals by Category

Spreadsheets Google Sheets

heather December 29, 2021, 2:29pm 5

Hi @hollyandtudor

A couple suggestions:

A pivot table
The Category Tracker - left side of it will show you total per category for a selected time range
For the itemized tax reporting piece, I’d recommend checking out this guide

Topic		Replies	Views
Isolating expenses in categories Google Sheets	4	302	March 4, 2024
Category Tracker(s!) Refresh News from Tiller tcs-categorytracker	28	3393	March 21, 2024
Category tracker but for Groups? Ask Anything google-sheets , how-to , tracking	14	1006	August 10, 2022
Category Tracker transactions Google Sheets	3	65	June 5, 2026
Seeing transactions per category in monthly budget Google Sheets	4	628	March 2, 2023

See Totals by Category

Related topics