CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies

[sgjenks01]

Please text me your Username via DM and I´ll have a look.

I found you on Twitter and I THINK I sent you a message. I don't use Twitter very much.

Steve

[Dario3000]

I found you on Twitter and I THINK I sent you a message. I don't use Twitter very much.
Steve

Nope, I don't see a message there.
Please let us know here and I will have a look: https://cointracking.info/feedback.php

Adding a gift, will still result in a current value and an unrealized profit.
If someone will send you 1 ETH, it will still have a value of 275 USD no matter if you have paid for it or not

QORA has a very low price. If you just have few of them, the value can be rounded off to 0.

As said, let us know and I will have a look.
Dario

[sgjenks01]

@dario3000
I sent the message to Keven, I just tried to send you a message @dario3000. Anyway, I think you nailed it. The account where I hold it says there are just over 16 QORA and it says it is worth 3 dollars. It was worth $5 when it was given to me. Kind of going the wrong way... I plan to retire on it. What do you think?

Steve

[Bermuda666]

Addition of transaction types at Cointracking

To be able to enter different transaction types more accurately and to get a more detailed classifications, we decided to orientate towards the common law and tax standards, by increasing the amount of transaction types.

With this additions it is possible to calculate the Tax-Report much more efficient, to add entries much easier and to improve the structuring of a portfolio on Cointracking.

Additionally to the current 3 types of transactions (Trade, Deposit and Withdrawal) it is now possible to enter more types into our system. These new transaction types are considered in all reports and especially have an influence on the Tax-Report.

From now on, following transaction types can be added to our system and have impact on the calculations:

(EXCHANGE) Trade Purchases/Sales
Are listed in the Capital Gains Report.

(IN) Deposits (Transfer)
Are considered as transfers between wallets or exchanges and are not included in the calculation.

(IN) Mining
Are listed in the Income Report with the value at the time of transaction.

(IN) Gift/Tip
Are listed in the Income Report with the value at the time of transaction.

(IN) Income
Are listed in the Income Report with the value at the time of transaction.

(OUT) Withdrawals (Transfer)
Are considered as transfers between wallets or exchanges and are not included in the calculation.

(OUT) Spend
Are listed in the Capital Gains Report.

(OUT) Gift
Are listed in the Gift and Donation Report.

(OUT) Donation (registered charity)
Are listed in the Gift and Donation Report.

(OUT) Stolen/Hacked/Fraud
Are listed in the Lost and Stolen Report.

(OUT) Lost
Are listed in the Lost and Stolen Report.



Information about the different kinds of Reports included in the Tax-Report:

Capital Gains Report - Your Sales of Capital Assets:
This table contains all sales during the selected tax year including its appropriate cost basis, calculated with the chosen method.

Income Report:
Income report including mining and received gifts.

Gift and Donation Report:
All gifts and donations made in the selected tax year. There is no gain for gifts and donations as the cost basis is transfered over to the recipient. If the recipients wishes to spend those coins, he needs the cost basis information.

Lost and Stolen Report:
All losses you have reported for the selected tax year. In some cases they can be deducted from your total tax as casualty losses, at their original cost basis value.

Closing Position Report:
This table contains all coins that you still own including their cost basis.

Everyday, we do our best to make the lifes of our members easier. We hope you are going to like this implementation and it´s useful for you.

Happy Tracking.

BTCest regards,
The Cointracking Team

[sgjenks01]

Wow! This looks great! But just think of all the work you have created... LOL

[Bermuda666]

Wow! This looks great! But just think of all the work you have created... LOL

Hey @sgjenks01,

Thank you for your feedback.

You are right, you can put in more work now, but also everything is more accurately.
We decided to choose the most perfect solution for our users.

Best regards,
Keven

[wowza1122]

what api do you guys currently use to pull all transactions from the bitcoin wallet address?

[wowza1122]

I'm asking @Dario3000
How does it work underneath? can we trust that you guys are only doing read only? 

[Dario3000]

I'm asking @Dario3000
How does it work underneath? can we trust that you guys are only doing read only? 

Ah sorry didn't see the word API in your question... But I think he just queries the blockchain.

Correct
We're querying the blockchain.
BTC addresses and xpubs have read permissions only.

Best, Dario

[Ale88]

I just found out about this website and looks very interesting! But I don't understand which option I should use when I sell some Bitcoin:for example when I buy I choose Trade (first option), but when I sell which Out option should I use?

Thanks!

[meln1k]

I just started using cointracking and love it... but I have some questions that I hope I can get a good resolution to.
1.  When I export my entire trading history, I do not find the "trade id" that is listed under the detail for a record in the Realized Gain area.
2.  I see realized gains that do not have a sell to them at all... for instance, I have a realized gain on DASH for 7/16/17 but there was no sell order that went through at all for that day.

I am using the Poloniex API to gather my trade data.

Thanks for your help!  I just want to make sure I understand this and the numbers just look a bit high to me..
Melanie

[Dario3000]

