Author

Topic: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies - page 102. (Read 122389 times)

newbie
Activity: 4
Merit: 0
Dashboard reported amount does not match amount shown  on ethplorer.io.


I've imported my purchases and trades from Bittrex without any issue.  I transferred all of my ETH to my Trezor, which has a MEW address.  The amount shown in Trezor/MEW matches ethplorer.io, however, the Cointracking database underreports my ETH by about 25%.  I have deleted and reimported my trades and MEW address multiple times, but cannot get Cointracking database to match the amount in MEW.

Additionally, when I manually input a trade to reflect the difference, the Cointracking database then overrepresents the ETH amount. 

 
Any suggestions?
newbie
Activity: 7
Merit: 0
Hey there,
When I export my trade history from exchange platforms (such as GDAX and Bittrex) and import them into Cointracking, I noticed the trade timestamps change by -2 hours. As a result, my portfolio value is quite inaccurate.
My timezone is correctly configurated in those exchange platforms (UTC+1), but when it comes to Cointracking it changes all the times to UTC -1. My Cointracking account timezone is UTG+1 aswell.

Here are two screenshots featuring a trade I did on Bittrex that illustrates my issue: http://imgur.com/a/o6jku

Can you help?
Cheers
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
@Prodigy4
I have checked your BTC address.
There are 6 transactions and all of them have already been imported into your account.

Dario
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Hey, all transactions are checked every few hours.
What time was the last BTC transaction for your address?

Please let me know via support ticket, so I can have a look if it does not import it within the next 2-3 hours.

Dario
newbie
Activity: 5
Merit: 0
The import of my BTC wallet transactions worked perfectly but now it doesn't add the future transactions. How can I fix this?
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Thanks,

Yeah, there was already a coins called HERO.
As soon the new coins will be listed here coinmarketcap.com or here cryptocoincharts.info (currently having issues), it will be listed automatically on CoinTracking.
This happens usually 0-3 days after a coins was listed on an exchange.

Dario
member
Activity: 91
Merit: 10
Hi Guys,

On a different subject, I see that HERO is now listed as a "Dead Coin". It's anything but. Perhaps there was a coin called HERO that "died", but HERO is alive and well and trading on the Bitshaes Exchange.

Here's the latest quote:

HERO : bitUSD
price: 159.83101
volume: 14.97k
change: 3.12%

Can you bring it back from the dead?

Thanks,

Steve
member
Activity: 91
Merit: 10
Adding minings into that calculation could result in a cost basis of 1200 USD.
The value would still be correct, but I does not tell you the break even of your trades any more, but for a mix of trades and minings.

@Dario,
If only my mining would result in a cost basis of 1200 USD!  Smiley

But I do see your point. An analogy in stocks might look at mining activity like dividends. If you have a stock that pays dividends, you can evaluate your trading based on the price you paid or you can look at your total investment by reducing the basis by subtracting the dividends. Both points of view are valid and are for two different purposes. I think the explanation you added to the Info popup clearly explains what the button does. I'm just not sure people using the platform will understand the reasons for displaying the results two different ways. But maybe I'm just a little slow sometimes.  Huh

Thanks,

Steve
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Sorry for the IOTA issues.
Multiple price APIs have changed the ticker and the decimals already 5 times in the last 3 days.
I really hope this was the last time Smiley

All IOTA prices are back again.


@sgjenks01:
It's just a recommendation and not a must-use option.
I'm using the gains page myself to see the profit I already did with my trade-sales and the profit I could achieve right now by selling my assets.
Adding your minings into that calculation will always distorts the values as they don't have a cost basis.

Let's say your overall cost basis is 2600 USD per BTC and the current price is 2500 USD.
It tells you to wait for the price to go up by 100 USD to break even.

Adding minings into that calculation could result in a cost basis of 1200 USD.
The value would still be correct, but I does not tell you the break even of your trades any more, but for a mix of trades and minings.

But that's why I have created a checkbox for this option. You can enable and disable it, to check both possible values.


