Transaction history expanded with earn/interest amounts, and delegation, e.g. as csv export for Tax

[FedderSan]

When I have to make my tax end of year, I need a full list of "earnings". Like on the Crypto.com "centralized" app, I can export all transactions in a csv file. For Tax purposes I really could use a feature giving me the option to export, both the transactions as seen on the "home" screen, aswell as all my earned "interests" that I have extracted, either in EUR/USD or other for the transaction date.

I looked into the API, on crypto.org, but the list of commands isnt full... so I havent found a command for it, else I could just do it in the cmdline...

An alternative is if anyone knows the cmdline command, so an extract could be done there as a workaround.

[HankFit247]

Better yet. This should be incorporated into tax.crypto.com.

Simply query the chain.

[crypto-eddy]

Hey folks, this looks like an interesting use case, we can definitely see how to incorporate this into our roadmap. Thx

[FedderSan]

@HankFit247 I dont know why I didnt think of that, query the chain... so used to Crypto.com's usual centralized platform... but it off course works...! The command is https://crypto.org/explorer/api/v1/accounts/{YourAddress}/transactions?limit=1000 The pagination commands I guessed with the ? so you can derive all your transactions in one go... Although I think a lot non tech savvy people would love the CSV export :-)

And tax.crypto.com, Is a good place, but all that is non US residents it is not ready yet... so for our purpose it is better to just have the data

[brendzy]

@FedderSan a problem with the api is it is missing the full transaction information. When you delegate to a validator and there is an existing reward, it doesn't show the existing reward being sent to the wallet. (cdc explorer is missing it too)

[FedderSan]

@brendzy I have been working more on my solution, and I can see that there is an issue with the balance vs transactions both on the desktop app and explorer (web).. I have found an account with not as many transactions, but if you add them up they do not equal the total balance. I looked into your issue, and I dont know if it has been updated since June, but It has a (+1 more) tab on the explorer, and in the api, the transaction is bundled into two, but they are available to take out as two transaction id's under one main "Transaction".. An easy account to try is cro13mzsef4p8wfx4m0rzxz5nylddh28euhajkgpfa... Although this is present, the balance is still an issue, can you clarify if the one you mentioned were the +1 (containing, both witdrawal and delegation) e.g. trans (024AB07569AE91D25E23BA8AC42DC6F349A91A286D82AFA0A0718601D9D18444) Or could you direct me to an example... couse on that account (and all others) it still doesnt fit :-(

Maybe I should raise this as an new issue

[FedderSan]

@brendzy I was actually able to replicate the issue as you state.... The key is to: Make sure there are:

1. unclaimed stakereward on a validator (lets say there is 14,12345678
2. ONLY stake from your usable balance, to the validator. (lets say you stake 8,00000000)
3. then your transaction log on the explorer and on mintscan will only show the transaction for the 8,0000000
4. Your 14,12345678 are added to your balance BUT not shown in the transaction list

This makes it impossible to make any use of the transaction log, for tax purposes and other... will create an incident