Skip to main content
All CollectionsGuides
How to use our Binance CSV statement manager without duplicating existing data
How to use our Binance CSV statement manager without duplicating existing data

Can you use the Binance CSV upload for missing transactions after adding transactions manually?

Sam Adams avatar
Written by Sam Adams
Updated over a week ago

If you had previously been using our manual upload workaround to add missing Binance data, jumping headfirst straight into the new Statement Manager feature could duplicate transactions and make your balance incorrect. There are two ways for you to proceed...
​

Option 1 - Delete all of your manually added, missing Binance transactions and re-upload using the Binance Statement Manager

Harsh, but the most effective way to ensure there is no data duplication so this is our recommended approach. Follow the steps below to delete all of your manually added transactions and then re-upload them and keep your account updated with future transactions via the new Statement Manager feature.

Step 1 - Deleting Manually Added Missing Binance Transactions

  1. Head to Activity and filter by Account: Binance and Status: Manually Entered.

  2. Click each transaction and select "Edit", then "Delete".
    ​

Step 2 - Adding Missing Transactions via the Statement Manager

Log into your Binance account and follow these steps:

  1. Navigate to the "Transaction History" icon dropdown menu.

  2. Click "Crypto Transaction History".

  3. Head to the "Export" icon at the top right of the screen.

  4. Click "Export Transaction Records".

  5. In the pop-up that appears select a time range by first clicking the dropdown menu below "Time (OTC +0)" and then selecting "Customized".

    You may have to download multiple files as Binance can take a long time to generate your CSV file. If you have many transactions perhaps download a different CSV file for each 3 or 6-month period?

  6. Make sure that the "Account" and "Coin" fields are both set to "All".

  7. Click the "Generate" button. You'll notice your request appear in the submission list - when your data is ready you will be sent an email containing a link to download it.

πŸ’‘ Binance are also restrictive with the number of files you can download, so you may be unable to complete this process in one session. Be sure to leave yourself plenty of time when filing your tax return!
​

8. Back in Recap, go to the Accounts page and hover the settings cog on your Binance account, then click "Manage Statements".
​

9. Click "Browse" to locate your CSV and then click "Import". The modal will close taking you back to Accounts where you will see your data is loading; this may take some time depending on how many transactions you need to add.
​

Step 3 - Keeping your Account Updated

To keep your account updated with future transactions repeat Step 2, changing the customized date range. It is entirely up to you how often you choose to update your account. We recommend generating one Binance CSV per calendar month so there is less confusion over the date range and therefore less chance of overlap and incorrect (duplicate) data. If you use Recap regularly and want to keep your account more up to date you may find smaller date ranges added more frequently work better for you.

πŸ’‘ Name your CSV's appropriately. If you import a new CSV that shares the name as an existing CSV, Recap assumes it is a copy and automatically deletes the old file and replaces it with the new one.
​

Option 2 - Keep your manually added transactions and adopt the Binance Statement Manager moving forward

We do not recommend this approach, however, we understand that you may not want to delete all of the transactions you have spent time adding manually.

Follow Steps 2 and 3 above to generate your statements in Binance and upload them to Recap. You must not upload historical transactions that you have already accounted for manually as this will create duplicates, so be mindful when selecting the date range for your first Binance statement export. Essentially, your start date should be after your final manually added transaction.
​
​Update 12.08.2021
Binance have updated their API to include fiat deposits and withdrawals, so please now delete any of these transactions that you have added manually otherwise they will be duplicated.

At this time, you do not need to delete manually added transactions for Referral Commission, OTC trades (Conversions), Leveraged tokens redemptions and Dust exchanges.
​
If you need any more help or have any questions contact us via in-app support.

Did this answer your question?