docs.stake.tax
  • StakeTax Documentation
  • DEVS
    • github for stake.tax
    • Add New CSV format example
    • Adding CSV in cosmos-based ecosystem
    • Configuring use of Mintscan API
  • Tokens
    • COSMOS+ (v1)
    • COSMOS+ (v2)
    • AKT
    • ALGO
    • ARCH
    • ATOM
    • BLD
    • BTSG
    • DVPN
    • DYDX
    • DYM
    • EVMOS
    • FET
    • HUAHUA
    • INJ
    • IOTX
    • JUNO
    • KUJI
    • KYVE
    • LUNA1 (LUNC)
    • LUNA2 (LUNA)
    • NLS
    • NTRN
    • OSMO
    • REGEN
    • SAGA
    • SEI
    • SOL
    • STARS
    • STRD
    • TIA
    • BAND (no longer supported)
  • CSV FORMATS
    • Default (StakeTax CSV)
    • Accointing
    • Awaken Tax
    • bitcoin.tax
    • BittyTax
    • Blockpit
    • Coinpanda
    • Cointelli
    • Cointracker
    • Cointracking
    • CoinLedger (CryptoTrader.Tax)
    • Cryptio
    • CryptoTaxCalculator
    • Crypto.com Tax
    • CryptoBooks
    • Cryptoworth
    • Divly
    • Koinly
    • Recap
    • Taxbit
    • TokenTax
    • ZenLedger
  • FAQ
    • FAQ
  • MEDIA
    • Media Assets
Powered by GitBook
On this page
  • Download CSV
  • Import CSV
  • What are NULL* currencies?
  • Notes
  • Reference
  • Change Log

Was this helpful?

  1. CSV FORMATS

Koinly

Documentation on import CSV into koinly.io

PreviousDivlyNextRecap

Last updated 2 months ago

Was this helpful?

Download CSV

  • Select koinlyin the download CSV prompt.

Import CSV

  • Go to

  • Add a wallet if not exists.

  • Select a wallet.

  • Import file -> Select CSV

    • use defaults (leave tag deposits blank)

What are NULL* currencies?

Because LP currencies (i.e. LP_MIR_UST, GAMM-2) are not recognized by koinly, they are replaced with NULL* so that import works.

  • Example: LP_MIR_UST becomes NULL1.

  • You can find the list of NULL substitutions here:

Notes

Omitted transactions

All transactions starting with underscore are omitted from the Koinly CSV (i.e. _LP_WITHDRAW). This means these transactions must be imported into Koinly manually (or ignored where appropriate).

Koinly detects the wrong currency with same symbol? What can I do?

  1. We'll have it fixed in a jiffy (or if you're a developer, send a PR!)

Can I import CSV multiple times?

Yes, for Koinly. You may import the full CSV multiple times and Koinly will detect duplicates and omit them.

Tips

  • You may want to import partial CSV first as a test. It's cumbersome to undo a large amount of transactions.

  • Quick delete: there's no bulk delete function. However, the quickest way to delete transactions appears to be deleting transactions page by page via the following: select one transaction -> go to bottom of page -> select icon to select all on page -> delete

Reference

  • REALIZED_PNL:

Change Log

3/5/21

  • Added LP deposits/withdraws as native koinly CSV imports with NULL* mappings

10/17/21

  • Added fix for inclusion of fees into koinly CSVs (previously only trades had fees included; now all transactions have fees included)

Find the koinly ID for the currency here:

a. example: STARS for Stargaze goes to . So ID is 36899.

Add comment to with currency and koinly ID (i.e. STARS and 36899). Can also email support@stake.tax.

CSV format conforms to guide at

: on handling of futures trade

: on csv format for futures trade (or realized pnl)

https://app.koinly.io/wallets
http://stake.tax/koinlynullmap
https://app.koinly.io/p/markets?search
https://app.koinly.io/p/markets/36899
https://github.com/hodgerpodger/staketaxcsv/issues/93
https://help.koinly.io/en/articles/3662999-how-to-create-a-custom-csv-file-with-your-data
https://support.koinly.io/en/articles/9490027-futures-and-perpetuals-pnl-transactions
https://discuss.koinly.io/t/youhodler-csv-upload/15981
https://github.com/hodgerpodger/staketaxcsv/search?o=desc&q=koinly&s=committer-date&type=commits