How to import data via Binance API key or CSV file?

How do I get my Binance API key?

API is the initially preferred method of integration.

If necessary, additional CSV files can be uploaded afterwards. When uploading CSV files, make sure to avoid transaction duplicates. More information on this can be found under CSV file upload.

  1. Log into your Binance account.
  2. Select API Management in the main navigation.

  3. Then click on Create Tax Report API.


    Please note that only one Tax Report API key can be created. If you want to create a new one, you must first delete the existing API key and then edit the API key of your existing integration.

  4. Now enter your verification code (2FA) and confirm with Send.
  5. Leave all API restrictions (permissions) set to Enable Reading enabled by default.



  6. Copy your API key and your Secret.
    Your Secret is now shown only once and available to copy!
  7. To import your data, you must first create an Integration in the Blockpit Web App.
    To do so, click + Integration in the upper navigation.
  8. Select Binance from the list of exchanges, and then copy the API key and the secret into the designated fields. Confirm your entries by clicking Create.

Important

If you still use an old standard API and not the new Tax Report API, you can simply create one according to the instructions above. Then copy the new API key and the secret into your existing Blockpit Integration. How this works exactly, you can read here.

 

Tip: If you are unable to create an Integration without "Mismatched Balances" using an initial API integration and additional CSV uploads, try creating a CSV Integration first and then convert your Integration into an API Integration afterwards. In addition, use a current import status date (e.g. import time span: today's date) as a separator to avoid transaction duplicates.

> How do I convert a Manual/CSV integration into a Synced Exchange/Wallet integration?
> Set a Start Date for your integration (Import Time Span)

 

 

Which data can be imported via Binance API?

Your complete transaction history always serves as the basis for your tax report. Preferably, automatic API solutions are used to import your transactions. Our team is committed to implementing all API data provided by your exchange for you.

Using the following list, you can identify all products that are implemented:

Transactions:

icon-clock.svg Due to the large product scope and limitations of the Binance API, there may be a delay of several hours or days in synchronizing your data.

icon-clock.svg  Spot Market Trades older than 720 days (2 years) are not available via API and have to be imported manually or via XLS template.

icon-clock.svg USD-M Futures transactions older than 3 months are not available via API and have to be imported manually or via XLS template.

Supported

check.png Crypto Deposits & Withdrawals
check.png Fiat Deposits & Withdrawals
check.png Fee Payments
check.png Spot Market Trades
check.png Leveraged Token Trades
check.png Futures Trades P&L (Profit, Loss, Fee, Funding)
check.png Buy Crypto (via Card/SEPA/etc.) (Fiat deposits must be added manually using the label "Non-Taxable In")
check.png Direct Conversion
check.png Dust to BNB Conversions (partially available)
check.png Margin Trades & Loans (Cross & Isolated) (Loans & Repays imported as Unlabeled Deposit and Unlabeled Withdrawal - Label "Non-Taxable" applicable.)
check.png Earn: Rewards & Distribution (Simple Earn, Locked Staking, Launchpad Claims, Launchpool, BNB Vault, etc.)  (Locked Staking Rewards only available starting from 05.05.2021 via API - In addition, the x.png products listed below are not fully available).
check.png
ETH/BETH Staking (Locked) (For internal transfers from ETH into BETH staking, a Trade can be created manually to resolve mismatched balance tips).

In case of missing transactions, you can identify them in the history of your exchange and help our support team via ticket to include them in our import spectrum.

Not Supported

x.png Auto-Invest
x.png Dual-Invest (Withdrawals on subscription date must be created manually.)
x.png
Liquid Swaps
x.png
Liquidity Farming
x.png Binance Pool Mining
x.png BNSOL - APR Boost Airdrop Reward Claims
x.png Binance Card/Pay/Gift
x.png Referral Bounties
x.png Trading Bots 
x.png Block Trading
x.png OTC Trades (P2P)
x.png Crypto Loans
x.png Auto-Conversions
x.png NFTs

Caution

Binance does not provide data for delisted assets and trading pairs via API.

Missing transactions can be found by comparing the actual history of your exchange. You can then add these directly to your Blockpit Integration by subsequently uploading your CSV file (see below) or by migrating your CSV data to our Blockpit Excel Template.

How do I get my Binance CSV file?

  • The following steps will help you to download your Binance CSV file and import it into your Blockpit Integration:

    1. Log into your Binance account.
    2. Select Transaction History in the main navigation.



    3. Then click on the icon shown below and select Export Transaction Records.



    4. Then select Customize to enter the relevant transaction periods (preferably whole tax years from 01.01 to 31.12).



    5. As soon as the file has been generated by Binance, you can download it. We also recommend naming the file after the corresponding transaction period. (Example: Binance history 2020-01-01 - 2020-12-31)
    6. You can now upload the file to your Blockpit Integration in the Dashboard. To do this, click on Edit / Upload CSV in the Integrations tab as shown below.





    7. Now drag the corresponding file(s) into the field displayed below and confirm your entry with Save to upload your transactions.


      When uploading your transactions into your Binance Integration, the system does not check for transaction duplicates.
      Transactions that already exist in your Integration must therefore be removed from the CSV file before uploading.

 

Synced Balance:

Supported

check.png All Account Balances

Mismatched

question.png Launchpool
question.png Liquid Swap Shares

If your assets are not locked in the Spot Wallet, but in the Launchpool, they will not be displayed in their entirety in the Synced Balance of your Blockpit integration (until reflow). However, this has no effect on the tax report, as no outflows (transactions) happen internally in your Binance Integration.

If your Synced Balance is displayed incompletely, you can help our support team via ticket to include it in our import spectrum (if technically possible).

> What is the difference between Synced/Manual Integrations and Synced/Calculated Balance?

> Which assets does Blockpit support & Why is the value of some assets not displayed in the Dashboard?

 

How do I solve problems with my Binance Integration?

 

Will Binance automatically deduct the tax for me?

Was this article helpful?