Describe the problem:
I exported the transaction file from waves.exchange but koinly says cannot import due to unknown format ? So what is the correct format ? As per the instructions - all it says is export from waves.exchange and import into koinly. what else needs to be done here ?
Which exchange/wallet is this regarding?
waves.exchange
How did you import data into this wallet?
export from waves.exchange and tried importing to waves.exchange wallet.
download the waves transfers, transactions and staking transactions files if u have any. regular import will fail so u will need to map the transfers and transactions data obtained into the simple custom layout koinly has . yes it is manual effort so be ready to spend some time on it.
once u have the custom file ready then just import it and voila all transactions are recorded correctly.
if u have staked any usdc or usdt then add those transactions manually as “send to pool” and “received from pool” and it records them correctly.
There could be other ways but for me the above worked and i have < 20 transactions so work effort was less.If you have lots of transactions then be ready to spend more time to create the custom files.
Download transaction CSV file from Waves Exchange. The layout of the file is very complex and it includes all the junk like the mass distributions, funny date format etc.
Import the CSV file into excel and create a new worksheet, don’t work directly on the CSV import worksheet. Copy the imported data to the new worksheet
Fix the date. Create a few columns and change the format of the date from 22.07.2020 12:33:13 or 07.22.2020 12:33:13 to the recommended format by Koinly which is 2020-07-22 12:13. As the fields are text this can be done through (if the date is in A1) =right(A1;4) would return the 2020 in A2. In the next cell =left(A1;5) returns 22.07 in A3 then two more of =left(A3;2) returns 22 in A4 and =right(A3;2) returns 07 in A5. Do the same with time =right(A1;8) returns 12:33:13 in A6 and one more =left(A6(5) returns 12:33 in A7. Then in your fixed date column you put =concat(A2;"-";A5";"-“A4;” ";A7) which returns 2020-07-22 12:33. Copy this over down all your rows
Create two import files, one for withdrawals/deposits and one for trades. For withrawals/deposits use the headings [Koinly Date;Amount;Currency;Label;TxHash;Description]
Filter your main file for the items you want to import like BTC, ETH, WAVES and any other important token you want and drop all the junk
Filter on deposits and withdrawals and copy the relevant fields from the prepared Waves Exchange file to the import file. Map as follows: Your fixed date goes to Koinly date, Amount asset ticker goes to Currency, Amount asset value goes to amount, transaction ID goes to TxHash, put Deposit under Label for all deposits and Withdrawal under Label for all Withdrawals.
Important notes: (1) All tokens with trading pairs will have Amount asset tickers. All dead tokens will be blank. If you want to have a record of all transactions use Amount asset name instead but then create an all caps ticker that correspond to an available ticker in Koinly. (2) Amounts for deposits should be positive and amounts for withdrawals should have a minus in front of the amount. (3) Check for commas. Koinly likes dots “.” and dont like commas “,” for the thousands separater. If needed do the same process as with the date to fix the amount so that the amounts are text in the format 1234.12345678 and not 1,234.12345678. The later will import as 1,23412345
Your file should now be ready and import successfully. Tickers not available in Koinly will fail and it is up to you if you want to ignore those as they are dead in anyways with no market data
For trades create a file with the headings [Koinly Date; Pair; Side;Amount;Total;Fee Amount;FeeCurrency;Order ID;Trade ID]
Open the trade CSV file from Waves Exchange in Excel. Create a preparation worksheet and copy over the content of the import sheet to the preparation sheet just like you did with the deposits/withdrawals
Fix the date in the correct format again as well as the amounts. In the case of trades also fix your trading pair in terms of the Koinly format - You concat Price asset ticker and Amount asset ticker to get BTC-WAVES using the same method as with the date.
Important notes: (1) Koinly works in terms of BTC for pairs. A sell is a sell of BTC in terms of the other leg of the pair and Buy is a Buy of BTC in terms of the other leg of the pair. Waves Exchange works other way around so all your Sells have to be captured as buys and all your buys as sells. (2) Waves Exchange does not have a total amount for the main leg of the pair eg BTC in the exported CSV file. You need to calculate this in another field in Excel or you have to copy the total amount of BTC directly from the Waves Exchange interface as it does appear there.
13 Your mapping is therefore: Your Fixed date goes to Koinly date; your fixed pair goes to Pair; your swapped around exchange buy and exchange-sell goes to Side; your calculated Amount of the main leg (amount of BTC bought or sold) goes to Amount; Amount asset value goes to Total; Fee value goes to Fee amount; Fee ticker goes to Fee currency; leave order ID blank and Transaction ID goes to Trade ID.
Your trade file should now be ready for import. Again there will be failures for tickers that are not in Koinly but again decide if you want them as they are dead anyways.