Welcome to the Tiller Foundations Guide. Use this guide as a self paced resource for building a strong financial foundation with Tiller.

Mostly likely you've already started a free trial, but if not, sign up at https://sheets.tillerhq.com/auth/signup.

ℹ️ You do not need to switch email addresses or sign up under a different account to try both Google Sheets or Microsoft Excel. You can use either authentication type (Google or Microsoft) and still use both platforms under the same subscription/account.

Table of Contents

Step 1: See everything in one place

➡️ Troubleshooting account connection issues

Step 2: Dive into ultimate control of your money

Tiller Tip 1: Keep your data fresh

Tiller Tip 2: Control your categories like never before

Tiller Tip 3: Find out how much you actually spent

Tiller Tip 4: Keep your money on track

Tiller Tip 5: See all your account balances organized your way
Tiller Tip 6: Explore the perfect solution for you
Tiller Tip 7: Gaining clarity and staying confident

Step 1: See everything in one place

Now that you’ve started a trial you can connect all your financial accounts to Tiller and easily start seeing spending and balances for all your accounts in one place. You can add all types of accounts including credit cards, investments, loans, and more.

How to connect financial institutions to Tiller

  1. Log in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Click "Add accounts" near the top or if you've already added some accounts and want to add more scroll down to the Account Summary and click “Add accounts”

  3. Search for your financial institution and select it from the list.

  4. Enter your username and password for the institution. The same username and password you'd use to log in to the account directly online.

  5. Once successfully added you should see the institution name and a list of accounts appear on the Console under the Account Summary.

  6. Apply account nicknames to accounts on the Console before you create your first spreadsheet. Read more here.

Troubleshooting account connection issues

If you have issues connecting a financial account, review our guide here and keep going with the next steps for accounts you can connect.

📺 Watch the Getting Started with Tiller for Google Sheets playlist on YouTube

ℹ️ Resources

Step 2: Dive into ultimate control of your money

Once you have connected accounts to Tiller you’re ready to create your first spreadsheet and dive into the most powerful way to see, know, and manage your money. You can create up to five Tiller-powered spreadsheets. You can mix and match accounts between them and try both Google Sheets and Microsoft Excel.

How to create a spreadsheet:

  1. Login to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Click "Create a spreadsheet"

  3. Choose "Start with Google Sheets" or "Start with Microsoft Excel" to open or download the Foundation Template on your preferred platform.

    1. If you're new to spreadsheets we recommend Google Sheets.

    2. If you're familiar with spreadsheets, and unsure which to choose review this guide.

  4. Follow the instructions on the first sheet (tab along the bottom) in the spreadsheet template to install Tiller Money Feeds

    1. ℹ️ If you choose to use Microsoft Excel and try to sign in to the add-in using your Google identity, but get an error, you may need to link a Microsoft account to your Tiller subscription. Read more about this here.

  5. Follow the tips below to learn how to keep your bank data flowing into your spreadsheet and get set up to use the Foundation Template.

If you prefer not to use our Foundation template:

You can connect Tiller Money Feeds to a blank workbook or your own spreadsheet.

  • Review our guide on connecting Tiller's financial feeds to your existing Google Sheet.

  • Review our guide on connecting Tiller's financial feeds to your existing Excel Workbook.

ℹ️ Resources

Tiller Tip 1: Keep your data fresh

You want a tidy place to check in on your spending. Making sure the data is reliably in that spot each day is crucial for building financial confidence. This happens in two steps in Tiller: Refresh & Fill.

Tiller can automatically refresh many accounts behind the scenes about once a day, but you’ll still need to use Tiller Money Feeds to fill the data into the sheet.

You also may need to manually refresh some logins if the institution enforces two factor authentication (2FA) or has disabled our ability to automatically refresh.

Read more in depth about how refreshes work.

You can opt into a daily email summary of your latest transactions and balances using these steps.

How to refresh your accounts:

  1. Log in in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Scroll down to the Account Summary to check the last refresh times for your institutions. You can also do this step in the Tiller Money Feeds add-on for Google Sheets under Connected Accounts.

  3. Click "Refresh" next to any institution that hasn't recently refreshed.

After you’ve confirmed all accounts have recently refreshed, fill your sheet with the latest data.

How to fill your Google Sheets with new bank data:

  1. Open your Google Sheet

  2. Open the Extensions menu at the top of the Google Sheet

  3. Choose Tiller Money Feeds > Fill sheets (sign in if necessary)

How to fill your Microsoft Excel workbook with new bank data:

  1. Open your Excel workbook

  2. Open the Data ribbon

  3. Click the Tiller Money Feeds icon

  4. Click “Fill"

ℹ️ Resources

Tiller Tip 2: Control your categories like never before

Tired of those generic categories that don't fit your lifestyle or are hard to edit? Now you can organize your spending just the way you want. Customizing your categories list on the Categories sheet allows you to be as broad or as granular as you need for your financial situation. You’re not locked into our example categories or groups.

  • Repurpose any of the example categories by typing over them.

  • We recommend keeping it simple.

  • Categories should be unique (no duplicates).

  • Each category should be assigned to a group in the Group column.

  • If you’re unsure of how to group things, just stick with our example groups as a start and clear any that don’t apply.

  • Don't worry about the month columns E through P just yet. We'll get to those later.

