Start fresh with Tiller
The easiest way to get started with Tiller is to start fresh in a new workbook. Follow the steps below to get started with our Foundation Template for Microsoft Excel which offers Monthly and Yearly budget sheets plus a Balances sheet where you organize your account balances and see a quick tally of your net worth.
đş You can also watch our on-demand recorded Excel Foundations webinar that demonstrates these steps and walks you through how to set up and use the Foundation Template.
If you want to migrate your Money in Excel template data follow the steps below and then move on to the next section for migrating your data.
If you haven't already, use this link to sign up for Tiller and start a free 60-day trial with Tiller
This link prompts you to choose an account to authenticate into the Tiller service, creates an account, and signs you in to the Tiller Console. If you have already started a trial with Tiller use the login provider (Microsoft or Google) and the login identity (email address) you used to start your trial.
Add accounts on the Tiller Console
You must connect at least one financial institution to get started with an Excel spreadsheet powered by Tiller.
For the best experience, be sure to connect the same accounts that you were tracking with Money in Excel.
If you have issues adding an account, try a different institution, and then come back to that one after reviewing our troubleshooting guide.
Click âCreate a spreadsheetâ then âStart with Microsoft Excelâ
This will download the Tiller Foundation Template to the folder where your downloads are saved.
Open this file and rename it with a unique name and save it to a location where you will remember.
If you opt to store your file on OneDrive, make note of the OneDrive account that is signed in to Microsoft Excel when you save it.
Install the Tiller Money Feeds Excel add-in
Open the Insert ribbon at the top of your Excel workbook
Click âMy Add-insâ
Choose âStoreâ
Search for Tiller Money Feeds
Follow the prompts to install the add-in
â ď¸ Please note, the add-in only works in versions of Excel installed via a Microsoft 365 subscription.
Setup Tiller Money Feeds in your new workbook
Open the Data ribbon
Click the âTiller Money Feedsâ icon
Click âSign in to Tillerâ and sign in to the account you used to subscribe to Tiller
Link the workbook
Click âLink Accountsâ to select accounts you would like to link to this sheet, preferably the same ones you tracked with Money in Excel
Click âConfirmâ
Click the âFillâ button to fill the latest transaction and balance data for those accounts.
If you want to start fresh with Tiller, youâre all set and can follow along the guide to using the Tiller Foundation Template here or watch the video below to learn more about how to set it up for budgeting and cash flow tracking.
Otherwise, continue on below to migrate your data.
Optional: Migrating your Money in Excel data to your Tiller workbook
If youâd like to migrate your data from your Money in Excel workbook to your new Tiller workbook, continue with the steps below. These steps assume that your columns in the Money in Excel workbook are still set to the default order.
â ď¸ If you customized your column order, deleted, or inserted columns, please carefully copy and paste the data to match Tiller's columns where Merchant in Money in Excel = Description in Tiller.
Open the Money in Excel workbook that has the data youâd like to migrate.
Migrate your categories
Navigate to the Categories sheet (tab along the bottom).
Select the first category in the list (but not the header row keyword âCategoryâ) then hold shift and click the last category to select the rest of the categories in the list.
Right click and choose Copy or use CMD/CTRL + C.
Back in your Tiller workbook navigate to the Categories sheet.
Clear the default categories, groups, and types from the sheet leaving the headers in row 1.
Right click the first category cell and choose âPaste Special > Valuesâ
Note: Using âPaste Special > Valuesâ makes sure the formatting is consistent with the rest of the Tiller workbookâs formatting rather than pulling the formatting from the Money in Excel workbook.
Migrate category type
Repeat the steps (a.i - a.v) above for the Type data to move it from your Money in Excel workbook to the Tiller workbook Categories sheet.
Assign groups to your categories
The group is the larger classification that your categories fall into. Read more on how we think about this structure and how itâs a little different than Money in Excelâs subcategories here. You can also do this step later.
Decide if subcategories are important to you.
If you have not assigned subcategories to any transactions in your Money in Excel workbook, delete this column in the Transactions sheet of your Money in Excel workbook then move on to step 3 below.
If you were using subcategories in Money in Excel, insert a column to the left of the Amount column (click the Amount column and choose âInsertâ from the Home menu) in the Tiller workbookâs Transactions sheet and title it Subcategory.
The column will adopt the data validation from the Category column. To remove it,
Open the Data ribbon.
Click the Data Validation icon.
Check the âApply these changes to all other cellsâŚâ option
Click âClearâ
Click âOkâ
Note: the Tiller template does not use subcategories or have a place to define subcategories so if you choose to move this data over it will be for historical purposes.
The Group > Category structure in Tiller is very similar and supports a category/subcategory mindset. Read more about that here.
Migrate your transactions
Compare the transactions in both workbooks to identify where the overlap of duplicates starts in your Tiller workbookâs Transactions sheet and clear these from the Transactions sheet in your Tiller workbook.
Tiller can fill 30 - 90 days' worth of historical transaction data so you may need to look back that far to identify the first transaction that only exists in the Money in Excel workbook.
Tip: If you have many accounts, use a filter to help you review one account at a time.
In your Money in Excel Transactions sheet,
Select all the data in the sheet starting with the first transactionâs date (but not the header keyword âDateâ)
Hold the shift key
Scroll and select (while still holding shift) the last transactionâs institution cell to select all the transactions you want to migrate.
Right click and choose âCopyâ
In your Tiller workbookâs Transactions sheet, right click the first empty cell in column A (the Date column) and choose âPaste Special > Values & Number Formattingâ to paste your transactions into the workbook.
Finally, sort the transactions sheet by the Date column from Z>A if your transactions are not in newest to oldest order.
The Tiller Foundation Template has some additional columns that will be blank for the migrated transactions. Itâs okay to leave those columns blank for migrated data.
Now youâre all set and can follow along the guide to using the Tiller Foundation Template here or watch the video below to learn more about how to set it up for budgeting and cash flow tracking.
Learn more about using Tiller with Microsoft Excel on our Help Center here.
Video demo of getting started with the Tiller Foundation Template