# 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)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.stake.tax/export-csv-formats/koinly.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.