ℹ️ This content is for Google Sheets
Connect your Foundation Template to Tiller Money Feeds
If you haven't already, you will need to connect your Foundation Template to your bank accounts using the Tiller Money Feeds add-on for Google Sheets.
Follow the steps here.
Watch this getting started video or read on below.
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.
Use the Transaction Analyzer to build your own customized reports on spending and earning.
2. Refine your Categories.
Overwrite or delete the example categories on the Categories sheet (tab at the bottom). Add new categories to the bottom of the list.
All categories must have a group and type assigned. You can have up to 200 unique categories.
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).
4. Categorize Transactions.
Categorize as many or as few transactions as you’d like to fuel the Yearly Budget sheet and other reports in this template. 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 and monthly 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 get a negative budgeted 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.
Adjust budget amounts on the Categories sheet per category.