Tiller Money Review: How to Automate Your Budget Spreadsheet

There are two kinds of people in the world: those who use spreadsheets to track their budget and those that don’t. 🙂

I’ve been tracking our net worth for many years using an Excel spreadsheet. For years, I logged into every single account to pull my data each month. That turned out to be a good thing because it pushed me to simplify our finances because our financial network map was a complete horror show. Even today, manually pulling the data is a time suck, even if you just do this once a month.

As it turns out, the folks at Tiller Money had similar issues and solved it by building a tool to automate the process. They basically give your budgeting spreadsheets, including Google Sheets, the power of automation. It’s like magic.

Learn if it might be the tool your budget needs in our Tiller Money review.

Try Tiller Money for Free

Table of Contents
  1. About Tiller
  2. Setting Up Tiller
  3. Using Tiller After Set Up
    1. Tiller Shows You Connected Spreadsheets
  4. Is Tiller Safe?
  5. How Does Tiller Make Money?
  6. Conclusion

About Tiller

Tiller was founded by Peter Polson, who previously founded Junxion (which was acquired by Sierra Wireless) and was CEO of Dashwire (which was acquired by HTC), in Seattle, Washington in 2014. When they first started, their automation tools only worked with Google Sheets but they’ve since expanded to include Microsoft Excel as well.

The easiest way to get started is to use their Tiller Money Foundation Template. When you connect your bank accounts and link them into the template, your financial data will get pulled in. It comes with separate tabs for your Transactions, Balances, Monthly Budget, Yearly Budget, and Categories. You can customize it to whatever you want but starting from a template makes it super easy.

If you need help, they have a Tiller Money Feeds Tour in the sidebar that’ll walk you through picking things like categories, running the AutoCat, setting budget targets, and updating your sheet. After that, you can use their other templates and tools on the Tiller Community Solutions add-on for net worth tracking, debt progress, business reporting, and other little extensions of the sheet. They expand the capabilities but may be intimidating to start.

When most people think of spreadsheets, they think of rows and columns of boxes. If that’s your experience, then prepare to be blown away. Spreadsheets can do so much more than a ledger of transactions.

They are more like complex databases, with the ability to produce automatic reports and charts, and they can support all types of budgeting systems. (and if Tiller doesn’t have a template you like, you can just download a free budgeting spreadsheet and use their Feeds to make it automated)

For example, the Savings Budget spreadsheet (available through a separate Tiller Community Solutions Add-on) can do envelope budgeting based on how you categorize your spending. It can track savings goals and adjust your budgets on the fly in case you go over one area and need to shift things around. If you want to allocate every penny, it can do that too.

The biggest difference is that a spreadsheet is like a tailored suit and many of the other tools are like buying off the rack. It’s perfectly fine to buy off the rack, but it won’t fit perfectly. To get it just right, you’ll need to bring it to a tailor… which you can do with clothes, you can’t do that with software. 🙂

So expect to do a little more work setting it up, but then it’ll be perfect.

And all the mundane data collection work will be handled by Tiller!

Setting Up Tiller

After you sign up and enter in your credit card information for the 30-day trial, you are asked to connect your first bank account.

The way you connect an account will depend on the bank.

I opted to connect my Bank of America account to Tiller and for that the system will be using Yodlee. The authentication is straightforward and requires you to log into your Bank of America account and give permission to Tiller (via Yodlee).

Once you do that, you’re greeted with this screen:

You can build a Google Sheet, which is stored on Google Drive, or you can use Microsoft Excel, which can be stored on your computer or your One Drive. Within Excel, you will be using an Add-in, which is like a plugin for Excel.

If you choose Google Sheets, you’re taken to the Google Template “Tiller Foundation Template” with instructions on how to set up your spreadsheet. It includes a 2-minute set up video to help facilitate the process – you can watch the video here to see what you’re getting into.

If you choose Microsoft Excel, you’ll download the Tiller-Money-Tracker.xls spreadsheet with instructions on how to get the Tiller Money Feeds Add-in (on the Get Started sheet). Once you install it, you will have to Sign in to Tiller to activate the add-in. The template spreadsheet has all the sheets you need to pull in your transactions and you can immediately begin playing with it. (it was all very intuitive, I was able to do it without reading any instructions)

Update for 2022: Tiller just announced a partnership with Microsoft where they now have full support for Excel through Tiller Money Feeds, a Foundation Template, and a Daily Account Summary Email. Microsoft has sunset their Money in Excel product and now Tiller is the solution they recommend.

Using Tiller After Set Up

After you connect an account, Tiller can pull in all of your transactions into the Transactions tab. In the beginning, it can be a little gnarly because it’s raw data all based on what the bank gives you. My list of transactions consists of a payroll and then Venmo and Cash App transactions:

Bank of America doesn’t even have this level of detail!

But you can categorize them (and update and change the categories in the Categories sheet) and get nicely formatted reports in the process.

From here, you can just play with the spreadsheet to tweak it to what you need.

Once really useful sheet is the Balances one, for when I update our Net Worth Spreadsheet. No more logging into multiple accounts!

Tiller Shows You Connected Spreadsheets

