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

To get started troubleshooting duplicates, first review the transaction IDs for the duplicates.

You can find the Transaction ID in a column to the right in your Transaction sheet. You may need to unhide some columns in the sheet (usually between columns J and M) by clicking the small arrows at the top where the column letters appear.

If the pairs of duplicates, triplicates, or so on you're seeing have identical transaction IDs these are likely due to a Tiller Money Feeds fill issue. Some duplicates may have been introduced due to a bug that was pushed to Tiller Money Feeds for Google Sheets on Dec 4, 2024 that we fixed on Dec 5, 2024. If they only seem to be occurring around this time (review the Date added column to the far right in your Transactions sheet to see if the duplicates were added on these dates) then you can Use these steps to clean up those duplicates in Google Sheets.

If you're continuing to see identical IDs for duplicates coming into your sheet regularly after filling the sheet or opening the sheet after Auto Fill has run, the issue could be due to ongoing crashes and you should consider turning off Auto Fill and following the recommendations to prevent fill crashes, which introduce the duplicates, in this help article.

If the pairs of duplicates have unique Transaction IDs then the cause is likely due to one of the issues detailed below. Continue to reading to assess the cause for your duplicates and next steps.

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:

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: 

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:

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:

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.