While CoinLedger automatically detects and filters out most duplicate transactions before they can be imported, some may slip through the cracks depending on the method you are using to import transactions into your account. This can be problematic, since duplicate transactions may lead to missing cost basis warnings and other inaccuracies with your tax report and portfolio tracking calculations. Read below to learn the scenarios where duplicate transactions might occur and how you can remove them from your account!

A telltale sign that you have duplicate transactions on your account is the presence of transactions which share the same exact timestamp, assets and amounts. For example, as shown below I can see two sets of transactions on Coinbase which are duplicated. The assets, amounts of assets and even the timestamp for each set of transactions are the same.

Another way to spot duplicate transactions on your account is to look at the Missing Cost Basis Troubleshooting tab on your account. The Missing Cost Basis Troubleshooting Tab is a dynamic summary of all missing data on your account with specific suggestions on how to resolve your missing basis warnings. It appears anytime you have a MCB warning on your account, and can be accessed from the Transactions stage of the CoinLedger app.

If you have duplicate wallet or file imports anywhere on your account, those will be flagged as a potential cause of your missing cost basis warnings on the Troubleshooting Tab. See the example below:

In this example, CoinLedger is warning me that I have a duplicate ETH address imported in my account - and it's also warning me that I imported the same CSV file from Coinbase twice. To open the source of the duplicate data and remove the problematic imports, I would click directly on the underlined account within the warning card, as shown below. There, I can manage or delete my duplicate imports.

Below are some common causes of duplicate transactions and instructions on how to resolve them.

Importing the same wallet address multiple times can cause duplicate transactions. To resolve this, first identify the wallet address that was imported multiple times. You can do this by using the Missing Cost Basis Troubleshooting tab on your account.

If an address has been imported multiple times, you’ll need to keep one of the imports and delete the rest. You can delete any unwanted wallet address from your imports by following this process:

Step 1

First, head to the account containing the address(es) you'd like to delete. You can jump there directly from one of the warning cards shown on the Missing Cost Basis Troubleshooting Tab.

Then, press the drop-down carrot icon next to the icon which states how many wallet addresses you have connected for that account (the number will vary across each account, but it will say XXX NUMBER of addresses connected). After that, press Disconnect.

Step 2

Here, you'll see a list of all the imported addresses for this account. If you see any wallet addresses listed multiple times on this pop-up menu, this is likely the source of your duplicate transactions. Choose one one of the addresses to keep, and then delete the other. Check the box next to the address(es) you'd like to delete, and then press the Disconnect button to fully delete that address.

Step 3

If you clicked on the Disconnect button in Step 1 but don’t see any duplicate wallet addresses on your list of imports, it’s possible that you imported the same wallet address into two separate accounts in CoinLedger.

For example, according to the MCB Troubleshooting Tab in my account, I imported the same ETH address in my Ethereum #2 and Ethereum #6 accounts.

To resolve this, I would simply delete one of these accounts while keeping the other, as shown below:

Another cause of duplicate imports is combining a file import and API import for the same exchange. For example, if I imported my Coinbase transactions via CSV and API, there’s a high likelihood that duplicate transactions will be imported. This is because, while our system is able to filter out duplicates when importing via just CSV file or just API, it is not built to detect duplicates when combining the two.

To resolve this, follow these steps:

Step 1

Locate the exchange where duplicate transactions have been imported.

Step 2

Click the clock icon in the top right corner to open up the Import History modal.

Step 3

On this menu you’ll see all of the imports you’ve made for this exchange. We recommend deleting either the file import or the API import and then keeping the other. You can delete an import by clicking the trash icon and then confirming the action by clicking Delete one more time.

Have any questions? Our support team would be happy to help :)