3
Coinbase Advanced Trading - Missing balance on Koinly
complete
d
d
I have a Coinbase API connection to Koinly. It normally works fine. After 2 months of inactivity I made some BTC and GRT trades on Coinbase Advanced trading, and synced my Koinly Wallet. After syncing the recent trades appear in Koinly in my CB wallet. But not on the Koinly dashboard - the balances do not reflect the recent trades. I've tried logging out and clearing my browser cache but the dashboard is still not registering the recent trades.
Koinly has flagged my CB wallet with a yellow exclamation bubble saying 'your calculated balance is different to what the API has reported', and the Koinly pop-up correctly lists the differences. This is kind of helpful, as it indicates Koinly's 'calculated balance' is higher and the API's 'reported balance' is lower. Buuuuut the only place Koinly could have learnt about that higher calculated balance is from... the API connection. I'm not uploading any CSV files or manual transactions. Confusing and Frustrating. Help appreciated.
Safari Version 16.2 (16614.3.7.1.7, 16614)
ps the Koinly pop-up showing the balance differences has a 'learn more' link which points to the wrong help doc:
I'm guessing the link should actually point to this:
Activity Feed
Sort by
This post was marked as
complete
d
d
This is still not fixed. Synced Coinbase wallet on Koinly, refreshed page. Exactly the same problems. No change.
I'm researching other tax software. If Koinly can't get correct balances for BTC on Coinbase - biggest crypto, major exhange - then I can't trust the service or the tax reports.
P
Petur
d:
Hi d,
The issue described in the ticket was related to the way that advanced trades were being synced, since the software would sometimes only import the partial trade.
It sounds like you are also having issues with the synced balances that Coinbase is reporting.
An earlier response that you mention from our support team accurately explains that issue:
The Coinbase API provides balances that Koinly will sync. Koinly has no say in what information Coinbase chooses to share or how these balances are reported. Unfortunately, Coinbase will only report the "available" balances, which means that any balances that are being held for your open orders will be excluded. This is something that we have no way of changing since it is a limitation on Coinbase's side. We do however monitor the API for any updates and as soon as Coinbase adds the ability to query the complete balances, Koinly will support it.
In the meantime, there is a setting that can be used to ignore these discrepancies. To enable this, just click on your Coinbase wallet and click on the 'Auto Sync enabled' banner. Here you should see a toggle called 'ignore reported balances'. Turning this option on will tell Koinly to ignore the balance that Coinbase is reported (since it is wrong) and only rely on the balances that Koinly has calculated (which is correct).
I hope this helps! Let me know if you have any further issues with your CB wallet :)
d
d
Petur: Well the issues described in my ticket are still occurring, so I can't agree that it's fixed.
What I see: if a stop limit order is opened on Coinbase Advanced Trading, then Koinly shows the incorrect balance and shows a yellow calculated/reported balance flag. If I cancel the stop limit order Koinly synchs the correct balance and the yellow flag is gone.
I've been talking with Tami about this. Apparently there is a private Canny link which covers the same issue. I can't access this but presumably you can.
By the way I've tested this on Cointracker and Cryptotaxcalculator. This issue does not repeat. Whatever API data they get from Coinbase Advanced Trading does not prevent them from showing the correct balance. The balances for fiat and crypto are accurate and match Coinbase even if stop limit orders are set.
The problem I've described is particular to Koinly.
P
Petur
d: Hi d,
Thank you for the additional info!
It's interesting that other platforms are showing the correct balances. My guess is that they are not using the "reported" balances and instead are only showing the "calculated" balances.
This would be equivalent to toggling the setting called "ignore reported balances", that I mentioned in my last message.
I have also instructed the dev team to have a better look into this to see if there's a hacky way to figure out the balances, even if Coinbase doesn't report them correctly. They will get back to us shortly :)
P
Petur
in progress
d
d
Petur: Many thanks Petur. This separate post looks like it could be the same issue in case you want to merge.
d
d
GBP balances on Coinbase also have a calculated/reported conflict. Not minor amounts either. Hope this is being addressed too.
d
d
Good work by Koinly, BTC and GRT balances looking more accurate - will keep checking as I trade. GBP balances still showing a reported/calculated flag though - really hope this gets fixed for good. Coinbase must be providing some weird API data to confuse Koinly... as the calculated and reported balances both ultimately come from the API source...no CSV user input here at all.
d
d
Update: I've just set a stop loss limit order on Coinbase advanced trading and the big GRT reported/calculated flag has returned on Koinly for exactly the amount set on the order. So a stop loss limit order is still looking like a potential trigger for API confusion. So not fixed yet.
d
d
Wanted to test this some more: As of 1420 today my BTC balance on Koinly is correct ie the calculated and reported balances match - no yellow flag icon.
I then set a stop loss limit order for BTC on Coinbase and resynced Koinly at 1430. As of 1435 My BTC balance on Coinbase is now flagged with a calculated/reported discrepancy.
So setting stop loss limit order on CB advanced trading seems like it could be the cause.
If the order is cancelled on CB then the BTC calculated/reported balance seems to resolve on Koinly. But a GBP calculated/reported balance discrepancy appears in its place.
d
d
Update: Support acknowdged this is a bug, and passed it to the dev team. Quote:
'that is pointing in a known bug's direction where the API is reporting the 'available to spend' balances, and not the 'total'. Mind you that canceling the open orders wouldn't have any effect on the issue, so there's no point in doing so. I will upvote the bug report on your behalf so that you'll receive an automated notification once the status of the request changes:
Feedback has been tracked.
Coinbase API: Reported balances are "available", not "total"
There's no communicated ETA about it, however, the fix is already in the pipeline for implementation from our dev. team, so I'd suggest a little patience before it's addressed on our side. 👍'
d
d
So that was 2 weeks ago. No fix, so I follow up with support and get this response. Quote:
'I have just received a message from our devs. regarding our bug report:
"the queried 'total' balance is not provided by the API - instead it returns only the 'available' balance - which means that it's not technically possible to pull the information from it, as it simply doesn't exist"
That doesn't sound like good news for the bug report, I reckon, but the workaround with the use of CSVs still stands.'
d
d
Not a great response and abit confusing. Feels like 'go away your problem can't exist'.
Meanwhile my BTC on Koinly doesn't not match my Coinbase balance. :(
Red flag for Koinly support. Wonder if Accointing is any good?