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

Does the unlimited version import all your gdax trade history?  Or is it only for new trades?  I create the API key with the phrase cointracking.  It creates a job but nothing gets imported ( I ave not been entering any new trades ).

I am trying to start very basic and erases everything.  Just importing my coinbase data and it was off by 942 USD ( the remaining bitcoin balance was correct )over the 4+ years.  Since I am only interested in this years taxes I just manually entered a withdraw of the USD amount before Jan1 and balances are correct.  Hoping I can figure out why GDAX data after that gets imported.

So far I have tried importing every .csv file manually from Gdax that had any transaction, following the instructions.  If I import every single tx from the beginning or if I just import just 2017 the numbers are always way off. 

One thing I am a little confused about is on the GDAX API auto importer ( that still has not imported a single tx even though the job is there ) there were 4 checkboxes on setup all pre clicked.  I left them all clicked but didn't understand what the "Skip deposits and withdrawals in USD"  was clicked.  Again, I left it clicked but wouldn't that throw numbers off?

I just wish I could import every single trade since the beginning from both coinbase and gdax and there would be no errors because all the data would be there.  It is the reason I paid for unlimited.

Same

Did you ever get cointracking.info to work?

I have a similar case, 10's of thousands of trades.  I import from gdax but the numbers are all insanely off.  Got a 1099 that says 15 mil in gross transactions and need to get something that works.  No way to do this manually.

Any help or advice on what you did or are trying would be greatly appreciated.

I do some of the same, but I lean on Excel a bit more to check my entries against the import file.

You don't have to file this as a Sch C. (I borrowed this from Turbo Tax Forum)

When you mine the coins, you have income on the day the coin is "created" in your account at that day's exchange value.  You can report the income as a hobby or as self-employment.  If you report as a hobby, you include the value of the coins as "other income" on line 21 of form 1040.  Your ability to deduct any expenses is limited -- expenses are itemized deductions subject to the 2% rule.

If you report as self-employment income (you are doing "work" with the intent of earning a profit) then you report the income on schedule C.  You can fully deduct your expenses (if you can prove them) (see later).  The net profit is subject to income tax and self-employment tax.

So I file the income as Hobby Income as I net out better than filing a sch C.

No matter what I try I keep getting negative balances, numbers that make zero sense for profit/losses/total amounts traded etc.



If I started trading many years ago when GDAX/coinbase if I import every single trade from both coinbase and gdax from day 1 there should be no anomalies right?

I am guessing my problems are stemming from trying to import the data for just 2017 and I coan't figure out what all my balances were before Jan 1 to make all the imported 2017 data not be short.

I might try deleting everything one more time and generating gdax and coinbase reports to import for each coin pair from 2012.

I have the pro version, but am quickly getting frustrated and might ask for a refund.

I agree. There is no justifiable reason why fees like BNB are not deducted from the total balance of that coin.

Turns out, my expectation of what the "fees" does is just plain wrong.  It is only for informational purposes.

See this link:  https://cointracking.freshdesk.com/en/support/solutions/articles/29000007202-entering-fees

Personally, I think this is a rather weak implementation.

By typing "Mining" in the "Type" field, you are telling CT that this is mining income.  CT will AUTOMATICALLY look up the price and assign it based on the date you enter.

I mine as well - this is what I did as far as getting the mining info into cointracking.  First, I made an excel file with the following column headers:
Type (Trade, IN or OUT)   Buy Amount   Buy Cur.   Sell Amount   Sell Cur.   Fee Amount (optional)   Fee Cur. (optional)   Exchange (optional)   Trade Group (optional)   Comment (optional)   Date   

Then, I went to my mining wallet, and there is usually a way to export transactions from you wallet (for example, Vertcoin.qt has an "Export" button on the bottom right when you click on the "Transactions" tab.

When you get all your transactions in .csv format, go through each column (really only 2 columns, coin amounts and date) and Hightlight, Copy and Paste ONE column at a time (for example, start with your mined coin amounts from the .csv you downloaded, and put all those transactions in the "Buy Amount" column.)  Then, do the same for the "date" column.

Here is a sample of what mine looks like:
Type (Trade, IN or OUT)   Buy Amount   Buy Cur.   Sell Amount   Sell Cur.   Fee Amount (optional)   Fee Cur. (optional)   Exchange (optional)   Trade Group (optional)   Comment (optional)   Date   
Mining                            5.73293703     VTC                                                                                                     VTC Wallet                      Mining                                     12-02-2018 15:28:25   


As you can see, most fields are blank - the IMPORTANT fields are "Type," "Buy Amount," "Exchange," and "Date."

For the "Exchange" field, I just call it "VTC Wallet" and I did make a "Trade Group" called "Mining."

Now, go to cointracking.info and hover over the "Enter Coins" tab.  Hover over "Bulk Imports" in the drop down, and then click "Excel Import."  Choose your saved excel file, and it will begin the upload process (which is very quick).

Mining is one of the EASIER things to keep track of using cointracking.info.  Based on the "Date" you enter, CT will calculate the price on the DAY YOU MINED THE COIN, effectively keeping track of your cost/price basis (when you do sell, you will have capital gains) AND keeping track of your mining profits which you will report as self employment income (Schedule C) in the year you mined the coins.

You can click on the "Tax Report" tab at the top to create a tax report for the current year (2018) to create a tax report.  Once your create the report, click "load report," scroll down a little and you will see every coin your mined with your mining profits.  I hope this helps.  thanks

Actually, this seems to be a more general bug - it looks like "fees" on all types of transactions are not included in calculating total balance.  I noticed that the transactions imported from my ETH wallet had no transaction fees, and that my "current balance" was incurred - by just about the amount of the transaction fees.  I went through all of the transactions and added the fee, but the "current balance" did not change.

Oddly, transactions imported from a BTC wallet do have transaction fees, even for incoming transactions.  However, for a BTC wallet import, the "amount" of the transaction includes the fee, which is why the BTC wallet balance is correct.

So, several bugs:
1) Transaction fees are ignored for computing current balance
2) ETH wallet imports don't include transaction fees
3) BTC wallet imports include transaction fees for incoming transactions
4) BTC wallet imports include the transaction fee in the amount of the transaction

