Use the table of contents to the right to review troubleshooting tips for common issues and questions for the Tiller Money Feeds add-on and the Tiller Foundation Template for Google Sheets.

If you signed up for Tiller using a Microsoft account you can still use Google Sheets. You do not need to start a new trial/create a new Tiller account. You will need to use a Google account to install the Tiller Money Feeds add-on and host your Google Sheet, but this will be independent from your Tiller account login. If you do not have a Google account you can create one here. If you already have a Google account you can use that account to install Tiller Money Feeds and host your spreadsheets.

If you have multiple Google accounts signed into the browser, we recommend a dedicated browser profile for use with Tiller.

Read more here.

If you're having trouble installing the Tiller Money Feeds add-on we recommend trying again using an incognito browser session.

If the incognito session does not work, please reach out to our support team using the Messenger in the lower right corner of this page.

If the incognito session works the issue was likely due to being signed in to multiple Google accounts in the same browser session. We recommend a dedicated browser profile for use with Tiller. Read more here.

If you're an admin for a Google Workspace domain you'll likely see the option for Individual Install Vs Domain Install when you are installing the Tiller Money Feeds add-on. Choose Individual Install if you want the add-on to only be avaialble for your specific user account. Choose Domain Install if you want the add-on to be accessible to any other account on your domain. Choosing "Domain Install" does not make your unique financial account data or spreadsheets available to other users on your domain.

If you haven't already, click here to install the Tiller Money Feeds add-on from the Google Workspace Marketplace. The Tiller Money Feeds add-on will appear near the bottom of the Extensions menu. Give the menu a few seconds to fully load.

If you signed up for Tiller using a Google account, be sure you used that same account to install the Tiller Money Feeds add-on. If you signed up for Tiller with a Microsoft account you can use any Google account, just make note of what account you used to install Tiller Money Feeds.

Back in your Foundation Template spreadsheet, make sure that the signed in user in the spreadsheet is the same as the one you used to install the add-on. Sometimes if you're signed into more than one Google account in the browser, the spreadsheet gets created in the Google Drive of a different Google account and the add-on is not installed for that account. We recommend a dedicated browser profile for use with Tiller. Read more here.

