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

New problem here now unfortunately?
I have been able to find a workaround by myself and re-import all of  the 135 transactions including the Timestamp error ones back into Cointracking.

BUT when I open the Trade Prices report it shows that a lot of the transactions have had their "Purchase Value"s changed again by Cointracking.
These were the original records that I exported from Cointracking after having made sure that all the individual transactions showed absolutely NIL difference in 'Sale Value' and 'Purchase Value' by manually editing each affected transaction record before exporting them and saving the file to my laptop. It is this .csv file of the saved Enter Coins' transactions that I have re-imported today.

So the question is why does Cointracking do this when the correct information is manually entered in a lot of cases and then the records are saved?? Cointracking is obviously overriding the users data that the user has entered and saved?? WHY???

Then how is this problem then solved for the future as I have other records that I wish to export then later re-import them as and when needed??
I await some informed advice from Cointracking support

Ah Mr Cointracking nice of you to reply to SpringChicken, He is indeed a fortunate person to have received your attention.
It would be extremely nice and very polite if you would also address my outstanding queries that predate this query.
Especially this fundamental one which I reprint here for your easy access. This goes to the very core of the problems that are introduced by Cointracking into every transaction that is imported by .csv and deserves an answer so that we all know how and why this problem is introduced. Is the reason that you have not bothered to respond to my query because you do not have an answer to why there are 5 different values for the one transaction, maybe??

Hello
I have been trying to get Cointracking to function accurately since December with very mixed results unfortunately.
So I thought I would go back to basics and start again in trying to understand the workings of this mysterious software.
To this end I set up a new empty account and have been trying some dummy entries to try and understand how this software works but I am even more confused now.
Does anyone have any valid explanation as to why there are 4 different values that appear when I simply enter a sample buy transaction as shown below?

Interestingly and very confusingly Cointracking provides 4 differing values for a 1 BTC purchase on the nominated date and time which just serves to muddy the waters and potentially produce reports that are wrong. Check it out yourself but in my example below this is what I found for the

1 BTC dummy purchase on 24 /02 /2019, I Entered $5898 as the Cost and $898 as the Fee and Home as the Exchange

$5898    The actual fiat cost value entered into the Enter Coins page (copied from LiveCoinWatch), Populates to the Sales Value box

$5870    Cointracking automatically inserted this figure in the Purchase Value box disagreeing with the above Sales Value box? Why?
$5535    The Cointracking Coin Calculator for 1 BTC on the purchase date value showed this figure when I checked out of interest. Why?
$5875    Showed as the current value of 1 BTC in the Summary box on the Enter Coins page at the exact  time of the purchase entry? Why
               

Next I checked the Total Realised and Unrealised Gains Report and this report uses the incorrect $5870 that Cointracking inserted automatically as a Cost Value to do the calculation which can only ever be wrong!.
This is further complicated and messed up beyond comprehension when I check the Tax Report / Closing Position Report which shows a 5th differing Cost value now inserted for this one simple purchase transaction of $5786. ?

Is there any wonder that confusion reigns supreme within this software when you have now 5 differing values for 1 BTC at the same date and time. Every transaction entered for every coin will be likewise affected so it would be required to be be very careful and triple check everything as there are potentially so many mistakes.   

The only factual amount was the $5898 that I theoretically paid to buy the 1 BTC and believe it or not the Cointracking software totally ignores the one and only cost value that matters. How could this software ever be relied on to produce correct reports when it uses so many differing values for the same coin?
There has got to be a better more realiable way to manage crypto surely.
I have applied extensive manual editing to correct these mistakes this but it is so labour intensive to make it not really worth the time especially when Cointracking could and should correct their introduced problems so that all of this manual editing is not required.

Maybe I am missing something here so I am open to any advice as to why there should be anymore than the one and only correct cost value used for all calculations.

Hopefully someone very knowledgeable from Cointracking will chime in here and explain this for all of us.

Hi SpringChicken,
I recommend you to explore our software, documentation and FAQ section. Many of your questions can already be answered.
However, I am happy to answer your questions here 

1. you can access our official Youtube channel via the following link:
https://www.youtube.com/channel/UCaCaTC7W9JeuFW34T_OC-wQ
On Youtube you can find many more helpful videos from diligent users.

2. can you please specify this question in more detail?

3. we have a BTC, ETH and Altcoin Wallet Importer that supports many (not all) Altcoins.
Go to "Enter Coins" -> "Wallet Import" in the menu.

4. all transactions (also deposits and withdrawals) should always be entered. You do not have to enter the binance transactions manually. You can import them via the Binance CSV or API Importer:
https://cointracking.info/import/binance/
https://cointracking.info/import/binance_api/

