Build Your Own No-Code Automated Personal Finance Tracker With Tiller

Tips and resources for building your own no-code automated personal finance tracker with Google Sheets and Tiller bank feeds from over 21,000 financial sources.

Today, dozens of apps and services promise to keep you in control of your money with the following core features:

  • Account aggregation so you can see everything in one place
  • Automated updates of recent transactions and balances
  • Transaction categorization so you can understand inflows and outflows
  • Reports that show trends and spending patterns

Unfortunately, while these apps can be helpful, they’re also often frustrating, inflexible, and spammy. Perhaps that’s why personal finance apps have a meager 3.4% user retention after 90 days [PDF link].

If you have your own way of tracking money and have been frustrated by apps, consider building your own automated personal finance dashboard with spreadsheets powered by Tiller.

How Tiller works

Tiller automatically updates spreadsheets with your daily spending, transactions, and account balances from over 21,000 financial sources, including banks, credit cards, loans, and brokerages.

Tiller combines the convenience of an app with the control of a spreadsheet through:

  • automated bank feeds
  • prebuilt templates
  • helpful workflow tools
  • dedicated user community

And unlike any app, with Tiller, you can customize everything with familiar spreadsheet workflows and manage your money, your way.

Using Tiller Money Feeds

You control most of Tiller’s settings directly in your spreadsheets with an add-on for Google Sheets or add-in for Microsoft Excel.

Starting with the Foundation Template

On Google Sheets, we recommend getting started with the flexible Foundation Template.

You’ll see how accounts are linked, how transactions are imported, and how categories work. 

The Foundation Template was designed to be customized by you and extended with free Tiller Community Solutions.

Starting with a blank spreadsheet

You can also start with a blank spreadsheet instead of the Foundation Template. In this case, Tiller Money Feeds will install a few required sheets:

  • Transactions
  • Balances
  • Categories
required sheets
Sheets installed with Tiller Money Feeds in empty Google spreadsheet

Depending on your settings, your spreadsheet will now import your daily finances automatically. Around these core sheets, you can then build your own template, with custom reports and charts, favorite formulas, and preferred add-ons.

Need sample data for your project?

Tiller offers a Google spreadsheet with a year of evergreen financial transactions to use in your next project.

Connecting Tiller to Google Sheets and Microsoft Excel

how tiller works 850px v3

You can sign up for Tiller and link your banks to your spreadsheets in just a few steps:

Tiller Builders Resources

What else does Tiller include?

Besides automated bank feeds, Tiller includes:

  • Autocat, for powerful, automated transaction categorization 100% based on your rules to automatically categorize transactions according to your rules.  
  • Daily email that summarizes all recent transactions and account balances
  • Foundation Template with budgets, net worth tracker, quick financial insights
  • Tiller Community Solutions with prebuilt tools and templates

Learn and Share in the Tiller Community

The Tiller Community is the ultimate resource for building personal finance dashboards powered by Tiller Money Feeds.

Get inspired, see what others have built, share your solutions, and ask and answer questions. See you there!

“For those of us who like to analyze spending, budget, trends, history, investment, and rental performance, Tiller is a powerful tool in tandem with the power of Google Sheets. Makes tax return preparation easy. Well worth the minor cost, great support, and far more useful than tools like Mint or Personal Capital.”

Dave Porter

★★★★★
Google Workspace Marketplace

Start Your Free Trial

Try Tiller free and track all your accounts in one place, always know where your money goes, and confidently plan your financial future.

Notable Replies

  1. Avatar for jono jono says:

    Good info here on best practices and how Tiller sheets work.

  2. Every new customer should be directed here. I have struggled with the Foundation sheet for 5 days before coming across this jewel. Please make it a new customer recommended read.

  3. Avatar for randy randy says:

    Glad to hear you’ve found this reference helpful, @4edjennings. We worry that it may be overwhelming to many users.

  4. Yes, it is too much for a newby. That’s why I suggest Tiller Money develop a User Manual. The Builder’s Reference is for Advanced users already familiar with Tiller sheets. We desperately need some guidance for new users. Like I said: An ounce of instruction is worth a pound of troubleshooting.

  5. I’ve been searching for something like this for days, hooray! Just knowing how the data feed interacts with the sheet is so helpful. Reading comments above, I do understand that this isn’t widely published to avoid intimidating new users, so maybe tiller could ask if you’re an advanced excel/sheets user, and then show you this if appropriate. I’d also say a lot was repeated, the real gem in that document for me was understanding how the feed interacts with the sheet, the reserved column headers, how tiller finds columns to update them, and the fact that tiller only ever pushes once to a given sheet.

Continue the discussion at community.tillerhq.com

3 more replies

Participants