You can use the existing category logic in the Weekly Expense Tracker template or the Build Your Own spreadsheet template to set up a simple subcategory structure using these simple steps.

  1. Fill in your list of categories and subcategories on the Category setup sheet. 
  2. Add a "Subcategory" column to your transactions sheet to the left of the existing Category column. 

Note: Adding next to this existing category column will replicate the category logic in the new column.

TIP: A sub-category method is available in the Tiller Budget template.

Now you have the ability to choose a category and a subcategory from your Transactions sheet. You can then build reports and pivot tables using these new subcategories to break down your spending in detail. 

Read more in depth about setting up subcategories on the Tiller blog

Did this answer your question?