The Tiller Money Tracker for Excel allows you to quickly see all your account balances in one place and easily understand your spending and earnings across categories for a selected time period, all in an Excel workbook. Save your workbook to OneDrive for easy access to your automated bank data spreadsheet while on the go using the Microsoft Excel app on your mobile phone.
How to Set up the Tiller Money Tracker for Excel
You can use the Tiller Money Tracker for Excel for free without connecting accounts and manually add your transaction and balance data to the sheet. Powered by Tiller this Excel finance template can be updated automatically with the simple click of a button.
- Download and open the Tiller Money Tracker
- Save and rename the workbook.
- Open the Tiller add-in via the Data ribbon.
- Sign in to the Tiller add-in.
- Click “Link workbook” to link the workbook to your Tiller Console.
- Click “Configure” to link accounts to the workbook.
- Click the “update” button to update your workbook with your latest available bank data.
- Refine your categories on the Categories sheet.
- Categorize transactions on the Transactions sheet.
- Review the built in reports to gain insights on your spending and net worth.
How to Set Up Categories
The categories sheet allows you to organize how your money is spent and earned. You can add new categories to the bottom of the list and overwrite or delete the example categories. Each category should have a group and a type assigned. The categories sheet populates the dropdown menu for the Category column on the Transactions sheet.
You can also set the start month for a yearly budget and add budget targets for each category to use the budget features in this template.
Note: If you don't want to use the budget feature you can delete the Budget sheet and the budget month columns from the Categories sheet.
How to Categorize Transactions
Quickly categorize transactions on the Transactions sheet in the Tiller Money Tracker for Excel by typing the category into the Category cell for a transaction or by using the dropdown menu that appears by hovering over the category cell.
Once a category has been used at least one time previously in the Category column Excel will auto-populate the Category cell once you start typing the category. Once the appropriate category appears, press tab to quickly move to the next line.
Using the Transactions Sheet
The Transactions sheet is the heart of your Tiller-powered Excel Workbook. It’s where Tiller pulls in your latest bank transactions when you click the update button in the Tiller add-in task pane.
The transactions sheet has a core set of data columns that include Date, Description, Amount, Account, Account #, Institution, etc. If these headers are present in row 1, Tiller will pull in the available data for them for each transaction. If a column is missing or the header has been modified (by accidental edit or otherwise), Tiller won’t be able to pull the data for those columns.
- Insert new rows below row 1 for manually recording transactions.
- Delete or clear transaction rows you don’t need or want.
- Insert new columns, and delete or hide any columns you don’t want to see.
- Change the name of the Transactions tab
- Remove the header row (row 1)
- Change the names of the headers for Date, Description, Amount, Account, Account #, Institution or other core data columns.
How to Review Account Balances
Review the Balances sheet to see all your account balances neatly organized in one place. The Balances sheet is organized by Assets and Liabilities, with a quick net worth calculation in the top right. The Balances sheet also includes last update date for each account that’s linked to the sheet.
Note: if an account is missing from the Balances sheet, but it's linked to the sheet, Tiller might not be able to pull the class (asset or liability). Review the Accounts sheet information below on how to set the class override.
Troubleshooting Balance Updates
If you notice that the update date is older than about a day
- Try clicking update in the Tiller Excel add-in to refresh the balance.
- If it doesn’t pull in any new balance information review these steps.
Reach out to firstname.lastname@example.org if you try these steps and still aren’t getting a new balance update, or continue to see an error for an account.
How to Review Transaction Summaries by Category
Review the Tracker sheet to visualize your spending and earnings across your categories for a selected time period.
Type in the Period, First Day, and Period, Last Day to set the date range for your data. Make sure you’ve categorized transactions during the selected date range.
The Tracker sheet gives you a period summary so you can quickly see your Net Cash flow, income, expenses, total transfers, and the number of uncategorized transactions that need your attention.
It also shows you line item sums for each category and its associated group organized by Income, Expense, and Transfer types.
Using the Balance History Sheet
The Balance History sheet is where Tiller records the latest balance, and other data associated with the account such as the last four digits of the account number, the institution, and the account class (asset or liability) for each account that is linked to the workbook.
Using the Accounts Sheet
The Accounts sheet in the Tiller Money Tracker allows you to assign a Class Override if Tiller is incorrectly pulling or doesn't know the class (asset or liability) for an account.
Use the "Class Override" field to assign the class so that the account will appear in the correct section on your Balances sheet.
Setting Up a Monthly Budget
The Tiller Money Tracker has a Budget sheet that allows you to review your monthly budget for an entire year. Budget start month and targets per category are set up on the Categories sheet.