Bitcoin Forum
April 24, 2024, 05:39:27 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: « 1 ... 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 [54] 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 ... 121 »
  Print  
Author Topic: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies  (Read 121745 times)
geekcryptogal
Jr. Member
*
Offline Offline

Activity: 56
Merit: 2


View Profile
February 05, 2018, 09:02:25 AM
 #1061

I am going crazy, I am new to crypto and have been daytrading (first time ever) on the ethereum market on biance for the past couple days.  I am fairing well , up $40 starting iwth $170.

I am using cointracking.info to import the binance data and I know it's importing correctly , because the program has the balances exactly right.

However it says I am up like $150 in cap gains past couple days, when in reality I am up only $40.   Did about 100 trades past couple days.  I see no way to set the tax report to use "average cost of ethereum" for the day.   The high volatility of both currencies in the pair is messing things up I think.
1713980367
Hero Member
*
Offline Offline

Posts: 1713980367

View Profile Personal Message (Offline)

Ignore
1713980367
Reply with quote  #2

1713980367
Report to moderator
1713980367
Hero Member
*
Offline Offline

Posts: 1713980367

View Profile Personal Message (Offline)

Ignore
1713980367
Reply with quote  #2

1713980367
Report to moderator
No Gods or Kings. Only Bitcoin
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1713980367
Hero Member
*
Offline Offline

Posts: 1713980367

View Profile Personal Message (Offline)

Ignore
1713980367
Reply with quote  #2

1713980367
Report to moderator
WickedPigeon
Member
**
Offline Offline

Activity: 345
Merit: 16


View Profile
February 05, 2018, 09:18:10 PM
 #1062

how do I go about finding the cost basis of my mining payouts.  I enter them in and I can find them in the trades list but the price and tx number are blank.  How do I go about filling all that in?
The cost basis of your mining payouts is 0.

Is that right? I thought that you have to pay tax on the value of the coin mined WHEN they are received. Then you have to realize a gain/loss when you sell them. (In fact I know this to be the rule). So all the mining I've done, each of my hundreds of little payouts, need to be recorded at the market rate when they where received in my wallet. Thus why I needed CT to help me. But I can't figure out how CT shows the mining value for tax filing (this is a US tax question).

Anyone know?

“How did you go bankrupt?” Bill asked.

“Two ways,” Mike said. “Gradually and then suddenly.”
soothaa
Hero Member
*****
Offline Offline

Activity: 1151
Merit: 528



View Profile
February 05, 2018, 09:23:36 PM
 #1063

how do I go about finding the cost basis of my mining payouts.  I enter them in and I can find them in the trades list but the price and tx number are blank.  How do I go about filling all that in?
The cost basis of your mining payouts is 0.

Is that right? I thought that you have to pay tax on the value of the coin mined WHEN they are received. Then you have to realize a gain/loss when you sell them. (In fact I know this to be the rule). So all the mining I've done, each of my hundreds of little payouts, need to be recorded at the market rate when they where received in my wallet. Thus why I needed CT to help me. But I can't figure out how CT shows the mining value for tax filing (this is a US tax question).

Anyone know?
That's not what you originally asked. The cost basis for mining payouts is 0 - that's how it is.

Whenever you sell, the capital gains/loss will be (current price - price at time mined) = cost basis.

The mining income will be subject to income tax and the cap/gains loss as such.

Want increased coin support within AwesomeMiner? Try my free plugin to add support for nearly any coin! https://bitcointalk.org/index.php?topic=2979494
Want Masternode income stats within AwesomeMiner? Try my free plugin to add support for them! https://bitcointalk.org/index.php?topic=3047367
WickedPigeon
Member
**
Offline Offline

Activity: 345
Merit: 16


View Profile
February 05, 2018, 09:33:16 PM
 #1064

how do I go about finding the cost basis of my mining payouts.  I enter them in and I can find them in the trades list but the price and tx number are blank.  How do I go about filling all that in?
The cost basis of your mining payouts is 0.

Is that right? I thought that you have to pay tax on the value of the coin mined WHEN they are received. Then you have to realize a gain/loss when you sell them. (In fact I know this to be the rule). So all the mining I've done, each of my hundreds of little payouts, need to be recorded at the market rate when they where received in my wallet. Thus why I needed CT to help me. But I can't figure out how CT shows the mining value for tax filing (this is a US tax question).

Anyone know?
That's not what you originally asked. The cost basis for mining payouts is 0 - that's how it is.