We recommend a simple structure for your categories and groups because it's easier to remember as you’re categorizing and the more likely you’ll stick with it in the long run.

How to customize your categories:

  1. Log in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Open your Tiller-powered Foundation Template spreadsheet

    1. Microsoft Excel workbooks maybe stored on your OneDrive or locally on your computer, the Tiller Console will display the name of linked workbooks, but there isn't a way to open them from the Tiller Console.

  3. Navigate to the Categories sheet (tab along the bottom)

  4. Overwrite any categories that don’t apply to your life by typing over them in column A

  5. Double check the Group in column B to see if the group still makes sense. Overwrite these too.

  6. Double check the Type in column C to make sure these match the category type. Read more about Transfers here.

How to categorize transactions:

  1. Navigate to the Transactions sheet (tab along the bottom)

  2. Use the dropdown menu in the Category column to assign a category to the transaction

To automate or not?

We’re not going to pretend like we know what category you’d want to use. A lot of tools do this and they get it wrong and that’s really frustrating. So we leave it for you to decide.

There is power in manually categorizing your transactions, especially if you’re trying to get a handle on your spending. Knowing that you have to touch each transaction will transform the way you spend money. Try it for yourself, at least for a month, if there are some areas where you’d like to cut back.

But if you’re busy and short on time, AutoCat can do it for you. AutoCat allows you to build a custom rule set based on your transactions for how you want them categorized.

The simplest option is to build rules based on keywords in your transaction descriptions. Use these steps to get started:

How to set up AutoCat for Google Sheets:

  1. Log in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Open your Tiller-powered Google Sheet

  3. Launch the Tiller Money Feeds add-on from the Add-ons (or Extensions) menu

  4. Click on the AutoCat option in the sidebar

  5. Click “Install AutoCat” to add the AutoCat rules sheet to your spreadsheet

  6. Click the “Suggest rules for past 90 days” option in the sidebar

  7. Review and modify the suggested rules & select a category for each one you want to keep or click the X in the upper right for any that you don’t want to add.

  8. Click “Create & run” in the sidebar when you’re ready to create some example rules and run them to categorize some transactions.

How to set up AutoCat for Microsoft Excel:

  1. Open your Tiller-powered Excel workbook

  2. Open the Tiller Money Feeds add-in from the Data ribbon (or Insert ribbon > My add-ins)

  3. Sign in to the add-in if necessary using the account you used to subscribe to Tiller

  4. Click the "Install AutoCat" button

  5. Quickly review your transactions sheet for common merchants where you always use the same category (e.g. mortgage, utilities, etc)

  6. Identify keywords from the transaction's description that are the same every time

  7. Navigate to the AutoCat sheet and type some keywords into the "Description contains" column for a row for one rule

  8. Assign a category to the rule in the Category column on the AutoCat sheet

  9. Click the "Run AutoCat" button at the top of the Tiller Money Feeds add-in sidebar

  10. Repeat steps 5-9 to build your rule set and categorize transactions.

You can also build more complex rules to have AutoCat do more than categorize transactions. It can do things like clean up descriptions, add notes, and more.

ℹ️ Resources

Tiller Tip 3: Find out how much you actually spent

“Where is my money going?” That’s the million dollar question, right? Maybe you’re also wondering, “Can we afford to buy that new house?” “Will we survive on one income?” “When can I retire?”

The biggest key in knowing how much you’re spending and whether your financial goals can be reality is putting in the effort to categorize your transactions.

You can do this manually, and you will learn a lot just with that exercise, (it’s well worth the time!) or you can have AutoCat help.

You don’t need to categorize all the historical data in your Transactions sheet. You can categorize this week or this month and go forward. The more you categorize, the more insights and awareness you’ll build.

If you want to start budgeting, and are unsure what your spending targets should be, we recommend categorizing last month up to today. In our next tip, we’ll explore where to set those budget targets.

How to review your spending after categorizing transactions

  1. Log in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Open your Tiller-powered Foundation Template spreadsheet

  3. Navigate to the Monthly Budget sheet (tab along the bottom)

  4. Select a month in the top right of the sheet that corresponds to the month where you have the most categorized data (e.g. if you categorized everything from last month, flip back to last month)

  5. Review the actuals in column G to get some clarity on where most of your money is going.

  6. You can also review top 10 expense and income transactions for a time period using the Insights sheet

If it’s emotionally hard to see your spending in one place because you haven’t done this before, pretend these are a friend’s accounts, not yours. This will help you be a more objective and kind observer.

ℹ️ Resources

Tiller Tip 4: Keep your money on track

It doesn’t matter if money is abundant or scarce in your life, budgeting can be a helpful learning experience that guides you toward the adjustments you need to make to help you achieve your financial goals.

The Foundation Template makes it easy to set up a simple 12-month budget in minutes and quickly gain insights about your cash flow.

