GBP Final Balance value

[fieryfurnace99]

I have noticed that the GBP value in the Final Balances section seems to be wrong.

I understand the data you get out of it is only as good as the input you put in.
I went through one of my wallets with a fine toothcomb, tracking all instances where I deposited GBP, bought and asset, including the transaction fee, and any disposals/withdrawls.

My manual calculation shows that all of the various trade types calculated my final GBP balance as 0, yet the pdf report is showing that I have a GBP value. Interestingly, the values of crypto each assett I own per wallet match perfectly, so i'm confused what is going on with the GBP.

Could this be a bug?

[nanonano]

Not all wallets/exchanges provide details of all fiat deposits/withdrawals so sometimes they will show a negative balance. This is not a problem regarding the tax calculations, but if you would like the audit to balance correctly you can manually add any missing GBP deposits/withdrawals.

Out of interest, what wallet/exchange does not balance for GBP in the audit?

[fieryfurnace99]

The exchange is coinbase pro (from when they used to have regular coinbase and coinbase pro as 2 separate wallets - whereas now you just have a single coinbase wallet and toggle between basic and advanced modes).

I have manually entered the majority of the data myself. I can see my GBP deposits, and then using GBP are my crypto transactions. The only GBP values left are the odd pence values here and there.

I will take another look to see if I can spot anything obvious, but the value that the report calculates doesn't add up as I've generally deposited round numbers such as £1000. But the GBP value it calculates is something like £264.35.

[fieryfurnace99]

I have worked out my issue.
When I have transferred or sold an asset, I have written the GBP value in column J 'Fee Value in GBP' not realising that I also should have entered that value in column H 'Fee Quantity' and the asset GBP in column I.

Also, after correcting the above, I have also realised when selling an asset for fiat, then the total sale amount goes in column A and the fee amount in column H. I was entering the amount I phsically recieved - exluding the fee in col A, and then the fee in col H which was skewing the figures.

[nanonano]

Glad you figured it out.

If the Buy/Sell/Fee Asset is GBP, then no need to specify the Buy/Sell/Fee Value. You just need specify the Quantity, that's it.