fbpx

Tiller is the easiest way to budget with the flexibility and control of a spreadsheet

"I used to use Microsoft Money, then Quicken, and now Tiller. Tiller is my favorite because it’s very flexible for reporting, categorizing for budgeting, and very reliable with excellent support."
★★★★★
Dave Ahlers, February 9, 2024
Google Workspace Marketplace

"The customizable aspects of Tiller are outstanding."

"My wife and I started using Tiller about a year ago. We were fairly responsible with our money but were unclear about what we were spending month to month on groceries, bills, dining out, and subscriptions.

Because we are saving for a house, every dollar matters.

So we started looking for a budgeting tool that allowed us to track expenses and savings 1 -2 times per month without a lot of manual updating.

We ultimately chose Tiller because of its flexibility and automation.

The customizable aspects of Tiller are outstanding.

Our favorite Tiller features include the AutoCat transaction categorizer, the savings budget sheet, and of course daily automated transaction updates.

We spend about 45 minutes per month tracking our spending and saving to make sure we’re on track.

The impact of Tiller is clear: we've saved a sizable down payment, and on average exceeded every monthly savings goal last year (with many smaller goals as well).

All with a detailed view of our cash flow.

It’s been very helpful and the subscription has paid for itself many times over."

Keep control of expenses and save more money

Get started fast with easy budget templates

Tiller is the most customizable personal finance service

Track your budget, your way:

  • Use your own custom budget categories
  • Create your own auto-categorization rules
  • Choose your own budgeting style and method
  • Make custom charts and reports
  • Style your budget with favorite fonts and colors

How to Save Money on Subscriptions With Tiller and Google Sheets

Here are a few quick Google Sheets tips to help you save money on your monthly subscriptions.

Around 50% of Americans get at least some of their TV fix from online streaming services like Hulu, Netflix, and Amazon Prime.

Perhaps you have subscriptions to all three. Which one do you use the most? How much money are you sinking into these services each year? Are you also still paying for cable TV on top of these streaming video services?

Perhaps you also have a monthly subscription to a streaming music service like Spotify or Pandora. You might even have an online newspaper subscription automatically withdrawing money from your checking account every month.

Luckily, if you use Tiller, you’re aware of when you’re charged subscription fees because you’re categorizing the expense every month. You might say to yourself, “Oh there’s the Netflix subscription again. I’ll file that under “Online Subscriptions” along with Hulu and Spotify.”

At that point, perhaps you consider, “Am I really even using this service? Does it add value to my life?” The question might come up simply because you’re taking the time to notice where that $11.99 is going.

Say you keep the subscription for a year. That’s $143. That chunk could have been allocated to saving for your next vacation or set aside for upgrades to the house.

What about the rest of your subscriptions?

If you’re curious to know just how much you’re spending on recurring discretionary spending like this, here are a few easy ways to use Tiller to help you find out.

Quick and Dirty Spreadsheet Sort

The quickest way to get an idea of how much you’re spending on a recurring subscription is to sort the Tiller Transactions sheet by the Description column. From there you can select the amount of data for all Transactions that match the descriptions for your subscriptions.

In the bottom right of the Google Sheet, you’ll likely see the SUM in a small box. If you don’t see SUM you can click this box to toggle between the calculation options like count, sum, average, and others. Do this one for each subscription to start building the picture of the cost of these services.

Trim-Subsriptions-Tiller

Use Categories and Pivots to Get a Quick Total of Your Online Subscription Spending

One method you can use to get a quick total of your online subscription spending is to use categories and a pivot table.

If you’re using the Tiller Budget template you could have a group for “Online Subscriptions” and then create a category for each one like Netflix, Hulu and Spotify.

If you’ve been categorizing your Transactions with Tiller for a while using a category structure like this you already have the data you need.

If you’re just getting started or want to update your existing categories a quick way to do this is to sort by the Description column on your Transactions sheet and then use the quick categorizing method to quickly fill or update your categories.

Finally, you can create a monthly spending pivot table using these steps.

Right away you’ll see how much you’ve spent on these subscriptions so far this year, or for as long as you’ve been using Tiller, in the Grand Total column. You may also learn something about your spending in other categories as well!

Trim subscriptions Tiller

Use Tags

Tags are another method you can use to get insights around your recurring monthly online subscription costs.

You’ll first need to follow the steps in this help article to set up the tags capability in any of your Tiller spreadsheets.

As you’re entering those first few tags to get the sheet working to think about how you want to tag these recurring expenses.

There are a couple methods that we find useful:

  • Use a single tag such as “recurring online” to see the sum of all your online subscriptions on the Tags sheet.
  • Alternatively, use multiple tags on a single transaction to slice and dice the data a couple different ways. Use the subscription title as a tag like “Netflix” and then also tag it using “yes” or “no” to indicate whether or not you’re actually using the subscription.
  • Review the Tags sheet to see how much money you’re spending on subscriptions you’re not using and also get a break down of exactly how much you’re spending on each one individually.
track subscriptions spreadsheet

Trimming Down Online Subscriptions

Now you can quickly see how much you’re spending on online subscriptions. You have the power to cancel (or keep) any of them. There are even apps out there, like one that Lauren Greutman recommends called Trim, to help you cancel your unused subscriptions with a single text.

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