# Binance US CSV buys are being categorized as sells

**URL:** <https://discuss.koinly.io/t/binance-us-csv-buys-are-being-categorized-as-sells/16898>\
**Category:** Koinly Support\
**Created:** [February 26, 2023, 7:49pm UTC](https://discuss.koinly.io/t/binance-us-csv-buys-are-being-categorized-as-sells/16898 "2023-02-26T19:49:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dylan](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/dylan/32/2542_2.png) [@dylan](https://discuss.koinly.io/u/dylan)\
**Post date:** [February 26, 2023, 7:49pm UTC](https://discuss.koinly.io/t/binance-us-csv-buys-are-being-categorized-as-sells/16898/1 "2023-02-26T19:49:05Z")

</div>

**Describe the problem:**  
Transactions imported from Binance US are miscategorized. Buys incorrectly show up as sells.

**Which exchange/wallet is this regarding?**  
Binance US

**How did you import data into this wallet?**  
CSV

**What have you tried to fix this so far?**  
Not sure what to do. Don’t want to manually modify 100s of recurring buys.

---

<div class="post-metadata">

**Author:** ![Sarzen\_Tor](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/sarzen_tor/32/1554_2.png) [@Sarzen\_Tor](https://discuss.koinly.io/u/Sarzen_Tor)\
**Post date:** [March 2, 2023, 4:27pm UTC](https://discuss.koinly.io/t/binance-us-csv-buys-are-being-categorized-as-sells/16898/2 "2023-03-02T16:27:58Z")

</div>

I am also having this same problem too. It is happening specifically with fiat / USD buys. It seems to be a glitch with the way Koinly is importing CSV files. I think I have found a temporary workaround. Open the CSV in Excel or similar. Sort spreadsheet by the category column so all of the straight “buys” are together. Then change “buy” to “sell” under both the columns “category” and “operation” and copy paste all the way down your buys. Then sort the spreedsheet back into its original order by date, export as corrected CSV, then import into Koinly. To avoid duplicating other transactions, it’s probably best to just erase the BinanceUS wallet and import everything over. It’s a pain. But I don’t have too many transactions. Under a 1000. I can imagine this being a nightmare with more.

---

<div class="post-metadata">

**Author:** ![Michael\_Koinly](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/michael_koinly/32/10244_2.png) [@Michael\_Koinly](https://discuss.koinly.io/u/Michael_Koinly)\
**Post date:** [April 6, 2023, 3:29am UTC](https://discuss.koinly.io/t/binance-us-csv-buys-are-being-categorized-as-sells/16898/3 "2023-04-06T03:29:04Z")

</div>

Hi @dylan and @Sarzen_Tor,

Thank you both for your patience with us and my apologies for the delay in response!

Our dev team has completed their work on this issue and our importer will now correctly categorize [Binance.US](http://Binance.US) CSV buys.

![image](https://canada1.discourse-cdn.com/flex052/uploads/koinly_app/original/2X/d/d01aeebca0fe43c8c52f8aafae99453872a741f6.png)

If anyone experiences persisting issues, please do [connect with our support team](https://support@koinly.io) so we can help resolve and save you time!

Have an awesome day!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex052/uploads/koinly_app/original/1X/7ac58e5593a7122893d066794a7254dcdb5ddb31.png) [@system](https://discuss.koinly.io/u/system)\
**Post date:** [June 5, 2023, 3:29am UTC](https://discuss.koinly.io/t/binance-us-csv-buys-are-being-categorized-as-sells/16898/4 "2023-06-05T03:29:49Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.