Fully agree on your assessment... The product looks promising but it needs work.  I'm disappointed that I paid for the pro version without closer inspection.  The lack of support for offline wallets is terrible.

how did you obtain the coins ? cause that matters
if you still have the wallet.dat add the mining transactions to your profile, alternatively you can estimate ( at least my accountant said i could if i must) so i added an exchange called before 2016 and put the coins I knew I had in it as gifts at 0 value or deposited fiat for and trade the cash value for those I know I traded I then transferred them to where they need to be

Why are BNB fees from trades on Binance not being calculated in the BNB balance?  The fees are correctly imported from Binance for purchases of coins but the BNB fees are not deducted from the total BNB balance?

Just purchased the software and am really impressed. Wish I knew about this earlier, I would be streamed lined already.

I do have a quick question someone might be able to save me some time with.


I have imported all the deposit/withdrawal histories and trade data from one exchange. Having a hard time calculating the proper gains for the year in terms of long/short term tax rate. I have warnings saying x amount of trades have no purchase data so it is assuming the coin was purchased and sold the same day. If the coins deposited came from offline wallets years+ old, What is the best way to correct this manually ?

Any insight would help. Thanks

Hi to the forum!

This might have already been asked/answered and dealt with before, but the search didn't give me any results.

My question is regarding the Trading Fee handling. One can add it into the transactions and get a detailed breakdown by exchanges, etc. However, what seems to have been neglected is taking it into calculations of the transaction amounts. What I mean is that the total amount of a transaction equals the trade activity amount, and not the trade activity amount plus the trading fee. For example, you buy 1 BTC for 8000USD (sell 8000 USD as trading counter part) and pay 80USD in trading fee, hence the exchange has charged you 8080USD for this trade. Once entered, the total amount for this trade will show 8000USD in the different charts and lists, instead of 8080USD. So, eventually all this will result in showing that you have spent less USD in the different charts than what you really have (if the fees were in the cryptocoin itself, the total amount for this coin will not correspond).
Now, if you in the example above instead put 8080USD in the 'Sell Amount', the total amounts will correspond in the different charts (Exchange Assets, etc.). However, the price you paid will NOT be accurate, as in all charts the unit price for this trade will show BTC/USD 8080, instead of the 8000 you actually paid.

So it seems one will have to choose between having either correct amounts / totals, or correct unit prices in the different charts, as both correct at same time doesn't seem to be possible.

Any clues or ideas in regards to this?

Thanks

I'm really, really struggling with this service. It came highly recommended, and is supposed to make taxes easy, but I can't even get my data in right. I have four years of mining/trading (mostly mining) to import and I can't seem to do it. The single biggest problem is that I need to be able to import thousands of mining transactions using a the standard core wallet CSV export and there doesn't seem to be any way to do it.

The custom exchange import could work if there was some way to tell the service that this is mining income and it needs to lookup the average daily price automatically, but there's no way to do that. It's only built for buying and selling on exchanges. In fact the whole service seems to be built around trading, not mining, which is driving me crazy. I already paid for two years of unlimited, and I desperately need the coin tracking and tax services offered, but I can't get my data correct!! Can't import wallet info, exchange API imports are leaving me with wrong balances, etc. In short it's a nightmare. I seriously don't know what to do and they won't/can't answer support questions in a timely matter. April 17th is fast approaching and I'm going to be screwed.

Will you be adding support for Uphold anytime soon - https://uphold.com/en/developer/api

Suggestion to Cointracking

Could you have more advanced total PORTFOLIO charts, reports etc.

I know you have the basic pie chart on the dashboard (but this doesn't show percentages unless you hover over the sections)
It would be better if you had a more adanced pie chart as that's what most people are buying for to see their total percentage allocation.

Also please update more exchanges like Gemini, Binance, Kucoin etc... API

I thought it would be more automated, but I trade constantly and am having to manually download then upload csvl files multiple times a day....

cointracking is showing me a bigger REALIZED GAINS than I ever had, 50% too high, how is this possible ? there seem to be a big problem in their calculation, i entered all my csv, finex kraken so on and it shows me huge gains that I never had, how to solve it

i was thinking all time but is this across accounts? you're right about pos wallets they take the piss on transactions which makes it harder to go through your actual trades sequentially unless you filter your wallets and then you might miss a withdrawal/deposit pair for those exchanges that dont support api or in the case that the api farts