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.

Aggregator Mistake 

Sometimes, though rarely, our aggregator will pull in duplicates for transactions. 

To fix this issue:

  1. Contact support via the chat window on our website or email us at support@tillerhq.com and we'll work with our aggregator to resolve. 
  2. Send us the transaction IDs (usually a column on the far right side of the transactions sheet) that correspond to one pair of duplicates in your sheet. 

Did this answer your question?