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

[dp_]

Can I delete old tax reports or update them?

[Bermuda666]

Hi @dp_

Thank your for asking these questions. Let´s go into it:

Can I delete old tax reports or update them?

Yes you are able to delete your Tax-Report. Click the edit button on the right side, below the table with your created Tax-Reports.
You can edit it after the export in a certain file, or by creating a new one.

Usability: I always need to change the "Show entries" value and the table sorting after a refresh. Why it cannot remember my last selection?

Ok thanks for the suggestion. We´ll keep it in mind and will think about a possible change in the future.

How do I handle following situation?
An OUT transaction of Bitcoins includes the fee in the value.

Code:

OUT; value: 1,00010000 BTC; fee: 0,00010000 BTC

-> sent 1,00000000 BTC
An OUT transaction of Waves does not include the fee in the value.

Code:

OUT; value: 100.00000000 WAVES; fee: 0,00100000 WAVES

-> sent 100.00000000 WAVES; what happens with the fee of 0,00100000 WAVES?
What, if the fee is not in the currency of the value?

Code:

OUT; value: 1.00000000 BTC; fee: 0,00300000 WAVES

-> sent 1.00000000 BTC; what happens with the fee of 0,00300000 WAVES?
I think, there should also be also a checkbox if the fee is included in the value or not.
In Waves, I have also coins (or tokens?) like Waves Classic, Midgetcoin, Pizza, Quake and so one, that I cannot represent with any available coin from the list. There is also a hard character limit for the currency name and whitespace is not allowed...

You need to switch the Enter Coins table to "Table View: Extended" first.
After that you will be able to enter fees for trades, deposits and withdrawals.
There's a FAQ article providing a detailed instruction:
https://cointracking.info/feedback.php

There you can also find information about Coins that are not listed.
"ICO Coins or assets that are not listed on any exchange yet can still be registered in your CoinTracking account.
To do this go to the Enter Coins page, create a new trade and enter the amount and currency of the purchased Coin or Asset. (The currency will not be displayed in the drop-down, but can still be saved.)
Once the new currency has been saved, it appears in the 'Summary' box on the right.
The currency value will be dashed. Click on it to enter a custom price."

Please use a shortcut without a space.

Can you please extend the csv and xls import template by a column, so that a row can be skipped?

Ok I´ll forward this request to our specialist and we´ll see what we can do about it.

https://cointracking.info/short_long.php
Do "Deposits & Withdrawals" reset the calculation or only "Trades"?

You can find the "Take into account Deposits & Withdrawals" Checkbox on the right side on this page.
If you activate it they´ll be counted.

I hope this is going to help you.

Best regards,
Keven

[Bermuda666]

@sgjenks01

Hi Steve,

thank you for the further questions.

Dario,
I have a related question: It seems like the amount withdrawn from an account (net of Fees) should match the amount deposited in another wallet. If that is correct, it follows that fees associated with a transfer should reduce the balance in the sending account just like the amount transferred out does.  This does not appear to be the case in CoinTracking. To test this, I manually changed the fee for a transfer out from .002 to 40 Dash to see what would happen. The balance for that currency did not change in CoinTracking. What am I missing here?
Thanks,
Steve

All values entered on Cointracking are with fees included. They are gross.
To change the value of the fee you would have to change the whole amount of the coin. Thus, the field where you can adjust the fee is not taken for calculation purposes. It´s only an informational value. If you change it, it does not change your balance. We decided to do this because you want to see how much money you spent overall and not just the net worth.

Dario,
I have a strange one. I don't know if it is a problem with the export from Bittrex, a reporting problem on the exchange, or a problem with CoinTracking or all of the above. I have two DASH transactions. On each trade, I purchased DASH and then almost immediately transferred it to my own wallet. In each transaction, the Bittrix account online shows that the net amount transferred out is .002 less than the net purchase, which I presume reflects a network fee, but no fee is reflected in the Transfer out transactions. The transfer in transactions on my wallet match the net send transactions from Bittrex. Since there is no fee reflected in the out transactions, I might think the Dash balance on Bittrex would be .004 DASH. But it's not, the Bittrex balance is zero Dash. Which would be correct if the .004 difference is network fees, despite the fact that transfer fees aren't accounted for anywhere. Now here is the really strange part: The Dash balance shown in CoinTracking is .002 Dash. One would think that it would either be .004 or zero, but NOT .002.
Also, if I edit the Bittrex out transactions to reflect the presumed .002 network fee, it has no impact on the coin balance in CoinTracking, which I guess makes sense.
Any idea what is going on?
Thanks,
Steve