I just found out about this website and looks very interesting! But I don't understand which option I should use when I sell some Bitcoin:for example when I buy I choose Trade (first option), but when I sell which Out option should I use?

Thanks!

Hey Ale88,
Use the type "Trade" for your sales as well.
Buys and sales are the same. Only the positions are switched.

Buying 1 BTC for 2000 USD:
Buy: 1 BTC
Sell: 2000 USD

Selling 1 BTC for 2000 USD:
Buy: 2000 USD
Sell: 1 BTC


@meln1k:
You're right. The "trade id" is not listed in the regular export file on the "Enter Coins" page.
If you want to export all your details, you can export the CSV or Excel file on this page: https://cointracking.info/trades_full.php

If you haven't sold any DASH yet, I'm absolutely sure that the displayed value is the "unrealized gain" and not the "realized".
Realized gains will be only calculated for sold assets.

Best, Dario

[natevoight]

Hi guys,

Quick question regarding the Kraken API. The instructions indicate that only "Query Ledger Entries" should be checked but so far, none of my Kraken traded are reflected in CoinTracking. Only fees seem to be syncing, oddly enough.

I tried checked all the other "query" options for that API key but the issue still isn't resolved. I noticed it when my USD CoinTracking balance did not reflect that of my Kraken wallet. Then I saw none of the short postions I had taken and closed during the past few days had synced.

Any thoughts? Thanks.

[Dario3000]

Hey natevoight,

"Query Ledger Entries" is enough, as all trade and margin data is included there.
No need to enable additional permissions.

It's hard to tell what's going on without any details.
Can you please send us a short ticket here at the bottom https://cointracking.info/feedback.php and I will have a look.

Thx,
Dario

[natevoight]

Hey natevoight,

"Query Ledger Entries" is enough, as all trade and margin data is included there.
No need to enable additional permissions.

It's hard to tell what's going on without any details.
Can you please send us a short ticket here at the bottom https://cointracking.info/feedback.php and I will have a look.

Thx,
Dario

Done. Thanks Dario.

[Dario3000]

Thanks.
The red entries you see are not fees, but withdrawals you did on Kraken
You can decide if you want to import them or not.

Here's what happend:

Please check the "Enter Coins" page and filter by "Kraken".
You will see, that several trades, withdrawals and deposits have been imported.

But as mentioned on the API page, Kraken has a strong API call limit, that's why it has only imported your trades of the last days.
To get ALL your trades into CoinTracking, you will have to import your Kraken CSV file for an initial import.
This only has to be done once and will just take 2 minutes. The API will do the rest in the future and will import all new transactions.

Best,
Dario

[allanster]

Suggestion... have Total actually present cumulative totals with the same views of all the data of your linked accounts.

I originally decided to store everything in one account, then when I saw you had a Total function, I took the time to create separate linked accounts for each exchange and mining thinking I would be able to view them all in Total the same way that I was able to view them in individual accounts. I was a little surprised to discover that wasn't the case. So I ended up moving everything back into one combined account. Total has little value without being able to present ALL of your data in the same was as the individual accounts.

Making this change could have the potential to lower your resource usage. There are those of us who do little trading on several exchanges but may trade numerous times on one. By giving us the ability to separate these out but still see them combined in total, it would mean we would often times just be refreshing the one account and your servers would need to crunch less data by not having to refresh all of it from the other mostly static accounts.

[sgjenks01]

Hi guys,
I saw you made some more tweaks to the Realized/Unrealized Gains page and I got a very strange result. I have it set to "Best Prices", "Average of Unsold Assets as Cost Basis", "In USD" and "All Currencies". Maybe this is what you expected it to do, but right now it is showing a HUGE unrealized loss on USD of almost 70%.

How is that?

Steve

[Pietpiraat]

The '' Balance by day '' function is lovely but i would like to have one button to print it all out because now i can say PDF or PRINT TABLE but the rows are all very messy !
I think this should be something to consider updating as i can really use that function.

[Dario3000]

The '' Balance by day '' function is lovely but i would like to have one button to print it all out because now i can say PDF or PRINT TABLE but the rows are all very messy !
I think this should be something to consider updating as i can really use that function.

Thanks,
Yeah it's hard to export cells with multiple line breaks.
Have a look again. It's much better now
I have updated all exports today (copy, print, PDF, CSV and Excel).

The readability of the PDF will depend on the amount of coins you have.
For more than 10 different coins, I would recommend to use the Excel export and print it from there.

Hi guys,
I saw you made some more tweaks to the Realized/Unrealized Gains page and I got a very strange result. I have it set to "Best Prices", "Average of Unsold Assets as Cost Basis", "In USD" and "All Currencies". Maybe this is what you expected it to do, but right now it is showing a HUGE unrealized loss on USD of almost 70%.

How is that?

Steve

Have a look at the second table "Realized Gain / Loss for all Sales" and sort by "Cumulated Cost per Unit" ascending.
If there are any entries with a 0 cost basis, there was no buy for this sale and this may lead to wrong values.

Dario