This help page explains how to add crypto transaction details to schedule VDA by downloading JSON file from e-Filing homepage.
Contents:
1. Introduction
If you'd like to learn how to report your cryptocurrency taxes on the e-Filing homepage, please refer to the blog article below. It covers everything from declaring gains under Schedule VDA to reporting other types of crypto income.
Step-by-Step Guide on Filing Crypto Taxes in India
While the above article explains filing tax on the e-Filing online, this help page introduces the method of declaring crypto transactions – Schedule VDA offline — no need to input each transaction manually.
2. Log in e-Filing account
2-1. Please access to e-Filing homepage.
2-2. Please log in e-Filing account and fill out the necessary information online.
3. Download JSON file
4. Download Utility Excel Based file
4-1. Select "Downloads" option.
4-2. Download "Utility Excel Based" file.
4-3. The file is downloaded as ZIP file, so please extract all and obtain the Excel Macro-Enabled Workbook (.xlsm) file.
4-4. Right-click on the Excel Macro-Enabled Workbook file and select “Properties” from the menu that appears.
4-5. Add check to "Unblock" and click "Apply," and then "OK."
5. How to import/generate JSON file
5-1. Please open the Excel Macro-Enabled Workbook (.xlsm) file.
On the "PART A-General" sheet, select "Import JSON" from the right menu, and then click "OK."
5-2. Please open the downloaded JSON file.
5-3. Once you open the JSON file, select "Generate JSON" on the "PART A-General" sheet.
5-4. When the dialog opens, select "VDA" and click "OK."
5-5. Click "OK" again.
6. Add transactions to VDA
6-1. Download "Capital Gains Summary" file from cryptact.
・Capital Gains Summary (the file titled "cryptact-india-capital-gains-summary-[Year]")
How to generate tax reports and calculation result files
6-2. On "VDA" sheet, add rows you want to add by clicking "Add Rows."
6-3. Copy and past the column (I to M) to the VDA sheet.
Note: To ensure that your data is correctly reflected in the e-Filing system, it must be entered in the proper format. The "For e-Filing" columns in cryptact’s report (from column I onward) are already prepared for direct copy and paste. Specifically, since the e-Filing system only accepts dates in year-month-day format, columns I and J contain dates with the time removed. Additionally, all numerical values must be entered as whole integers, so the values in columns K to M are rounded versions of the actual report figures
6-4. Once the data is input, select "Validate" from the right menu.
7. Calculate TAX
7-1. Move to "PART A-General" sheet and click "Calculate TAX" from the menu on the right.
7-2. Once you confirm the sum of the capital gains displayed on the dialog, click "OK."
7-3. Enter the value of the capital gains on transfer of Virtual Digital Asset taxable at the rate of 30%.
7-4. Click "Validate."
7-5. Then click "OK."
8. Validate
8-1. Go to "PART A-General" sheet , and select "Calculate TAX" from the menu.
8-2. Address the errors encountered. (In this example, the value was blank on the "OS" sheet)
8-3. After you fix the issue, click "Validate" on the "OS" sheet.
8-4. Click "OK."
8-5. Go back to "PART A-General" sheet, and click "Calculate" from the right menu.
*Please repeat this steps until all the errors are cleared.
8-6. Once all the errors are cleared, click "Generate JSON."
8-7. Click "OK" after you read the messages.
9. Save JSON file
9.1 Click on "Save JSON" to generate JSON file.
9-2. Click "OK."
10. Import JSON file to e-Filing
10-1. Log in e-Filing account and go to "e-File"→"Income Tax Returns"→File Income Tax Return."
10-2. Select the appropriate option and click "Continue."
10-3. Upload the JSON file and then click "Proceed to verification."
10-4. Select a verification method and click "Continue."