.CSV Export format

[JSayos]

As of today, SAFEW and YOROI are the only Ergo wallets that support .csv exportation. Yoroi being unusable, users choice goes preferably towards SAFEW.

Tax softwares that'll allow .csv imports for trades and transactions also support direct wallet reading for this data via public keys.
To my knowledge, Ergo is not supported by any of the tax softwares (yet), which is why manual .csv imports are the only way to store and manage your trades and transactions for tax purposes.

Yoroi has a functional format of transaction .csv, although it is not listing any other assets than Erg itself.
SAFEW .csv is in a format that is unreadable by atleast the most popular tax softwares which is why I have listed some specifications on what the .csv format should be like for the tax softwares.

• Date

  • YYYY-MM-DD HH:mm:ss

• Decimal separator (amounts)

  • Dot (e.g. 2.17403)

• LP Tokens

  • Irrelevant for tax software, but have to be careful due the big values. e.g. 27,717,801,841 should be 27717801841

• Fees

  • New fields for:
    1. Fee amount
    2. Fee currency

• Transactions

  • Current balance +/- format should be fixed to Yoroi style:
    1. Type: Deposit/Withdrawal (IN/OUT)
    2. Received amount
    3. Received currency
    4. Sent amount
    5. Sent currency

• Assets

  • Assets are typically not recognized by tax softwares but can still be stored and accounted for.
  • This is not completely clear to me what kind of format should assets have. Yoroi does not export asset transactions, neither does
    Eternl in Cardano. Daedalus however uses the following format:
    • 'Amount Name (fingerprint)'
    • e.g. '1 (asset123456)' OR '141,049,480 randomCoin (asset654321)'

• Labels

  • Transactions can include labels defining the nature of transaction.
  • For example:
    • Mining
    • Airdrop
    • Reward
    • Liquidity IN
    • Liquidity OUT
    • Swap
    • etc. Completely list can be found from link below.

For these format specifications I used Koinly custom .csv instructions.
See: https://help.koinly.io/en/articles/3662999-how-to-create-a-custom-csv-file-with-your-data

[ThierryM1212]

Thanks for reporting the issues.
I will try to improve the feature in the next version.
Unfortunately, ergo transactions can be more complex than what can be integrated in the "Advanced" Koinly format.

So I won't be able to follow it... I will keep several rows per transactions to be able to report multi-asset transferts that can occurs.