Unsplash

So, after yesterday's little crank out about finding and replacing all the botched imports from KuCoin and finding it all quite time consuming and tedious. I started to explore the more advanced versions of seraching and filtering that are available on Cointracking. Now... most of the problem with rectifying all the changes from the crapped up import revolve around matching the initial lending transaction that was marked as a simple "Withdrawal" with the eventual payment of the principal plus interest that would be marked "Income". Now, with so many lending and repayment transactions happening every day, this quickly led to the false tracking of a stupidly high income that was many orders of magnitude off the real amount.

I mean, when I first saw the tax export, I nearly choked!

However, even when just filtering by exchange, it was quite tricky to match the corresponding loan and repayment entries. And every match would require that the repayment was altered to only incude the interest as "income" by removing the initial loan amount... and then deleting the "withdrawal" entry that represented the tokens leaving my account for the loan.

Now, that would be relatively easy if the two entries were right next to each other... even if that meant that I needed to remove more of these than I cared to count. However, the problem was that each pair would be seperated by quite a number of other entries... as repayments could occur within seconds... or up to 14 days! So, sometimes, finding the matching entries was quite a slow process... and that wasn't even coming to grips with different tokens and different amounts of loan amounts!

So, this wasn't going to be a fun few days if this was the way that it was going to work... and I did spend more than a few hours trying to do it in this brute force way. However, I started to think that there must be a better way to do this.

... and I started to play around with the "advanced" sorting and filtering options on Cointracking. First filter would be for the exchange, KuCoin... and then I could set the transaction tokens for the "buy" and "sell" to be one of the myriad of lending options that were possible. Now this worked when the "buy" and "sell" were set as an "OR" condition... so, all the loans would be triggered by the "sell" field and the repayments would be triggered by the "buy" option.

Thankfully, I do very little in the way of trading... and so pretty much all the transactions were lending and repayment transactions that came from the KuCoin savings products.

It meant that most of the loan and repayment transactions were right next to each other!... or at the very worst, separated by only a few entries! And many of the loans tended to be repaid in a pretty similar time, so many of them had similar loan and interest amounts. That meant that I could batch together many transactions to edit in a single go! That wasn't something that I could do easily when everything was looking more chaotic as I couldn't be sure that I was matching all the right pairs.

So, with this huge step up in efficiency due to this sorting and batching, I am pretty sure that I can fix all this up in much less time than I was worried that it was going to take! It will still take more than a few hours... but that is a lot better than several days or weeks!

I can also be found cross-posting at:
Hive
Steem
Publish0x

Handy Crypto Tools

Ledger Nano S/X: Keep your crypto safe and offline with the leading hardware wallet provider. Not your keys, not your crypto!
Binance: My first choice of centralised exchange, featuring a wide variety of crypto and savings products.
WooX: The centralised version of WooFi. Stake WOO for fee-free trades and free withdrawals!
GMX.io: Decentralised perpetual futures trading on Arbitrum!
Coinbase: If you need a regulated and safe environment to trade, this is the first exchange for most newcomers!
Crypto.com: Mixed feelings, but they have the BEST looking VISA debit card in existence! Seriously, it is beautiful!
CoinList: Access to early investor and crowdsale of vetted and reserached projects.
Cointracking: Automated or manual tracking of crypto for accounting and taxation reports.