Please take a look at this page:
https://cointracking.info/feedback.php under "How do I enter my fees" for more information, about this question and the previous one.

Most exchanges only show you the net worth of your transactions, because they don´t like to show the costs they charge you. We at Cointracking want to show our users the gross value. This is more realistic and we handle it the same way as banks or other institutions do it. It´s just the way we decided to do things.

I hope this is helpful for you.  

Best regards,
Keven

[Bermuda666]

Hey again @dp_  

I have following problems:

2.
Automatic API Wallet Import for ETH
TheDAO transactions have been not imported.

4.
Manually importing the exported Bitstamp transactions
The calculated balance is wrong. Bitstamp exports the value without the fee included. Cointracking wants the value with the fee included, or not?
Automatically imported BTC and ETH transactions have the value with the fee included.

Ok we are going to take a look into this and if necessary work on a correction for it. Thanks for reporting.

3.
Automatic API Wallet Import for BTC, ETH
The fees are not imported.
How can I re-import old wallet transactions from a saved transaction job?

You could just delete the API job and set it up once more. This way all your transactions will be imported to Cointracking again, plus all future transactions.
I´ll forward the information about the missing fees and hope we´ll find a solution for that sooon.

Please have some more patience, while we are working on that.

Best regards,
Keven

[dp_]

All values entered on Cointracking are with fees included. They are gross.
To change the value of the fee you would have to change the whole amount of the coin. Thus, the field where you can adjust the fee is not taken for calculation purposes. It´s only an informational value. If you change it, it does not change your balance. We decided to do this because you want to see how much money you spent overall and not just the net worth.

This is not going to work. A Bitcoin transaction does include the fee in the whole amount -- fine. But an Ethereum transaction does not include the fee in the whole amount. It is separately shown/accounted. And a cointracking record should do that too, so that I can put both on top of each other and compare them correctly.

Now the worst part: A Waves transaction can have Bitcoins as amount but the fee is paid in Waves. Even if I could add on the fee to the amount, my balance will be not correct anymore. I need an extra cointracking record to correct the balance.

[Bermuda666]

This is not going to work. A Bitcoin transaction does include the fee in the whole amount -- fine. But an Ethereum transaction does not include the fee in the whole amount. It is separately shown/accounted. And a cointracking record should do that too, so that I can put both on top of each other and compare them correctly.

Now the worst part: A Waves transaction can have Bitcoins as amount but the fee is paid in Waves. Even if I could add on the fee to the amount, my balance will be not correct anymore. I need an extra cointracking record to correct the balance.

Hey again @dp_

