How to Download Your Holding Statement from Your Broker

How to Download Your Holding Statement from Zerodha

Your holding statement is essentially the inventory list of your demat account. Think of it like a kirana store owner’s stock register – it tells you exactly what you own, how many units, and at what average cost. If you trade or invest through a discount broker, downloading this statement takes about two minutes. Here is how.

What Exactly Is a Holding Statement?

A holding statement is a snapshot of all the shares and securities currently sitting in your demat account. It shows the company name, ISIN (a unique 12-character identifier assigned by NSDL or CDSL to every listed security), quantity held, and the average purchase price. It does not show your past trades or profits – those appear in separate reports.

Every investor who holds stocks, ETFs, or sovereign gold bonds in a demat account has a holding statement. Your depository participant – that is, your broker – generates it from the records maintained by CDSL or NSDL.

Why Do You Need Your Holding Statement?

There are three situations where you will need this document:

  1. Tax filing: When filing ITR-2 or ITR-3, you need to declare your capital assets. The holding statement is the source document for the Schedule AL (Assets and Liabilities) section if your income exceeds Rs 50 lakh.
  2. Portfolio review: Checking your actual holdings against your intended allocation helps you spot concentration risks. If one stock has grown to 30% of your portfolio, you may want to rebalance.
  3. Advisor meetings: If you are consulting a financial advisor or portfolio manager, they will ask for your current holdings as a starting point. A clean holding statement saves time.

How Is a Holding Statement Different from a Tradebook or a P&L Statement?

These three reports are often confused. Here is how they differ:

Report What It Shows Time Period Used For
Holding Statement Current securities in your demat account Snapshot (as of today) Portfolio review, ITR Schedule AL
Tradebook Every buy and sell transaction executed Date range (custom) Tax computation (FIFO), brokerage tracking
P&L Statement Realised and unrealised profits/losses Financial year ITR capital gains schedule, tax planning
Contract Note Single day’s trade confirmations One trading day Trade verification, dispute resolution

How Do You Download Your Holding Statement from Your Broker’s Web Platform?

Most discount brokers run a back-office or reports portal, separate from the trading terminal, where all your statements live. The steps are broadly the same across brokers:

  1. Log in to your broker’s back-office or reports portal using your client ID and password.
  2. Click on Portfolio or Holdings in the left sidebar menu.
  3. Open the Holdings view. You will see a table listing all your current holdings with quantity, average cost, current value, and day’s P&L.
  4. Click the download icon (usually a small arrow pointing downward) at the top-right corner of the holdings table.
  5. Choose your preferred format – CSV (opens in Excel or Google Sheets) or PDF (for printing or sharing).

The file downloads immediately. No waiting period, no charges.

How Do You Download Holdings from Your Broker’s Mobile App?

If you prefer using your broker’s trading app on your phone, the flow is similar to the web version:

  1. Open your broker’s trading app and tap on the Portfolio tab, usually at the bottom of the screen.
  2. You will see your holdings listed with current market values.
  3. Tap the menu icon (often three dots) at the top-right corner.
  4. Select Download or Export to save the holdings report to your device.

For an official statement from the depository, you can also download the CDSL Easi or NSDL e-CAS statement. These are consolidated holding statements that show your holdings across all demat accounts, not just with one broker. The CDSL e-CAS is particularly useful if you have accounts with multiple brokers.

What Should You Check After Downloading?

Once you have the statement, run through these quick checks:

  1. Verify quantities: Make sure the number of shares matches your records. Discrepancies are rare but worth catching early.
  2. Check concentration: If any single stock exceeds 15-20% of your total portfolio value, you may be overexposed to that company’s risk.
  3. Review average cost: The average cost shown is your effective purchase price after accounting for multiple buys. This is the number used for capital gains calculation.
  4. Plan your next move: Use the holding statement alongside a SIP Calculator to plan fresh investments that balance your existing portfolio.

Frequently Asked Questions

Can I download my holding statement as a PDF?
Yes. Most brokers offer both CSV and PDF download options from their reports portal. The CSV format is better for analysis in Excel, while PDF works for sharing with advisors or submitting to banks.

Does the holding statement include mutual funds bought through my broker’s app?
Not always. Mutual fund units purchased through a broker’s in-app mutual fund platform are typically held in a separate account with the respective AMC or its Registrar and Transfer Agent (RTA). You can download your mutual fund statement from the MFCentral portal or from the AMC website directly.

How often should I download my holding statement?
Once a quarter is sufficient for most investors. Download it at the end of each financial quarter (June, September, December, March) to track your portfolio over time.

Is a broker’s holding statement accepted as official proof?
For most purposes, yes. Banks and financial institutions generally accept it. For legal or regulatory matters, you may need the CDSL e-CAS or NSDL statement, which comes directly from the depository.

Does the holding statement show pledged shares?
Yes. If you have pledged shares as collateral for F&O trading, the statement will indicate the pledged quantity separately. These shares remain in your demat account but are marked as pledged with the clearing corporation.

To Sum Up

To sum up, downloading your holding statement is a two-minute task that every investor should do at least quarterly. It is your portfolio’s inventory register – the foundation for tax filing, rebalancing decisions, and meaningful conversations with financial advisors. Log in to your broker’s reports portal, open Portfolio, download, and you are done. For tax filing, pair it with your P&L statement to compute capital gains accurately.

Plan your next SIP with our free Calculator →

Try our free Gold Investment Calculator →

Try our Portfolio Rebalancing Calculator →