@BitcoinPC:
You can register completely anonymous. You do not even have to enter an email address.
Our tool was designed for your convenience, so you do not have to track thousands of trades by hand in a list.
If you don't like it, use Excel Wink

Have a great weekend,
Dario
member
Activity: 85
Merit: 10
We are sorry guys,

at the moment there seem to be big problems with IOTA and our price is not correct.

We are currently working on that and we just wanted to let you know.

Please have patience. We hope we are able to fix it as soon as possible.

Thank you.

Beat regards,
Keven
hero member
Activity: 812
Merit: 500
It looks interesting but seems that you have the clients collecting all the info themselves.  We stopped at the first entry.  If I have to get the buy in price, sell price and all of that, then why don't I simply do the last few little steps myself and graph the info.  No one is going to give you account access to other accounts, which would be the only real way to get this done, because there is no reason to trust you.
member
Activity: 91
Merit: 10
I have added a new function into the gains page called "Add Deposits & Withdrawals to remaining amount"
Activating this function will show the same values as in the dashboard.

Disable: Calculates all gains and the costs basis from trades only. (recommended)
The remaining amount of a coin can deviate from the values in the dashboard, because deposits and withdrawals will not be included.

Dario,
Thanks for implementing a solution so quickly.

However, I am curious why you recommend not using this option.

In the case of deposits from mining, shouldn't the basis of those coins be zero and thereby "average down" the cost basis of all those coins which are owned?
Conversely, if a person sells a coin in exchange for goods and services (a withdrawal), wouldn't that result in a gain or loss on the number of coins sold using the current market price of the coin versus the basis for all coins owned at that point in time based?

Please help me understand your recommendation.

Thanks,

Steve
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Bitcoin price in cointracking.info has been stuck at $2,503.83 for several hours now.

Thanks. It's updating again.
BitcoinAverage has disabled their old free API without letting users know Smiley
legendary
Activity: 1708
Merit: 1036
Bitcoin price in cointracking.info has been stuck at $2,503.83 for several hours now.
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Do I need to pay for each account if I link them? I am using a trading bot which generates thousands of trades. It would be nice to separate each account out, but might become very costly to do that.

Thanks.

Hey coolcash,

No, you don't have to pay multiple times Smiley

See the info on the upgrade page:
For users with multiple accounts, all current and future accounts will be upgraded when purchasing CoinTracking Pro or Unlimited.

Best, Dario
newbie
Activity: 30
Merit: 0
Do I need to pay for each account if I link them? I am using a trading bot which generates thousands of trades. It would be nice to separate each account out, but might become very costly to do that.

Thanks.
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Hey guys,

I have added a new function into the gains page called "Add Deposits & Withdrawals to remaining amount"
Activating this function will show the same values as in the dashboard.

Disable: Calculates all gains and the costs basis from trades only. (recommended)
The remaining amount of a coin can deviate from the values in the dashboard, because deposits and withdrawals will not be included.

Enable: Includes all deposits and withdrawals into the calculation.
Gains and the cost basis will change as deposits and withdrawals do not have a cost basis.

member
Activity: 85
Merit: 10
Dario & Kevin,
I ran into issues when I sold all BTC and ETH because I had errors related to the ShapeShift transactions I didn't keep good records on. These errors caused the balances to be negative, which, as you know, CT can't deal with, so it showed realized gains at zero and losses at zero. To try to figure out the errors, I decided to use the "Double Entry List" report. Doing this actually helped me find the gross errors, but the totals still didn't match what I expected.

While doing this, I noticed that the Double Entry List pulls Fees out of the Fee column and puts it as an "Out" transaction. This means that if I add up all the Ins and Outs for a particular currency, I get a different answer than the Remaining Amount that shows on the Realized/Unrealized page. So, I thought if I just strip out all the Out transactions for fees that I would get a total quantity by currency from the Double Entry List that would match the quantities in the Remaining Amount column of the Realized and Unrealized Gains page.

