You will need to create separate wallets on Coinpanda if you have traded futures or used cross/isolated margin trading on Binance. See our respective guides here: Binance Futures, Binance Cross Margin, and Binance Isolated Margin.
Supported transaction types
It is important that you import all transactions from Binance to Coinpanda to calculate your taxes accurately. Coinpanda supports the following transaction types from Binance today:
| Tx Type | API import | CSV file upload |
|---|---|---|
| Spot trades |  | |
| Deposits and withdrawals | | |
| Staking/Airdrops/Rewards/Distributions | | |
| Dust to BNB conversion | | |
| Binance Liquid Swap (BSwap) | | |
| Binance Leveraged Tokens (BLVT) | | |
| Convert History | | |
| Buy/Sell Crypto History (fiat) | | |
| Fiat deposits/withdrawals | | |
| C2C Trades | | |
| Binance Pay (Binance Card) | | |
| Commission rebates + referral kickbacks | | |
| BUSD Auto-Conversion | | |
| Futures trading (realized pnl, funding, fees)* | | |
| Margin trading (Isolated)* | | |
| Margin trading (Cross)* | | |
* You will need to create a separate wallet on Coinpanda to import your futures and margin trades. The same API keys can be used for all wallets.
Import trades automatically with API
We are only requesting view permissions. This does not give us access to your private keys or the ability to move your funds.
To add your Binance account to Coinpanda, follow these steps:
- Go to the Binance API page by hovering over the user icon in the top header and then click ‘API Management’.
(https://www.binance.com/en/my/settings/api-management) - Click on ‘Create Tax Report API’.
- Click ‘Get code’ to receive a verification code to your email address.
- Enter the verification code and your 2FA code if required, then click ‘Submit’.
- Copy the API Key and Secret Key to Coinpanda.
The Binance API has several limitations that are important to be aware of. Please see this list for more information and how to get around this.
Upload a CSV file to Coinpanda
Binance Statements CSV
- Go to the Transaction History page by hovering over ‘Wallet’ in the top header and clicking ‘Transaction History’.
(https://www.binance.com/en/my/wallet/history/deposit-crypto) - Click on ‘Generate all statements’ in the top-right corner.
- Select a custom time period (max range is 3 months).
- Click ‘Generate’ and download the file when ready.
- Repeat the previous two steps until your full trading history is covered.
- Upload the CSV file(s) to Coinpanda.
While the “Statements” CSV file is the recommended option, you can also upload other CSV or XLSX files exported from Binance. Below, we mention some of the most typical files you can export from your Binance Spot wallet.
Trade History
- Go to the Trade History page by hovering over ‘Orders’ in the top header and clicking ‘Spot Order’.
(https://www.binance.com/en/my/orders/exchange/openorder) - Click on ‘Trade History’ in the left menu, and then on the ‘Export’ button (top-right corner).
- Next, click on ‘Beyond 6 months – Custom’ to export a maximum of one year of trade history for each file. Make sure to export files for all years you have traded on Binance.
- Click ‘Generate’ to start the process of creating the file. This process can take anywhere from 15 minutes to 1 hour. You will receive an email notification from Binance when the file is ready to download.
- Upload the CSV file(s) to Coinpanda after downloading.
Note: You can also export trade history for up to a maximum of 6 months by selecting ‘Within 6 months – Custom’ instead. This file will download directly without any waiting time.
P2P Orders
- Go to the P2P order page by hovering over ‘Orders’ in the top header and clicking ‘P2P Order’.
(https://c2c.binance.com/en/fiatOrder) - Select the ‘All Orders’ tab.
- Select ‘Completed’ in the Status dropdown and your desired date range.
- Next, click on the download icon (right side) to download the file.
- Upload the XLSX file to Coinpanda.
Buy Crypto History
- Go to the Buy Crypto History page by hovering over ‘Orders’ in the top header and clicking ‘Buy Crypto History’.
(https://www.binance.com/en/my/wallet/exchange/buysell-history) - Click the ‘Export’ button and select your desired time range. The max range is 3 months which means you will most likely need to export multiple files for all months you have bought/sold crypto on Binance.
- Click on ‘Export’ to download the file.
- Next, select ‘Sell’ in the tab (top-left corner) and repeat the previous steps for your sell history.
- Upload the XLSX file(s) to Coinpanda.
Convert History
- Go to the Convert History page by hovering over ‘Orders’ in the top header and clicking ‘Convert History’.
(https://www.binance.com/en/my/orders/convert/history) - Click the ‘Export’ button and select your desired time range. The max range is 6 months which means you will most likely need to export multiple files for all months you have converted crypto on Binance.
- Click on ‘Export’ to download the file.
- Upload the XLSX file(s) to Coinpanda.
Deposits and Withdrawals
- Go to the Transaction History page by hovering over ‘Wallet’ in the top header and clicking ‘Transaction History’.
(https://www.binance.com/en/my/wallet/history/deposit-crypto) - Click on ‘Export Deposit History’ and select a custom time period (max 3 months).
- Click ‘Export’ to download the file. Make sure to export the deposit history for all months.
- Next, select ‘Withdraw’ in the ‘Type’ dropdown and repeat the previous steps for withdrawals by clicking ‘Export Withdrawal History’.
- Upload the XLSX file(s) to Coinpanda.
Special note for Withdrawals: You will need to check the XLSX file for any withdrawals having zero fees. Withdrawals with zero fees will be imported as Receive, so you should therefore add a withdrawal fee to these transactions in the XLSX file and then remove the fee(s) after the transactions are imported.
Binance limitations
Both the Binance API and file export functionality (web interface) have several limitations which are very important to be aware of.
- Trades made with delisted coins cannot be synced from API. You have essentially two options to get around this if you have traded any delisted coins:
- Select the Start import from: Now option in the modal where you add API keys and upload your historical transactions with CSV/XLSX files instead.
- Add trades with delisted coins using the Coinpanda generic file, or by uploading a CSV/XLSX file from Binance that ONLY contains trades for delisted coins to avoid duplicate transactions with data already imported from API.
- Only dust to BNB conversions from December 1, 2020, can be imported. If you have dust conversions from before this date, please contact Binance customer support and request a CSV file with the complete history since Binance doesn’t allow exporting this from their web interface either.
- Not all reward transactions (distributions, airdrops, bonuses, interest payments, etc) are made available from the API. You will need to go to this page and check if all transactions have been imported to Coinpanda.
- Internal Binance transfers between your Spot, Futures, and Margin wallets can only be imported from the past 6 months. This limitation was introduced by Binance in November 2021. Unfortunately, we don’t have any control over what changes Binance decides to do now or in the future.
We recommend using the Coinpanda generic file whenever you need to import transactions manually.
