Tiller’s Foundation Template is your command center for personal finance management. Join Heather from Tiller as she gives you a tour of this powerful tool, available for both Google Sheets and Microsoft Excel. In this video, learn about:
- The components of the Tiller Foundation Template
- Using the Spending Trends sheet for quick financial insights
- Managing and categorizing transactions in the Transactions sheet
- Customizing account groups in the Accounts sheet
- Viewing your net worth in the Balances sheet
- Getting an overview of your budgets in the Monthly and Yearly Budget sheets
- Setting up categories and budgets in the Categories sheet
- Introduction to the Debt Payoff Planner add-on
- How these features work together to give you a comprehensive view of your finances
- Preview of upcoming videos on budgeting and debt management with Tiller
Transcript
Hi, I’m Heather from Tiller. In part four of our “Getting Started with Tiller” video series, I’ll walk you through the Tiller Foundation Template for Google Sheets and Excel.
Introduction to the Foundation Template
The Foundation Template is a collection of pre-built financial sheets, including:
- Spending trends tracker
- Debt payoff planner
- Monthly and yearly budgets
- Balances and net worth sheet
- Sheets for storing transactions and categories
Note: The Microsoft Excel version is identical to the Google Sheets version.
Spending Trends Sheet
- Provides a quick overview of your money for selected time periods
- Shows net worth based on connected accounts
- Displays total income and expenses
- Customizable date range for insights
- Signals data that needs categorizing
- Allows drilling down into specific groups and categories
Transactions Sheet
- Stores all transaction data
- Allows modification of descriptions and dates
- Enables sorting and filtering of transaction data
- Used for categorizing transactions
Accounts Sheet
- Customizes how accounts appear on the Balances sheet
- Allows grouping of accounts (e.g., checking accounts, credit cards)
Balances Sheet
- Shows organized view of accounts based on Account sheet groups
- Provides overview of net worth
Monthly and Yearly Budgets
- Gives high-level overview of budgets
- Shows planned vs. actual cash flow
- Compares spending against set budgets
Categories Sheet
- Used for setting categories and budgets
Debt Payoff Planner
- Can be added to the Foundation Template
- Helps control debt (to be covered in a later video)