5. The easiest way is to check the transactions for completeness and correctness.
If you are stuck, please send us a ticket via our HelpDesk (https://cointracking.freshdesk.com) and we will check it in your account.

6. the same answer as answer 5. probably the sales or withdrawals are not registered.

7. This question is answered in our FAQ:
https://cointracking.freshdesk.com/en/support/solutions/articles/29000018053-entering-editing-renamed-or-re-branded-coins-e-g-ans-and-neo-/

8. -

9. in which you create a single tax report for each year. You can select the year when creating the report.

Further to my import problem as above I just imported the records to see what would happen. It imported 50 records but not the one with the Timestamp error. I also clicked on see the Raw Data and this reveals that all the dates and timestamps are present and correct in the raw data but Cointracking is not importing them all?
Does anyone have any clues as how to solve this bug?
 And or it would be very nice if someone knowledgeable from Cointracking support finally made an appearance with some advice on their software.
As an aside I tried to import these same records a second time and the software reimported the same 50 records and at the same time showed a message that there were 'No Duplicated Records"? I then had 100 records which were the 50 records DUPLICATED to show 100 records? So it seems that one cannot rely on the Cointracking software to even identify duplicate records when importing, amazing but not surprising I guess. 

Hi. I am new to Cointracking and have a few Qs.
1. Are there video tutorials on how to use the software properly?
2. You do not specify in ur documentation, but does ur software require import of wallet addresses/holdings in order to match up buys/sells and short vs long term?
3. If yes to 2, then can u tell me in detail how I import coins addresses held on Ledger Nano S, Jaxx, and altcoin wallets like Aion, Factom, Ontology, Vechain?
4. When entering coins purchased on Abra manually, do I also need to input the transfer out to Binance to purchase altcoins? Is that under the transfer category?
5. I have noticed at first glance that many of my balances r incorrect. For ex, you say I have much more Eth than I actually do. This tells me you have not accurately noted when I sold eth to purchase altcoins. How do I reconcile this?
6. There are several coins that show a balance but I no longer own. How do I reconcile this ?
7. Several years back I purchased Antshares before it became NEO. You software shows I still own it as AnS. What do I do?
8. In general, it seems the only way I can look for errors is on the unrealized gains/realized gains/ loss page. Is there a better way as today, I only know the balances of each coin I own and the average cost from a separate software tracker.
9. How do I generate tax reports for 2017 and 2018 separately? Thank you for your time!!!

I originally downloaded from my account my Enter Coins data via the Export to .csv button to my laptop.
Now a week later I am trying to re load this same .csv report back into my Cointracking account and I am getting this garbage Timestamp Error messages as shown below.

Error: We couldn't find a timestamp. This trade will not be imported

Import Report:

Validation: Datasets in import file: 135, Transactions: 135
Notes: Duplicate transactions found: 0
Errors: Empty timestamps: 86, Empty values: 0


It is the exact same .csv dataset that was exported by Cointracking and now Cointracking will not import all the records back in?
It is saying there are 86 timestamps missing when they are not missing? They are ALL formated in the EXACT same date format as the 49 records that Cointracking seemingly will accept to import. This is just crazy and so time consuming trying to troubleshoot garbage problems like this that should not exist! I have tried reformatting and clearing the formatting then reformatting the Date column but nothing works!
I have tried cutting the Date column and pasting into a new sheet then changing the Date format and pasting the new Date column back in over the old but no!!!!
 
Does anyone have any advice on how I can solve this this whilst I wait for a timely response from someone from Cointracking to chime in here.
I have not lodged a Ticket with CT as extensive previous experience shows me that it is a complete waste of time and effort.

 

Ok so it has now been 7 days and there is still no advice from anyone at Cointracking as to how or why this happens?
I am pretty sure that others apart from myself would be interested to know why CT inserts so many incorrect values for 1 simple purchase?
Disappointing to say the least.

Hello
I have been trying to get Cointracking to function accurately since December with very mixed results unfortunately.
So I thought I would go back to basics and start again in trying to understand the workings of this mysterious software.
To this end I set up a new empty account and have been trying some dummy entries to try and understand how this software works but I am even more confused now.
Does anyone have any valid explanation as to why there are 4 different values that appear when I simply enter a sample buy transaction as shown below?

Interestingly and very confusingly Cointracking provides 4 differing values for a 1 BTC purchase on the nominated date and time which just serves to muddy the waters and potentially produce reports that are wrong. Check it out yourself but in my example below this is what I found for the

1 BTC dummy purchase on 24 /02 /2019, I Entered $5898 as the Cost and $898 as the Fee and Home as the Exchange

$5898    The actual fiat cost value entered into the Enter Coins page (copied from LiveCoinWatch), Populates to the Sales Value box

$5870    Cointracking automatically inserted this figure in the Purchase Value box disagreeing with the above Sales Value box? Why?
$5535    The Cointracking Coin Calculator for 1 BTC on the purchase date value showed this figure when I checked out of interest. Why?
$5875    Showed as the current value of 1 BTC in the Summary box on the Enter Coins page at the exact  time of the purchase entry? Why
              

Next I checked the Total Realised and Unrealised Gains Report and this report uses the incorrect $5870 that Cointracking inserted automatically as a Cost Value to do the calculation which can only ever be wrong!.
This is further complicated and messed up beyond comprehension when I check the Tax Report / Closing Position Report which shows a 5th differing Cost value now inserted for this one simple purchase transaction of $5786. ?

Is there any wonder that confusion reigns supreme within this software when you have now 5 differing values for 1 BTC at the same date and time. Every transaction entered for every coin will be likewise affected so it would be required to be be very careful and triple check everything as there are potentially so many mistakes.  

The only factual amount was the $5898 that I theoretically paid to buy the 1 BTC and believe it or not the Cointracking software totally ignores the one and only cost value that matters. How could this software ever be relied on to produce correct reports when it uses so many differing values for the same coin?
There has got to be a better more realiable way to manage crypto surely.
I have applied extensive manual editing to correct these mistakes this but it is so labour intensive to make it not really worth the time especially when Cointracking could and should correct their introduced problems so that all of this manual editing is not required.

Maybe I am missing something here so I am open to any advice as to why there should be anymore than the one and only correct cost value used for all calculations.

Hopefully someone very knowledgeable from Cointracking will chime in here and explain this for all of us.

 

It's a personal decision based on what you want to track. I do it in the "Group" field. I use Funding for when I am adding new investment funds and Leached for when I remove/withdraw funds. (I do a lot of mining so I'm tracking PoW & PoS too). Then when you click on the Balance by Exchange tab, change the drop down to Grouped by Trade-Group, you get a quick breakdown of each: Mining, Funding and Leached. You can get the same info via the Tax Report, but this is a quick dashboard and I use it every day.
Good Luck

