CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies - page 61.

AltScope

sr. member

Activity: 714

Merit: 252

Quote from: CoinThreads on March 28, 2018, 03:27:52 PM

Is anyone else's Tax Report not catching all Deposits and Transfers between exchanges? (Specifically Bittrex).

I have all the API jobs running and tried uploading the Full Order History .CSV from Bittrex, however I am getting 13 "Warnings" when I generate a Tax Report, even though when I got back to my transactions list it shows both the Withdrawal from an exchange (ex. Bitfinex) and a Deposit (Bittrex).

I've also tried deleting those transactions and reuploading them with the same timestamps, however I still get those errors when generating the report. Everything else is relatively balanced in my portfolio.

If anyone has any expertise, or if you @Dario3000 have any insights, that would be greatly appreciated. I have a ticket open #13473 if that makes anything easier.

Thank you in advance for your help!

there needs to be a payment history for how you originaly obtained/bought the coins, I had major headaches with this.

lets say you bought a btc at bitstamp but you didn't enter the cash deposit as the correct type (income i believe) you will get a tax warning for the cash
if you traded say some ltc to btc on bitfinex but had the deposit type for the ltc as deposit(IN) rather than mining/income/gift it'll flag the ltc as a warning

CoinThreads

newbie

Activity: 2

Merit: 0

Is anyone else's Tax Report not catching all Deposits and Transfers between exchanges? (Specifically Bittrex).

I have all the API jobs running and tried uploading the Full Order History .CSV from Bittrex, however I am getting 13 "Warnings" when I generate a Tax Report, even though when I got back to my transactions list it shows both the Withdrawal from an exchange (ex. Bitfinex) and a Deposit (Bittrex).

I've also tried deleting those transactions and reuploading them with the same timestamps, however I still get those errors when generating the report. Everything else is relatively balanced in my portfolio.

If anyone has any expertise, or if you @Dario3000 have any insights, that would be greatly appreciated. I have a ticket open #13473 if that makes anything easier.

Thank you in advance for your help!

AltScope

sr. member

Activity: 714

Merit: 252

don't forget to delete the t from the middle of the timestamp, never tried without but cointrackings kinda finiky on the uploads. There have been more than a few instances where I've had to copy the entire sheet into a new one before it'll upload without errors (if it complains about timestamp errors but all timestamps are there try it)

Quote from: WickedPigeon on March 22, 2018, 08:23:33 AM

Quote from: AltScope on March 22, 2018, 05:08:18 AM

c'mon guys add XSN already

How about getting Coin Market Cap to list it.

I'm surprised its not there already as it was a coinswap from POSW, been a while now to but they still have just POSW listed.

Are you saying that unless its on coinmarketcap it wont be added? I would've expected other ways such as a selection of the many exchanges.
Relying on 1 websites kinda stupid

WickedPigeon

member

Activity: 345

Merit: 16

Quote from: WickedPigeon on March 25, 2018, 10:13:02 PM

Quote from: robinson5 on March 25, 2018, 05:41:42 PM

I'm having trouble figuring out how to calculate my mining income with cointracking, if someone could help me out.

I can make a tax report which calculates gains and losses. But my mining transactions that I've imported into cointracking are not calculated with that, since I haven't sold anything I've mined yet.

Is there a way to calculate what my income has been? The IRS says it should be calculated at the point of receipt, so it would be nice if cointracking added up the value of all my mining transactions at the time they were mined. Instead of calculating the current value of all my mining proceeds.

Thanks for the help!!

Are you recording/uploading your transactions from your wallet as "mining" ?

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 - I use the Excel file in CT bulk upload:
   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.

WickedPigeon

member

Activity: 345

Merit: 16

Quote from: robinson5 on March 25, 2018, 05:41:42 PM

I'm having trouble figuring out how to calculate my mining income with cointracking, if someone could help me out.

I can make a tax report which calculates gains and losses. But my mining transactions that I've imported into cointracking are not calculated with that, since I haven't sold anything I've mined yet.

Is there a way to calculate what my income has been? The IRS says it should be calculated at the point of receipt, so it would be nice if cointracking added up the value of all my mining transactions at the time they were mined. Instead of calculating the current value of all my mining proceeds.

Thanks for the help!!

