Missing Trades / Withdraw Issues

I have 4 CSV’s from OceanExPro and I have re-formatted to the Koinly templates for trades and deposits etc. and all are processed ok, no errors. The Withdraw CSV seems to not take effect and I get the below error (I wish I did have 17,845 ETH !!), these were VET-ETH on the BUY side. Only transactions on the date in question are that indicated in the detail below - only 1 day. The entries are correct so why is Koinly seeing these as SELL side (I assume), ie sell VET, Buy ETH, and not VET-ETH BUY side for Selling ETH for VET ? Further it imports 38 Withdraw entries, none of which seem to show up.

The OceanEx format is as follows >>;

time(UTC), coin type, amount, received amount, fee, status, txid
‘21/10/2021 08:14’ ‘vet’ ‘5,632.10’ ‘5,582.10’ ‘50’ ‘succeed’ ‘transID’

Which I translated to the Koinly headings (template) as follows >>;

Koinly Date Currency Amount TxHash
‘21/10/2021 08:14’ ‘vet’ ‘5,582.10’ ‘transID’

I removed Amount, change Amount Received and removed fee so I assume this is correct. This also raises a question in how does Koinly calculate the fee in this case ?

Koinly generated text for this issue is as follows ;


Wallet: OceanEx (OceanEx)
Transactions: 455
Imported with: CSV

  1. No crypto withdrawals found
  2. 10 transactions are missing purchase history
    ---- Missing 15659.00101399 VTHO on 2020-07-09 17:41:00 UTC
    ---- Missing 17845.61079893 ETH between 2020-05-31 11:35:00 UTC and 2020-05-31 14:00:00 UTC
    ---- Missing 699.9911806 USDT on 2021-10-21 08:13:00 UTC

Obviously this is a massive discrepancy sop I need to understand why the OceanEx Withdrawls aren’t working as expected.

Many thanks

Jason

Hello!

Alex from Koinly here :slight_smile:

I believe this might be happening due to the comma that you have in the amounts column values.
I have seen issues with decimal separators being confused before, so try using 5632.10 instead of 5,632.10

As for the fees; you will need to either add the fee amount paid to the total of the sent amount if the fee was paid in the same currency as the one you sent.
If it was paid in a different currency then you need to add the “Fee Currency” and “Fee Amount” columns with the corresponding values to the template as well.

If you’re still seeing a big discrepancy after trying this then please send an email to hello@koinly.io so we can take a closer look at your specific situation :slight_smile:

Best regards,
Alex

If that doesn’t