Author

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

hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Hey whallify and thanks a lot Smiley

I would recommend to track mining coins as deposit. This is the easiest way.

You say:
>> I bought some GHS on the market and it regularly deposits BTC into what looks to be a private wallet (they don't display the address) and they withdraw the fees.

But they must send those BTC to your address. Right?
Maybe hashnet is not displaying the BTC address inside their app, but once they are sent to your wallet, you have the address.
That's why I would use the "Bitcoin Wallet Import" to automatically import all your hashnet transactions into your wallet.

If you want to import the CSV (what's more difficult), I would do:
"Declare as deposit, if amount >= 0" and
"Declare as withdrawal, if amount < 0"
This is not perfect for tracking, but will show at least the right balance at the end.


Q2: Track down discrepancies:
First you should check if you have entered fees correctly.
Please note, that they should be already included in the Buy or Sell price.
This means, if you buy 1 BTC for 1000 USD and you pay an additional fee of 5 USD, the final entry should be:
Buy: 1 BTC | Sell: 1005 USD | Fee: 5 USD (a common mistake is to set Sell = 1000 USD)

Second, you should check in the "Trade Table" if movements between wallets or exchanges have been tracked in both ways.
This means, if you send 1 BTC from Exchange A to Exchange B, there should be
One "Withdrawal of 1 BTC from Exchange A"
and one "Deposit of 1 BTC to Exchange B".

Maybe not all of them are listed, as not all exchanges show deposits and withdrawals in their CSV file.

When your trades are correct, the discrepancy must be somewhere here.

I hope that helps.
If not, let me know and I will help you searching Smiley

Best regards and a nice weekend,
Dario
newbie
Activity: 3
Merit: 0
Gotta say, Dario... what a great site! I quickly decided to go pro even though I'm not to the 200 trades yet, as I'm very appreciative of this wonderful tool.

I've been playing with manual import, import from various exchanges, and the bulk import.  I'm doing pretty well with the 28 different altcoins with 7 different exchanges, and I love the graphs.  I think I messed up with how deposits are tracked (coinbase specifically, and trying to track USD wallet there differently than using an external bank account for purchases) but I think I'm good on that.

Two remaining questions:

Q1: Mining. (cloud mining - are these deposits/withdrawals?)
I just started playing with mining, and I'm using hashnest.  I bought some GHS on the market and it regularly deposits BTC into what looks to be a private wallet (they don't display the address) and they withdraw the fees.  I can export the transactions, which comes in an xlsx file with a chinese workbook name, so I can't import. So I convert to CSV and I'm good.

This is what it looks like
No.   Date   Amount   Balance   Type   Comment
1   2017-03-14 23:05:32   -0.00013285   0.01444857BTC   Mining   Maintain Fee 457266:AntminerS9:Duration Time 2 h 42 m 35 s
2   2017-03-14 23:05:31   0.00016203   0.01458142BTC   Mining   Earnings 457266:AntminerS9:Duration Time 2 h 42 m 35 s

I figure I can remove "No." and "Balance" because that doesn't matter to the import. 

When I drag and drop the CSV into custom exchange import, it sees all the data.  But I don't know if:
  • I should make two separate CSV files, one with all the fees and one with all the earnings, and import them separately
  • or if it will automatically understand positive is earnings and negative is fee
  • if I do make two separate CSV files, do I do the override to say "this is deposit/withdrawal"
  • or if this is even supposed to be deposit/withdrawal

So, what's the best practice for tracking cloud mining?

Q2: How best to try and track down discrepancies, like with BTC?

I'm noticing that what cointracker thinks is my bitcoin balance and what I've verified it to be is off.  As an example, let's say cointracker says my btc balance is 2.15 but when I go check all of my exchanges manually, I only count 1.9.  There's a delta there.

First thing I did was double check all my imported and manually entered transactions for typos.  I didn't find any, so I checked again.  Maybe there's a fee, transfer or something else that I'm missing.  I went to the trade list and put in "BTC" and the exchange name so I could just see all the transactions there, and then I would go to the exchange and do the same thing.  Didn't find anything.  I also checked the daily balance report (great report) to see if there were any issues there.

What would you recommend as to help try to track down discrepancies?   Maybe another report or comparison I should try?
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
This is really useful and I am now using for more than 6 months now.

when can we expect auto import from poloniex API?

Thanks a lot Smiley

Poloniex API is already on my to do list.
Should be ready in 1-2 weeks.

Dario
newbie
Activity: 25
Merit: 0
This is really useful and I am now using for more than 6 months now.

when can we expect auto import from poloniex API?
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Hey kkris,

I have just released the requested feature.
You can now activate your public URL under "Account" -> "Public Portfolio".

Features:
- total value for all coins, currencies, commodities, and the total account value
- information about your trades like: first trade, last trade, used exchanges, trades per month, trades per exchange... (can be enabled or disabled)
- list for all your currencies incl. amount, price, trend and trend chart
- P/L chart (can be enabled or disabled)
- value each currency as column chart

- change the URL (alias) of your portfolio
- add a public comment to your portfolio
- enable / disable portfolio

Here's a demo: https://cointracking.info/portfolio/Demo

Have a nice weekend,
Dario
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Feature request:

Allow sharing a long and obfuscated private URL that will provide a read-only view to anybody who has that URL.

The read-only view would include at least the amount and value of currently-owned each coin and the total balance.

Hey kkris,

Yeah sure. I already had something similar on my todo list.
Give me 1 or 2 days to create this feature.

Best regards,
Dario
newbie
Activity: 11
Merit: 0
Feature request:

Allow sharing a long and obfuscated private URL that will provide a read-only view to anybody who has that URL.

The read-only view would include at least the amount and value of currently-owned each coin and the total balance.
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Here we go... another new features on CoinTracking

New Coin Trends
A list of all coins available on the market, including price, trend, change in percent, price chart and current order volume.

New Reporting: Tax-free coins (Short & Long Calculation)
Our new reporting calculates tax-free coins (long) and taxable coins (short) for any date and period.
The overview shows which coins can be sold tax-free at a specific date.


- New import for Gemini.com
- Updated import for Coinbase.com
- Themes (light, dimmed, dark)
- And many more...
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
And again some new features on CoinTracking:

New importer for almost all exchanges
This custom importer allows you to import trades from almost any exchange and source. This also applies to exchanges that are not listed on CoinTracking.
If the exchange specifies the trade date and the currencies/coins in an export file (CSV, XLS, XLSX or TXT), the data can be imported.


Extension of the tax report - All currencies and coins in one report
We've released a new feature for the tax report.
This allows the profit and tax to be calculated simultaneously for all currencies and not just for a specific trade pair.
Useful for all users who trade many different coins but also to determine the tax for FIAT trades (for example, profits from EUR, USD and JPY trades).


New Reporting: Double-Entry List
All transactions including deposits, withdrawals and fees, split according to debit and credit.


The exchange can now be edited
The "Exchange" field in the Enter Coins table is now editable.


New FIAT currencies integrated into CoinTracking
- AED (United Arab Emirates Dirham)
- ARS (Argentine Peso)
- CLP (Chilean Peso)
- CZK (Czech Koruna)
- HUF (Hungarian Forint)
- IDR (Indonesian Rupiah)
- ILS (Israeli New Shekel)
- INR (Indian Rupee)
- KRW (South Korean Won)
- MXN (Mexican Peso)
- PHP (Philippine Peso)
- PKR (Pakistani Rupee)
- TRY (Turkish Lira)
- TWD (Taiwan Dollar)
- ZAR (South African Rand)
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
We would like to present a list of new features on CoinTracking:

New Reporting: Realized and Unrealized Gains
Calculation of unrealized and realized gains for all your currencies including a coin-grouped summary.
It's the profit you've achieved till today with all your sales and the profit you would achieve if you sell all your coins right now.


New Reporting: Balance by Currency
This reporting shows the details for all your coins and currencies, including trades, amounts, values and volume, grouped by month or by year


Easy Enter statistics and entry on one page
We have merged both Easy Enter pages. Under "Reporting -> Easy Enter Statistics" you can now add or edit entries. The charts and analyzes are updated dynamically as they are entered.


Spread added to the Trade Prices table
You can now find the trade spread under "Reporting -> Trade Prices". This is the calculated percentage difference between the purchase and the sale value.


Set custom Prices for Coins and Currencies
On numerous requests we have included the possibility to set custom prices for coins and currencies. This can be useful for ICO coins, which are not yet on the market.
To do this, open the options in the Summary box (arrow symbol at the bottom) and select "Set custom Prices".


Show/Hide zero balance Coins in the Summary box
You can now show or hide currencies you once owned in the Summary box (All your currencies with a current amount of zero).
Open the options (arrow symbol at the bottom) and click on "Coins with Amount = 0" to show or hide them.
By default, these coins are hidden.


Coin sorting in the Summary box
Coins and currencies can be sorted by coin name, by coin value and by coin amount in the Summary box. BTC is always at the top
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Latest version is 49.0.1  Cheesy

Opps, my bad.
I meant 45.0.1.
But that's still not the latest version Cheesy
You see, I'm not a FF user Smiley

OK, updated to 49.0.1 and it's still working good.

It's just a regular JS modal box. It's supported by all common browsers.
I'm pretty sure, it's just a setting in your browser.
Let me know, if it's still an issue.
Dario
hero member
Activity: 984
Merit: 1000
Hey, just tested it with FF 35.0.1 (should be the latest version) and it's working good.
Latest version is 49.0.1  Cheesy
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
I don't see "New" button in latest Firefox on Enter Coins page. Bug?

Hey, just tested it with FF 35.0.1 (should be the latest version) and it's working good.
Can you please try:
- closing Firefox, reopen and check again
- check your Firefox Addons for some JavaScript blocking tools
- check if JavaScript is disabled in your Firefox

If it's still not working, can you please send me a screenshot to [email protected]

BTW: All other buttons (like edit or duplicate) are visible for you?
Thanks & best regards, Dario
full member
Activity: 196
Merit: 100
I don't see "New" button in latest Firefox on Enter Coins page. Bug?
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Hello,

@Soyouz:
Poloniex has changed their CSV layout multiple times in the last months, but the current one is working.
I just have checked the import with the latest CSV from Poloniex.
Please ensure you download the "Complete Trade History" on Poloniex.
Also please note that a Poloniex CSV does not include withdrawals and deposits.
If you have some, you have to enter them manually into CoinTracking as withdrawal or deposit, to ensure your coins are correct.

Poloniex API is still on our list.
Let me have a look, if it's save to use.


The Idea of "Easy Enter" was to create a very simple tool, to only get the current value (and optional the purchase value) of your coins.
The function you are requesting can be found in the regular trading system of CoinTracking.
Once you enter your trades, you can find the value of all your coins for every single day in the past in many charts and under "Reporting -> Daily Balance"


@bitcapitalist:
Thank you very much.
Do you have any exchanges in mind, you would like to see on CoinTracking?

Best regards and a nice weekend,
Dario
member
Activity: 110
Merit: 10
Nice tool! Great solution for traders and investors like me. Will check it out!  Wink

Do you plan on adding more exchanges?  Smiley

Thank you!
newbie
Activity: 2
Merit: 0
Ah and while I'm here, I also have a suggestion feature:

Don't you think it would be nice to have the possibility to "historize" the "Easy Enter Statistics" portfolio?.
Example:
On day 1, you press "historize" button and you portfolio is valued 100$ with X1 % of BTC Y1 % of ETH, Z1 % of AltCOIN and so on..
On day 2, you press "historize" button again and you portfolio is valued 120$ with X2% of BTC Y2% of ETH, Z2% of AltCOIN and so on..
And so on.

In that way, you will be able to follow up your portfolio value even when there is some errors with imports..
(maybe from the person who import by the way!)



newbie
Activity: 2
Merit: 0
Hello there,

I've read in that thread and on a previous post that the POLONIEX API support was on the TO DO list.
Is it still planned?
It would be really handy to support this exchange regarding its popularity for some alt-coins according to "Coinmarketcap".

Moreover, as for me, it seems that the .csv import is buggy.
It displays an incorrect amount for some of my coins.
And for some coins that I do not own anymore, my dashboard display a low residual value...

Thanks for your help!

hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
A new feature-request is online:

Balance of all Currencies by Exchange or Trade-Group
See all your currencies grouped by exchange or by a custom trade-group under "Reporting" -> "Balance by Exchange".
hero member
Activity: 760
Merit: 516
CoinTracking - Crypto Portfolio & Tax Management
Wow... just wow, I can't possibly thank you enough for creating this facility!
Beautiful work and I can't wait to see what else you have in the pipeline!

Hi Andy and thanks a lot! We're really glad to hear that.


Here just a few thinks we have worked on the last weeks:

New Tax Report by FIFO, LIFO, HIFO and LOFO
On time for the tax season 2016, we present our new tax report.
It includes a capital gains report for sales of capital assets and can be exported to many formats such as PDF, CSV, Excel, Form 8949, TaxACT and TurboTax.

Parameters such as the tax rates for short and long term, the method of calculation, exchanges and currencies can be adapted as needed.
Try it here: http://cointracking.info/tax/


CoinTracking now mobile-friendly on your Smartphone / Tablet
CoinTracking now detects mobile devices and automatically switches to the mobile mode incl. a new clearer navigation for mobiles and a much better presentation of all pages.
In the footer the mobile view can be enforced, deactivated or set to "automatic".





Import all transactions of a Bitcoin address
This new function will import instantly all transaction of a Bitcoin address into your CoinTracking account and will also add all future transactions of this address.
You can find it under: Enter Coins -> Automatic API Imports -> BTC Public Address Scan.


New API Import: The Rock Trading
Trades from the Rock Trading can now be imported automatically into CoinTracking.


Nice weekend and good trading!
Dario
Jump to: