Hi Andreas_CoinTracking
I am having a couple issues with my detailed calculation tax report.
First, my ending share balance and ACB for my USDC tokens on the detailed report excel printout don't match anything else. I am off by the exact amount in the first line of the closing position report below (9577 shares and 12207.63 cost basis). You can see it has a wonky date and no buy/input value. Do you know how I can dig into where this is coming from? There are other tokens that have the same date and buy/input issues but the detailed calculation report isn't out of balance for them so im not sure where to begin.
CoinTracking - Closing Position Report
Amount Currency Date Acquired Buy/Input at Purchase Price in CAD Year End Price in CAD Cost Basis in CAD Year End Value in CAD Gain/Loss in CAD
9570.510 USDC 1969-12-31 1.2755473 1.27057488 12207.63861 12160.05002 -47.5885968
103.083938 USDC 2021-12-29 Sol Wallet DSAC 1.27504356 1.27057488 131.4365117 130.9758623 -0.46064943
102.755701 USDC 2021-12-29 Sol Wallet DSAC 1.27504356 1.27057488 131.0179953 130.5588126 -0.45918264
Also, often (but not always) when I open the excel file that exports for this report I get the following error: "we found a problem with some content in 'cointracking - detailed report.xlsx Do you want to try to recover as much as we can? If you trust the source of this workbook, click yes."
When I hit yes it opens and I get this message - "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Repaired Records: Cell information from /xl/worksheets/sheet1.xml part"
I don't necessarily see any issues with the file after but its hard to know for sure with over 20,000 lines of data so its a little concerning. Have you heard of this issue before and do you know a solution?
Finally, I noticed that the coins in the report are never in the same order twice (i.e. when I create a new tax report). Again I can't see any issues but its hard to confirm everything and its a little odd to me.
Thanks!