Unfortunately, it didn't turn out that way. The totals from the Double Entry List (without Fees) is almost always an amount lower than the amount reported on the Realized Gains and Losses page. It's usually a small amount - just a fraction of a coin. But with BTC, the totals disagree by 0.25 BTC, which at today's prices is a pretty hefty difference how much is being reported.

You might be wondering how I got the numbers. I started with the raw output from the Double Entry List and then filtered out all the fee transactions and deleted them. Next, I downloaded the Realized Gains and Losses spreadsheet. I transposed it so that the totals and currency symbols go across the page instead of down. Then I wrote Excel formulas to only extract data into a column if the symbol matched the cell containing the symbol from the Realized Gains and Losses sheet. The formulas looked for In or Out in the transaction type and changed all the Out transactions to a negative number. Next, I calculated a running total and it's that total that I compared with the amouts from the Remaining Amount column. So, in essence, I wound up with a spreadsheet with the transactions running down the page on the left with all the symbols running across the page. Each column in that array only contains transactions that relate to that column's symbol and all the Out transactions are negative quantities.

It seems to me that the quantity from the Gains and Losses page should match the sum of all non-Fee transactions for that currency, and they don't. What am I missing?

Steve

Sorry for the "book".

The book continues... I did some more digging on this and what I have found is that the Double Entry List (minus the Fee entries) either matches exactly with a tally of the wallet totals for that currency or very, very close. On BCN, I had a transaction where I moved BCN from a miner to the "Main" wallet and then decided to create a "Miner" wallet and move those funds over. I end up with a discrepancy of ZERO between the IN?OUT totals and the wallet totals. But the total from the Realized and Unrealized page doesn't account for the coin moved to the "Miner" wallet AT ALL. Similarly, with BTC where I had a discrepancy of over .25 BTC when comparing the IN/OUT total to the Realized and Unrealized page where the difference between the IN/Out total and the actaul wallet values is .0003147 BTC or about 75 cents. With BTS, the error is the opposite of that found in BCN. Here the Realized and Unrealized total is overstating the available balance, where the difference between what the wallets say I have and the In/Out totals is off by .01213 BTS or 0.4 cents.

Anyway, I hope you see that the In/Out totals (excluding Fees) agrees very closely with what is in the wallets and the totals from the Realized and Unrealized Gains page does not.
Steve

Hey Steve,

ok, thank you for going into this.  Smiley

We have to check your statements in detail and this could take a while,
since there is a lot of stuff to do at the moment.

Please have patience. Thank you.

Best regards,
Keven
member
Activity: 91
Merit: 10
Dario & Kevin,
I ran into issues when I sold all BTC and ETH because I had errors related to the ShapeShift transactions I didn't keep good records on. These errors caused the balances to be negative, which, as you know, CT can't deal with, so it showed realized gains at zero and losses at zero. To try to figure out the errors, I decided to use the "Double Entry List" report. Doing this actually helped me find the gross errors, but the totals still didn't match what I expected.

While doing this, I noticed that the Double Entry List pulls Fees out of the Fee column and puts it as an "Out" transaction. This means that if I add up all the Ins and Outs for a particular currency, I get a different answer than the Remaining Amount that shows on the Realized/Unrealized page. So, I thought if I just strip out all the Out transactions for fees that I would get a total quantity by currency from the Double Entry List that would match the quantities in the Remaining Amount column of the Realized and Unrealized Gains page.

Unfortunately, it didn't turn out that way. The totals from the Double Entry List (without Fees) is almost always an amount lower than the amount reported on the Realized Gains and Losses page. It's usually a small amount - just a fraction of a coin. But with BTC, the totals disagree by 0.25 BTC, which at today's prices is a pretty hefty difference how much is being reported.