thanks for the reply. (:

You know the Cryptocurrency business is a really fast moving branch.
We do our best to stay always up to date in this continously changing field. But sometimes we have to decide either for one option or another, to keep things going.

Sure, we try to improve our service all the time and hope to find a solution if this is going to be a major problem, for many users.

We are going to discuss your suggestion and hope to find a good compromise.

Thank you for contributing.

Best regards,
Keven

[Pietpiraat]

When viewing balance by day and i try to make a pdf from it, it isn't showing all currencies correctly and it seems its not fitting on the paper,
Can you make it that it fits ?

[Bermuda666]

When viewing balance by day and i try to make a pdf from it, it isn't showing all currencies correctly and it seems its not fitting on the paper,
Can you make it that it fits ?

Hi @Pietpiraat

thank you for submittig this problem.

I added this one to our todo list and we try to fix it as soon as it is possible.

Please be patient, our list is long at the moment.

Best regards,
Keven

[Pietpiraat]

When viewing balance by day and i try to make a pdf from it, it isn't showing all currencies correctly and it seems its not fitting on the paper,
Can you make it that it fits ?

Hi @Pietpiraat

thank you for submittig this problem.

I added this one to our todo list and we try to fix it as soon as it is possible.

Please be patient, our list is long at the moment.

Best regards,
Keven

Sure, much appreciated what you guys are doing keep it up

[sgjenks01]

I tried to edit a job in the Alt Coin import area because i had two addresses and transactions for DASH and noticed that I could include both addresses in one job, but when I clicked on edit, it brought up the details of the job, but no way to edit them.

Thanks,

Steve

[sgjenks01]

Dario,
I have worked with CT a LOT during the past several days and have learned some things the hard way that I wish I could have read about instead. Perhaps you could create a “READ THIS FIRST” file. I think it would cut down on questions here in BitCoinTalk and also improve user experience. There are probably more ideas that could be include, but these are things that I think should be in such a file:

•   CoinTracking assumes all Buy/Sell and transfer amounts are the Gross cost of the transaction. This means the Buy/Sell amounts should include all exchange and network fees. This way it shows you the Profit and Loss after expenses. If you believe an exchange or wallet is sending Net values in the amounts columns, please let us know so we can investigate and correct the issue.
•   The Fee column, together with the underlying Currency the fee is reported in is there to help you keep track of expenses. What you put in these columns has NO effect on your balances. There is a reporting function called Trading Fees where CoinTracking converts all the fees to USD for you. Be sure that the underlying currency column has a currency listed or CoinTracking will ignore that transaction cost. This is easy to check. Simply sort the table by Fee and then look at all the transactions with an associated fee that don’t have a currency reported.
•   When CoinTracking does an import from anywhere, it looks to see if there are any transactions were already imported and ignores them. It is important that you NOT edit any imported field values. CoinTracking will re-import any transactions that you may have edited and then you have duplicate transactions.  
•   ShapeShifter allows one to exchange coins without having to move the funds to an exchange and then back to your wallet afterward. Many users find this a good approach to keeping their currencies safe. Shapeshift doesn’t require the user to provide any personal information to execute the trade. Because of this, you need to either write down or take screenshots of the information about the exchange as it happens. If you don’t, you will have no record of what was exchanged for what or what the fees were.

Moving on, I have some ideas that I think will help users maintain their data.

•   The “Table Backup” function should be somewhere on the menu structure. Right now, it’s just buried as a link on an import page.
•   I see a fair amount of dialog in BitCoinTalk about needing to change the table to Extended View to perform certain functions. I suggest you simplify by eliminating the choice and just have an Extended View.
•   The advanced search function is awesome. The link should be a bit more prominent. I didn’t know it was there for quite a while. Using it from the beginning could have saved me a lot of time.
•   One thing I do when trying to figure out what might be wrong about a transaction is use the filter to find a transaction. Then I want to see the transactions around that transaction, so I turn off the filter. Then, of course I have no idea where the transaction actually was that I just found. You could solve this by numbering all the rows of transactions. These numbers shouldn’t change when filtering is done. That way, the user can go right to the transaction after turning off the filter.
•   When working with CoinTracking, I discovered that the Bulk Delete button doesn’t do anything. It brings up a dialog that allows some customization of the bulk delete, but once the selections are made, nothing is deleted.
•   In the section above, I recommended cautioning users about editing imported transactions. You could aid in that by somehow highlighting the rows that were imported vs manual entries. You could either bold the imported rows or put an asterisk on the imported rows.

Sorry this turned into such a book, but I had a lot of ideas.  

Steve

[Bermuda666]

I tried to edit a job in the Alt Coin import area because i had two addresses and transactions for DASH and noticed that I could include both addresses in one job, but when I clicked on edit, it brought up the details of the job, but no way to edit them.

Thanks,

Steve

Hi @sgjenks01

thanks for your question.

Please create two seperate jobs if you have two seperate adresses. This could be the cause of the error.
If you do this, it should solve your problem quickly. Please try it and let me know if it worked.

Best regards,
Keven

[Bermuda666]

Dario,
I have worked with CT a LOT during the past several days and have learned some things the hard way that I wish I could have read about instead. Perhaps you could create a “READ THIS FIRST” file. I think it would cut down on questions here in BitCoinTalk and also improve user experience.

Hey again @sgjenks01,

I wanted to say thank you for going into so many details and the work you put into this.
It shows you understand our software very well.

I like the idea of a “READ THIS FIRST” file, we are going to talk about it and if that would be a good way to improve the user experience on our website. Nice idea.  
Most of the things are either already mentioned in the FAQs, the descriptions or the documentation, but maybe to read about them bundled before starting is a good thing.

Also thanks for your ideas and suggestions. I pick them up. We will take every single one very serious and we are going to talk about a possible integration.

Your contribution is really much appreciated and we are proud to have such active users like you. This helps us to become better every day.

Enjoy the day.
Greetings,
Keven

Update:
I just read your problem with filtering the bulk deletion. Please be sure you picked an option in the upper section of the Pop-up window. Otherwise nothing can be filtered. Please read the text below. Hope this solves the problem.

[sgjenks01]

Kevin,

First, re Bulk Delete: I checked the box at the very top that says "Delete all trades". That was the only box I checked.

When I just tried to log in to be sure what the box was actually called, I got this: "cointrracking info says: DataTables warning: table id=trade_table - An error occurred while connecting to the database 'my-btc'. The error reported by the server was: SQLSTATE[0804] [1040] Too many connections"

I hit refresh and the table loaded. Sounds like a possible capacity issue?

Steve

[Dario3000]

Hey sgjenks01,
Sounds to me like your bulk delete was not finished when you have reloaded the page.
There will be a message in the bulk delete box, once all trades have been deleted.
Best, Dario

[bitbadger]

Hi, I registered to use CoinTracking free version at the start of the year and used it for a short while (I soon reached the max free trades) and then forgot about it.

I've just come back to have a look again. I'm a professional trader so I am looking for a portfolio management system which can meet most or all of my requirements.

I need a system which automatically records and updates my trades with real time API data, produces reports, stats and graphics, and also produces accurate tax information (for Germany where I am currently based). So CoinTracking looks pretty good on these points. 

I long since reached the free trades limit back at the start of the year as I'm a high volume trader so I would be looking to purchase the pro version.

What I ideally also need is the functionality to split the portfolio into different sub-portfolios as I work on my trades according to different criteria according to which portfolio each coin/position belongs to. 

Obviously I need a total overview of all positions, but I also need to be able to assign coins/positions to different sub-portfolios.

Is it possible to do this with CoinTracking? Or if not, can such a facility be programmed?


 

[sgjenks01]

@ Dario re Bulk Delete. There was no indication that it was doing anything. That's a problem for impatient users. 

[bm303]

So I got everything imported from the 3 exchanges I use. Bittrex, Kraken, Pol. The issue is that I am 5 BTC negative. I can't figure out why. Is Bittrex not importing my deposits and only importing my trades? Same for Poloniex? Kraken is the only one with the correct BTC balance. The rest are negative. Very confused here. Thanks.

[sgjenks01]

@BitBadger
I'm a new user, but I have used CoinTracking extensively. I thought I would give you my thoughts from the perspective of a user.

Re the real time API. It depends on how "real time" you want/need. CT will automatically import once a day. However, once you have set up the job, you can do this manually once an hour. (Enter Coins => Automatic API imports). If that's not often enough, that will need to be addressed by Dario/Kevin

Splitting trades by portfolio can be done (Enter Coins => Overview and Manual Imports), Once there, you must change to View:Extended (at the bottom of the table). I would also set Inline Editing:On  Set up that way, you should be able to see Groups and be able to click on a trade and assign it to a group to create the "sub-portfolios".  Done at this level, you could assign a transaction for BTC to one Trade Group and another BTC transaction to a different trade group, regardless of what Exchange it was done on. I recommend that you actually set up all this with the 100 trades that will be in CT once you set up all the Imports and Groups. For this test, you don't have to assign real groups just to test it out and one of your groups can be blank for this test (or later), so you don't have to put a lot of effort into checking out if this would work for you.

From my own experience, if you use CT, you will want to assign those groups as soon as the import is done because it could quickly get away from you as to what belongs where. It's also possible to export the entire table to Excel, add the Groups (you could assign multiple transactions this way) and then import the finished spreadsheet. This is where Bulk Delete would come in handy, because you would want to empty the table before you uploaded the revised spreadsheet, otherwise you would probably get double entries. If you take this approach, you would want to put API Imports on Manual so that when you empty the table it stays that way. You can also back up your table before doing any of this so it's easy to recover from any mistakes.

Once you have some groups assigned to some trades, you can view a report (Reporting => Balance by Exchange). At the top of the report, there is a button titled: Group by Trade-Group. This is referring back to the Groups you defined above. That probably isn't exactly what you want for a report, but you can see how it works. I think the report you would want is Reporting => Realized & Unrealized Gains. Unfortunately, that page is only displayable by currency right now. However, I'm guessing that Dario could add a couple of buttons to toggle back and forth between Currencies and Trade Groups. He might even be able to have the Groups report give the user Gains/Losses grouped by Trade Group, then by Currency.

So, my recommendation to you is to use your free access to test out these ideas to see if it will meet your needs and go from there.

I hope this helps.

Steve

[sgjenks01]

@ Kevin and Dario,
It would be nice if CT "remembered" the user's choice for the number of rows to display. When I'm working on transactions, I often go run a report to see if what I did is correct. Then when I go back to the Table, I have to select the number of rows again. Not a big deal, but an annoyance just the same.

Also, I thought of a better name for "READ THIS FIRST". Call it a "Quick Start Guide". Not an original name, but would draw the eye of a new user.

Steve