In this video we explore the basics of the Tiller Transactions tab. We cover some modifications you can make to the Transactions tab and the basics of using filtering and sorting in Google Sheets.
Hey it’s Heather from Tiller. Today we’re going to be exploring the power of the Transactions Tab.
In this video I’m going to show you some modifications you can make to the transactions tab and how you can dig deeper into your data by using the built in filtering and sorting features of Google Sheets.
The transactions tab is the heart of Tiller. Each day the Tiller feedbot pulls in the settled transactions from your bank, credit card, or whatever other financial institution you might have linked to this particular sheet. The Tiller feedbot does this by adding a new row to your Tiller Sheet for each new transaction, and then the feedbot sorts the data by date so your newest transactions are on top. The longer you use Tiller, the larger this Transactions tab will grow.
On the transactions tab you’ll spend time reviewing your transactions and adding extra data to help you stay organized and understand your spending. We can see here there are a few transactions from the weekend that are uncategorized. I can take a look at those and assign a category that captures the intent of each purchase.
On Saturday morning I had breakfast with friends at our favorite bagel shop so I’ll categorize that as “dining out.” I did some laundry so I’ll categorize this $1.50 as “Laundry.” I bought some groceries for the week on Sunday, and I went out to dinner with friends on Sunday night. I’ll revisit my Tiller Sheet in a few days to review new transactions.
Most Transactions tabs have columns for your transaction date, amount, description, and bank information. The feedbot visits this tab several times a day with updates. If the feedbot recognizes a column header, like Amount, Date, or Description, it will fill in the data for those columns for each new transaction. In addition to the default columns you see on your transactions tab, you can add in additional Tiller columns as well. To see our full list of supported columns, visit tillerhq.com/columns.
You can also create columns for your own purposes that will be ignored by the feedbot. The note column is an example of one that isn’t used by the feedbot, but may be useful to you. Perhaps I want to flag work expenses that I’ll need to get reimbursed for from my employer. I can make note of that in the note column. Maybe I use my Tiller Sheet to manage my freelance consulting business. I could add an Invoice # column to my sheet to help me track which invoices have been paid.
You can modify any data on the transactions tab. When you modify the data, it doesn’t change the data on other Tiller Sheets you might be using. You can clarify a description, add notes, or create a split transaction by inserting a row and adding in a second line. You can add rows for cash transactions not captured by Tiller if you want to track your cash.
The great thing about your Tiller Sheet is that it’s a spreadsheet so just like any other spreadsheet you can filter and sort the data. Let’s say I want to see all my transactions associated with dining out. I can filter the category column on the “dining out” category by clicking this little arrow on the column header, choosing “clear” and then selecting only the “Dining out” category.
After I’ve reviewed what I needed to see for the Dining out category I can once again show the data for all Categories by selecting that arrow again, choosing “select all” and then clicking ok.
If I want to review my transactions alphabetically by the account name I can click the arrow on the “account name” header and choose to sort A→ Z. Each column can be filtered or sorted for a drilled down data review. Perhaps I need to filter the transactions to recall how much I spent at a new upcycled clothing and accessories boutique. I remember the name of the store so I can do a text filter by selecting the filter arrow on the “Description” column, choosing “Filter by condition,” choosing the “Text contains” option and then entering the name of the store to find all purchases that have that text in the description.
Now I can see that I spent $96 on items at the store. The filtering and sorting options are expansive so feel free to explore.
If you have sorted your Transactions tab, remember it will be re-sorted by newest transactions first when the feedbot adds in new transactions later today or tomorrow. The feedbot doesn’t mind if you have filters turned on, but don’t forget they’re on when you return to your Tiller Sheet. If you find you’re missing transactions, it might be due to a filter. If you see any of the filter icons in the header rows highlighted in green then you know a filter is turned on.
We hope you found this tutorial useful. If you have any questions, feel free to reach us using the live chat window on our website.