You might be wondering how I got the numbers. I started with the raw output from the Double Entry List and then filtered out all the fee transactions and deleted them. Next, I downloaded the Realized Gains and Losses spreadsheet. I transposed it so that the totals and currency symbols go across the page instead of down. Then I wrote Excel formulas to only extract data into a column if the symbol matched the cell containing the symbol from the Realized Gains and Losses sheet. The formulas looked for In or Out in the transaction type and changed all the Out transactions to a negative number. Next, I calculated a running total and it's that total that I compared with the amouts from the Remaining Amount column. So, in essence, I wound up with a spreadsheet with the transactions running down the page on the left with all the symbols running across the page. Each column in that array only contains transactions that relate to that column's symbol and all the Out transactions are negative quantities.

It seems to me that the quantity from the Gains and Losses page should match the sum of all non-Fee transactions for that currency, and they don't. What am I missing?

Steve

Sorry for the "book".

The book continues... I did some more digging on this and what I have found is that the Double Entry List (minus the Fee entries) either matches exactly with a tally of the wallet totals for that currency or very, very close. On BCN, I had a transaction where I moved BCN from a miner to the "Main" wallet and then decided to create a "Miner" wallet and move those funds over. I end up with a discrepancy of ZERO between the IN?OUT totals and the wallet totals. But the total from the Realized and Unrealized page doesn't account for the coin moved to the "Miner" wallet AT ALL. Similarly, with BTC where I had a discrepancy of over .25 BTC when comparing the IN/OUT total to the Realized and Unrealized page where the difference between the IN/Out total and the actaul wallet values is .0003147 BTC or about 75 cents. With BTS, the error is the opposite of that found in BCN. Here the Realized and Unrealized total is overstating the available balance, where the difference between what the wallets say I have and the In/Out totals is off by .01213 BTS or 0.4 cents.

Anyway, I hope you see that the In/Out totals (excluding Fees) agrees very closely with what is in the wallets and the totals from the Realized and Unrealized Gains page does not.
Steve
member
Activity: 91
Merit: 10
Dario & Kevin,
I ran into issues when I sold all BTC and ETH because I had errors related to the ShapeShift transactions I didn't keep good records on. These errors caused the balances to be negative, which, as you know, CT can't deal with, so it showed realized gains at zero and losses at zero. To try to figure out the errors, I decided to use the "Double Entry List" report. Doing this actually helped me find the gross errors, but the totals still didn't match what I expected.

While doing this, I noticed that the Double Entry List pulls Fees out of the Fee column and puts it as an "Out" transaction. This means that if I add up all the Ins and Outs for a particular currency, I get a different answer than the Remaining Amount that shows on the Realized/Unrealized page. So, I thought if I just strip out all the Out transactions for fees that I would get a total quantity by currency from the Double Entry List that would match the quantities in the Remaining Amount column of the Realized and Unrealized Gains page.

Unfortunately, it didn't turn out that way. The totals from the Double Entry List (without Fees) is almost always an amount lower than the amount reported on the Realized Gains and Losses page. It's usually a small amount - just a fraction of a coin. But with BTC, the totals disagree by 0.25 BTC, which at today's prices is a pretty hefty difference how much is being reported.

You might be wondering how I got the numbers. I started with the raw output from the Double Entry List and then filtered out all the fee transactions and deleted them. Next, I downloaded the Realized Gains and Losses spreadsheet. I transposed it so that the totals and currency symbols go across the page instead of down. Then I wrote Excel formulas to only extract data into a column if the symbol matched the cell containing the symbol from the Realized Gains and Losses sheet. The formulas looked for In or Out in the transaction type and changed all the Out transactions to a negative number. Next, I calculated a running total and it's that total that I compared with the amouts from the Remaining Amount column. So, in essence, I wound up with a spreadsheet with the transactions running down the page on the left with all the symbols running across the page. Each column in that array only contains transactions that relate to that column's symbol and all the Out transactions are negative quantities.

It seems to me that the quantity from the Gains and Losses page should match the sum of all non-Fee transactions for that currency, and they don't. What am I missing?

Steve

Sorry for the "book".
Jump to: