- Why am I missing some transactions when using the Binance API?
- How do I get all my transactions imported from Binance?
- Do I need to upload the CSV files I received from Binance specifically?
If you have ever had any of these questions, you are in the right place. In this article, we will teach you how the Binance API and CSV import works. By doing so, you’ll learn how to import all your transactions from Binance.
Before we get too far into this article id like to point out that we made the Binance import for Binance.com and not Binance.us. Because of this, there might be some things that we don’t support for Binance.us. We will try to point out some of those things when we come across them in this article.
To get all the data available to us from Binance, we need to use over one importing method. This is because Binance doesn’t support all transaction types using the API. To fix the problems, we need to use both the API and the CSV importing methods. We will go over how to use both, but start with the API in the next section.
Import Transactions Using The Binance API
As always, using an API connection is the easiest way to import your transactions. Binance is no exception. This is because, once connected, it’s all done automatically. Unfortunately, using the Binance API isn’t as simple as it should be. There are limitations to the API provided by Binance. Those limitations prevent ACCOINTING.com from importing certain types of transactions automatically. The following are the kinds of transactions that are currently known to be unavailable using this method.
- Any transactions involving fiat currency (buys/sells, balances, or deposits/withdraws)
- Transactions involving margin that are older than 6 months
While there is no margin trading on Binance.us, it is currently unknown if they include transactions involving fiat in their API.
If you have any missing transactions, you can import them in a couple of different ways. We can do it automatically using the Binance provided CSV export files or manually using the ACCOINTING.com provided template. Later in this article, we will go over how to do the former.
Connecting The API
To connect to the Binance API, you must first create an API key pair on Binance. The processes are the same on both Binance.com and Binance.us. You can go here to learn how to do so. Once you have your key pair, enter the public and secret keys into the corresponding fields located here. The video below shows what this process would look like.
Now that we connected our API, we can now move on to the next section.
Import Transactions Using The Binance CSV Files
In this section, we will go over importing your Binance transactions via file import. Even though we must use this type of import to add missing transactions, it too has limitations. The following issues may change in the future, but are things you need to be aware of currently.
- You can only export your data three times per month.
- The maximum amount of data you can export at a time is three months.
- It could take anywhere from an hour to days to export your data.
- Can cause duplicate transactions on ACCOINTING.com that we must resolve manually.
- The exported data file can be intentionally or unintentionally changed proper to upload.
Binance separates transactions into different history files depending on their type. Binance.com and Binance.us both provide different history export files. We must download these Binance files individually to import the transactions properly. Once downloaded, we can then upload them on the “Files” tab located here. While ACCOINTING.com is working on supporting more types of export files, the rest of this section will cover the ones currently supported.
Even though the video below shows Binance.com in the address bar, it shows how to export your trading history from Binance.us.
This process has changed when using Binance.com. To get this file from Binance.com, you need to go to the “Buy Crypto History” section located here and click on the export button shown in the image below.
Fiat Deposit History
Binance.com provides this file and is not available on Binance.us. To download this file, go to the “Transaction History” section, and click on “Fiat”. That should bring you here. Press “Export Deposit History” on the right to select a timeframe and begin the download. The image below shows where this export button is located.
Fiat Withdrawal History
Binance.com also provided this file and is not available on Binance.us. To download this file, go to the “Transaction History” section, click on “Fiat”, then select “Withdraw” in the Type drop-down. That should bring you here. Press “Export Deposit History” on the right to select a timeframe and begin the download. The image below shows where this export button is located.
Now that we have connected our API and uploaded our CSV files, we’re done importing our transactions. Any transaction that is not present would need to be added manually.
We’d like to thank you for choosing ACCOINTING.com as your crypto portfolio tracker. As you may already know, creating an account to track your portfolio is always FREE. But if you would like to use us to generate tax reports as well, and haven’t done so already, select a tax plan to get started.
Want to receive new article notifications?
Subscribe using the form below to receive email notifications when new articles are published.
Can’t find what you’re looking for?
We’re sorry you weren’t able to get the help you needed. If you visit our community forums, you might find the answers you’re looking for. Or if your issue is more private, send us an email at firstname.lastname@example.org.
Also, if something is missing from this article, let us know. Providing your feedback lets us know what improvements we can make to the articles to better help the community. You may do so using the form below.