Spending and Income Dashboards for Mint Trends Lovers 

A free template that replicates Mint's spending and income trends dashboards in Google Sheets. Includes flexible filters for drilling into your Groups, Categories, and transactions on one screen.


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.

It’s 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.

View Screenshots


Version 3.4 of this template is here.

Questions and Feedback

Share your feedback, bug reports, and suggestions here in the Tiller Community.


  • Fixed bugs with Spending/Income over time prior year comparisons that caused periods not to line up correctly.


  • Fixed a bug that broke Net Worth Over Time if any Groups and Accounts had the same name.


  • 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.


  • 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.


  • 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


This is a free template built by a member of the Tiller Community. While it’s free for anyone to use, it’s designed for spreadsheets automated by Tiller. Additionally, it’s recommended for use within the Foundation Template.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar.

This template for Excel works best when installed in Tiller’s Foundation Template.

Visit the Tiller Community with any questions about this template.

Leave a Reply

Start Your Free Trial

"There isn’t another tool on the market that does what Tiller can do.”
Will Hinton, Google Review October 30, 2023