How to Track Daily Average Spending Trends in Google Sheets

Here's a quick way to visualize your daily average spending trends in a Tiller-powered Google Sheet, so you can optimize your budget for long-term success.

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, a Tiller Community member created a quick way for you to visualize your average daily spending trends in an Average Daily Spending Trends Google Sheet.

Getting the Spending Trends Sheet Into Your Google Sheet

average daily spending trends spreadsheet

You can quickly add this sheet to any Tiller spreadsheet that has a Transactions sheet using the Tiller Community Solutions add-on.

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.

spending trends sheet

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.

daily spending chart
Heather Phillips

Heather Phillips

Heather comes from a background of user experience design & customer support. She loves helping others learn, explore and discover better ways to use applications and products that improve their lives. When she’s not coaching customers on Tiller best practices, tweeting or writing blogs, she’s probably at a yoga class, out for a hike in the Blue Ridge, or off volunteering for a variety of non-profits.

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