Do I need to use this guide?
This guide is for customers who have been on the new ("ysl") version of our data feeds since they started with Tiller, but are still using a Feed Bot sheet and need to transition to using a Tiller Money Feeds sheet. If you DID NOT receive an email indicating that your bank feeds have been upgraded then this is the guide you want to use. You can search your inbox for an email with subject: "Action required: your Tiller bank feeds have been upgraded"
If you are still on the old version ("legacy") of our data feeds or were just recently upgraded to the new version ("ysl") (you received an email with subject: "Action required: your Tiller bank feeds have been upgraded") and also need to transition off a Feed Bot sheet you need to use this guide instead.
Do I need to completely start over in a new spreadsheet?
You do have to create a new spreadsheet, but there are a few options to consider depending on how important your categorized data or customized template is to you. You can start fresh in a new sheet, migrate just your categorized transactions, categories, and manual accounts into the Foundation Template, or make a copy of your existing template and manually modify it to work with Tiller Money Feeds.
Read more on the options below.
Easiest option & you're okay with just seeing the new uncategorized upgraded accounts' data in your new spreadsheet and you don't care to see your historical categorized transaction data in the sheet.
Time to transition: 10 minutes
You want to see your historical categorized transactions, AutoCat rules, manually tracked accounts in your new spreadsheet, but you're okay starting in a new, better template.
Time to transition: 20 minutes - 1 hour
You want to continue using a template that you have invested a lot of time into customizing such as building your own custom reports, dashboards, charts, and queries. You're probably an advanced spreadsheet user and would not want to have to re-create all those customizations in a new spreadsheet.
Time to transition: 45 minutes - 2+ hours
Option 1: A fresh start
The easiest option for transitioning off the Feed Bot and into a Tiller Money Feeds Google Sheet is to just start fresh in a new spreadsheet using the Foundation template. The steps for this workflow are documented here.
This means you would not see any of your categorized historical data from the past several years in this new spreadsheet and you may want to clear out transactions from prior years or months so there is less to re-categorize. Think of this as a fresh start with Tiller.
Log in to the Tiller Console (https://sheets.tillerhq.com/auth/google)
Click "Create a spreadsheet" and choose your platform (Google Sheets or Excel)
Follow the instructions on the Install Help / Getting Started tab of the spreadsheet.
Link your financial accounts to the sheet when you reach the account linking step.
Set up your template
Unlink your Feed Bot spreadsheet from the Console
On the Console click "Open sheet" and from the file menu choose "Make a copy"
Back on the Console, click the sheet's name and then choose "Unlink this sheet"
Get to know the Tiller Money Feeds add-on to understand what's different about your new spreadsheet and how to keep it filled with new data.
Join the Tiller Community and explore Tiller Community Solutions for Google Sheets
Option 2: Leave behind the old template, but bring over the categorized data
If you have a lot of historical categorized transaction data that you really want to bring over we recommend the below workflow that involves creating a new Google Sheet starting with the Foundation Template (our only supported template now) and migrating your categorized data, categories, manually tracked accounts, and AutoCat rules using the Tiller Migration Helper add-on.
Step 1: Create a new Google Sheet
Open the Foundation Template (or a blank Google Sheet if you prefer to build your own).
You can also start in a blank Google Sheet if you prefer not to use the Foundation Template, but you will need to launch the Tiller Money Feeds add-on from the Extensions menu to link the sheet and fill it with Transaction data.
Launch the Tiller Money Feeds add-on from the Extensions menu at the top of your Google Sheet (it will appear near the bottom of the Extensions menu, and can take a few seconds to load).
Sign in to Tiller using the Google account you used to subscribe to Tiller.
Link the sheet to the Console.
Link the same accounts to the sheet.
⚠️ If you will be linking more than 10 accounts we recommend linking in batches of 2 or 3 accounts at a time to ensure that the fill process does not time out due to a large data set.
If you're linking accounts in batches, wait for a successful fill and then click "Connected Accounts" to link a few more accounts.
⚠️ If the fill process takes more than about 5 minutes and you do not see a success message indicating "x transactions/balances added"
Open the File menu in the Google Sheet
Choose Version History
Restore your sheet to the first version
Start over and try linking fewer accounts at one time.
Step 2: Migrate data from your Feed Bot sheet
Step 3: Unlink your Feed Bot sheet
On the Console click "Open sheet" and from the file menu choose "Make a copy"
Back on the Console, click the sheet's name and then choose "Unlink this sheet"
Step 4: Review the Resources section for next steps
Get to know the Tiller Money Feeds add-on to understand what's different about your new spreadsheet and how to keep it filled with new data.
Join the Tiller Community and explore Tiller Community Solutions for Google Sheets
Option 3: keep your template and modify it to work with Tiller Money Feeds
Generally this is going to be the approach you'll want if you're an advanced spreadsheet user and started with a "raw data template" or the "build your own template." Most likely you will choose this option if you're using a template that you've put a lot of customization into outside of just categorizing transactions, building AutoCat rules, and manually tracking accounts (e.g. you have built your own custom dashboards, charts, reports, or other visualizations). You can continue using that template following the steps below.
⚠️ We no longer offer support for non-Foundation Template Google Sheets. If you're using one our old templates and didn't build your own reports we recommend that you just start fresh or create a new Foundation Template sheet and migrate data.
Step 1: Get your Feed Bot sheet up to date
Visit the Console and make sure that all your accounts are refreshed and the latest available data is in your spreadsheet. Check the Account Summary for last refresh times.
Categorize all your newest transactions. This will help you clean up duplicates.
Step 2: Make a copy of your Feed Bot sheet
Open the File menu
Choose "Make a copy"
Update the name so you'll know which sheet is your new one to use going forward
Step 3: Archive & Unlink your Feed Bot sheet
Open your Feed Bot sheet from the Tiller Console (click the sheet's name to access the open button) and from the file menu choose "Make a copy" - this is a backup in case the steps below need to be repeated.
Back on the Console, click the sheet's name and then choose "Unlink this sheet" - you'll always have a copy of the sheet on your Google Drive
Step 4: Update your Balance History sheet to use Account ID
Newer sheets no longer fill the Index number column in Balance History (usually hidden) to uniquely identify accounts. See notes about Index vs Account ID below.
Open the Balance History sheet (if you don't see it, open the View menu > Hidden Sheets to unhide it)
Insert a column to the right of the last visible column (right click and choose Insert 1 right)
Enter Account ID for the header (row 1) for the new column
Step 5: Clear your balance history entries (optional)
⚠️ Recommended if you have more than 5000 rows in your Balance History sheet.
Open the Balance History sheet
Sort the Balance History sheet by the Index column
Clear all rows except row 1 where the Index number is NOT 9999
In the next step the add-on will repopulate all of your Balance History entries for automated accounts. To reduce the amount of data in the Balance History sheet we recommend this step so that the add-on does not get crash while trying to sort a very large data set. Accounts with Index 9999 are manually tracked accounts.
⚠️ If you have manually added balances for automated accounts (e.g. perhaps on days when Tiller missed a balance) you may not want to perform this step since the next step would not bring those balances back into your sheet.
Step 6: Link the sheet using Tiller Money Feeds
Open the Extensions menu in the new (copy) sheet
Choose Tiller Money Feeds > Launch
Click the Sign in with Google button and use your Tiller subscribed Google Account to sign in
Link the sheet and choose the same accounts that you already had linked to the original one and confirm
⚠️ If you will be linking more than 10 accounts we recommend linking in batches of 2 or 3 accounts at a time to ensure that the fill process does not time out due to a large data set.
If you're linking accounts in batches, wait for a successful fill and then click "[N] Linked Accounts' at the top of the sidebar to link a few more accounts.
Tiller Money Feeds will feed your sheet with transactions and balance history. This will result in a lot of duplicates.
Step 7: Clean up duplicate transactions
If you made sure your sheet was fully up to date before making a copy of it and you categorized all transactions before setting up the data feed with the Tiller Money Feeds add-on you can easily clean out duplicates using a filter or the Date Added column.
Clean up by Category column:
Turn on the filter in your Transactions sheet
Filter the Category column to show only blank rows
Clear out all Transactions where the Category is blank (these are the duplicates)
Clean up by Date Added column:
If you don't have the Category column because you use Category Hints you can clear out the duplicates using the Date Added column
Note, if you had to refresh accounts at step 1 you may have some transactions the Feed Bot added on the same date, be sure to watch out for those so you don't accidentally delete them.
Scroll to the far right in your Transactions sheet
Sort your Transactions sheet by the Date added column Z>A (newest to oldest)
Clear the transactions that were added on the date you're performing these steps
Step 8: Upgrade your Accounts sheet (only required if you have an Accounts sheet)
In your new sheet, rename the Accounts sheet (right click the tab) to Accounts-Archive.
Delete the Balances sheet (right click to delete) - this version no longer works with Tiller Money Feeds.
Launch the Tiller Money Feeds add-on from the Extensions menu
Click "Templates" in the sidebar and "Adopt" any sheets if prompted.
Install the Accounts sheet and then the Balances sheet by clicking the "Install template" button under each.
Using your Accounts-archive sheet as a reference, reselect your accounts using the dropdown menu in column A on the new Accounts sheet and apply class overrides as needed and assign accounts to groups if desired.
Step 9: (optional) Set up manual accounts in Tiller Money Feeds
The new Accounts sheet doesn't give the option to save balances for manually tracked accounts like the original version did. Manual accounts are entered and updated using the Tiller Money Feeds add-on. If you were manually tracking accounts in the right side area of the Accounts sheet follow these steps:
In your new sheet, open the Balance History sheet (from View menu > Hidden sheets > show Balance History if you don't see the tab)
Filter the Balance History sheet to only show accounts with an index of 9999. You may need to unhide the index column.
Sort the Balance History sheet by Account or Account name column.
Launch the Tiller Money Feeds add-on (from the Add-ons menu at the top of your Google Sheet)
Click "Manual Accounts"
Enter the information for a manual account as it appears in the Balance History sheet. You only need to save one entry per manual account.
Copy the Account ID generated by the Tiller Money Feeds add-on that starts with "manual:" and paste it into all entries for that manual account. ⚠️ Do not use the quick fill square for this step to avoid it enumerating the Account ID.
Repeat steps 6 and 7 for each manual account tracked.
Step 10: Transitioning AutoCat (only necessary if you were using AutoCat)
We've released a new version of AutoCat that is only available in the Tiller Money Feeds add-on. You can read more about the upgrade here.
Open the Tiller Money Feeds add-on (via the Add-ons or Extensions menu at the top of your Google Sheet)
Click "AutoCat" in the sidebar
Click "Migrate" to migrate your ruleset to use the new format.
Step 11: Rework other customizations (if needed)
We deprecated the Index column fill for Google Sheets when we released the Tiller Money Feeds add-on.
If your customized dashboards, reports, or visualizations were using the Index column in the Balance History to unique identify accounts you will need to modify your visualizations/dashboards to use the Account ID as a unique identifier instead. You should only do this after you have completed all other steps for this transition option.
Explore the community
Now you are all set to explore community built and supported options available in the Tiller Community Solutions add-on.
Resources
How to set up the Foundation Template
For a fresh start, feel free to clear out any historical data you don't want to see in the Transactions sheet.
How to add more reports and dashboards
Including templates previously available on the Tiller Console
The Foundation is a great starting point for budgeting and tracking, but if you want to get the Debt Planner, Net Worth Tracker, or other Weekly Expense Tracker reports in your new Google Sheet install the Tiller Community Solutions add-on to build on top of your “foundation.”
These solutions are now supported by the Tiller Community. If you have questions about anything installed via the Tiller Community Solutions add-on please post your question in the Tiller Community and a team or community member will reply soon. We do this for the one to many benefit of the Q&A.
Open the Tiller Community Solutions add-on from the Add-ons menu at the top of your Foundation Template
Accept the privacy and experimental tool disclaimers.
Browse and add solutions from the Explore section or search for a solution at the top
Use the Help tab in the Tiller Community Solutions add-on sidebar to review existing topics and post a question to the Community about a solution.
Customize your accounts
Unhide the Accounts sheet in your Foundation template (View menu > Hidden sheets)
Select accounts from the dropdown menu and then enter a group name.
Set any necessary class overrides.
What to expect with Tiller Money Feeds
The way your bank data makes it into your spreadsheet is a little different with the Tiller Money Feeds add-on. It's not automatic. Read more here.