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.

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.