# Docs: Useful tax time reports

**URL:** <https://community.tiller.com/t/docs-useful-tax-time-reports/120>\
**Category:** gSheets Templates\
**Tags:** taxes, workflows, google-sheets, tracking\
**Created:** [August 17, 2019, 4:03pm UTC](https://community.tiller.com/t/docs-useful-tax-time-reports/120 "2019-08-17T16:03:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [August 17, 2019, 4:03pm UTC](https://community.tiller.com/t/docs-useful-tax-time-reports/120/1 "2019-08-17T16:03:02Z")

</div>

# Generate a quick annual summary

If you need to quickly see the total amount spent or earned for a specific set of categories for the entire year for tax reporting you can do this easily with a pivot table by year in a **Google Sheet.**

If you’re just starting out with Tiller you’ll only see about 90 days worth of data. Use [these steps](https://help.tillerhq.com/gathering-and-importing-your-financial-data/how-to-manually-import-your-bank-data) to get your entire reporting year into your sheet.

1. [Add the year column to your Transactions sheet](https://help.tillerhq.com/gathering-and-importing-your-financial-data/add-year-data-to-your-tiller-spreadsheet)
2. Select all the data in your Transactions sheet by clicking the square above row 1 and to the left of column A
3. Open the Data menu and choose “Pivot table,” which will create a new tab in your spreadsheet.
4. On the pivot table configuration sidebar choose “Category” for the row.
5. Choose “Year” for the column.
6. Choose “Amount” for the values.
7. Add any filters you may want to further filter the data like the year or certain categories.

 ![](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/1X/3ccc94bba49df3bd4ab40a82ba0785d3d2095480.png)

 ![](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/1X/4b6c6f19bb412b323f574f84a4cb0ca2e4466e01.png)

# Generate a detailed itemized deduction report

If you itemize your tax deductible spending instead of taking the standard deduction you can use Tiller’s Category Rollup report for a detailed analysis of your itemized spending for tax time reporting.

_ **Note** _ _: consult with a tax advisor or account regarding what types of spending are eligible for itemization on your tax return._

1. [Add](https://community.tiller.com/t/using-tags-in-the-categories-sheet/117#how-to-add-the-tags-column-to-the-categories-sheet) the Tags column to your Categories sheet.
2. [Tag](https://community.tiller.com/t/using-tags-in-the-categories-sheet/117#how-to-use-the-tags-column-in-your-tiller-powered-google-sheets) categories as “Tax” that you want to include in the itemized deduction reporting.
3. [Configure](https://community.tiller.com/t/using-the-category-rollup-report/121) the Category Rollup report using the “only categories tagged Tax” option for the tax reporting time range.
4. [Generate](https://community.tiller.com/t/using-the-category-rollup-report/121) the Category Rollup report
5. [Export to PDF](https://community.tiller.com/t/using-the-category-rollup-report/121) or [share your sheet with your accountant.](https://help.tillerhq.com/tiller-for-google-sheets/notifications-sharing-revisions-and-access/collaborating-on-a-tiller-sheet)

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [April 14, 2022, 2:49pm UTC](https://community.tiller.com/t/docs-useful-tax-time-reports/120/2 "2022-04-14T14:49:22Z")

</div>