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.
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
Show Posts
