# Celsius loan collateral not reflected in Koinly **URL:** \ **Category:** Koinly Support\ **Created:** [August 27, 2021, 1:00pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940 "2021-08-27T13:00:31Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Greg\_Duffy](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/greg_duffy/32/4293_2.png) [@Greg\_Duffy](https://discuss.koinly.io/u/Greg_Duffy)\ **Post date:** [August 27, 2021, 1:00pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/1 "2021-08-27T13:00:31Z")
I’ve just taken a loan on Celsius, providing BTC as collateral and receiving USDC from them in return. It’s a 25% LTV loan, so the amount of BTC held as collateral is 4 times the amount of USDC received. Problem: The USDC that I’ve been issued with has appeared in Koinly, but the collateral is NOT being reflected cleanly, and certainly not clearly. Koinly appears to have done the following: - updated my BTC holding to reflect the amount of BTC that still remains in my account, not held as collateral. - Forgotten all about the BTC that I provided as collateral … it’s just disappeared - Consequently, adjusted the current value of my BTC holdings - While maintaining the same cost basis - Consequently, it is showing my account as having made a loss. Although there is a transaction showing the USDC that I received, there is no transaction that shows the BTC that has been taken out of my account to be held as collateral. Also, Koinly is now reporting an error against my BTC holding. (‘Calculated balance is different from the amount reported by the API’). I think, strictly speaking, that there perhaps should have been a ‘sale’ transaction reflected in Koinly, since the Celsius Terms position the loan as a sale and repurchase agreement. Apart from a lack of clarity, I’m concerned that this might be reported wrongly to HMRC in the tax return section. Can someone advise, please? Many thanks! See below for answers to the new topic template questions: This is regarding the Celsius wallet, and it’s in a UK account, following the provision of a UK loan (which I think might be handled differently from a US loan). The data was imported into the wallet through the API. I have not found a way to fix this myself, other than to make a note on the USDC transaction to remind me. ---
**Author:** ![cryptothrowawa6](https://avatars.discourse-cdn.com/v4/letter/c/7ea924/32.png) [@cryptothrowawa6](https://discuss.koinly.io/u/cryptothrowawa6)\ **Post date:** [September 22, 2021, 2:44am UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/3 "2021-09-22T02:44:52Z")
I haven’t taken a loan from Celsius but a potential solution would be to go into the Celsius wallet on Koinly, hit the “edit” button, then “Edit API settings” and then check the “Ignore reported balances” option. ---
**Author:** ![DiJohns4](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/dijohns4/32/537_2.png) [@DiJohns4](https://discuss.koinly.io/u/DiJohns4)\ **Post date:** [October 8, 2021, 8:41pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/5 "2021-10-08T20:41:54Z")
Hey Greg … Have you asked Koinly Directly? as in logged a Ticket? be Very Interested in knowing if there is a Work Around that can be done successfully. I will ask each poster this question… Cheers Di ---
**Author:** ![blu3drag0n](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/blu3drag0n/32/265_2.png) [@blu3drag0n](https://discuss.koinly.io/u/blu3drag0n)\ **Post date:** [September 21, 2021, 11:08am UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/2 "2021-09-21T11:08:22Z")
+100 to this! I was just looking if someone know how to work around this, but now I just found thise report here and have to say the same. We are missing a Withdrawal option like “Collateral” or “Start Lending”, which just keeps track of our balances. I don’t mind if we need to do it manually. And if the loan finished to put down another Deposit as “Collateral” or “End Lending” to then have the blances correct again would be helpful. KR ---
**Author:** ![DiJohns4](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/dijohns4/32/537_2.png) [@DiJohns4](https://discuss.koinly.io/u/DiJohns4)\ **Post date:** [October 8, 2021, 8:42pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/6 "2021-10-08T20:42:19Z")
Hi … Have you asked Koinly Directly? as in logged a Ticket? be Very Interested in knowing if there is a Work Around that can be done successfully. I will ask each poster this question… Cheers Di ---
**Author:** ![Auggie\_Boy](https://avatars.discourse-cdn.com/v4/letter/a/74df32/32.png) [@Auggie\_Boy](https://discuss.koinly.io/u/Auggie_Boy)\ **Post date:** [October 9, 2021, 2:17pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/8 "2021-10-09T14:17:45Z")
I don’t use Celsius collateral loan, but I sent coins from Gemini to Gemini Earn. I use tags “sent to pool” and “received from pool”. If I had this Celsius issue, I would play around with those tags. ---
**Author:** ![AnastasioSays](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/anastasiosays/32/4692_2.png) [@AnastasioSays](https://discuss.koinly.io/u/AnastasioSays)\ **Post date:** [October 2, 2021, 4:58pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/4 "2021-10-02T16:58:27Z")
Yes. When borrowing money from Celsius how do we do this? Would love a manual solution until Koinly can automate this. ---
**Author:** ![DiJohns4](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/dijohns4/32/537_2.png) [@DiJohns4](https://discuss.koinly.io/u/DiJohns4)\ **Post date:** [October 8, 2021, 8:42pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/7 "2021-10-08T20:42:41Z")
Hey Anastasio … Have you asked Koinly Directly? as in logged a Ticket? be Very Interested in knowing if there is a Work Around that can be done successfully. I will ask each poster this question… Cheers Di ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex052/uploads/koinly_app/original/1X/7ac58e5593a7122893d066794a7254dcdb5ddb31.png) [@system](https://discuss.koinly.io/u/system)\ **Post date:** [December 8, 2021, 2:18pm UTC](https://discuss.koinly.io/t/celsius-loan-collateral-not-reflected-in-koinly/6940/9 "2021-12-08T14:18:03Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.