Coinbase: bittytax_conv mis-classifying trade as gift-received about bittytax

[nanonano]

The previous Coinbase export format had a lot more detail, with this one it's difficult to categorise the transactions correctly.

I think it would be safer to assume 0 fees is also a standard trade, and then it will be a case of manually checking the transaction records to see if any Trade's were early referral rewards (i.e. around £7.xx) and changing them to Gift-Received, and do the same for the BSV airdrops.

[nanonano]

Hi @wayneprice I've pushed a fix for this, please can you re-test?

Early coinbase referral rewards were being differenciated from regular trades (they look identical) by checking if they had a zero fee.

This is no longer viable, as some trades can legitimately have zero fees. Instead these early referrals will have to be manually changed to Gift-Received, with the sell amount in GBP moved to the Buy Value field.

Airdrops can also look like regular trades and will need manual correction.

I've also added the change below so you will notice your "Convert" transactions now have buy/sell values populated.

This change also includes an improvement to populate the buy/sell value where possible for non-Trades (i.e. "Coinbase Referral", "Coinbase Earn", "Rewards Income", "Convert") using the GBP total or calculated from the GBP spot price.

[wayneprice]

Yes, all seems OK.

Only awkward thing is changing the (now incorrect, as expected) BSV to a 'Gift Received' prior to generating the tax report itself. The 'Trade' type in the drop-down can only be 'Trade', so can't be changed. I did try a quick hack for the validation to allow 'Trade' or 'Gift-Received', but with that, and changing the BSV entry to Gift Received complains that Sell Asset/Quantity are not blank as expected when generating the report.

So to manually change the BSV drops, choices are:

• Set the Sell Quantity for these to 0

or with the hack:

• Change to Gift Received and delete/erase Sell Quantity/Asset

[nanonano]

Thanks @wayneprice.

Yes correcting any Trade to be Gift-Received is not simple, the validation does not support this as it's not normally part of the work flow.

You either need to disable the validation, or copy/paste it from another cell which contains a genuine Gift-Received.

Yes for a fork airdrop you could set the Sell Quantity to zero, this is the same as making it a Gift-Received with a Buy Value of 0.

In the pipeline are Excel macros to help with this sort of thing, a macro could change the Trade' to Gift-Received` and automatically move the Sell Quantity into the Buy Value, before removing the Sell Quantity/Asset. You would still have to manually change the Buy Value to zero to differentiate between a fork and a Coinbase referral.

[nanonano]

Hi @wayneprice I've just pushed a change c675904 to add a new config item "coinbase_zero_fees_are_gifts", to switch the parser from handing zero fees as Trades (default) to Gifts.