Whenever you sell, the capital gains/loss will be (current price - price at time mined) = cost basis.

The mining income will be subject to income tax and the cap/gains loss as such.

Here is my question:
When I mine a coin and receive it in my wallet. At that moment I have taxable income - whatever the value to that coin is, at that time I receive it, it becomes taxable. I've tracked all my mining in Cointracking using the Excel upload (as my alt-coins are not supported with an API); Now it's time to pay my taxes on the coins I mined. How do I get that info from Cointracker?

“How did you go bankrupt?” Bill asked.

“Two ways,” Mike said. “Gradually and then suddenly.”
rvf
Newbie
*
Offline Offline

Activity: 12
Merit: 0


View Profile
February 05, 2018, 09:49:42 PM
 #1065

I'm testing the free version and set up cointracking manually today and trying to make sure I correctly understand everything I need it to track for US taxes at the end of 2018.

Am I correct that when mining I need to get 3 numbers:
(1) my payout in ETH and equivalent USD -- this is income recorded at the price and the time of transfer from the pool wallet to my wallet
(2) the pool fee taken by the site -- this is an expense but you don't record it because it's taken before your payout.  The extra income and the fee would cancel each other out.  Am I correct it's best practice to track net income rather than gross income (i.e. before pool fees)?
(3) the transfer fee to move the payout from the site wallet to your wallet.  This is an expense you need to track and total and the end of the year.

I manually entered my payouts, and looked up the transfer fee for each one and entered it.

I then tried the automated import feature for ETH wallets to see if it would save me time in the future.  When I did this, it correctly entered the payout amount, but the fees column was always 0. 

Is it a limitation of the automated import that I need to go and manually look up each transaction and correct the fees column?

Thanks.
Balkos
Newbie
*
Offline Offline

Activity: 49
Merit: 0


View Profile
February 06, 2018, 04:36:27 AM
 #1066

Question.  Where can I find my account number?  I am filling out my Schedule D right now for 2017 and they want an account number.

thanks!
1izzie
Newbie
*
Offline Offline

Activity: 8
Merit: 0


View Profile
February 06, 2018, 10:15:57 AM
Last edit: February 06, 2018, 10:39:04 AM by 1izzie
 #1067

I just logged into my cointracking and it's showing me every single transaction I've ever made in the realized/unrealized gains, like not calculating correctly so it shows I have way more money than I actually have. Is there some kind of database or server problem right now?

I paid a lot for this service and it has not been up to my expectations, with all of the Binance importing problems, server downtime, now this.

EVERY time it matters the most, this app always screws up. I just tried deleting all my trades and re-importing everything and the calculations are STILL wrong.

FIX THIS!!!!
infojunkiePHD
Newbie
*
Offline Offline

Activity: 49
Merit: 0


View Profile
February 06, 2018, 03:31:20 PM
 #1068

Love the software. Imported from all my accounts via API fairly easily, and let me change entries from trades to mining quickly.  My taxes are already done and submitted!  

There were a few hiccups the first day, when it was showing me holding odd amounts of cash, ether, etc that diddn't exist.  But after a day those all were fixed.  I also had to go and put in 'spend' transactions for cashouts in coinbase.  Basically just data cleanup for my own use-cases.

Is there an ETA for supporting tradesatoshi's API?  I plan on doing some trading there that I want cointracking to monitor, but it seems there's no support for the API yet.

Thanks!
undersun1
Newbie
*
Offline Offline

Activity: 11
Merit: 0


View Profile
February 06, 2018, 04:33:52 PM
Last edit: February 06, 2018, 05:03:24 PM by undersun1
 #1069

When I run the "Capital Gains Report," all my trades (3,261 of them) show as "shorts" (in the Short/Long column).  I don't have margin so is this a mistake in the software?

I used the API Import feature to import all my trades from various exchanges (GDAX, Coinbase, Binance, Bittrex, Bitfinex, and Poloniex plus my wallet information for all my coins).

Has anyone else noticed this?

