CoinDCX is one of the most popular crypto exchanges in India, and thankfully, they make it reasonably easy to download your tax report. But there are a few quirks — like headers starting at row 8 and separate sheets for different trading types — that trip people up. Let me walk you through the whole process.
Step 1: Log In to CoinDCX
Open coindcx.com on your desktop browser and log in to your account. While you can use the mobile app for trading, the tax report download works best on the web version. Make sure you're on the main CoinDCX site, not CoinDCX Pro (though they've largely merged now).
Step 2: Navigate to the Reports Section
Once logged in, click on your profile icon in the top-right corner. From the dropdown menu, select "Reports" or "Tax Center". CoinDCX has updated their UI a few times, so the exact label might vary — look for anything that says Reports, Tax, or Transaction History.
If you can't find it in the dropdown, try going directly to the Account Settings page. There's usually a "Tax Reports" or "Download Reports" tab there.
Step 3: Select the Financial Year
You'll see a dropdown or selector for the financial year. Choose the FY you want — for example, FY 2024-25 (April 2024 to March 2025). Make sure you select the right year. A common mistake is downloading FY 2023-24 data when you need FY 2024-25 for your current ITR.
Step 4: Select Report Type and Download
CoinDCX typically offers a Tax Report (XLSX) option. This is the one you want. Click "Generate Report" or "Download". Depending on how many transactions you have, it may take a few seconds to a couple of minutes to generate.
The file will download as an Excel file (.xlsx). Save it somewhere you can find it — you'll need it for CryptoITR upload.
What's Inside the CoinDCX Tax Report?
When you open the XLSX file, you'll notice it has multiple sheets (tabs at the bottom). Here's what each one contains:
Sheet 1: Instant
This covers all trades made through CoinDCX's Instant Buy/Sell feature — the simple interface where you buy or sell crypto at market price. Each row shows the date, crypto asset, buy/sell type, quantity, price, total amount in INR, and TDS deducted.
Sheet 2: Spot
This is your Spot trading history — orders placed on the order book with limit or market orders. It includes trading pairs (like BTC/INR, ETH/USDT), executed price, quantity, fees, and TDS. If you're an active trader, this is where most of your transactions will be.
Sheet 3: Futures INR-M
If you traded INR-margined futures on CoinDCX, this sheet has your futures PnL. It shows entry price, exit price, quantity, realized PnL in INR, and funding fees. For tax purposes, the realized PnL from each closed position is your taxable gain (or non-deductible loss).
Sheet 4: Futures USDT-M
Same as above, but for USDT-margined futures. The PnL here is in USDT, so you'll need to convert it to INR at the exchange rate on the date of each trade. CryptoITR handles this conversion automatically when you upload the file.
Important: Headers Start at Row 8
Here's a quirk that confuses many people. CoinDCX's tax report has summary information in rows 1-7 — things like your name, PAN, total trading volume, etc. The actual transaction data headers (Date, Type, Asset, Quantity, etc.) start at row 8.
If you try to open this in a tool that expects headers in row 1, it'll look broken. Don't try to manually edit the file to fix this. CryptoITR is built to handle this exact format and automatically picks up the headers from the correct row.
Understanding the TDS Columns
Each sheet includes columns for TDS deducted. CoinDCX deducts 1% TDS under Section 194S on sell transactions. The report shows:
- TDS Amount — the actual amount deducted in INR
- TDS Transaction ID — a reference you can cross-check with Form 26AS
Make sure the total TDS in the report roughly matches what you see in your Form 26AS under CoinDCX's TAN. Small differences (₹1-2) can occur due to rounding, but if you see a large gap, some transactions may not have been reported correctly. Contact CoinDCX support if the mismatch is significant.
How to Upload to CryptoITR
Once you have your CoinDCX XLSX file, uploading it to CryptoITR takes about 30 seconds:
- Go to CryptoITR.com and log in (or start a new calculation)
- Click "Add Exchange" and select CoinDCX from the list
- Upload the XLSX file you just downloaded
- CryptoITR will automatically detect all four sheets, parse the transactions, and calculate your gains
The tool handles the row-8 header offset, USDT-to-INR conversion for USDT-M futures, TDS extraction, and per-transaction gain calculation using FIFO method. Within a few seconds, you'll see your total taxable gains, total TDS, and a transaction-level breakdown.
Common Issues and Fixes
Report Shows Zero Transactions
Double-check the financial year. If you traded in April 2024 but selected FY 2023-24, those trades won't appear — they belong to FY 2024-25 (which starts April 1, 2024).
Missing Futures Data
CoinDCX sometimes separates futures data in a different section. If your Futures INR-M or USDT-M sheets are empty but you know you traded futures, try downloading the report again or contact CoinDCX support for a complete export.
File Won't Open / Corrupted
This occasionally happens if the download was interrupted. Just delete the file and download it again. If the problem persists, try a different browser — Chrome works best for CoinDCX downloads.
Old Transactions Missing
CoinDCX generates reports per financial year. If you need data from FY 2022-23, you'll have to generate a separate report for that year. CryptoITR lets you upload multiple files from different years if you need to establish cost basis from earlier purchases.
That's the whole process. Download the report, upload to CryptoITR, and you'll have your exact tax numbers in minutes. No spreadsheets, no manual calculations, no guessing about which row the headers start on.