Use the Category Rollup report to get a detailed view of your finances for a selected time period organized by type, group, and category. The Category Rollup report is also great for itemized deduction reporting during tax time.
- If you don’t see it in the add-ons menu at the top of your Google Sheet, install the Tiller add-on.
- Choose Add-ons > Tiller > Other Solutions > Category Rollup
- Configure the report’s settings.
- Choose “Create report” to generate a one time report based on your settings.
Note: the Category Rollup report will overwrite the existing report data on the Category Rollup sheet when you click “create report.”
Understanding How the Category Rollup Report Works
The Category Rollup Report is a static view of your data meaning if you make changes to the transactions sheet (like recategorizing transactions or adding in manual transactions) after the report has already been generated, the report will not automatically update with those changes. You will need to re-generate the report from the Tiller add-on to get the updated data.
The Category Rollup report organizes your financial data based on the configuration settings you chose and then by type (income, expense, or transfer), group, category, and then the transaction details including date, description, amount, and note.
How to Configure the Category Rollup Report
Choose which transaction details should be included in the report based on the settings the report offers.
Include Hide from Reports categories
This option will include transaction details for any categories that are marked as “Hide” in the “Hide from reports” column on the Categories sheet.
Include uncategorized transactions
This option will include transaction details for any transactions that are uncategorized on the Transactions sheet and group them under an “Uncategorized” heading at the top.
Only categories tagged tax
This option will include only transaction details for categories that are tagged as “tax” in the “Tags” column on the Categories sheet.
Use the Period Preset drop down option under Time Period to choose a time period for which the report should pull transaction data. Use the start and end date fields to customize the date range to your liking.
To archive a previous Category Rollup report
Since the Category Rollup report gets overwritten each time it is re-generated from the Tiller add-on, you may want to archive your previous reports for reference later.
Duplicate the tab
- Right click the “Category Rollup” tab
- Choose “Duplicate”
- Update the name of the tab from “Copy of Category Rollup” to a name of your choosing.
Print the report
Alternatively, if you don't want to duplicate the tab you can print the report to PDF or hard copy from the file menu in the Google Sheet.