Supported transaction types
To calculate your taxes accurately, you must import all transactions from Binance Futures to Coinpanda. Coinpanda supports the following transaction types from Binance Futures today:
| Tx Type | API import | CSV file upload |
|---|---|---|
| Realized PnL |  | |
| Trading fees | | |
| Funding payments | | |
| Bonuses and rewards | | |
| Coin swaps | | |
| Insurance clear | | |
| Referral kickback | | |
| Internal Binance transfers | | |
| Cross collateral transfers | | |
| Auto-exchanges | | |
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 Futures 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.
Please note: Earlier in 2022, Binance introduced several limitations to their API so that only futures data from the last three months are available for USD-margined futures. This is, unfortunately, completely out of our control, and we encourage you to contact Binance customer support and request that they remove this limitation. For now, we recommend using file upload as described below instead. COIN-margined futures are not affected by this limitation.
Coinpanda will automatically aggregate all Realized P&L transactions for the same timestamp to a single transaction. All fees and funding payments will be saved as a single daily transaction for each individual settlement currency.
This is done to avoid importing thousands of small transactions of insignificant value often provided by the Binance API. This means that you might see only 100 transactions on Coinpanda instead of 1,000 or 2,000 using another crypto tax platform. The resulting gain/loss will be exactly the same.
You might see one or more Negative balance warnings on the Transactions page. This can happen because Binance allows having negative wallet balances and is, therefore, most likely not due to an error with the API import.
Upload a CSV file to Coinpanda
- Hover over ‘Orders’ in the top header and click ‘Futures Order’
(https://www.binance.com/en/my/orders/futures/openorder) - Click ‘Transaction History’ in the left menu
- Click the ‘Export’ button, select ‘Big Data Download’ and select a date range of up to 1 year
- Click ‘Generate’ and download the file when ready. Make sure to generate files for all years.
- Repeat the previous steps for Coin-margined futures by selecting the ‘COIN-M’ tab
- Upload the CVS files to Coinpanda