Are you recording/uploading your transactions from your wallet as "mining" ?

robinson5

full member

Activity: 130

Merit: 100

I'm having trouble figuring out how to calculate my mining income with cointracking, if someone could help me out.

I can make a tax report which calculates gains and losses. But my mining transactions that I've imported into cointracking are not calculated with that, since I haven't sold anything I've mined yet.

Is there a way to calculate what my income has been? The IRS says it should be calculated at the point of receipt, so it would be nice if cointracking added up the value of all my mining transactions at the time they were mined. Instead of calculating the current value of all my mining proceeds.

Thanks for the help!!

moonshoot

member

Activity: 73

Merit: 51

Quote from: WickedPigeon on March 22, 2018, 08:23:33 AM

Quote from: AltScope on March 22, 2018, 05:08:18 AM

c'mon guys add XSN already

How about getting Coin Market Cap to list it.

It would be great if you could add Phore (PHR) to the Altcoin Wallet Import. It has been listed on CoinMarketCap for six months.

llanaio

newbie

Activity: 58

Merit: 0

I have 30K+ txs that I'm importing into Unlimited. It's vexing because some APIs are unreliable (KuCoin) and many wallets are unsupported. When all -Qt wallets have the same essential format, why the hell does CoinTracking not have a dedicated importer for them? It's absolutely ridiculous!

I have created a process for transferring QT wallets into CoinTracking accepted Excel files (or CSV files). Sharing in case it's helpful to others. This is easy to implement as an Excel macro or just to do if you only have a few wallets to sync.

QT Wallet Export CSV -> CoinTracking Excel Import Macro

1
Import CSV file.

2
Request CoinName text from user.

3
Check CSV Col-A (Confirmed) and delete any rows <> TRUE.

4
Modify Date to text as “YYYY-MM-DD HH:MM:SS” (use 24 hr time. If SS is blank add as 00) (If altering by hand, just find/replace "T" with " ".)

5
If CSV file Col-C (Type) = “Received with” then Output file Col-A (Type) == “Deposit”; Output Col-B (Buy Amount) == CSV Col-F (Amount); Output Col-C (Buy Cur.) == CoinName.

6
If CSV file Col-C (Type) = “Mined” then Output file Col-A (Type) == “Mining”; Output Col-B (Buy Amount) == CSV Col-F (Amount); Output Col-C (Buy Cur.) == CoinName.

7
If CSV file Col-C (Type) = “Sent to” then Output file Col-A (Type) == “Withdrawal”; Output Col-D (Sell Amount) == CSV Col-F (Amount); Output Col-E (Sell Cur.) == CoinName.

8
If CSV file Col-C (Type) = “Payment to yourself” then Output file Col-A (Type) == “Transfer”; Output Col-B (Buy Amount) == 0; Output Col-C (Buy Cur.) == CoinName; Output Col-D (Sell Amount) == 0; Output Col-E (Sell Cur.) == CoinName; Output Col-F (Fee Amount) == CSV Col-F (Amount); Output Col-G (Fee Cur.) == CoinName.

9
Output file Col-H == CoinName+“ wallet”; Output Col-J (Comment) == CSV Col-D (Label).

hammerhart

member

Activity: 381

Merit: 11

Quote from: hammerhart on March 17, 2018, 01:56:52 AM

Quote from: AltScope on March 16, 2018, 04:06:37 PM

Quote from: hammerhart on March 16, 2018, 03:42:18 PM

So after supervising the tool for 1,2 month i deciced to buy it as well;)
The API is nice- but i am wondering if there is already a sample list (with example setups for each exchange) available somewhere to import manually from exchanges which are not supported so far:
I thereby have in mind:
Coinexchange.io
Coinsmarkets.com
https://stocks.exchange/

For exchanges like coinsmarkets one has obviously first copy the trades into a xls file before being somehow able to import them;) Anyone has a link/hint for me?

Same i was wondering if there was a list, whith import-examples, somewhere to add other altcoins-wallets, which are not supported by the AltcoinsImport at the moment. Thinking about Rain/condensate/Boat/aerium etc.

My last question is if there is a nice guide/recommendation how to best consider staking coins with the tool- e.g. Pool-staking, POS, or special tokens like DAY.

Thank you for your support.