One nice feature, to help you keep track of what spreadsheets are linked, is that they show you the spreadsheets when you log in. I only have the one Excel spreadsheet set up so it just lists that one:

This is great because it allows you to disconnect spreadsheets from one location, rather than having to track down each spreadsheet.

Is Tiller Safe?

Like many similar financial aggregators, Tiller uses Yodlee to securely aggregate banking information. Tiller doesn’t store any of your bank transactions locally, everything is handled through Yodlee (by data aggregation or newer Open Banking connections now available for several large U.S. banks). Then Tiller gets read-only tokens. Tiller uses those read-only tokens to pull your data – so Tiller cannot do anything in your accounts, it can only read the transactions and import them into your spreadsheets.

As you’d expect with any company of this nature, there is 256-bit AES encryption as well as Google’s built-in 2-step authentication.

In terms of internal controls, no human at Tiller ever sees your data. You log in through the third party APIs, Tiller only gets the read-only token, and the data is pulled directly into your spreadsheet. You don’t have to worry about someone within Tiller being compromised because no one within Tiller ever sees your full account numbers, balances, or transaction details.

How Does Tiller Make Money?

Subscription fees.

Not ads. Not by selling data. Not by pitching you products.

Tiller does not sell data and does not advertise to you (the classic “ad-supported” business model). A lot of companies, armed with rich transaction data, love to sell this data to third parties as a way to increase revenue. A lot of companies will look at all this financial data and use it to make commission-based offers that will help you but also their bottom line. If you are using a free tool with no premium up-sell, chances are they’re making money off the data.

Tiller has a 30-day free trial and then is $79 a year. That’s it.

If you are a student, you can get it for a full year, totally free on their Student Plan.

Conclusion

If you are a spreadsheet junkie, then Tiller just might save you a boatload of time every month, if not every day. And it’s no surprise that spreadsheets are often considered one of the best personal finance apps out there, albeit time consuming without automation like Tiller.

If you are more of a spreadsheet novice, it can be a little overwhelming at first. The templates have a lot of features and Tiller offers quite a bit of support with their tutorials and libraries, but it will still take some time to get up to speed. If you invest that time, you’ll find it to be very rewarding.

Also one thing that’s very cool is that Tiller Money offers free live weekly webinars on their Foundation Template to help you get started and ask your questions to their support team, you can sign up here.

When it comes to money management, you really can’t get any closer to your money than with a spreadsheet.

Try Tiller Money for Free

Tiller

$6.58 / month
9

Overall

9.0/10

Strengths

  • Automates your spreadsheets!
  • Free Templates - budgeting, net worth
  • Daily summary of activity

Weaknesses

  • Does not have investment tools
  • Spreadsheet novices may be overwhelmed

Other Posts You May Enjoy:

Copilot Review: The Best Budgeting App for iOS Users?

Copilot is financial management and budgeting tool designed to help iOS users to master their financial lives. If you’ve been looking to get better control of your financing across multiple accounts, Copilot may be the right choice for you. It gives you the ability to track your spending, create budgets, and have more control over your financial destiny.

Albert App Review: An All-in-One Banking and Investing App?

Many personal finance apps specialize in specific tasks like saving money, earning a high-interest rate, paying bills, and potentially earning spending rewards. Finding one platform offering both banking and investing accounts can be challenging. That's not the case with Albert. This Albert app review dives into the various features that can help improve your finances.

Tomo Credit Card Review

It can be challenging to qualify for a rewards credit card when you have bad credit. Now, you have another option with Tomo. The Tomo card doesn’t charge an annual fee or require a security deposit, and it also earns 1% back on purchases. Find out more in this full Tomo credit card review.

Globe Life Insurance Review: Online Approvals Without a Medical Exam

If you’re looking to quickly purchase a life insurance policy with a relatively low death benefit, Globe Life Insurance is worth checking out. That’s the exact type of policy they specialize in. They offer an all-online approval process for both adults and children, often with no requirement for a medical exam.

About Jim Wang

Jim Wang is a forty-something father of four who is a frequent contributor to Forbes and Vanguard's Blog. He has also been fortunate to have appeared in the New York Times, Baltimore Sun, Entrepreneur, and Marketplace Money.

Jim has a B.S. in Computer Science and Economics from Carnegie Mellon University, an M.S. in Information Technology - Software Engineering from Carnegie Mellon University, as well as a Masters in Business Administration from Johns Hopkins University. His approach to personal finance is that of an engineer, breaking down complex subjects into bite-sized easily understood concepts that you can use in your daily life.

One of his favorite tools (here's my treasure chest of tools,, everything I use) is Personal Capital, which enables him to manage his finances in just 15-minutes each month. They also offer financial planning, such as a Retirement Planning Tool that can tell you if you're on track to retire when you want. It's free.

He is also diversifying his investment portfolio by adding a little bit of real estate. But not rental homes, because he doesn't want a second job, it's diversified small investments in a few commercial properties and farms in Illinois, Louisiana, and California through AcreTrader.

Recently, he's invested in a few pieces of art on Masterworks too.

>> Read more articles by Jim

Opinions expressed here are the author's alone, not those of any bank or financial institution. This content has not been reviewed, approved or otherwise endorsed by any of these entities.

Reader Interactions

Leave a Comment:

As Seen In: