Skip to main content
All CollectionsTransactionsTroubleshooting
What Should I Do if I See Duplicate Transactions in my Sheet?
What Should I Do if I See Duplicate Transactions in my Sheet?

Learn how to deal with duplicates in your transactions sheet.

Heather Phillips avatar
Written by Heather Phillips
Updated over a week ago

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.

  3. Optionally, remove duplicates manually or using the experimental Tiller Community Solutions add-on Manage Duplicates workflow.

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. Remove the accounts associated with one of the logins from the Tiller Console.

  3. Optionally, remove duplicates manually or using the experimental Tiller Community Solutions add-on Manage Duplicates workflow.

Re-added a Previously Removed Account

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

To fix this issue:

  1. Remove duplicates manually or using the experimental Tiller Community Solutions add-on Manage Duplicates workflow.

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 this issue:

  1. Remove duplicates manually or using the experimental Tiller Community Solutions add-on Manage Duplicates workflow.

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.

Existing duplicates will remain in your sheet even after the data feed issue is addressed by our data provider. You can remove duplicates manually or by using the experimental Tiller Community Solutions add-on Manage Duplicates workflow.

Did this answer your question?