As a recent Mint convert, I was really missing the trends views that Mint has to let me see spending and income cut various ways â so I put together some dashboards that I think replicate a lot of this functionality, and even improve upon it with more flexible filters and the ability to drill into Groups, Categories, and transactions all on one screen.
I have published two builds of version 3.8 of this template:
- Version 3.8 with Apps Script which includes selection to filter behavior
- Version 3.8 without Apps Script
The template is designed to layer on top of your existing Tiller-linked sheet, so itâs easy for me to roll out new versions (and for you to adopt them!).
Features include:
- A Dashboard tab that summarizes net income over the last 6 months, and a Month / Month spending comparison (ala Mintâs home page).
- A Net Worth Over time tab that shows your total net worth, assets, and liabilities, grouped by account. You can filter this to include account groups, or even add custom account properties so you can filter by whatever you want (I use this for tax status, tagging various types of investments, and account ownership).
- A Net Income Over Time tab that lets you see how income and spending have changed together over time.
- Tabs for Spending by Group/Category, Spending by Merchant (aka Description), and Spending Over Time.
- Tabs for Income by Group/Category, Income by Source (aka Description), and Income Over Time.
- Easy options to filter dates (This Week/Month/Quarter/Year, Last 7 Days/30 Days/3 Months/12 Months, Last Week/Month/Quarter/Year, All Time and Custom).
- Summary tables that show spending/income as well as pie charts to show breakdown of spending, or bar charts (with Y/Y or prior period comparisons) that show spending/income over time.
- Ability to filter to show only specified Accounts, Groups, Categories, or Tags using the Advanced Filters (Click to expand on the right side of any tab).
- Click on the values in Column A to filter the next level charts / transaction table to whatâs selected, or use the drop downs.
- Flexible support for Transactions tabs with edited columns (no hard coded column values) so this should work with however youâve edited your transactions sheet!
- Support for Google Sheet theming so you can customize the colors however you want across all tabs.
- Configurable column names so if your underlying data changes you can update whatâs imported in one place.
Feedback, bug reports, and suggestions are most welcome!
Updates:
V 3.8:
- Fixed bug on dashboard where Year over Year comparison only shows the first 99 days of the year.
V 3.7:
- Toggle to show future assets/income/spending in Real or Nominal Dollars
- Options to forecast a fixed investment growth rate (how it worked before) or to do a monte carlo simulation and choose 10th/25th/50th/75th/100th percentile or âBest first 5 yearsâ / âWorst first 5 yearsâ scenarios to use. Requires a mean (average) and standard deviation for your asset class, which you can get from portfoliovizualizer, or I found this bogleheads resource helpful: Simba's backtesting spreadsheet - Bogleheads
V 3.6:
- Some small bug fixes.
V 3.5:
-
NEW! On the Spending/Income over time graphs you can now see transactions from both the current and prior comparison period.
-
NEW! For those of you who asked for the ability to change the âDescriptionâ to use âMerchantâ now you can! Iâve made all column names configurable via a hidden tab called Config Keys. Just change the value for the key TXN_DESC from Description to Merchant and everything should update. You can also change other column names here as well.
-
NEW! Post-Retirement Budget Tracker. A tab designed for budgeting in a post-retirement phase, where your budget is mostly set by your investable assets and a withdrawal rate. This new tab will will look at your current assets, your desired withdrawal rate, any additional income you make in the year, and then help you track spending vs. your budget. Iâve included some parameters to let you configure this, but this is obviously a deep area. What I have works for me, but would love requests on other things that would be useful to add.
-
NEW! Simple Annual Budget Tracker. Iâm not a big budgeter, and the stuff built into Tiller is way over the top in terms of level of detail for me. This lets you set an annual budget, and a few particular categories or groups you want to pay attention to managing. Then you can see spending vs. where you âshouldâ be on an annualized basis, and the remaining $$ you have to spend against your annual budget. Iâm sure some folks will want more detail but this works for me so I thought Iâd share.
-
Fixed chart labels on spending/income Y/Y comparison graph (they were reversed).
-
Fixed issues where tags would appear selected when they werenât.
-
Made improvements to Net Worth Over Time to handle larger histories better. This is now generated to align with your selected dates (instead of all time) and I think should work to show any 54 periods (e.g., all weeks in a single year, or months over a 4 year period, or 50 years of data). The max is configurable via Config Keys (more below). I tried a bunch of things to make this faster but bumping into Google Sheets limits here unfortunately. At least it shouldnât totally crap out now!
-
Edits to make the âFilters appliedâ a little more focused so itâs harder to miss.
V 3.4:
- Fixed bugs with Spending/Income over time prior year comparisons that caused periods not to line up correctly.
V 3.3:
- Fixed a bug that broke Net Worth Over Time if any Groups and Accounts had the same name.
V 3.2:
- Changed how importing from the Tiller Foundation sheet works to only import required columns. Hopefully this makes things a little snappier and makes this work better âout of the boxâ for people with lots of data or added columns.
V 3.1:
- Added Net Worth and Net Income Over Time Tabs.
- Added support for custom account properties, to further slice and dice your accounts in filters.
- Added support for a âClosed Dateâ to correctly track net worth over time.
- Adding dynamic comparison ranges on the Spending/Income over tabs, so you can compare to the same period last year, or the prior period (e.g., This month vs. Last month as well as January 2024 vs. January 2023).
- Support for filtering by tags (with AND/OR)
- New built-in date ranges
- Edit links so you can edit a transaction nearly directly from this dashboard (it will open your main tiller sheet but take you directly to the transaction).
- Added an Income by Source tab (to parallel Spending by Merchant) for consistency.
- Built in recent version tracking and an alert if a new version is available.
- Lots of internal changes to make the code easier to manage and bug fixes to selection code.
V 2.6:
- Added filters to Dashboard page.
- Added ability to toggle data range on Dashboard in the period-to-date spending graph, so now you can see Month/Month, Quarter/Quarter and Year/Year!
- Added preview of top Expenses/Income/Transfer transactions in the past month to dashboard page.
- Added preview of uncategorized transactions to Dashboard page.
- Added support for Google Sheets themes (so you can easily adjust colors how you like).
- Changed color scheme from brown which my wife said was ugly.
V 2.5:
- Added a Dashboard tab with net income over the last 6 months, and a Month / Month spending comparison (ala Mintâs home page).
V 2.1:
- You no longer need to add a Type and Group field to your Tiller Transactions sheet â in fact if you did and donât need them for anything else, please remove them. Now these fields are added at the âDashboardâ layer instead to make this easier to experiment with. You should only need to update the link to your Tiller sheet!
V 2.0:
- Added Filters
- Transactions sheet Year column should be formatted for YYYY and not a general date
- Transactions sheet Date Added column should be formatted as a general date
