How to get Binance.us crypto API tax to upload properly?

I also for the past few weeks have been unable to get turbotax to accept my tax API key from Binance.US. I have tried deleting and creating new API keys several times and none of them go. I am wondering if there is a limit to the number of trades/transactions that turbotax can accept and upload... I have over 70,000. I don't feel I should have to pay $1000 to places like cointracker or koinly to calculate profit numbers for me to put into turbotax. I have also downloaded my .CSV file directly from binance.us to import to turbotax that way but none of the column titles match up so turbotax won't accept the .CSV file. So frustrating. Help please. Thanks.

We have more than 10000 transactions so this was the reason we weren't able to import. TurboTax for some reason can only do 10000 or less which doesn't work for us 😞

this worked for me, thanks for the work around

(deleted)

TaxBit is not working smoothly for me. At first, it wanted me to upgrade to a basic plan. Then, I went back a 3rd time and suddenly I had export capability. Then, after selecting turbotax online CSV, I clicked download and got a 14 page .pdf doc filled with explanations...not happy with Binance. My Robinhood account had seamless integration.

It may be that you could enter summary totals if you are unable to import your file.  The information is here for you and if you have a .CSV file you could sort it to have short term sales together and long term sales together.  You may already know the difference but the information is placed here for convenience.

• Long term is a holding period of more than one year and receives capital gain tax treatment (0%, 10%, 15%, 20% depending on your regular rate of tax)
• Short term is a holding period of one year or less and receives ordinary gain tax treatment (your regular rate)

The steps to enter a summary of your sales transactions is provided below.

1. Open or continue your return (if it's not already open) and search (upper right) for the phrase stock sales > Press enter
2. Select Jump to stock sales > Click on Add investments > Continue on the 'Get ready to be impressed' screen (TurboTax Online) > Continue
3. Select Enter a different way > Select Stocks, Bonds, Mutual Funds, et, > Continue 
4. Enter your financial agency information > Continue 
5. Answer the questions asked > Continue to Now, Choose how to enter your sales
6. Select Sales section totals > Review the information on the next screen > select Continue.
7. You'll now be able to enter the total proceeds (sales) and cost basis, along with the sales category (Long or Short term, covered or noncovered). 
8. Refer to your 1099-B for the amounts and category. When finished, select Continue.
9. When you are done, you will see  Now we'll help you upload your 1099-B…. (or transaction details) either must be in pdf format (you can skip and return later to upload your pdf if you create one)
10. Next, select how you plan to submit your 1099-B > Continue       
11. You will return to Your investments and savings list for review or edit > Confirm at the bottom
12. Here's a summary of your broker sales screen where you can edit, delete, or enter more sales.

If you are e-filing your tax return, then mail your statements (1099-Bs or other document showing detailed sales information) along with Form 8453 to: 

Internal Revenue Service

Attn: Shipping and Receiving, 0254 

Receipt and Control Branch 

Austin, TX 73344-0254

If you need a blank Form 8453, you can download this pdf, enter your address information and check the box for Form 8949 (this form is really just a cover sheet)

• How many stock transactions can TurboTax handle?

@lakeviewlivin 

You may be able to upload a .csv file from your provider.  I was be able to upload a .csv file by following these steps: 

• Go to Federal / Wages & Income / Your income / Investments and Savings.
• Click Start / Revisit to the right of Stocks, Cryptocurrency, Mutual Funds, Bonds, Other.
• Click Add investments.
• At the screen Relax. We got it, click Continue.
• At the screen Let’s import your tax info, click Enter a different way.
• At the screen OK, let’s start with one investment type, select Cryptocurrency.  Click Continue.
• At the screen Select your crypto experience, select Upload.  Click Continue.
• At the screen What’s the name of the crypto service, select Other, the name of the service, and click Gain/Loss or 1099-B.
• Click Continue.
• At the screen Go ahead and upload your crypto CSV file, upload the file.

The .csv should follow this format.

• All the columns from the .csv file were deleted except for the five columns listed below.   
• All other lines other than the headings and the five columns of data were deleted.

•    Purchase Date
•    Date Sold
•    Proceeds
•    Cost Basis
•    Currency Name

.csv file format.

           A                   B              C                  D                   E

purchase date  date sold    proceeds   cost basis   currency name

11/24/2021        2/1/2022    1,779.96     1,916.52         ABFOA

12/7/2021          4/1/2022    1,111.46     1,225.45         ABFOA

11/24/2021        3/1/2022    1,638.54     1,638.54         ABFOA

@aowens93