Why Zerodha Users Need a Tax Planning Strategy
Zerodha is India's largest stock broker by active clients, and for good reason. The platform is clean, commissions are low, and Kite makes trading simple. But when it comes to tax planning, many Zerodha users struggle because they do not know which reports to use, what the numbers mean, or how to turn raw data into actionable tax decisions.
Zerodha provides all the data you need through Console, its back-office reporting platform. The challenge is knowing which report to download, how to interpret it correctly, and what to do with the information. Most users glance at their P&L, feel either happy or sad about the number, and move on without actually planning.
This guide walks you through every step of the process: from logging into Console and downloading the right reports, to understanding what each report contains, to using that data for year-end tax optimization. Whether you use TaxHarvestLab or work with a CA, this guide ensures you have the right data in the right format.
If you trade or invest through Zerodha, this is the definitive resource for turning your Console data into real tax savings.
Understanding the Zerodha Tax P&L Report
The Tax P&L report is your primary document for tax planning. Here is what each section means.
The Equity Intraday section covers trades where you bought and sold on the same day. These are treated as speculative business income, not capital gains. They have separate tax treatment and are not relevant for capital gains planning.
The Equity Delivery section is what matters for investors. This section shows: - Buy date and buy price for each lot - Sell date and sell price - Quantity sold - Realized profit or loss per transaction - Whether the gain is short-term or long-term
Zerodha uses FIFO (First In, First Out) methodology for the Tax P&L report, which aligns with the Income Tax Department's requirement. This means if you bought 100 shares of a stock in January and 100 more in June, and then sold 100 shares in August, the report matches the sale against the January purchase first.
The report also provides a summary at the bottom showing total STCG, total LTCG, and turnover. These summary numbers feed directly into your ITR.
One caveat: the Tax P&L report only shows realized transactions. It does not show unrealized gains or losses on your current holdings. For tax planning, you need both.
Understanding Holdings and Unrealized Gains
Your Tax P&L tells you what has already happened. Your holdings report tells you what could happen, and this is where tax planning really begins.
In Zerodha Console, the Holdings section shows each stock you currently own, including: - Stock name and ISIN - Quantity - Average buy price - Current market price - Unrealized P&L
However, there is a critical limitation. Console shows average buy price, not FIFO cost basis. If you bought shares of the same stock on multiple dates, the average price blends them together. But for tax purposes, the FIFO method applies, meaning the oldest shares have a specific cost basis that may be very different from the average.
This is one of the most common gotchas for Zerodha users. You might see a stock showing a small unrealized profit based on average cost, but under FIFO, your oldest lots might have a large profit while recent lots have a loss. Or vice versa.
TaxHarvestLab solves this problem by reconstructing your FIFO cost basis from your tradebook data. When you upload your Zerodha holdings, the tool calculates the true tax cost for each lot, giving you an accurate picture of your tax position rather than the averaged view Console provides.
How to Download Reports for TaxHarvestLab
TaxHarvestLab is designed to work seamlessly with Zerodha data. Here is the exact process to get your data ready.
Step 1: Log into console.zerodha.com
Step 2: Go to Portfolio > Holdings. This page shows your current holdings. You do not need to download a file. TaxHarvestLab can work with the holdings data you see on screen. Simply copy the relevant data or use the export option if available.
Step 3: For a more detailed analysis, download your Tradebook from Console > Reports > Tradebook. Select the financial year and equity delivery segment. Download as CSV.
Step 4: Upload your data to TaxHarvestLab. The tool accepts Zerodha's format directly. You do not need to reformat or modify the CSV files.
Step 5: TaxHarvestLab processes your data, applies FIFO cost basis, separates short-term and long-term holdings, and identifies every optimization opportunity. It shows you exactly which stocks to sell for loss harvesting, which to sell for gain harvesting within your LTCG exemption, and the exact tax impact of each action.
The entire process takes about 5 minutes from logging into Console to seeing your personalized tax optimization recommendations.
Common Zerodha-Specific Gotchas
After working with thousands of Zerodha users, here are the most common issues that trip people up.
Gotcha 1: Average price vs FIFO cost. As mentioned, Console shows average buy price in holdings. This is fine for tracking portfolio performance but misleading for tax planning. Always use FIFO-based calculations for tax decisions.
Gotcha 2: Corporate actions and bonus shares. When a company issues bonus shares, Zerodha adjusts your holdings, but the cost basis of bonus shares is zero for tax purposes. The Tax P&L report handles this correctly, but your holdings view may show a blended average that obscures this.
Gotcha 3: Demerger and stock splits. After a demerger, Zerodha may show the demerged entity as a separate holding with a cost basis derived from the original company. Verify this against the demerger ratio announced by the company, as errors can occur.
Gotcha 4: Mutual fund holdings are separate. If you invest in mutual funds through Zerodha's Coin platform, those holdings appear in a different section of Console. Coin uses a separate reporting structure, and mutual fund capital gains have their own rules.
Gotcha 5: Intraday vs delivery confusion. Ensure you are looking at equity delivery data, not intraday. Intraday trades are speculative business income and should not be mixed into your capital gains calculations.
Building Your Zerodha Tax Plan: A Practical Example
Let us walk through a concrete example. Suppose your Zerodha Tax P&L for the year shows: - Realized STCG: Rs 45,000 - Realized LTCG: Rs 80,000 - No realized losses so far
Your current holdings (FIFO basis) show: - Stock A: Bought 14 months ago, unrealized loss of Rs 30,000 (long-term) - Stock B: Bought 8 months ago, unrealized loss of Rs 20,000 (short-term) - Stock C: Bought 18 months ago, unrealized gain of Rs 60,000 (long-term)
Here is your tax plan:
First, you have Rs 45,000 remaining LTCG exemption (Rs 1,25,000 minus Rs 80,000). Sell enough of Stock C to realize Rs 45,000 in long-term gains. This is completely tax-free under the exemption. Buy Stock C back immediately if you want to keep holding it.
Second, sell Stock B to book the Rs 20,000 short-term loss. This offsets Rs 20,000 of your Rs 45,000 STCG, saving you Rs 4,000 in STCG tax (20% of Rs 20,000). Buy Stock B back immediately if you still believe in it.
Third, consider selling Stock A for the Rs 30,000 long-term loss. This can offset LTCG from the Stock C sale or be carried forward to next year.
Total savings: Rs 5,625 on the gain harvesting (avoiding 12.5% on future Rs 45,000 LTCG by resetting cost basis) plus Rs 4,000 from loss harvesting. Nearly Rs 10,000 in savings from a few minutes of planning.
Generating Reports for Your CA
If you work with a Chartered Accountant, having clean, organized data saves time and reduces errors. Here is what to share from Zerodha.
For your CA, download and provide: - Tax P&L report from Console for the full financial year (April to March) - Tradebook for the full financial year as backup documentation - Holdings statement as of March 31 - Any contract notes for corporate actions (bonus, splits, demergers)
If you use TaxHarvestLab, the tool generates a summary report that condenses your entire tax position into a CA-friendly format. It shows total STCG, total LTCG, losses harvested, exemption used, and carry-forward losses in a clear table. Many CAs prefer this format because it saves them from manually parsing through hundreds of rows in a tradebook.
When discussing with your CA, focus on three questions: - Is there any remaining LTCG exemption I should use before March 31? - Do I have any carry-forward losses from prior years that are about to expire? - Is my advance tax obligation covered, or do I need to pay before March 15?
These three questions, combined with accurate Zerodha data, form the foundation of a solid tax plan.
See how this applies to your portfolio
Upload your Zerodha or Groww reports and get personalized recommendations in under 2 minutes.
Analyze My Portfolio FreeFrequently Asked Questions
Where do I find my capital gains report in Zerodha Console?
Log into console.zerodha.com, go to Reports > Tax P&L. Select the financial year and the Equity segment. The report shows all your realized gains and losses separated into short-term and long-term categories, using FIFO methodology.
Why does my Zerodha holdings page show a different P&L than my actual tax liability?
Zerodha Holdings shows unrealized P&L based on average buy price. For tax purposes, India mandates FIFO (First In, First Out) cost basis. If you bought the same stock on multiple dates, the average price and the FIFO cost basis can be significantly different, leading to different P&L numbers.
Can TaxHarvestLab work directly with Zerodha data?
Yes. TaxHarvestLab is designed to accept Zerodha Console data directly. You can upload your holdings data from Console, and the tool will automatically apply FIFO cost basis, identify loss and gain harvesting opportunities, and calculate your exact tax savings.
Does the Zerodha Tax P&L report include mutual fund transactions from Coin?
No. Mutual funds purchased through Zerodha Coin are reported separately. The Tax P&L report on Console covers equity delivery, intraday, and F&O trades. For mutual fund capital gains, you need to check the Coin section or use a consolidated statement from CAMS or KFintech.