All Collections
Troubleshooting and Guides
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

  1. In Binance head to the Wallet dropdown and select Fiat and Spot.

  2. Click "Deposit Withdraw History".

  3. Next, click "Transaction History".

  4. On the next page, click "Export Transaction Records"

  5. In the pop-up that appears in "Time" choose "Customize" and use the calendar to select the date range for your historical data.
    πŸ’‘ You may have to download multiple files as Binance limits this to 12 months of data per file.

  6. 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.


    ​

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

  8. 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?