How to set up a budget:

  1. Log in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Open your Tiller-powered Foundation Template spreadsheet

  3. Navigate to the Categories sheet (tab along the bottom)

  4. Enter budget amounts into column E for each category

  5. Adjust individual months as needed by editing the category amount for that month and the next month if it doesn't need that adjustment.

  6. Navigate to the Monthly Budget sheet (tab along the bottom) and review your budgets, actuals, and available for each category.

  7. Navigate to the Yearly Budget sheet to get the big picture view of your entire year by scrolling right to review each month.

  8. Adjust your Budget targets on the Categories sheet as needed

Review your monthly budget sheet weekly to see how you’re doing. The planned cash flow in the top left shows what you’d have left over if everything goes according to plan. The cash flow to date is most helpful at the close of the month to see how you actually did.

ℹ️ Resources

Tiller Tip 5: See all your account balances organized your way

You probably have various accounts of all types scattered across the internet at several different institutions. What would it be like to see all those organized neatly in one place? How about not having to log in to all those individual sites every time you want to see a balance?

How to use the Accounts and Balances sheets to organize your accounts:

  1. Log in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Open your Tiller-powered Foundation Template spreadsheet

  3. Navigate to the Accounts sheet

    1. In Google Sheets, open the View menu

    2. Choose “Hidden Sheets> Accounts”

  4. Select an account from the dropdown menu in Column A

  5. Assign it to a group by typing it into the Group column

  6. Navigate to the Balances sheet (tab along the bottom) to review.

Common groups for accounts are things like “Credit cards, Checking, Investments, Kids College” and the like.

Think of the Balances sheet as your financial scorecard. If this is the first time you’re seeing everything in one place, it can be exciting, but maybe also daunting. Don’t be discouraged if you’re faced with the reality of debt here. Use it as a motivator to help you build a plan around getting out of debt.

If there are accounts that Tiller can't automate you can track the balance manually using the Tiller Money Feeds add-on for Google Sheets or manually add Balance History entries in your Excel workbook.

How to manually track a non-automated account balance in Google Sheets:

  1. Log in to the Tiller Console at https://sheets.tillerhq.com/auth/login

  2. Open your Tiller-powered Google Sheet

  3. Launch the Tiller Money Feeds add-on from the Add-ons (or Extensions) menu

  4. Click "Manual Accounts"

  5. Enter the account details and click "Add Manual Account"

How to manually track a non-automated account balance in Microsoft Excel:

  1. Review this guide for manually tracking non-automated accounts in Microsoft Excel

ℹ️ Resources

Tiller Tip 6: Explore the perfect solution for you

So many personal finance tools and apps out there try to box you into their way of doing things. Tiller gives you the control to understand your money your way. The power of a spreadsheet is its unlimited flexibility and that means endless possibilities.

We recommend the Foundation Template as the default because it’s easy to understand, set up, and use.

But there are many options in the Tiller Community to help you level up your Foundation Template based on your financial goals and needs.

Community-built solutions for Microsoft Excel:

Explore the Microsoft Excel Show & Tell category

Excel Community Favorites:

Category Tracker

Transaction Tracker

Transaction Comparison

Community-built solutions for Google Sheets:

Explore the Google Sheets Show & Tell Category

Google Sheets Community Favorites:

ℹ️ Resources

Tiller Tip 7: Gaining clarity and staying confident

Now that you’ve completed the setup of your Tiller Foundation Template here are the key takeaways for using Tiller to help you gain clarity and stay confident about your financial future.

Stay engaged

Staying engaged is the number one key to achieving your financial goals and dreams. Give it your attention, remember these takeaways, and control of your money is within reach.

Keep the data flowing

You may need to visit the Tiller Console (https://sheets.tillerhq.com/auth/login) to refresh financial institutions so we have the latest available data to pull into your spreadsheet. Don’t forget to click the “Fill” button in the sidebar of the Tiller Money Feeds add-on or add-in to fill that new data into your spreadsheet.

Stay on top of categorizing

Categorize new transactions at least once a week. Do it manually with ease or build your awesome rule set to have AutoCat help out. This is key to gaining clarity about where your money is going and empowers you with the information you need to achieve your financial goals and dreams.

Tune those budget numbers

At the end of the month review your Monthly Budget sheet to check in on which categories were under and over budget. Consider adjusting budget amounts on the Categories sheet accordingly for the new month. Review the cash flow to date amount near the top left of the Monthly Budget sheet to see how you did.

Maintain motivation

Whether you’re a budgeting pro or finally decided to face your money situation, it’s comforting to know you’re not alone. There are others out there in the same situation.

Feeling supported is a big motivator toward achieving your financial goals and dreams. Finding community when you feel lost, confused, triumphant, or just want to share something cool that you built makes all the difference.

The Tiller Community is a vibrant, supportive, and inclusive space to ask questions, share wins, and explore all the possibilities for using Tiller to gain control of your financial life.

Click here to visit the Tiller Community

The Tiller team is here for you too.

If you ever run into issues connecting your bank, understanding how to use the Foundation template, or have a basic Tiller question, you can reach us via the chat tool in the lower right corner of the Tiller Console at https://sheets.tillerhq.com/auth/login

ℹ️ Resources

Did this answer your question?