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.
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 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.
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 "Templates" 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
Open the Excel workbook where you want to add the Spending Trends sheet
Right click the tab along the bottom called "Spending Trends"
Choose "Move or Copy..."
In the pop up window, select your Excel workbook (from step 1) in the "To book" dropdown.
Leave the "create a copy" option unchecked
Follow the steps here to update the reference links (IMPORTANT!)