> I will use your CSV import idea as that makes sense. Thank you!
Dario - I figured it all out eventually. I knew that I had either made too many manual transactions in USD with Coinbase for USD Wallet stuff, and didn't trace down the withdrawals and where they went to, and the corresponding deposits in those other places.
How I fixed it: What I did was make a backup and a full CSV export (just in case), deleted all trade data, then went exchange by exchange and did the automated imports if it allowed, then checked the deposits and withdrawals at each exchange since they typically don't get imported with the bulk imports. This is where I had issues before, because not only did I not put in there things like purchases (my cointracking upgrade was one of them!) and marking my hashnest mining purchase as an import over at hashnest account, but I had several bitcoin transfers from my main wallet to other exchanges not input or reflected at all.
Now the BTC balance in cointracking.info is exactly what I added up manually at the 7 different exchanges. All the other currencies (~30 of them) look correct as well.
--
Then for the mining, what I did was export all the transactions to a local file, then I split it into three different files - one with just mining earnings, one with just mining fees, and one with just mining trades/deposits. I had to manipulate the data by removing the "no" and "balance" columns and I added a currency column (BTC). One neat feature would be to be able to override some things like Currency in case the import file doesn't have it. For example, we can set an exchange over on the right side of the "Custom Exchange Import" page.
I also tried to research the hashnest wallet thing since the address I can deposit to at hashnest only had the two transactions (my .75 btc deposit in and a btc withdrawal to somewhere). I realized I could check the destination address and see what that had in it, but it only had a couple transactions that might have some fee, and then I saw where THAT went, and then it went to an address with way too many transactions that would match my account (ie, there were transactions from January but I started in March), so they must be obscuring it somewhere.
I'll let you know if Hashnest supports a better export, or I can send you what the file looks like and maybe you can more easily parse the mining earnings, fees and deposits. It would even be neat if cointracking.info supported GHS as a currency (ie, they call it ANTS9 and ANTS7 for two of their current "currencies"). In the report, they show a "trade" of (x) BTC for (y) ANTS9. It actually exports in XLS but has chinese characters in the workbook name and doesn't import well in your generic parser.
Here's a sample:
No. Date Amount Balance Type Comment
1 3/24/2017 20:39 -0.00138888 0.96746603BTC Trade Sale taker fee AntS9 amount 7716.0 at price 0.00012
2 3/24/2017 20:39 0.92592 0.96885491BTC Trade Sale AntS9 amount 7716.0 at price 0.00012
3 3/24/2017 20:39 -7716 0.0ANTS9 Trade Sale AntS9 at price 0.00012
Last note - since Coinbase Exchange changed to GDAX, maybe that importer should be renamed as well. The help file should at least be updated.
thanx again - wonderful tool and I'm glad for it being very flexible for all the complicated things I'm wanting to do.