Also, when someone pays me through Coinbase (I have a Coinbase acc't and they have a Coinbase account), this transaction just shows as a "deposit."  I usually just send this to my GDAX account, and
add it to my trading BTC.  But all these transactions show up with no cost basis (because there is no trade associated with them), so the cointracking.info software gives me an "Warning" message in the capital gains report that there is "No suitable purchase for this sale" and assumes a $0 USD cost basis.  I have tried adding trades, but the message still persists.  
bitChipper
Sr. Member
****
Offline Offline

Activity: 896
Merit: 290


View Profile
February 06, 2018, 04:38:57 PM
 #1070

I am going crazy, I am new to crypto and have been daytrading (first time ever) on the ethereum market on biance for the past couple days.  I am fairing well , up $40 starting iwth $170.

I am using cointracking.info to import the binance data and I know it's importing correctly , because the program has the balances exactly right.

However it says I am up like $150 in cap gains past couple days, when in reality I am up only $40.   Did about 100 trades past couple days.  I see no way to set the tax report to use "average cost of ethereum" for the day.   The high volatility of both currencies in the pair is messing things up I think.


This is what im worried about with these services, you may end up paying way more taxes than you owed....its not like the IRS is going to be like "hey you gave us too much"..

Feel like the only way is to try and do it all yourself, which for some of us is next to impossible....what if someone has lost huge gaps in their trading history for things out of their control? Mintpal, cryptsy, mt gox ect....those records are gone...

I just feel like crypto-fiat taxes are enough right now, exchanges are no where near the level they need to be at for people to comply with the crypto-crypto tax..
bitChipper
Sr. Member
****
Offline Offline

Activity: 896
Merit: 290


View Profile
February 06, 2018, 04:40:34 PM
 #1071

When I run the "Capital Gains Report," all my trades (3,261 of them) show as "shorts" (in the Short/Long column).  I don't have margin so is this a mistake in the software?

I used the API Import feature to import all my trades from various exchanges (GDAX, Coinbase, Binance, Bittrex, Bitfinex, and Poloniex plus my wallet information for all my coins).

Has anyone else noticed this?

Lol i think you are confusing a short sell with the notion of short and long term gains, the tracker is treating every single one of your trades as short term gains...which is a higher tax % btw
undersun1
Newbie
*
Offline Offline

Activity: 11
Merit: 0


View Profile
February 06, 2018, 04:57:21 PM
 #1072

When I run the "Capital Gains Report," all my trades (3,261 of them) show as "shorts" (in the Short/Long column).  I don't have margin so is this a mistake in the software?

I used the API Import feature to import all my trades from various exchanges (GDAX, Coinbase, Binance, Bittrex, Bitfinex, and Poloniex plus my wallet information for all my coins).

Has anyone else noticed this?

Lol i think you are confusing a short sell with the notion of short and long term gains, the tracker is treating every single one of your trades as short term gains...which is a higher tax % btw

Lol, thanks (I am such a noob).  That really helps.  But I still can't figure out how to get rid of those "Warnings" on the report.  I have tried adding trades every which way but they just won't go away.
undersun1
Newbie
*
Offline Offline

Activity: 11
Merit: 0


View Profile
February 06, 2018, 05:22:16 PM
 #1073

I have about 30 of these warning messages, which correspond to 30 BTC payments I have received in my Coinbase account from other Coinbase customers (and also for the $10 referral fee paid in BTC I receive for referring customers).

So when someone pays me through Coinbase (in BTC) this transaction just shows as a "Deposit" as it should - Then, there is a corresponding "Withdrawal" transaction and another "Deposit" transaction as I send it to my GDAX trading account.  Now, all these transactions show up with NO cost basis (because there is NO trade associated with them), so the cointracking.info software gives me a "Warning" message in the "Capital Gains" report that says "There is no suitable purchase for this sale" and assumes a $0 USD cost basis.  I have tried adding trades, but the message still persists.  Does anyone know how to handle this type of transaction?

Here are the warnings the capital gains report:


Amount          Currency Date Acquired   Date Sold                                                           Short Term Gain/Long Term Gain                                                     Buy Input  Sell Input  Proceeeds / Cost Basis / Gain in USD
0.00660200   BTC   04.12.2017   04.12.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   74.76   0.00   74.76
0.01079998   BTC   26.11.2017   26.11.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   100.83   0.00   100.83
0.01450300   BTC   25.04.2017   25.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   18.49   0.00   18.49
0.02220600   BTC   23.06.2017   23.06.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   60.09   0.00   60.09
0.02250300   BTC   03.10.2017   03.10.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   95.62   0.00   95.62
0.02394883   BTC   12.09.2017   12.09.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   99.49   0.00   99.49
0.04000000   BTC   04.01.2017   04.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   45.60   0.00   45.60
0.04128600   BTC   20.06.2017   20.06.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   113.95   0.00   113.95
0.04266892   BTC   06.04.2017   06.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   51.12   0.00   51.12
0.04562400   BTC   25.05.2017   25.05.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   110.29   0.00   110.29
0.05077098   BTC   19.05.2017   19.05.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   98.11   0.00   98.11
0.05527600   BTC   15.01.2017   15.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   46.36   0.00   46.36
0.05816800   BTC   17.07.2017   17.07.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   120.59   0.00   120.59
0.06475708   BTC   17.04.2017   17.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   76.11   0.00   76.11
0.06492337   BTC   18.09.2017   18.09.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   259.11   0.00   259.11
0.07474800   BTC   18.02.2017   18.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   78.96   0.00   78.96
0.08209100   BTC   24.02.2017   24.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   98.21   0.00   98.21
0.08527500   BTC   09.01.2017   09.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   77.34   0.00   77.34
0.09460000   BTC   20.02.2017   20.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   100.38   0.00   100.38
0.09590900   BTC   28.02.2017   28.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   114.42   0.00   114.42
0.09602300   BTC   28.03.2017   28.03.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   99.64   0.00   99.64
0.09688723   BTC   13.01.2017   13.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   80.67   0.00   80.67
0.11589227   BTC   19.04.2017   19.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   139.25   0.00   139.25
0.12500000   BTC   16.01.2017   16.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   104.93   0.00   104.93
0.33252100   BTC   31.01.2017   31.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   311.24   0.00   311.24
infojunkiePHD
Newbie
*
Offline Offline

Activity: 49
Merit: 0


View Profile
February 06, 2018, 05:31:35 PM
 #1074

I have about 30 of these warning messages, which correspond to 30 BTC payments I have received in my Coinbase account from other Coinbase customers (and also for the $10 referral fee paid in BTC I receive for referring customers).

So when someone pays me through Coinbase (in BTC) this transaction just shows as a "Deposit" as it should - Then, there is a corresponding "Withdrawal" transaction and another "Deposit" transaction as I send it to my GDAX trading account.  Now, all these transactions show up with NO cost basis (because there is NO trade associated with them), so the cointracking.info software gives me a "Warning" message in the "Capital Gains" report that says "There is no suitable purchase for this sale" and assumes a $0 USD cost basis.  I have tried adding trades, but the message still persists.  Does anyone know how to handle this type of transaction?

Here are the warnings the capital gains report:


Amount          Currency Date Acquired   Date Sold                                                           Short Term Gain/Long Term Gain                                                     Buy Input  Sell Input  Proceeeds / Cost Basis / Gain in USD
0.00660200   BTC   04.12.2017   04.12.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   74.76   0.00   74.76
0.01079998   BTC   26.11.2017   26.11.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   100.83   0.00   100.83
0.01450300   BTC   25.04.2017   25.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   18.49   0.00   18.49
0.02220600   BTC   23.06.2017   23.06.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   60.09   0.00   60.09
0.02250300   BTC   03.10.2017   03.10.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   95.62   0.00   95.62
0.02394883   BTC   12.09.2017   12.09.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   99.49   0.00   99.49
0.04000000   BTC   04.01.2017   04.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   45.60   0.00   45.60
0.04128600   BTC   20.06.2017   20.06.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   113.95   0.00   113.95
0.04266892   BTC   06.04.2017   06.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   51.12   0.00   51.12
0.04562400   BTC   25.05.2017   25.05.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   110.29   0.00   110.29
0.05077098   BTC   19.05.2017   19.05.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   98.11   0.00   98.11
0.05527600   BTC   15.01.2017   15.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   46.36   0.00   46.36
0.05816800   BTC   17.07.2017   17.07.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   120.59   0.00   120.59
0.06475708   BTC   17.04.2017   17.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   76.11   0.00   76.11
0.06492337   BTC   18.09.2017   18.09.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   259.11   0.00   259.11
0.07474800   BTC   18.02.2017   18.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   78.96   0.00   78.96
0.08209100   BTC   24.02.2017   24.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   98.21   0.00   98.21
0.08527500   BTC   09.01.2017   09.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   77.34   0.00   77.34
0.09460000   BTC   20.02.2017   20.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   100.38   0.00   100.38
0.09590900   BTC   28.02.2017   28.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   114.42   0.00   114.42
0.09602300   BTC   28.03.2017   28.03.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   99.64   0.00   99.64
0.09688723   BTC   13.01.2017   13.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   80.67   0.00   80.67
0.11589227   BTC   19.04.2017   19.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   139.25   0.00   139.25
0.12500000   BTC   16.01.2017   16.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   104.93   0.00   104.93
0.33252100   BTC   31.01.2017   31.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   311.24   0.00   311.24


If people are paying you, it's income.  AFAIK you need to edit the initial 'deposits' to 'income'
WickedPigeon
Member
**
Offline Offline

Activity: 345
Merit: 16


View Profile
February 06, 2018, 08:31:18 PM
Last edit: February 06, 2018, 08:50:17 PM by WickedPigeon
 #1075

how do I go about finding the cost basis of my mining payouts.  I enter them in and I can find them in the trades list but the price and tx number are blank.  How do I go about filling all that in?
The cost basis of your mining payouts is 0.
Here is my question:
When I mine a coin and receive it in my wallet. At that moment I have taxable income - whatever the value to that coin is, at that time I receive it, it becomes taxable. I've tracked all my mining in Cointracking using the Excel upload (as my alt-coins are not supported with an API); Now it's time to pay my taxes on the coins I mined. How do I get that info from Cointracker?

Here is what I have figured out on how to track tax liability from Mining using Cointracking.
I use this for mining Small-Cap, Alt-coins to a Wallet, no Cointracking API:
1 - I've exported the transaction from the wallet to Excel. (Most wallets have this feature).
2 - in Excel, I adjust the columns and the headers to match Cointracking - adding:
   Type - Mining (I've added this after the export)
   Buy - quantity mined,
   Currency - the Symbol Mined, like BWK (I've added this after the export)
   Exchange - I call each Wallet an exchange - like "BWK Wallet" (I've added this after the export)
   Date - make sure that you keep the time stamp from the Wallet.
3 - Back to Cointracking, Enter Coins - Bulk Imports - Excel - [Filename]
4 - Review import and update Cointracking
5 - In Cointracking, Report - Trade Prices - Excel; now the mining has a value attached to each transaction.
6 - In Excel, sort by type (mining) and date (Tax Year). Copy and paste to clean file and there you go, tax file for income earned on mining.

Hope this helps.

“How did you go bankrupt?” Bill asked.

“Two ways,” Mike said. “Gradually and then suddenly.”
undersun1
Newbie
*
Offline Offline

Activity: 11
Merit: 0


View Profile
February 06, 2018, 08:53:43 PM
 #1076

I have about 30 of these warning messages, which correspond to 30 BTC payments I have received in my Coinbase account from other Coinbase customers (and also for the $10 referral fee paid in BTC I receive for referring customers).

So when someone pays me through Coinbase (in BTC) this transaction just shows as a "Deposit" as it should - Then, there is a corresponding "Withdrawal" transaction and another "Deposit" transaction as I send it to my GDAX trading account.  Now, all these transactions show up with NO cost basis (because there is NO trade associated with them), so the cointracking.info software gives me a "Warning" message in the "Capital Gains" report that says "There is no suitable purchase for this sale" and assumes a $0 USD cost basis.  I have tried adding trades, but the message still persists.  Does anyone know how to handle this type of transaction?

Here are the warnings the capital gains report:


Amount          Currency Date Acquired   Date Sold                                                           Short Term Gain/Long Term Gain                                                     Buy Input  Sell Input  Proceeeds / Cost Basis / Gain in USD
0.00660200   BTC   04.12.2017   04.12.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   74.76   0.00   74.76
0.01079998   BTC   26.11.2017   26.11.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   100.83   0.00   100.83
0.01450300   BTC   25.04.2017   25.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   18.49   0.00   18.49
0.02220600   BTC   23.06.2017   23.06.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   60.09   0.00   60.09
0.02250300   BTC   03.10.2017   03.10.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   95.62   0.00   95.62
0.02394883   BTC   12.09.2017   12.09.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   99.49   0.00   99.49
0.04000000   BTC   04.01.2017   04.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   45.60   0.00   45.60
0.04128600   BTC   20.06.2017   20.06.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   113.95   0.00   113.95
0.04266892   BTC   06.04.2017   06.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   51.12   0.00   51.12
0.04562400   BTC   25.05.2017   25.05.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)   __   GDAX   110.29   0.00   110.29
0.05077098   BTC   19.05.2017   19.05.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   98.11   0.00   98.11
0.05527600   BTC   15.01.2017   15.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   46.36   0.00   46.36
0.05816800   BTC   17.07.2017   17.07.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   120.59   0.00   120.59
0.06475708   BTC   17.04.2017   17.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   76.11   0.00   76.11
0.06492337   BTC   18.09.2017   18.09.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   259.11   0.00   259.11
0.07474800   BTC   18.02.2017   18.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   78.96   0.00   78.96
0.08209100   BTC   24.02.2017   24.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   98.21   0.00   98.21
0.08527500   BTC   09.01.2017   09.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   77.34   0.00   77.34
0.09460000   BTC   20.02.2017   20.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   100.38   0.00   100.38
0.09590900   BTC   28.02.2017   28.02.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   114.42   0.00   114.42
0.09602300   BTC   28.03.2017   28.03.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   99.64   0.00   99.64
0.09688723   BTC   13.01.2017   13.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   80.67   0.00   80.67
0.11589227   BTC   19.04.2017   19.04.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   139.25   0.00   139.25
0.12500000   BTC   16.01.2017   16.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   104.93   0.00   104.93
0.33252100   BTC   31.01.2017   31.01.2017   There is no suitable purchase to this sale. Assuming purchase on the same day for 0 USD. Short (Warning)      GDAX   311.24   0.00   311.24


If people are paying you, it's income.  AFAIK you need to edit the initial 'deposits' to 'income'

I think you are right - I changed each GDAX deposit to "[In] Income" and the warnings are now GONE.  Now I just need to figure out how to reconcile this mess with the 1099K I received from GDAX.  I know I have to to fill  out Form 8949 (Sales and Other Dispositions of Capital Assets) with the information provided by cointracking.info, and that will go on my Schedule D.  But where do I reconcile the 1099K?  Will that go on a Schedule C?
infojunkiePHD
Newbie
*
Offline Offline

Activity: 49
Merit: 0


View Profile
February 06, 2018, 09:03:06 PM
 #1077


I think you are right - I changed each GDAX deposit to "[In] Income" and the warnings are now GONE.  Now I just need to figure out how to reconcile this mess with the 1099K I received from GDAX.  I know I have to to fill  out Form 8949 (Sales and Other Dispositions of Capital Assets) with the information provided by cointracking.info, and that will go on my Schedule D.  But where do I reconcile the 1099K?  Will that go on a Schedule C?

Assuming it's income, yes.
liveawar3
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
February 06, 2018, 11:28:33 PM
Last edit: February 06, 2018, 11:40:29 PM by liveawar3
 #1078

Hi -

I have just subscribed to cointracker.info and setting up trades, however I have run into an error on the Trade List page. It is throwing me an error saying

 ''DataTables warning: table id=trade_table - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1"

Does anyone know why this happens and how I can resolve it?

Thanks,

Rob

Update : Problem solved. I created an exchange name with a backslash i.e. RD\BTC Markets. It seems you can't have exchange names with backslashes in them.
Balkos
Newbie
*
Offline Offline

Activity: 49
Merit: 0


View Profile
February 06, 2018, 11:43:14 PM
 #1079

When I run the "Capital Gains Report," all my trades (3,261 of them) show as "shorts" (in the Short/Long column).  I don't have margin so is this a mistake in the software?

I used the API Import feature to import all my trades from various exchanges (GDAX, Coinbase, Binance, Bittrex, Bitfinex, and Poloniex plus my wallet information for all my coins).

Has anyone else noticed this?

Also, when someone pays me through Coinbase (I have a Coinbase acc't and they have a Coinbase account), this transaction just shows as a "deposit."  I usually just send this to my GDAX account, and
add it to my trading BTC.  But all these transactions show up with no cost basis (because there is no trade associated with them), so the cointracking.info software gives me an "Warning" message in the capital gains report that there is "No suitable purchase for this sale" and assumes a $0 USD cost basis.  I have tried adding trades, but the message still persists.  

I believe the short/long is the tax category.  If its was help for less than 1 year it will show as short.

geekcryptogal
Jr. Member
*
Offline Offline

Activity: 56
Merit: 2


View Profile
February 07, 2018, 12:08:30 AM
 #1080

I WAS interested in your software and not so much now.  I've done two days of daytrading and it exceeds yoru 200 record limit.

I am having a big problem with capital gains calculations -- I think your software is FLAWED.   Said I had $150 in gains in those two days when I only gained $40.

I sent a support ticket with the question and you did NOT answer me.

I am not going to fork out bitcoin for your application, if it doesn't allow me to test it out further than 2 days.. especially since it has problems and you aren't responding to my support ticket.

I will most likely design my own relational database and write my own program to generate my form 8949 and income statement.. Using fractional FIFO. 

At least if I write it and it has a bug, I can fix it myself, instead of hoping to get a reply from you folks.

Pages: « 1 ... 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 [54] 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 ... 121 »
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!