# Binance REALIZED\_PNL inaccurate

**URL:** <https://discuss.koinly.io/t/binance-realized-pnl-inaccurate/1353>\
**Category:** Koinly Support\
**Created:** [January 20, 2021, 10:47pm UTC](https://discuss.koinly.io/t/binance-realized-pnl-inaccurate/1353 "2021-01-20T22:47:10Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chrisolufc](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/chrisolufc/32/722_2.png) [@chrisolufc](https://discuss.koinly.io/u/chrisolufc)\
**Post date:** [January 20, 2021, 10:47pm UTC](https://discuss.koinly.io/t/binance-realized-pnl-inaccurate/1353/1 "2021-01-20T22:47:10Z")

</div>

The REALIZED\_PNL shown on a transaction via API is higher (by more than double) compared with the actual REALIZED\_PNL when I manually download my futures trade history.

I have emailed support about this and have attached the transactions in question and screenshots.

But does anyone else have similar issues? It’s also worth noting that when I import the CSV containing the exact same transactions (into a new wallet) the calculation that Koinly makes on the REALIZED\_PNL is even worse than the API despite the CSV showing the correct figure.

Thanks for any help

---

<div class="post-metadata">

**Author:** ![miguelm](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/miguelm/32/679_2.png) [@miguelm](https://discuss.koinly.io/u/miguelm)\
**Post date:** [January 21, 2021, 8:21am UTC](https://discuss.koinly.io/t/binance-realized-pnl-inaccurate/1353/2 "2021-01-21T08:21:49Z")

</div>

that is strange and it does concern me as well, I want to use koinly as main source for the taxes, but I have a question if you import your data cointracking.info do you get different REALIZED\_PNL results?

---

<div class="post-metadata">

**Author:** ![chrisolufc](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/chrisolufc/32/722_2.png) [@chrisolufc](https://discuss.koinly.io/u/chrisolufc)\
**Post date:** [January 21, 2021, 10:14am UTC](https://discuss.koinly.io/t/binance-realized-pnl-inaccurate/1353/3 "2021-01-21T10:14:40Z")

</div>

I don’t use cointracking.info however after additional efforts on this, I have found the following:-

Deleting the trades permanently from Koinly and re-importing them via API is hit and miss, sometimes it simply doesn’t import anything and it never imports the right values for these transactions.

If I take the XLSX file produced by Binance from my futures trades and edit that file to ONLY include the transaction in question it then seems to import it correctly. This implies something else is causing the API/XLSX to produce incorrect numbers but I cannot find it, no other transaction would cause the REALIZED\_PNL to more than double.

Its very confusing and makes me doubt all of my previous Binance API imports now, how do I know that they are accurate and not also subject to errors?

---

<div class="post-metadata">

**Author:** ![koinly](https://avatars.discourse-cdn.com/v4/letter/k/49beb7/32.png) [@koinly](https://discuss.koinly.io/u/koinly)\
**Post date:** [January 21, 2021, 12:47pm UTC](https://discuss.koinly.io/t/binance-realized-pnl-inaccurate/1353/4 "2021-01-21T12:47:30Z")

</div>

Koinly will aggregate all your pnl transactions in the same day to reduce the total txn count since there can be hundreds of these, this is why you will see completely different figures after importing them. You can verify this by summing all pnl for a particular day and comparing with what koinly shows you.

---

<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:** [November 2, 2021, 1:41pm UTC](https://discuss.koinly.io/t/binance-realized-pnl-inaccurate/1353/5 "2021-11-02T13:41:24Z")

</div>

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