Spending Trends 2.0
Some customers as of Feb 12, 2026 have a newer version of the Spending Trends sheet, Spending Trends 2.0, available for Google Sheets only at this time.
The Spending Trends 2.0 sheet is a simplified version of Spending Trends that includes basic cash flow calculations, a customizable donut chart that defaults to your top 10 spending categories plus a Simple Transaction Lookup tool.
The simple cash flow total is income minus expenses for the selected time period. It also shows the sum amount of transfers and the $ amount representing uncategorized transactions for your selected date range. It was inspired by the Category Tracker and the need for a quick transaction lookup + a better starting place when you’re diving into Tiller.
Installing or Restoring Spending Trends 2.0
If you want to try or need to restore the Spending Trends 2.0 sheet here are the steps.
Copy the URL of your Tiller-spreadsheet where you want to install or restore Spending Trends 2.0
Right click the Spending Trends tab and choose “Copy to” > Existing Spreadsheet
Paste the URL of your Tiller sheet into the top of the dialog that appears and press enter
Select your sheet from the results that appear
Click “Insert” to copy in the template
Open your Google Sheet
You’ll see a new tab called “Copy of Spending Trends” - you can rename this tab by double clicking it, but keep in mind that you may already have a tab called Spending Trends which you’ll either want to rename or remove before you can rename the new version “Spending Trends”
What is the Spending Trends sheet?
The Spending Trends sheet helps showcase key insights about your spending and earning during customizable time periods as you’re getting set up with the Foundation Template. Keep in mind this sheet provides a visualization of your data and is not meant to be edited directly, outside of choosing the time period in the drop down menu.
You will see balances and a quick net worth number for accounts linked to this spreadsheet at the top under Current Assets, Current Liabilities, and Net Worth.
Most customers have the Spending Trends (1.0) as depicted below.
Then, as you categorize your transactions you can watch the sheet come alive in the Income & Expenses Breakdown for the time period that you choose.
The Spending Trends sheet will also share helpful data at the top for Spent Yesterday, Spent Past 7 Days, and Spent Past 30 Days.
You can drill down further by selecting a time period using the drop down menu next to Insights for. The time period applies to only areas of the Spending Trends sheet below it.
You can quickly see your Cash Flow (income minus expenses) and Average Daily Expense for your selected time period.
The Income & Expenses Breakdown will show you exactly how much you are spending and earning in each of your custom categories (listed on the left) and if there are any transactions that still need to be categorized.
Each sparkline to the right of your categories will represent how much you’ve spent in that category for the selected time period relative to the category’s type. The sparkline range for spending is based on the maximum amount for that time period for that type. E.g. The max sparkline amount for expenses in the example below is based on the $950 Prius loan category. All other sparklines for expenses are relevant to that amount.
How to get the Spending Trends (1.0) sheet
If you've been with Tiller for a while and are already using our Foundation Template you can get the spending trends sheet using the steps below until this template is available for install from Tiller Money Feeds.
Google Sheets
Open the Google Sheets where you want to add the Spending Trends sheet
Launch the Tiller Money Feeds add-on from the Extensions menu near the top of your Google Sheet
Note Tiller Money Feeds will appear near the bottom of the Extensions menu and may take a few seconds to fully load the menu.
Choose the "Manage Tiller Solutions" option in the sidebar
Click the "Install Template" button under Spending Trends in the sidebar
Wait for the sidebar to indicate that the template has been successfully installed
Microsoft Excel
Open the Excel workbook where you want to add the Spending Trends sheet
Launch the Tiller Money Feeds add-in from the Data Ribbon at the top of your Excel Sheet
Choose "Tools" then "Manage Templates"
Click the "Install " button by the Spending Trends template in the sidebar
Wait for the sidebar to indicate that the template has been successfully installed and click "OK"