To fill data into your Google Sheet after the initial fill when you first linked the sheet, you need to click "Fill Available Updates" in the sidebar. The add-on should let you know if there is new data available to fill or if there are accounts that need your attention, which you may need to refresh. You can refresh them on the Console (https://my.tillerhq.com/) or under Connected Accounts in the add-on.

Read more about refreshes

Read more about missing transactions

If you click "Fill Available Updates" and it just seems to fill forever without completing (does not show you how many transactions/balances were added), or you get an "the fill could not be completed" or an "Exceeded maximum execution time" error the add-on has crashed during the fill due to a high volume of accounts connected or complicated dashboards in your sheet.

Note that in Nov 2024 we made some changes to the fill process to try and address these performance issues, but we're still working on that. The changes will allow the fill process to run for longer so the fill could take 5+ minutes if you are trying to fill a lot of data and have complex dashboards.

Sometimes if the fill crashes you may see duplicates in your spreadsheet afterward. If you have Auto Fill enabled, and the fill crashes during that process, you may also notice duplicates have been added to your spreadsheet. If you're consistently seeing duplicates we recommend turning off the Auto Fill and use these steps to clean up these duplicates.

To prevent the fill from crashing try these steps:

If you're seeing duplicates transactions in your Google Sheet with identical Transaction IDs you can use these steps to clean up those duplicates.

Note: this workflow will not address duplicates that came in where the original transaction was split and possibly will remove the version of the transaction with your customizations (e.g. category, modified description, etc)

If you don't have the Transaction ID column in your spreadsheet these steps won't work for you and you'll need to either manually remove the duplicates or restore your spreadsheet to a prior version before the duplicates were introduced and fill from that point.

This error happens when the word "Date" is missing in row 1 for the Date column in the Transactions sheet. Add the word "Date" back to row 1 in the date column and then click the "reload" link in the warning message.

You're getting the following error: ⚠ This spreadsheet does not contain a Transactions sheet. Tiller Money Feeds will create this sheet when updating feeds.

This means your Transactions sheet was either accidentally deleted or you renamed it. The add-on expects the Transactions sheet (tab) to be named "Transactions" (without the quotes). If you renamed the Transactions sheet tab, you'll need to rename it back to Transactions in order for the add-on to continue filling your original Transactions sheet and not create a new one.

If you accidentally deleted your Transactions sheet you can restore to a previous version where of the Google Sheet using the version history features under the File menu.

Sorry, but it looks like this Google Sheet is already being updated by the Tiller Feed Bot.

Feed Bot sheets cannot be connected to the Tiller Money Feeds add-on. Learn more about transitioning to Tiller Money Feeds.

There are a few common update failed errors you might get during the update process (after you click "Fill sheets") if something goes wrong in your sheet.

Failed to update Transactions with Error: Exception: The data validation rule argument "=Statements!$N$3:$N" is invalid

This error is usually due to having a Statement column in the Transactions sheet, but the Statements sheet was removed. You can fix this issue by deleting the Statement column in the Transactions sheet and re-running the update.

Note: if you see a different "argument" that does not reference "Statements" in this error there is a data validation rule in a cell/column on your Transactions sheet that is no longer valid. This means that the sheet referenced in the error (in the example above, Statements) no longer exists in your Google Sheet. To correct this, find the column with an invalid data validation rule and remove it. You can tell a column has an invalid rule by clicking the dropdown in a cell and see an empty list that just presents the word "loading...".

Usually this means there is a conflict between the default Google user signed in to the browser and the Google account you're trying to use to launch/sign in to the add-on.

Click here for steps on how to fix it.

You might see the following errors/messages in this situation.

We recommend using Tiller in a dedicated Google Chrome browser profile where only the Tiller subscribed email is signed in to prevent these types of account authentication conflicts. You can also review other options to fix the issue below.

See: what to do if none of these steps help.

⚠️ Be sure you know the passwords to all Google accounts signed in when you get to step 3 below before proceeding to step 4 if you will need to sign back in to those accounts.

You can then sign in to other Google accounts in the browser and this won't interfere with your use of Tiller.

If you already have a browser profile for this Google user, sign out of other Google accounts in the profile and only use your Tiller subscribed Google account or set your Tiller-subscribed Google account as the default.

You're trying to launch the add-on from the Document add-ons sidebar (Extensions > Add-ons > Document add-ons) by clicking "use" and you get a permission denied error or you just see the "working" message at the bottom and nothing happens.

To fix:

This issue is usually due to being signed in to multiple Google accounts in the browser.

We recommend a dedicated Google Chrome profile for use with Tiller that isn't signed in to other Google accounts.

Sometimes if you insert a row into the Categories sheet or accidentally edit the default rows this can break the "cascading budgets" feature. You can read more about this feature and how to reset it here.

The monthly budget columns on the Categories sheet are where you set budget amounts. Review the Yearly Budget tab for actuals per month or install the Monthly Analysis sheet from the Tiller Community Solutions add-on for more granular monthly tracking insights.

If you’re not seeing budget or actual amounts on your Monthly Budget or Yearly dashboards for any category double check that you’ve entered budgets on the Categories sheet starting in Column E.

If you’ve entered budgets into Column E, double check your headers (row 1) in the Categories and Transactions sheets. If these header keywords are missing the dashboards’ formulas can’t find the correct columns in the referenced sheets to pull the data in.

Categories sheet required headers:

Transactions sheet required headers:

Make sure that you're only using Income, Expense, and Transfer for the Type in the Categories sheet. These are the only supported Category Types. If you've modified the category Types to something other than Income, Expense, and Transfer you'll need to revert those changes back the defaults.

Make sure your budget month headers after the first month are formulas rather than static text. If your second budget month is in column F the formula in the header for that column (row 1) should be =eomonth(E1,0)+1

If you inserted columns into your Categories sheet this can also break other dashboards "downstream" of the Categories sheet. You may need to remove the extra columns or restore your sheet to a previous version before you made the edit.

If all the headers are still correct, or you're just seeing missing amounts for some categories, try reformatting your Amount column in the Transactions sheet as currency $.

Most often these errors appear because a direct edit was made to the dashboard (e.g. you tried to set the budget amounts in the budget column directly in the dashboard). You can easily correct these errors by clearing the contents of the cell referenced in the error. For example, in the screenshot below the the error indicates there is text in cell F20 that is preventing the formula from expanding that displays the data. After clearing the manual entry in F20 the error should go away and the dashboard should resume working.

If that doesn't help, you can try restoring the dashboard using the Tiller Money Feeds add-on under Tiller Solutions > Add & Manage Templates in the sidebar.

If you notice that your budget dashboard seems broken and you get the following error double check that the "Hide from Reports" column still exists on your Categories sheet. You may also see a "No matches are found in FILTER evaluation" error if you have renamed the Categories sheet. Be sure it's spelled correctly "Categories"

Sometimes this happens when you restore the Accounts sheet using the Tiller Money Feeds add-on. The best way to fix it is to restore the Insights sheet using the Tiller Money Feeds add-on.

If that doesn't fix your Insights sheet reach out to support@tillerhq.com to let us know or via the chat tool in the bottom right corner of this page.

Sometimes the data validation (dropdown menu) breaks in the Transaction sheet when you insert a row at the bottom of the Categories sheet. You can use this guide to help you reset it.

Accounts sheet in Google Sheets Account column dropdown is showing an error that says "Invalid: Input must fall within specified range"

This error indicates that the value in the cell is not in the list that's generating the options for the dropdown.

This can happen if you rename accounts on the Tiller Console after you have already filled data for the accounts into the spreadsheet and selected those Accounts on the Accounts sheet. Read more here.

If you're not seeing accounts and balances on the Balances sheet try restoring the Accounts and Balances sheet.

The archive of the Accounts sheet will have any customizations you've made to account groups and class overrides. You can copy/paste these from the Archived Accounts sheet to the new Accounts sheet. If you haven't made any customizations to the Accounts sheet you can choose "Overwrite Existing" in step 5.

Repeat the same steps for the Balances sheet except you don't need to Archive before restoring.

You may get this message if you try to run the Tiller Budget (via the Tiller add-on) setup process in the Foundation Template. These budgets are not compatible with each other.

Read a more comprehensive comparison of the two budgets over on the Tiller Community here.

You might also get a spreadsheet not compatible message in the Tiller Money Feeds add-on, specifically about the Transactions sheet, if you have accidentally deleted the word "Date" in the Transactions sheet. You can simply re-type the word "Date" into the header row and reload the Tiller Money Feeds add-on to fix this issue.

Finally, some community solutions are not compatible with certain versions of sheets You may notice that some solutions are listed in the Incompatible solutions section of the Tiller Community Solutions add-on when trying to Add a Solution.

Learn more about incompatible solutions in the Community Solutions add-on.

The red triangles in the upper right of the category cell on the Transactions sheet with the error "invalid: data must fall within specified range" indicate that the category, as it's displayed in the cell on your Transactions sheet is no longer in the list on the Categories sheet OR the range for the data validation rule has been altered so it falls outside the list's range.

Read more about how to fix it here.

We're seeing this issue when there is text or improperly formatted currency in the Amount column in the Transactions sheet.

To fix: