Quebec Canada Cryptoasset Return TP-21.4.39-V form
Tasha
Please support new form for investors in Quebec https://www.revenuquebec.ca/documents/en/formulaires/tp/TP-21.4.39-V%282024-12%29.pdf
Workaround
- Generate a "Capital gains" report for custom dates: Jan 1st - Jun 30th (How to generate reports for custom dates)
- Open the file in Google Sheets
- Select the table and click Insert > Pivot table (see screenshot)
- Choose "New Sheet" in the popup
- Drag and drop "Asset" to "Rows", then "Amount", "Proceeds", "Cost", "Gain/Loss" to "Values" (see screenshot)
- Use the sums in the table to fill the form
- Repeat steps 1-6 for a report generated for Jul 1st - Dec 31st
S
Separate Turtle
Does any one knows if the copy paste of numbers is working on the form ?
I
Instant Blackbird
I followed the procedure. However, the amounts in the.csv file do not exactly balance with the totals in the full report.
The difference is a few cents but all the same, the amounts do not balance. My calculator makes fewer miscalculations.
For example: 4.31 - 0.72 = 3.56 according to the cross table when it should be 3.59
There are several other similar errors that add up. In the end, this distorts the Gains and Losses. We have to debug Koinly because you have to balance to the cent in the Revenu Quebec form (Section 4.1 and 4.2)
The same type of error occurs for interest income (Section 6.2).
In the end, I believe that Koinly needs to add a reliable report without errors to respond to the TP-21.4.39 form rather than leaving the problem in the hands of users.
O
Olive green Frog
That update of the TP-21.4.39-V form will be the reason I buy Koinly or not. Please add it,Thanks.
C
Collective Swallow
Yes please it would be really great if Koinly supported this kind of form.
Oui s'il vous plait, il serait vraiment super si Koinly supportait ce type de formulaire.
Merci!
M
Middle Dingo
So you should update these two pages:
And update your YouTube videos. In particular, in this YouTube video you are using the 2021 HR Block version and you have selected the T1170 instead of Appendix 3/G (Schedule 3)
C
Cool Stoat
Also, as an added step before creating the pivot table, you will probably have to convert all dots to commas for it to work properly. While you have the table selected, click Edit / Find and replace, then Find ''.'' Replace with '','' / Replace all
You then follow up with Insert / Pivot table etc.
T
Tropical Sheep
Is it possible to make the same type of sheet for staking rewards and lending interests ?