Is there any benefit to keeping track of USD deposits/withdrawls into Coinbase using Cointracking?

Thanks,

Jeff

It seems like this sounds cool, and is useful for those who have many altcoins, this place is suitable for those investors and those who like to collect lots of coins without making many wallets.

Did you enter the "Type" of transaction as Mining?

This is my first year mining and my CPA told me that my tax report is showing everything as trades and not showing my mining as being mining. How do I go about making sure that the tax report annotates the mining as mining under income report. Currently under income report it show $0 for mining.

Dear CoinTracking User. We would like to inform you about the following changes / improvements:

Updates and Improvements
- Update to the new Kucoin API version
- New Total-View page for all users with multiple accounts
- Binance allocation of BTT and CMT

Updates for the Tax-Report
- As of now, the depot separation (tax lots) can be activated for tax reports
- Update for the Form 8949 PDF Report
- New tax export for 'Drake Software'
- The detailed tax report no longer displays a warning if rounding errors occur after the 8th decimal place
- The TurboTax report now creates one new file per 200 transactions, because TurboTax cannot import more than 200-250 transactions per file at the moment

2 new reports
- 'Missing transactions' help to find missing deposits and withdrawals
- 'Duplicate transactions' search for duplicate entries in your account

Hi alex_cheese,

It is important that the settings on the Gains page are the same as the settings on the Tax Report.
Also, it is not possible to filter the Gains page correctly for a period, as pools + cost base are not calculated outside the filtered period. However, this is important and is taken into account so correctly by the tax report.
If there are still discrepancies, please send us a ticket via our HelpDesk.

Hi

In Short: why aren't realized gains and capital gains the same thing?

I've just bought my second year of subscription to CT. I'm using it to do my tax now and my question is about Realized Gains vs Total Capital Gains: why are they not equal?

I thought realized gains and capital gains would be the same thing (unless you're being paid dividends or something like that). I ask because my tax report from Cointracking is giving me a *much* larger figure than the realized gains calculator is giving me. I spent many days putting this all together and looking for errors. I can't figure it out.

Cheers
Alex

Try to update your Job. There is button "Update Job and Trade Pairs"

There is comment
"Important: Trade pairs are now generated as part of the API Job set-up. If you have additional pairs, please click on "Update Job and Trade Pairs".
Optional settings and filters:"

This is what I was questioning, purely and simply and whether the coin is listed on an exchange or not should not affect the handling of the entry if it is received as a Gift free of any cost outlay.

Your "answer" below has very little to do with the answer to the original question.
  . This is irrelevant to the question asked.

So I respectfully ask the question again so that I do not make any mistakes in the future.

 If I enter a coin in as a Gift/Tip with a 0 cost basis and then when I sell it the software ignores the sale and any gain made from the sale.
Is that how it works and is supposed to work because this has not been my experience so far??

Why would the software do this because if I receive a coin as a Gift at 0 cost value then I sell the coin later for a profit why do you assert that
 'the software will also not calculate a gain on a sale.' as it it would be obvious that a gain had been made and that tax is due on that gain, surely?

I think there's been a misunderstanding.

If a suitable purchase is missing for a sale, then this must always be entered. No matter whether it is a real trade or earnings from Airdrops or Referral.
Entering an Airdrop as a "gift" was only a suggestion how to enter it.

It has never been mentioned that these are coins that are not listed on any exchange.

I understand that, regardless on whether it is a gain or gift, I was mainly looking for a way once these are sold to have the balances equal out and not have negative balances. 

So when the software recognizes a coin sold with no input, it allows you to tag it whatever way, and zero out the balance once sold to have a more accurate looking portfolio instead of negative balances.