Author

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

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".
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Is their a way to show the ''total value'' without sum currencies ?
Because when i decide to sell for euro i would like to not show it in the total value anymore.

Sum Coins:       1.458,84 €
Sum Currencies:    500,00 €
Total Value:       1.958,84 €

Hey, the "Total Value" without currencies is exactly the "Sum Coins" value.
So you can just use this one if you're not interested in your currencies.

As an alternative you could add a withdrawal of 500 EUR to equal both values.
But the first solution is much easier.


so now i delete all data till my date but avery day after avto import it load all data including before 10/06/17 .

Yes, the API import will always re-import all trades once they have been deleted.
I have this "time-period" feature already on my todo list.

But there is a workaround for now:
Go to the Enter Coins page, and select all your older trades you don't want (use the SHIFT key to select multiple entries at a time).
Click now on the "edit" button and set the "buy amount", "sell amount" and "fee amount" to 0.
This will overwrite all selected trades with 0 and because they are not deleted, they will not be re-imported or overwritten by the Polo API.

Best, Dario
newbie
Activity: 1
Merit: 0
Hello, who can help me solve my problem.
i bought Unlimited license for cointracing but cant set up it as i need.

i have 3 Poloniex acc and 1 Bittrex
so i want all info be imported using API from all this acc.

and here the problem i have. I need all data from 3 poloniex acc be imported only from certain date 10/06/17 and Bittrex from the opening acc is ok.

so now i delete all data till my date but avery day after avto import it load all data including before 10/06/17 .

so how i can setut my acc for this?

regards
sr. member
Activity: 326
Merit: 250
Is their a way to show the ''total value'' without sum currencies ?
Because when i decide to sell for euro i would like to not show it in the total value anymore.

Sum Coins:       1.458,84 €
Sum Currencies:    500,00 €
Total Value:       1.958,84 €
        
member
Activity: 61
Merit: 11
Hey moftkhor,

Currently not, but I will add that to our to do list.
Right now we have 30 different colors. Once you have reached 30 coins, the colors will repeat.
I could add more than 30, but I guess it will be hard to see a difference Smiley

Best, Dario

Well, there's no need for more colours really. Only the choice of colour for each coin is more than enough.  Wink
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Hey moftkhor,

Currently not, but I will add that to our to do list.
Right now we have 30 different colors. Once you have reached 30 coins, the colors will repeat.
I could add more than 30, but I guess it will be hard to see a difference Smiley

Best, Dario
member
Activity: 61
Merit: 11
Is there any way to change colours on the coin diagram 'Value each Currency in EUR.'
There are too many kinds of blue on 1 circle diagram right now and that makes it a little messy when there are numerous coins on 1 diagram.
Can we customize the colors?
member
Activity: 85
Merit: 10
@ Dario,

You are welcome.

I have another feature request, which I had been meaning to put in, but you beat me to it, sort of. You changed the interface so that if the balances need to be recalculated, you put up a dialog asking the user to push the button. My idea was to have CT do something more automatic. Here's why:  As long as the user is changing the table by manual entry or import, CT should do no recalculating. But as soon as the user asks for a display of the data in any form, except the Data Input Table, CT should check to see whether anything has changed since the last recalculation (which you have always been doing) and if it's needed, just go ahead and recalculate and display the same progress bar that you do now.

Here's why I say that. If I have been adjusting transactions, or putting them in. When I want to see what happened to the results, i will most commonly ask to see the Balance by Exchange report because it gives the sort of sub-totals I want to be sure line up with what is at the exchanges and/or wallets. But here's the thing: I already know a) that I made changes, and b) that to check them, recalculations have to be done. So why ask me? By adjusting and entering transactions and then asking for a report, I know that such action will require a recalculation, so just do it! Smiley

Thanks,

Steve

Hey Steve

Thanks again for your suggestion. I just put it on the todo list and we will talk about it.

Wish you good investings.

Best regards,
Keven
member
Activity: 91
Merit: 10
@ Dario,

You are welcome.

I have another feature request, which I had been meaning to put in, but you beat me to it, sort of. You changed the interface so that if the balances need to be recalculated, you put up a dialog asking the user to push the button. My idea was to have CT do something more automatic. Here's why:  As long as the user is changing the table by manual entry or import, CT should do no recalculating. But as soon as the user asks for a display of the data in any form, except the Data Input Table, CT should check to see whether anything has changed since the last recalculation (which you have always been doing) and if it's needed, just go ahead and recalculate and display the same progress bar that you do now.

Here's why I say that. If I have been adjusting transactions, or putting them in. When I want to see what happened to the results, i will most commonly ask to see the Balance by Exchange report because it gives the sort of sub-totals I want to be sure line up with what is at the exchanges and/or wallets. But here's the thing: I already know a) that I made changes, and b) that to check them, recalculations have to be done. So why ask me? By adjusting and entering transactions and then asking for a report, I know that such action will require a recalculation, so just do it! Smiley

Thanks,

Steve
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
You're welcome.
Yeah, it's much faster to find the issue in an account than just guessing what it could be.

Thank you too for answering user questions here at bitcointalk Smiley
I really appreciate it.
Dario
Jump to: