The Transactions sheet is the heart of Tiller. It's where Tiller pulls in the data about your latest financial transactions from the accounts you have linked to the spreadsheet. 

Note: Please do not rename the Transactions sheet (tab at the bottom). Doing so will prevent your data from being pulled into the sheet.

Basics of editing data in the Transactions sheet

Your data is yours! Feel free to add custom columns, delete columns for data you don't want to see, and insert or delete new rows in the Transactions sheet. 

You can directly edit any of transaction details below row 1 in the Transactions sheet. 

Note: Do not modify the headers (contents in row 1) or Tiller will not be able to properly pull this data. 

What happens to my data if I make edits?

Tiller stores the original data that was filled in a database so edit to your heart's desire. If you connect a new spreadsheet to Tiller's data feeds the original data will populate into that sheet. 

Editing Columns in the Transactions sheet

Tiller's starter templates have a base set of columns in the Transactions sheet. The column's data is defined in row 1 with a header. The base columns in all templates are:

Date
Description
Category
Amount
Account
Account #
Institution
Month
Week
Transaction ID
Check Number
Full Description
Date Added   

Read the descriptions of the data that's automatically pulled into these columns and the other supported columns you can add to your Transactions sheet here

Note: if you insert additional columns that Tiller can fill automatically, it will fill the data for new transactions going forward. It does not retroactively fill for transactions that already exist in your sheet. 

Did this answer your question?