# Koinly

## Download CSV

* Select `koinly`in the download CSV prompt.

## Import CSV

* Go to <https://app.koinly.io/wallets>
* Add a wallet if not exists. &#x20;
* 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. &#x20;

* Example: LP\_MIR\_UST becomes NULL1.
* You can find the list of NULL substitutions here: [http://stake.tax/koinlynullmap ](https://stake.tax/koinlynullmap)

## 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. Find the koinly ID for the currency here: [https://app.koinly.io/p/markets?search](https://app.koinly.io/p/markets?search=STARS)

   &#x20; a. example: STARS for Stargaze goes to <https://app.koinly.io/p/markets/36899> .  So ID is 36899.
2. Add comment to <https://github.com/hodgerpodger/staketaxcsv/issues/93> with currency and koinly ID (i.e. STARS and 36899).   Can also email <support@stake.tax>.
3. 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

* CSV format conforms to guide at <https://help.koinly.io/en/articles/3662999-how-to-create-a-custom-csv-file-with-your-data>
* REALIZED\_PNL:
  * <https://support.koinly.io/en/articles/9490027-futures-and-perpetuals-pnl-transactions> : on handling of futures trade
  * <https://discuss.koinly.io/t/youhodler-csv-upload/15981> : on csv format for futures trade (or realized pnl)

## Change Log

<https://github.com/hodgerpodger/staketaxcsv/search?o=desc&q=koinly&s=committer-date&type=commits>

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)