Add support for Harmony One tokens | Integrations

For those waiting desperately for koinly to support hrc-20, try the koinly csv export on the transactions tab at https://dfkreport.cognifact.com/home.py. It was created for dfk and won first prize for dfk’s tax report bounty but the csv has transactions on viper, tranq, foxswap, defira, etc. it’s enough to get you what you need with a little manipulation of the csv file. You’ll need to change same token names to ones koinly recognizes (like 1USDC can be changed to USDC) or replace them with “null1”, “null2”, etc. Using null tokens was helpful for the dfk quest items, none of which koinly recognizes at the moment.

Specki

Chuck: hey man, can u send me the modified CSV you have ? :) Just to see how it has to be that Koinly can implement it.

Chuck

Specki: I can't send it, but what i did was:

Split the tokens in the "send" and "receive" columns into two separate rows for any token where there was a "/" in the token name (for some reason the dev of this tool decided to merge the two tokens going into a Jewel-LP into a single cell, so you'll see tokens like "ONE/JEWEL" instead of two separate rows for each side of the liquidity-in transaction. Just split those up using find and replace or vlookups). Also divide the value of these transactions by 2 when splitting them so you don’t double your capital gains/losses on them.
Import into Koinly to see what errors were thrown and go through the list to fix those, mainly by renaming things like 1USDC to USDC, Tranquil to TRANQ, random contract addresses to WAGMI, COMFY, etc. You can create a dummy trade in Koinly to play around with what tickers might be recognized by Koinly. Usually if a token is on CMC or coingecko, its ticker will be recognized by Koinly but the lila's ledger dev didn't always use the right ones, e.g. "Tranquil" instead of "TRANQ".
Anything that's not listed on CMC or Coingecko can be replaced by a null token (e.g., DFK quest items and JEWEL-LP tokens). I created a separate spreedsheet so i can refer back to which tokens i assigned to null tokens. I guess this is koinly's way of letting you create custom tokens ("null1", "null2", "null3", etc.)
Delete values in the "Fee amount" and "Fee currency" columns if you'd rather account for gas costs in ONE than USD. I don't know why the dev decided to track costs in USD because this leads to inaccurate ONE accounting. So i rely on the Koinly harmony api sync to pull in gas tx's.

Hope this helps!

Chuck

Another tip: create dummy wallets in koinly to test the import out before importing it into your API-synced harmony wallet, if you created "one" to get the "ONE" transactions already. :)
If you import the lila's ledger csv into your api-synced wallet, which i did because lila's ledger doesn't include the ONE used as gas, you will end up with some duplicate ONE transactions. I just delete those as I go through in Koinly itself. It's a pain but whatever.
Also lila's ledger seems to treat WONE as ONE. Heads up if you care about tracking wrapping/unwrapping precisely. At this point I just gave up being meticulous about it and went with what lila's was giving me and deleted any "send" transactions that were for wrapping. This is about the best i can do with reasonable effort since Koinly hasn't even given us any notice about when they can pull in HRC-20s and tax day is days away.

DefiKev

Chuck: Hi,I've been following your steps exactly like you described. I've uploaded my custom csv file from Lila's Ledger and made the changes just as you described. How do you get the "Market Price" for your Jewel/ONE LP tokens? Koinly is unable to recognize the "market Price" for my LP tokens.

Chuck

DefiKev: I didn't bother entering the values for LP tokens. If you mark them sent to pool, their cost basis should carry through to the "received from pool" transactions and ultimately the trade from the LP tokens to the underlying tokens, where the csv should already have the USD value of those. Hope that makes sense.

DefiKev

Chuck: Yes, I think that makes sense. So "withdrawing LP tokens from metamask wallet and depositing them into the pool" would count as "sent to pool", and "withdrawing from the LP or claiming rewards" count as "received from pool"? Also, should the Jewel LP tokens and xJewel be left as Null1,Null2,Null3, etc. or should the names be need to be changed in koinly after the upload?

DefiKev

Also, when depositing jewel to the jeweler, should xjewel tokens be marked as sent to pool as well? Edit: I tried marking them as sent to pool because they are considered staking, but there is no option for me to do so. I only have an option to tag as swap. According to Koinly, "Swap can be used for any tax-free "trade". This label should not be used for regular trades but only tax-exempt transactions such as migrations and rebases. " But this isn't the case, technically it is staking. Do you know a work around for this? Here is the link to the swap definition https://help.koinly.io/en/articles/3663453-what-are-labels

Chuck

DefiKev: yup that’s right. For the jewel lp tokens, I’ve just left them as null tokens and left in the description field from Lila’s that identifies the specific pair in the lp token

Chuck

I just make jewel to xjewel and vice versa exchanges and leave it at that

DefiKev

Chuck: Hi Chuck, thank you for answering all of these questions as this has been a complete tax nightmare. Koinly definitley needs ERC20 integration for Harmony tokens!! But anyways, how did you resolve the issue of not having purchase history for the Null Tokens (ie. $One LP Token & Jewel LP Token)? FYI, Null 1 for me is Jewel LP Token Jewel & Null2 is Jewel LP Token ONE

DefiKev

Also, how do you sync your Metamask Transactions? I did some research and it looks like only ETH is supported on MM. Is there a way to export harmony transactions to a csv?

Chuck

DefiKev: oh man, those missing tx warnings are a nightmare. If you go to into one of those transactions, then ledger, and click on the eyeball thingy you can see previous null1 or null2 balances and find where the error may be, like duplicate tx’s or a missing one. It sucks.

Chuck

DefiKev: if you go to the harmony explorer and then the HRC-20 tab, you can download a csv there with some hrc-20 tx’s. It helped me find some stuff Lila’s ledger was missing with some xlookups but it’s still a pain because only token contract addresses are provided.

labacke

need token support for harmony... their block explorer is so bad

Antonio Roberti

Support Harmony ONE

Scott Smith

Please support Harmony ONE.

Pbj Climbing

If there was Harmony support I would be paying for the most transaction package...

Ryan Moore

PLZ PLZ

Chuck

Can we at least get an idea of whether you will do this before April 18? Otherwise we will need to look into other options ASAP. Products like dfktracker’s csv export are options but not complete and koinly does not recognize the many DFK quest item tokens (bloaters, runes, etc.)

→