Why sign in to the Community?

  • Submit a question
  • Check your notifications
Sign in to the Community or Sign in to TurboTax and start working on your taxes
New Member
posted Feb 3, 2023 9:11:37 PM

Is there any way with Coinbase Pro API to remove duplicates en masse? All transactions imported for me show as duplicates, with 300 records to scrub manually

I have tried API import twice and both times end with duplicates

0 1 193
1 Replies
Expert Alumni
Feb 6, 2023 9:21:05 AM

Once the transactions have been imported, I do not know of a way to remove duplicates en masse.  If you were to delete the entire import, or just delete the duplicates, the following may assist you in finalizing the crypto section:

 

Depending on the number of transactions you have imported, one solution would be to look at any that have a zero cost or sales amount and enter 1 in both cost and sales boxes.  If both are showing zero you can delete the transaction with the trash can icon.

 

If some have sales amounts but no cost basis and some have basis with no sales amounts, keep track of them, add all the sales amounts together, and all the cost basis amounts together, and combine them into a single transaction outside of the import feature.  After this, delete the entries you combined.  This has worked in the past.

 

Another method would be to request if you do not already have one, Form 8949 from the issuing agency.  Delete all imported transactions, and enter the totals as a single transaction as shown on the 8949.  

 

You may want to attach a pdf copy of the 8949 to your return for verification purposes.

 

The IRS is concerned that you are properly reporting your total capital transactions with their associated cost basis and while individual transactions are important, the totals are the most important.

 

@dednor