What is the Tiller Foundation template?
It’s the simplest budgeting and financial insights spreadsheet on the interwebs. We built the Foundation template to be the easy go-to budgeting spreadsheet option no matter your skill level with Google Sheets.
Immediately get a quick insightful analysis of your financial standing and recent spending. Quickly fine tune your categories and budget based on your unique situation. Easily build a budget and cash flow analysis for an entire year in minutes.
Feeding bank data to the Foundation Template
- Click here to open the Tiller Foundation template for Google Sheets
- Click “Use template” in the upper right. This will create a copy of the sheet in your Google Drive.
- Give this sheet a unique name. Edit the name in the upper left of the Google Sheet.
- Click “Add to Sheets” in the sidebar on the right hand side. If this doesn’t automatically appear for you, open the Add-ons menu at the top of the Google Sheet and choose Tiller Bank Feeds > Install.
- Authorize the add-on to run using the gmail you use for Tiller.
- Click “Use” in the sidebar to launch the Tiller Feeds add-on.
- Sign in to the Tiller Feeds add-on using your Tiller subscribed gmail account.
- Click “Link sheet” to link the sheet to your Tiller Console.
- Choose which accounts should feed this sheet by placing a check mark next to them and then choose to Confirm the account links.
- The Feeds add-on should start updating your sheet with the latest transactions and current balances for any accounts you linked to this sheet.
Quick Start Guide
1. Explore the Insights sheet.
You’ll get out of the box insights after your first data feed. See your Net Worth and get useful analysis to help you better understand your money and your spending.
2. Refine your Categories.
Overwrite or delete the example categories. Add new categories to the bottom of the list. All categories must have a group and type assigned. How do you spend and earn money? We recommend starting with a simple category and group structure.
3. Assign your budget amounts.
Enter your budget amounts into the January column to have the same budget amount per category cascade to each month for the rest of the year. Directly edit the budget for a month for a category as needed. (e.g. if your electricity bill is higher in July than it is in January, edit the budget amount for electricity for July directly to overwrite the automatically filled budget amount. Note: future months after July will adopt July’s new budget amount.)
4. Categorize Transactions.
Categorize as many or as few transactions as you’d like to fuel the Monthly Budget & Yearly Budget sheets. The more you categorize, the more insights you’ll gain. Use AutoCat to help you automate your Category workflows.
5. Quickly gain insights.
Review the Monthly Budget and Yearly Budgets sheets gain insights about your yearly budget and cash flow.
6. Fine tune your budget.
Pay attention to the budgeted cash flow for each month on the Yearly Budget sheet. You can also review a single month at a time using the Monthly Budget sheet.
If you have a negative planned cash flow number you either need to increase your expected income, decrease your expected expenses, or know that a surplus of income will come in a later month. Make adjustments to budget amounts on the Categories sheet.
Note: Editing certain areas of the budget dashboards can break important formulas. These are visualization sheets. Use the date selector controls to adjust the view.
The Insights sheet will light up as soon as you start the data feed to your Foundation template using the Tiller Bank Feeds add-on. It’s intended to give you insights into your current financial standing and recent spending
You’ll see a few key insights from the last 90 days of your transaction data in the top left of the Insights dashboard. You also see some stats about how much data Tiller has pulled for you so far.
You’ll also see the current balances of your three most active accounts based on transaction activity in the last 90 days.
The Insights dashboard also aims to provide a quick net worth calculation (assets - liabilities) based on accounts you’ve linked for automated feeds to this spreadsheet. If something looks amiss here, check the Balances sheet to make sure your account classes (asset or liability) are assigned correctly. If not, you can correct that using these steps.
If you want to manually track accounts review these steps.
The Transaction Analyzer will give you a few basic reports as soon as your data starts feeding into the sheet. You can adjust the analyzer’s settings to customize the reporting data for a different time period or just a specific account.
Top 10 inflows shows you the top 10 inflowing transactions, usually this is income, but it can also include transfers depending on what accounts you have linked and/or visible in the reports.
Top 10 Outflows shows you the top 10 outflowing transactions, which is usually spending, but it can also include transfers.
Note: If you don’t want transfers included in these reports you should make sure all your transactions are categorized and that Transfer category types are marked as “Hide” on the Categories sheet.
Top 10 Accounts by Activity shows you which of your accounts have the most transactions order from most to least active accounts.
Top 10 Descriptions by Frequency shows you where you’re spending money most, the total count of transactions across the selected date range and how much.
Set up your categories and start categorizing your transactions to fuel even more of the Insights sheet.
After categorizing transactions, grouped rows 19 - 31 will come to life.
Using the Transactions Sheet
The Transactions sheet is a core Tiller sheet that is fed by the Tiller Bank Feeds add-on. You can insert additional columns to further customize your sheet, but it requires that the headers in row 1 remain intact for the feed to work and that the tab is named “Transactions.”
You can edit any of the data in the Transactions sheet except the headers in row 1.
Transactions are added by the Bank Feeds add-on automatically when you have the Auto Update turned on and will be sorted to the top of your sheet.
You can also manually add transactions by inserting rows into the Transactions sheet.
Open the Categories sheet to start customizing your Categories. Think about how you spend and earn money. Try to keep it simple. We provide a few example categories to help you think about it.
Overwrite or delete the example categories and add new ones. The template supports up to 200 categories. All categories should have a Group and a Type assigned.
Hide a category from other reports by marking it as “Hide” in the “Hide from Reports” column on the Categories sheet.
How to set up your budget
Open the Categories sheet and enter the budget amounts for each category in column E. Each subsequent month will automatically be populated with the budgeted amount in column E for that category.
Once you’ve set the budget amounts on the Categories sheet you can start categorizing transactions and reviewing the Monthly and Yearly Budget tabs. Based on those budget view sheets you can fine tune your budget amounts for each category on the Categories sheet.
You can change a category’s budget amount for a specific month by directly editing the value for that month. Be aware that months after that change will also adopt the new budget value.
Adjusting the start month of the budget
You can change the year’s budgeting start month by editing the date in cell E1 to be the first day of the month in which you want the budget year to start. For example, if you want your budget year to start in September 2019 you would enter 9/1/2019 into cell E1.
The rest of the year (12 months) following Sept 2019 will automatically populate. This is nice if you just want to start budgeting this month going forward.
Review your Monthly Budget
The Monthly Budget sheet gives you a breakdown of planned vs actual spending and income as well as a planned vs actual cash flow analysis.
Visualize your budget by type, group, and category. You can quickly see what’s remaining for a category or if you’ve gone over.
Each group’s line also indicates the % of your expense budget that’s allocated to that group.
Customize the view of the data on this sheet by using the controls in the upper right. You can view the data for the previous year and month here. If there are no budget periods configured for the time frame on the Categories sheet you will still see your actuals for that period.
Review your Yearly Budget
You can use the Yearly Budget view to see your entire year’s budget. Get a cash flow analysis for the entire month and the year based on the budget you’ve set on the Categories sheet and your actual spending.
You can view a different 12 month period of budgets and data using the controls in the upper right. Keep in mind this is a visualization of your data based on the start month and number of budget months that are configured on the Categories sheet.
Use the Balances sheet to review your account balances and when they were last updated. The Balances sheet gives a net worth total and organizes accounts by asset and liability as well as group if you have those configured on the Accounts sheet.
Using the Accounts sheet
The Accounts sheet is a hidden sheet in the Tiller Foundation template. You can use it to customize or correct details about your accounts.
The dropdown list in column A is populated from the Balance History sheet (another hidden sheet in the template).
Choose an account and then customize.
You can override the class (asset or liability) if it’s being assigned incorrectly.
You can assign the account to a group, which will change the way it’s organized on the Balances sheet.
You can hide the account from other reports by using the “hide” flag on the Accounts sheet.
The Balance History sheet is a core Tiller sheet that is fed by the Tiller Bank Feeds add-on. You can insert additional columns to further customize your sheet, but it requires that the headers in row 1 remain intact for the feed to work and that the tab is named “Balance History.”
You can edit any of the data in the Balance History sheet except the headers in row 1.
Your latest balance entries are added by the Bank Feeds add-on automatically when you have the Auto Update turned on and will be sorted to the top of your sheet.
How to manually add balances
If you’d like to manually track an account, or the automated feed from your institution isn’t supported by Tiller, you can add manual entries to the Balance History sheet.
- Open the Balance History sheet (it might be hidden, click the four horizontal lines in the lower left corner of your sheet).
- Unhide the Account ID column (if it’s hidden)
- Insert a row above row 2
- Enter the information for your manual account including a unique Account ID.
- This can be as simple as 1 as long as it’s unique from other entries and you will remember to reuse the same unique ID for this account for each new entry.
- Repeat these steps each time you want to add a new balance update for this manual account.
Now these manual accounts will be available in the Accounts sheet dropdown list in Column A.
Note: We hope to have a less manual workflow available in the Tiller Bank Feeds add-on later in 2019.