The Binance API has multiple limitations that might make it difficult to use. If your Binance API does not report your entire transaction history then you might need to use the CSV files instead.
Bot trading
Binance does not provide any way to import bot trades (strategy account) via API. If you used Binance's bots, you can either:
Switch to a CSV import - the "transaction record" file now includes bot trades
Or import the file "Binance trading bot - Trade History" that can be downloaded from Binance. Note that this file is partly incomplete (doesn't include fees paid)
Missing Rewards/Penalties
Some rewards or penalties may be missing from Binance CSV files. To address this, create a pivot table to calculate the rewards based on historical data. When adding them manually, choose the date that best matches the period the rewards were accrued. This happens due to incomplete CSV exports. Learn more here.
Liquid Swap
Users must download “Liquidity History > Liquidity” from Binance. However, Binance has restricted access to this data for European users (and possibly others). You may need to contact Binance support to retrieve it, as they typically say it’s unavailable, but persistence often works.
Liquidations
If your collateral is liquidated, Binance doesn’t always show the transaction details (e.g., assets sold to repay loans). You can sometimes find these on Binance’s liquidation page and add them manually, but they are often missing from there as well.
Changelog
2025-12-11: Bot trades update
Bot transactions are now available when using CSV to import data (still not available via API - there is no api endpoint to query)