How to Track Daily Average Spending Trends in Google Sheets

How to Track Daily Average Spending Trends in Google Sheets

Heather Phillips
May 30, 2019

Do you know what you spend per day on average?

Are you spending more or less than you used to? Why is your spending going up and down? How does your daily spending impact your long term financial goals?

Understanding your daily spending can help you fine-tune your budget for long-term success.

To make this easier, Tiller Money has created a quick way for you visualize your average daily spending trends in a Spending Trends” Google Sheet.

Note that you’ll need a Tiller-powered Google Sheet template for this to work.

Getting the Spending Trends Sheet Into Your Google Sheet

Average Daily Spending Trend Google Sheet

You can quickly add this sheet to any Tiller spreadsheet that has a Transactions sheet:

  1. Open your Tiller spreadsheet.
  2. Copy the URL of the sheet.
  3. Click here to open a read-only version of the Spending Trends sheet.
  4. Right-click the tab “Spending Trends” at the bottom and choose “Copy to”
  5. Paste the URL of your Tiller spreadsheet into the bottom of the dialog that pops up.
  6. Choose select and you should receive confirmation that the sheet was successfully copied.
  7. Navigate back to your Tiller spreadsheet and rename the tab from Copy of Spending Trends to Spending Trends or whatever you’d like to name it.

Customizing the Spending Trends Sheet

Once you’ve added the Spending Trends sheet it should immediately begin working. There isn’t any additional configuration required, but there are some things you can do to customize the sheet.

Choosing the Time Period and Number of Periods

You can choose to review your average daily spending across weeks (starting on Sunday or Monday), months, quarters, or years.

You can choose how many periods you’d like to be displayed in the chart.

You can adjust this at any time to review various time periods and get a sense of how your average daily spending is changing.

After a time period is chosen and the number of periods is set, you’ll see the average daily spending per period amount, total spending in that period, and number of days in the period.

Below that, you’ll see a chart that shows your spending for each day across the number of periods, and period type chosen, against your average for those periods.

Choosing a Different Chart Type

If you’d rather see your daily spending against your average daily spending as a bar chart with a line you can edit the chart and change it to a combo chart.

There may be some other charts you can experiment with, but the line chart and the combo chart seem to work best.

Hiding the Daily Spending Totals

Average Daily Spending Trend3

If you don’t want to see the daily spending totals and data in the columns H, I, and J on this sheet you can select those columns by their column letter then right click and choose “hide.”

You’ll get a pop up that asks whether you want to include the hidden data in the chart, and you’ll need to click “include data” for the chart to continue to work with the columns hidden.

Related Stories

Google Sheets Add-ons
January 21, 2018

3 New Google Sheets Add-ons for Your Personal Finances

Top Google Sheets Add-ons for personal finance to make your regular financial management workflows more efficient (and fun).

Best Free Real Estate Spreadsheet Templates
March 3, 2019

15 Best Free Real Estate Spreadsheet Templates

Here are 15 free real estate spreadsheets you can download right now to help plan, manage, and optimize your investment.

February 28, 2019

Visualize Spending as Hours of Work With This Free Google Sheet

Here's a simple formula for Google Sheets that translates your spending into the hours you had to work to perform to afford everything.