Your bank transactions and balances make it into your sheet in two steps: A refresh and an update.
Tiller will automatically refresh most of your account balances and transactions each day. However, based on your activity, bank account security settings, and the refresh health of the institution this may happen more or less frequently.
Tiller can only pull in cleared transaction data. It can take 2-3 days for some transactions to clear at your bank before they are available for refresh.
Even once the transaction clears it can take a day before our data provider, Yodlee, attempts to automatically refresh the data, if automatic refreshes are available for your accounts. Read more below on automatic vs manual refreshes.
Tiller may refresh your loan, mortgages, and insurance accounts (and other low frequency accounts) less frequently. Some loans are known to refresh only twice a month.
Once Yodlee has refreshed the data it is available in our system for updating your sheet. Updates happen automatically for Feed Bot fed spreadsheets. Tiller Money Feeds add-on fed spreadsheets require that you to click "update sheets" or turn on Auto Update for the latest data to make it to your Google Sheets.
With many institutions, Tiller can refresh your bank, card, and investment account data about once a day without your intervention (the refreshes are automatic) and pull that data into your spreadsheets. The logins for these institutions typically don’t have an added layer of security, or our data provider was able to successfully learn the answers to your security questions.
Accounts where you have or are expected to have multi-factor authentication turned on will likely require your regular intervention on the Tiller Console to refresh the data.
How can I tell whether my accounts will automatically refresh?
- Visit the Tiller Console and scroll down to the Account Summary.
- Review the Last Refresh time and Refresh buttons for each institutions.
- Accounts that have a white refresh button and a recent last refresh time are likely ones that refresh automatically.
Any accounts that have a blue refresh button and a last refresh timestamp of greater than 24 hours ago most likely require your intervention (possibly every day or every few days) to re-authorize and pull data. This is likely because you have multi-factor authentication turned on or your bank expects you to have it turned on, even if you don’t.
Once you re-authenticate your accounts from the Tiller Console the account should refresh (you’ll see the gathering your data screen) and upon successful refresh on that page your data is then available for us to pull into your spreadsheets.
What is multi-factor authentication (MFA)?
Multi-factor authentication (MFA) is an added layer of security for accessing your accounts. Often it’s simple security questions like “what is your mother’s maiden name?” It could also be two-factor authentication (2FA), which requires a security code sent from your bank to your email or your phone. Multi-factor authentication is great and it keeps your accounts safe.
Why do I have to re-authenticate so frequently?
The access token or session our data provider makes with the bank may last a day or it may only last a few minutes, but expect the account to disconnect. The access window has expired for that specific code or session. (e.g. when you’re logged in directly to the bank’s website after a minute or so of inactivity the bank site will log you out automatically). The exact timing of the disconnect varies by institution.
You may receive an email when the account disconnects because the disconnect results in an error on our side. You can opt in or out of the automatic error alert emails on the Tiller Console.
How can learn more about the refresh health of my institution?
Sometimes Yodlee has a global outage with a specific institution (check the Institution Outages Dashboard for recent outages and resolution ETAs). Technical errors are not uncommon, but typically resolve on their own in a few days.
What if it times out while it’s gathering data or I get stuck in an endless MFA loop?
Some customers are reporting that they receive timeout errors on the “Gathering data” step or they get stuck in an endless loop of MFA or 2FA questions and cannot successfully refresh.
Please reach out to firstname.lastname@example.org if you’re experiencing this issue.