Skip to main content
All CollectionsWorkflowsPersonal Finance
How to Generate a Yearly Pivot Table for Easy Tax Time Reporting
How to Generate a Yearly Pivot Table for Easy Tax Time Reporting

Learn how to create a pivot table by year for easy tax reporting.

Heather Phillips avatar
Written by Heather Phillips
Updated over a year ago

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 to get your entire reporting year into your sheet. 

  1. Select all the data in your Transactions sheet by clicking the square above row 1 and to the left of column A

  2. Add the pivot table as a new sheet/worksheet

    1. Google Sheets: Open the Insert menu and choose “Pivot table,” which will create a new tab in your spreadsheet.

    2. Microsoft Excel: Open the Insert ribbon and choose the Pivot Table icon

  3. On the pivot table configuration sidebar choose or drag and drop “Category” for the row. 

  4. Choose “Year” for the column.

  5. Choose “Amount” for the values.

  6. Add any filters you may want to further filter the data like the year or certain categories. 

Did this answer your question?