on cointracking
import from excel file
download the template (CoinTracking_Excel_Import.xls)
input the trades
upload

Thanks - well i somehow hoped for a "excel" file where there is already some kind of data-transformations-formulas implemented to be compliant with the required cointracking-style (e.g. date/buy/sell-order) Wink

Anyhow I am doing it myself now - i am planning to share it here so other dont have to do the same again;) but be warned i am not a guy of nice optics XD

***Update***
So my taxes are done- much more than i thought i would be:/
I will publish the next days an excel-file with example code i used for some exchanges to only/mainly copy-past the transactions and then import with cointracking- if anyone has already something similar- ffeel free to drop a line and i can maybe add my examples;)

So all together,

i uploaded my file to convert exchange data to a cointrack-format:
https://docs.google.com/spreadsheets/d/1kXmgfhlBVPDbpZ4dpg1ZcuyMC05S6kKeE3MMo9Vf85Q/edit#gid=242444363

Feel free to use on your own responsability. It was useful to me, maybe it is also useful for someone else- Even if it is just as a starting point for his own exchanges;)

MrBender

newbie

Activity: 8

Merit: 0

Gee that forgotten password system totally blows. What if i forgot my username.. then i can't reset my password.. yikes.

WickedPigeon

member

Activity: 345

Merit: 16

Quote from: AltScope on March 22, 2018, 05:08:18 AM

c'mon guys add XSN already

How about getting Coin Market Cap to list it.

AltScope

sr. member

Activity: 714

Merit: 252

c'mon guys add XSN already

FrankWatsonJr

newbie

Activity: 269

Merit: 0

I am interested in reviewing more of these tools for better UX

I will provide feedback when the time comes after I have done the full analysis with my Organizational audits

Pink Panther

newbie

Activity: 33

Merit: 0

hi, can you please disable deps/withdrawals for binance
regards

Onda_su_onda

newbie

Activity: 19

Merit: 0

Kindly, I would like to use this call to the CoinTracking API in Excel:

$result = cointracking('getBalance');

better if you could make a quick video to put in your youtube channel, but any form of manual for the user would be welcome

Thank you for your kind attention

jda009

newbie

Activity: 1

Merit: 0

Hi,

I am using pro version and trying to import transaction from Kucoin via API. I am always getting "Error: Signature verification failed" error for the last three days. Can anyone please shed some light on how to overcome this error?

~J

krypt0n1

full member

Activity: 238

Merit: 100

🔵 Brickblock.io - Future of Stock Trading

Quote from: shinep on March 19, 2018, 03:04:11 PM

Quote from: krypt0n1 on March 19, 2018, 11:50:28 AM

Is anyone else having trouble using the Liqui.io API? I've already manually entered the deposits and withdrawals since these cannot be accessed with the software's API, but the trades should be importing. I've deleted the API access and created a new API key but it still is listing zero imports.

Any help/insight would be appreciated.

I have the same issue. Looks like the liqui api is not supported for now.

I ended up manually entering since I didn't have too many liqui trades.
However, depending on your trade size and technical skill, I found this post about an hour after I posted. He includes a link to the script he wrote to import the liqui trades.

https://www.reddit.com/r/ethtrader/comments/7oldza/just_spent_about_12_hours_figuring_out_my_tax/

shinep

hero member

Activity: 630

Merit: 500

Quote from: krypt0n1 on March 19, 2018, 11:50:28 AM

Is anyone else having trouble using the Liqui.io API? I've already manually entered the deposits and withdrawals since these cannot be accessed with the software's API, but the trades should be importing. I've deleted the API access and created a new API key but it still is listing zero imports.

Any help/insight would be appreciated.

I have the same issue. Looks like the liqui api is not supported for now.

krypt0n1

full member

Activity: 238

Merit: 100

🔵 Brickblock.io - Future of Stock Trading

Is anyone else having trouble using the Liqui.io API? I've already manually entered the deposits and withdrawals since these cannot be accessed with the software's API, but the trades should be importing. I've deleted the API access and created a new API key but it still is listing zero imports.

Any help/insight would be appreciated.

eclips

newbie

Activity: 25

Merit: 0

hi, can you correct this :
https://reho.st/thumb/self/1ab11120a37e63d57a1d3afe12167d530dc60c0c.jpg

thanks

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