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
Photo Viewer
View photos in a modal
Jack
Merged in a post:
Feature Request: New Declaration requirement for Canada/Quebec: Form TP-21.4.39 - Asset Categorization
H
Heliotrope purple Hummingbird
I am writing to request the addition of a new report or an automated classification feature that meets the tax requirements of Quebec (Canada), specifically for form TP-21.4.39.
Recently, Quebec tax authorities require that capital gains and income be broken down into very specific categories of cryptoassets. Currently, Koinly groups most transactions under a generic label, requiring us to do a lot of manual work to separate our earnings into the following classes:
Cryptocurrencies (Standard)
Security Tokens
Non-fungible tokens (NFTs)
Utility Tokens
Privacy coins
The problem:
The volume of transactions for an average user makes manual classification virtually impossible and subject to human error. As Canadian users, we need Koinly to be able to:
Identify the asset type automatically (via API metadata).
Allow the export of a specific report that groups the profits/losses by these categories.
The addition of this functionality would make Koinly the reference solution for the Quebec and Canadian market, which is becoming more and more demanding in terms of compliance.
I
Instant Blackbird
I 100% support this request.
You need a native report to answer form TP-21.4.39
The only solution offered by Koinly to date (see link) is not professional and requires the user to correct the numerous calculation errors present in Koinly's CSV reports.
https://feedback.koinly.io/feature-requests/p/quebec-canada-cryptoasset-return-tp-21439-v-form
We expect better.
T
Tiny Bird
Please add support. Tax season is coming in and I need this.
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 4.3, formerly 6.2).
In the end, I think Koinly needs to add a reliable, error-free report to answer the TP-21.4.39 form rather than leaving the problem in the hands of users.
I
Instant Blackbird
12 months later and no progress from Koinly.
In addition to not having a reliable report to answer TP-21.4.39-V, there are still just as many calculation errors in CSV reports for Capital Gains and Income.
It is still us who have the burden of correcting the Koinly amounts manually.
Really disappointing.
Jack
Instant Blackbird I don't think Google would allow its product to make calculation errors like that. The few cent difference is probably caused by rounding.
Gain/Loss column is calculated from exact values, not the rounded ones you see in Proceeds and Costs. So it may be off by 1 cent sometimes, and this difference may add up the more transactions you have.
Using your example: if the true totals were 4.311 and 0.729, then 4.311-0.729 = 3.582 -> 3.58, not 3.59
If you want gains to be calculated from rounded values, then ignore the Gain/Loss column in the CSV and add your own calculated column using a formula.
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 ?
Load More
→