If you see duplicates in your transactions sheet there are a few possible causes and solutions. 

Multiple logins that share accounts

If you have multiple logins connected to the Tiller Console that share one or more accounts, such as a joint checking account with a spouse or business partner, and you have both instances of the account linked to the same Tiller Sheet, this can cause duplicates.

To fix this issue:

  1. Unlink one of the duplicate accounts from the sheet. Click here to learn how to unlink an account.
  2. Alternatively, you can email support@tillerhq.com and ask to have one of the logins removed from the Account Summary on your Tiller Console if you don't really need both connected.

Multiple Online Portals

Some institutions have multiple online banking portals with different usernames and passwords. If you add both logins to your Tiller Console, and link multiple instances of the same account to your sheet, this can cause duplicates. 

To fix this issue: 

  1. Unlink one of the duplicate accounts from the sheet. Click here to learn how to unlink an account.
  2. Alternatively, you can email support@tillerhq.com and ask to have one of the logins removed from the Account Summary on your Tiller Console if you don't really need both connected.

Re-added a Previously Removed Account

If you've removed an account from the Account Summary of your Tiller Console and then re-add the account and link it to a sheet to which it was previously linked you'll see duplicate transactions in that sheet from that account.

To fix:

  1. Delete the duplicated transactions from the sheet after you re-add and re-link it. 

Manual Data Entry

If you manually added transaction data from Mint, Personal Capital or your bank you might have added some that overlapped with the data Tiller was able to automatically pull from your institution. Be sure to check the date range before manually adding data so that you don't introduce duplicates. 

To fix:

  1. Delete the manually added duplicate transactions.

Data provider mistake

Sometimes our data provider will pull in duplicate transactions. This can happen when the transaction was in a pending state and then was later posted. Most of the time duplicates caused by our data provider will resolve on their own (they catch the mistake and fix it pretty quickly - usually within a week).

If you're seeing duplicate transactions for recent transactions (within the last 5 days) for more than two weeks in a row please send us two pairs of transaction IDs that correspond to the duplicates. (i.e the ID for the original and the ID for the corresponding duplicate). 

One set should be from the most recent duplicates (must be within the last 5 days) and the next most recent duplicates.

You can find the Transaction ID in a far right column in your Transaction sheet. You may need to unhide some columns in the sheet by clicking the small arrows that will appear at the top of the Transactions sheet between a missing column letter.

Did this answer your question?