I still can’t get API working.
Tried uploading the csv files but get message “Please upload your trade-history file instead!”.
I thought that’s what I was doing!
Anybody help?
I am using a competitor’s product for margin, export the csv, adjust it to fit Koinly format, import it.
I have created a separate Binance margin account and ensured that there are in/ out matching transactions in the Binance sport and margin wallets.
You still have to do a lot of elbow grease as Koinly does not support seconds in the timestamps and, as a result, the order of some transactions is off.
It doesn’t help that Binance has some duplicate tx either, so those have to be fixed manually.
Honestly, I started thinking of developing a product of my own - no tax sw that works with Canadian tax is perfect. That competitor has other issues as well.
I wish I’ve got the advise above way back - like 2 months ago. I am now almost done.
I hope this helps others. Since Koinly does not even bother to check and reply to the community I will name the other solution - Cointracker - they support margin since recently. As I said, they have other issues though, which is why I didn’t jump the ship.
Cheers
5 Likes
One more thing… You have to download the full tx csv from Binance as well, filter for the distribution stuff (airdrops, etc), the commission history (if you have referrals) and the small tx (dust conversions).
You will then have to convert to Koinly format and import into Koinly.
Be careful at all times, or you will have to redo all steps from the beginning.
1 Like
Can I ask what competitor are you using?
Binance APY import is not useful at all. I’m missing over 3k transactions.
Thanks Krakatu for a solution. I was trying to do the same however never found a competitor that was able to handle it. I will make use of the same solution.
Cheers
Hey Krakatau, did you use the generate csv reports or the api to manage the margin data etc on the Cointracker service. In csv report upload format it seems to not be possible to add margin information as it needs to follow a basic template like shown in this link: Convert any CSV into the CoinTracker CSV format - Setting up your Wallets & Exchanges - CoinTracker Forum.
I will add my api and see if that does the trick and try and upload it into koinly.
I’ve also paid for cryptotaxcalculator.io which also has a similar problem.
My main issue is incorrect final balances, which obviously means either double counting or not counting enough. the issue is all of these piece of software don’t let you accurate match and filter properly, like Xero for accounting.
The other issue that’s clear is that the binance data and format is either wrong or has a lot of issues with syncing via the API.
My issue now is, do I submit something to the tax authorities that i know is incorrect (i have too much balance) but that is roughly right for my trades, or do i wait for fixes in the software?
Not exactly the same issues as you face but I discovered that imports from Binance CSV (ALL) was skipping entries that had different “operations” like “Transaction Related” or “Large OTC trading” entries (in my spot account) and maybe the same happens with the API import.
Perhaps not the same issue but If you haven’t verified those operations from the CSV it may be worth taking a look at.
3 Likes
I have the same issue. Have you solved it somehow?
Any solution to this problem? Koinly is working to solve this? Thanks
Any solution to this problem? Koinly is working to solve this BINANCE CHAIN? Thanks
You most likely need to download and import the CSV files from Binance, manually. Go to Wallet > Transaction History > Generate All Statements. Once downloaded, import it on the wallet page on Koinly.
This was not enough to fix my issues though, I also had to import an XLSX file called “Export Deposit History” which I found in Wallet > Transaction History > Fiat > Deposit.
Koinly doesn’t seem to mention importing this second file but it fixed a lot of missing transaction for me. Now my only issue is some 0.1 USDT is missing. Also, for some reason, Koinly reports that my transaction imports show my balances to be double what they actually are. When I look at my wallet on Koinly, the balances are correct (due to API sync) but each currency has an exclamation point next to them, reporting that my calculated balances are double the value that they actually are.
Koinly is kinda working for me but I am hoping something smoother comes along soon, whether that be a Koinly update, a Binance API update or a competitor. I do not want to add every transaction manually, I would sooner pay a crypto tax expert to go through my statements.
6 Likes
Thanks for detailing your methods.
I find Binance Bridge swaps transactions are missing and need manual transactions to remedy Missing Purchase History warnings.
Did you figure out the solution to the double balance problem as I’m getting the same.
Thank you Louis. Will give this a go. Exporting data from Binance doesn’t seem as straightforward as with Kraken (ref to your comment regarding deposits in to Binance ).
I Imported my Kraken Ledger (all transactions) to Koinly with no errors.
I dream of having a 0.1USDT discrepancy!
It is a nightmare to use Koinly with Binance. If you are doing any sort of staking, then the coins are not reported at all.
1 Like
Hi Jules,
I used Binance API recently. Binance Locked Staking reports interest each day and that interest doesn’t compound, it goes to your spot wallet. So when the API had completely the import, it registered a total of 1400+ transactions most of which are staking transaction to spot wallet!
I’ve only been with Binance since late March 2021!
2 Likes
The only way around this that I have found is to add every trade manually as I go along. It’s a bit of a mission - as Binance can break up one trade into several parts, however it’s the most sure way of keeping it tidy and correct.
1 Like
many problems with binance. using api or csv both lead to multiple problems: mislabeling, missing info, redundancy. it’s useless if it requires a complete check and verify on every single transactions…
1 Like
Yep, I’d second this! My Binance import data is way off. I have around 3000 transactions, including staking. No idea how to fix it and I can’t get any customer support from Koinly. If I’d known this I’d never had paid for a tax report from them! Now I’m stuck with them and can’t do my tax return! Funny not funny…