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

[Andreas_CoinTracking]

@scatterbug
Okay. So in that case I suggest to use a separate transaction type which you do not use somewhere else e.g. minting. And then set this income transaction type slider to middle state (there are some of them which are all listed on the income report just with a different transaction type). 

[dr1ver]

We import transactions 1:1 as they appear in reality. And every transaction count - there is no way to exclude transactions from those limits.
Some customers combine those to daily/weekly/monthly or even yearly transactions if allowed according tax laws in each country. This has to be done manually.
Then you can set a start date to API jobs to avoid re-imports.
Please create a backup beforehand.

So just to be clear on the steps:
1. Backup!
2. Edit Binance.com API in CT to modify Start Date
3. Export using the Trade List - so that I can combine all Interest Income in Excel
4. Delete Interest Income transactions from CT
Is there a way I can do this in one go?
Can I delete all Interest Income just for a specific coin/currency?
5. Use the CoinTracking Excel Import template to combine Interest payments, and upload this

[Andreas_CoinTracking]

Yes exactly.
There is no "one go" here. Just manual way via Excel und set start date to prevent re-import.
Bulk Deletion is not possible for one coin, just for a whole exchange. You can do this via Filter and select those transactions with CTRL+SHIFT to delete those.

[dr1ver]

Yep - I don't need any guidance the basics of Excel   

So Steps 4 & 5 are:
4. Delete *All Transactions* from CT for the Exchange that contains Interest Income
5. Using the CoinTracking Excel Import template:
- combine Interest payments for the date range and for the Exchange
- upload *all transactions* for the date range and for the Exchange (but now with combined Interest Income, rather than granular Interest Income)

[Andreas_CoinTracking]

Yes, sounds good.

[dr1ver]

actually that won't quite work, because CT won't let me bulk delete for a given date range (I assume), so I'll need to do all transactions for the Exchange in Excel, not just the ones in a date range

[dr1ver]

I earn interest on BSC at Vaults at AutoFarm.Network and at Beefy.Finance, and these are not included in CT.
Do I need to add these manually?

If the answer is "yes", is there a way I can filter out Interest Income from the Binance API?
Then I can just upload all Interest Income manually rather than having to go through multiple steps of backup, exporting, deleting etc

[Andreas_CoinTracking]

Bulk delete by date range and by exchange is possible. But not via transaction type or something in addition.
In this case you need to filter (search) for them on "enter coins" page and select them with CTRL+SHIFT and delete them there.

[Andreas_CoinTracking]

BSC: they should come in via BSC API import.

[dr1ver]

ah sorry - I didn't appreciate that your CTRL+SHIFT comment was about CT and not Excel - ok that makes things easier 

CT shows my deposits into the vaults, and the vault tokens, but not the interest being earned. Maybe the interest isn't being posted onto the blockchain, but just at the sites, until I do a withdrawal (?)

[Andreas_CoinTracking]

We would need specific wallets here to comment on that. I would suggest to raise ticket with account name and the wallet address here.

[scatterbug]

@scatterbug
Okay. So in that case I suggest to use a separate transaction type which you do not use somewhere else e.g. minting. And then set this income transaction type slider to middle state (there are some of them which are all listed on the income report just with a different transaction type). 

Gotcha, that is what I've been doing in the meantime.
I just thought there is an "official" way to do it, so to speak.^^
At the moment I'm using "Other Income" and set that to a zero cost basis.

