There are a few reasons you may be missing transactions in your Transactions sheet.
Brand New Sheet
If you're just getting started with Tiller it may take several minutes before your financial data appears in the Transactions sheet.
Transactions Refresh Delay
Sometimes if you don't visit your Tiller Console for several days there can be a delay in updating your Transactions sheet. It's best practice to open your Tiller Sheet from the Tiller Console, rather than a bookmarked linked or your Google Drive.
Visiting the Tiller Console initiates a data refresh and will usually pull in the most recent cleared transactions after a few moments.
Lost link to financial account
Sometimes if a linked financial institution goes into an error state it can prevent transactions from automatically filling into your Tiller Sheet.
- Log in to the Tiller Dashboard
- Click Account Summary
- Review your list of linked accounts to see if any indicate errors (red dots).
- If you see errors, update the login for the account to try and re-establish the connection. Note: sometimes you may need to provide the answers to security questions via this "update login" when first getting started with Tiller.
- If an update login does not fix the error state for the linked account, contact support via the chat window in the lower right corner of this page or anywhere on our website or email firstname.lastname@example.org
Accounts are not linked to a sheet
If you've recently added new accounts to the Account Summary, and are expecting to see transactions from those accounts in your Tiller spreadsheet, you'll need to make sure you have linked those accounts to a sheet. Click the sheet name and put a check mark in the box next to the new accounts to start feeding their data into the sheet.
Incorrect transactions sheet name or headers
Transactions sheet name change
The feedbot relies on the Transactions sheet being named "Transactions" in order to automatically populate your financial data.
If you changed the name of the Transactions sheet to something else you'll need to change it back in order to resume the automated data feed.
Header name changes
The feedbot also relies on the Date, Amount and Description columns on the Transactions sheet to be named as such in order to automatically populate the Transactions sheet with your financial data.
If these column headers were changed or missing you'll need to change them back (or add them back) in order to resume the automated data feed.
Filters are turned on
If you have a filter turned on in your Transactions sheet the missing transactions might not be visible.
If none of the above cases apply to your situation, please contact our support team using the chat window in the lower right corner of our website or by email email@example.com and we'll figure out what's going on for you.