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

If the GDAX API auto importer is suppose to be importing all your data history it is not working.  I have done it correctly but something is broken or it doesn't handle that much trade history. 

Either way it is not working.

First you have to create the API key on CB. Make sure you keep both the key and the secret.
Then create an import on CT. You will need to put in the key and secret you created on CB here. There are a few options when you create this. One of them is a start date that will only import transactions after that date.

I do very little trading and am mining.

I can download a CSV from here that contains all my payouts with the transaction ID, date, time, and amount:
https://chainz.cryptoid.info/lux/

What I want to do is upload that CSV into cointracking and have it add the USD value of each payout then let me re-save the file.  This is for tax purposes.

Thanks.

Any way to delete the trades I've inputted? It's all wrong

Yes, but if you make TOO much mining, the government is not going to buy that this is just a hobby.  I don't know what that figure would be, but probably approaching $10k it would no longer be considered a hobby??

Will you have Huobi API import soon?

Read some previous posts) Yes. Cointracking ALWAYS works strange. Wrong or missed imported data, wrong balances, sometimes errors during importing data... But, despite all this annoying details i don't know more powerful instrument to analyze my deals. Often with manual checking (for example as with last Binance crash) Not every time there is the cointracking problem. Mostly exchanges API or some inside problems.

Hi guys I have been using the free version and sometimes the number are not correct does this happen for the paid version?

Thx for helping,I'm gonna backup everything before doing something.
But I just don't understand how to recreate a key with a special start date,the first time I created it I don't remember about such a setting( is it on CT or CB ),or is this something linked with the API version upgrade button I was talking about with  2018-01-11 date ?
Sorry if my question looks weird ,I'm a newbie with API stuff but I'm happy to learn more

Create a backup of your transactions before doing this. Delete the API key in CT and CB. Recreate it with a start date after your last successful import. Technically, setting the start date shouldn't be necessary as CT apparently ignores potential duplicates based on the Coinbase TXN ID but better safe than sorry. If it all goes wrong, just restore from backup.

Hi,
I never had problem importing with API and Coinbase until today.
Suddenly when I try to import via API , Cointracking is displaying "invalid key",but I didn't change anything and when I go to my Coinbase settings to check the key, it's the same one I use since the beginning.
Is there something dealing with the API version,in the Coinbase settings I see the API version 2018-01-11 and a upgrade button ?
I just imported trades from Gdax with no prob ,if someone experienced the same prob or knows what I can do to fix this I would be thankful;)

I really appreciate your response.  Right now I am completely frustrated with so many trades. So you are saying go back to the very first day of gdax, then do a manual import of every pair on gdax for example btc/usd eth/usd starting at the very first trade. Then also import the coinbase data ( which I think comes over correct and full history with the api).  Then after all the data is imported that gives all the crazy errors and completely off balance values, go to google sheets and upload the gdax csv files to compare to the cointracking.info trades list?

If that is what must be done I will start it.  Thinking it will be probably more like 80 hours for me.  Also from your experience I assume that when you did it line by line somehow the imported data and what you were showing in your excel sheet you downloaded differed?  Strange since they would be the same files from gdax imported to 2 different places, google sheets and then manually imported into cointracking.info.


Swimming in this quagmire with overloaded CSR and no help anywhere else to be found facing a daunting task your response was greatly appreciated!  Wish there was a step by step of how to fix the problem by people like yourself who have done so.  Obviously the FAQ on the site shows you how to import the data that gives errors and then even tells you where your problem could be, however, it doesn't give you a detailed solution path like you briefly described.

I use the Unlimited and trade at GDAX as well as 3 or 4 other exchanges. I set Cointracking up after about six months of trading - not nearly as much unrecorded history as you have, but still it was a lot. I would have quit if it wasn't for the fact that I paid for the unlimited version before moving my trades and mining into Cointracking. And I'm too cheap to throw away the money. It took me a good 40 hours of trade analysis between what was uploaded in CT and the crap that the exchange has for records. This is so hard without Exchange statements to balance against. But, if you export CT trades, by exchange, to Excel and go line by line with the export from GDAX - you can get it to balance. Once I did that, keeping on top of it is a weekly chore, but it's easy now.

CT is a type of accounting system. And it's not magical, you have review your uploads and entries. I review my balances all the time - each exchange and each Wallet. It took time and spreadsheets to set it up. But, once you get it balanced, it's easy to maintain, and really worth it.

You can do it, just get it all spread out in Excel and check it off, trade by trade.    

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.