The problem with the other income types (as you've mentioned) is that they add additional transactions or make further changes that are not desired.
E.g. when choosing "Minting" or "Masternode" and setting that to 0 cost basis, then it also sets the proceeds to 0.
When choosing "Derivatives" or "Margin Profit", then in addition to adding the gift-sale with 0-cost (which is the desired outcome) it also adds the gift-transaction itself as another sale with 0-cost and 0-proceeds.
That would be fine as well, as they come out as a zero gain/loss, but I don't like having them listed on the tax report when there was no actual additional sale.

It seems the only way to have a 0 cost basis gift-sale be added correctly is by adding it as "Other Income" and setting that transaction-type to 0 cost basis.
Which works fine at the moment, but if I ever have "Other Income" that shouldn't be calculated at 0-cost, then I can't properly record that without influencing the 0-cost gift-sales.

Another (though less problematic) thing is that the filter of the tax generation screen doesn't seem to save the filter settings, so one always has to remember to set "Other Income" to 0 cost basis.
Because of that and the other problems, it would be super helpful if there was a way to mark individual transactions with a 0 cost basis.
Or alternatively to let us set the group-sliders to 0 cost basis as well.
Maybe for a future update? 

[Andreas_CoinTracking]

@scatterbug
okay, just stick to income transactions instead of margin PnL as there is a different group then those several income transaction types.

Reset to default values creating tax report is on purpose.

Another idea would be to edit the asset value of your transactions manually and set it to 0,00000001 (could not be 0).

[scatterbug]

Another idea would be to edit the asset value of your transactions manually and set it to 0,00000001 (could not be 0).

Omg, that's it!
I sear I've tried to enter a near-zero value before and it didn't save. But it does seem to save if the fractional part has no more than 8 digits. *self-facepalm*
It works wonderfully now (both in the Cointracking tables and the tax reports) without any workarounds I might forget in a year.  


Thanks a bunch for all the help, much appreciated! ♡

[Andreas_CoinTracking]

Great to read that. You are welcome.

[dr1ver]

Hi,

I wonder if you can help me with the Missing Transactions report. I don't understand some of the basics of how this report works.

I've read the article on the Support page:
https://cointracking.freshdesk.com/en/support/solutions/articles/29000033710
I've read the FAQ on https://cointracking.info/missing_transactions.php
I've searched for "missing" in this forum.

Before I understand White transactions, I think I need to understand Green transactions.
For a Green transaction, is this table showing *pairs* of rows that have been matched up? If so how do I know which 2 rows are a linked pair?
I assume the table should be sorted by date? Is the goal to not have any data in this table? Or is the goal to have all transactions appearing in green, where a withdrawal matches a deposit?
For instance I have the following 2 green transactions. Are they green because they have matched with each other? (I have remove the Comment and TradeID)

Deposit   141.20800000   1INCH         496.35098647   BSC Transaction         2021-04-20 17:57:28   100.0000% (High)

Withdrawal   -141.26000000   1INCH   0.05200000   1INCH   496.53376827   Binance      2021-04-20 17:56:52   100.0000% (High)


Is this telling me there is problem that I need to fix? Or is it saying it is green and so there is nothing to be done?

[Andreas_CoinTracking]

There is nothing to do regarding green lines. Only white entries need to be checked as described in the FAQ. Just focus on them.
And yes they are green as they are detected as counterpart transaction - a deposit must always have a counterpart withdrawal in your portfolio. Otherwise it is the wrong transaction type or the counterpart is just missing as transaction.

[ctdude]

In Enter Coins, the regex filters don't seem to work if you are in Server Side Processing mode. They only seem to work if you are using Client Side. Is there a fix for this?

[Andreas_CoinTracking]

Correct, only in CSP mode search is working.
You need to use the "advanced search mode" here - on Top above your transactions on the right.
Details are shown in the "Enter Coins" Page when you click on "CSP Mode" below your transaction list there.

[Andreas_CoinTracking]

Updates and Improvements
- New CSV Import: Swissborg

- OKEX CSV import now supports the new file format
- Trezor CSV import now supports the new file format
- Crypto.com CSV import update (new transaction types)
- Nexo CSV import update (new transaction types)
- Bitcoin Suisse CSV import update (support for multiple formats)

- Kucoin API import update (support for Kucoin v2 API Keys - all v1 API Keys will be deactivated by Kucoin on 1 May 2021!)

- Binance API import update (fix for ratelimit errors)
- Bitfinex API import update (import of airdrops + profit/loss updates)
- Bitpanda API import update (import of ICOs)
- Indodax API import update (fix for ratelimit errors)
- Bittrex API import update (fix for withdrawals)

- Binance Smart Chain Import Update

- Airdrops and rewards can now be excluded from the capital gains calculation
- FBAR Report adjustments in the tax reports