What is Tax P&L report?
Your broker gives you a contract note for every trade. Your mutual fund platform gives you a statement for every redemption. But none of those documents tells you what it means for your taxes. They tell you what happened; they do not tell you how the tax department sees it.
The Tax P&L report translates those transactions into tax language. It calculates your capital gains, separates short-term from long-term, identifies which gains come from equity and which from other assets, pulls out your intraday and F&O income as business income, and adds up your dividend income. It presents all of this in a single Excel file so that you have everything in one place when it is time to file ITR.
Taxable Income Summary Sheet
The Summary sheet is the right place to start when you open the Tax P&L report. Every other sheet in the report feeds into this one. Rather than listing individual trades, it pulls everything together into a single view: what you earned, what you lost, and how it all maps to your tax obligations for the year.
Capital Gains from Securities
When you sell securities like shares, mutual fund units, or bonds, the report captures every transaction and works out your taxable gain or loss automatically. This section covers three sheets: the Scripwise Delivery Summary sheet, the Delivery Settlements sheet, and the Schedule 112A sheet.
The most important factor in calculating your capital gains tax is how long you held the asset before selling. The holding period threshold and the applicable tax rates vary by asset type. The report uses these rules automatically to classify every transaction.
Capital Gains from Real Estate and Other Assets
The Real Estate sheet and the Other Assets sheet follow the same structure. Both cover capital gains from assets outside the securities world.
Dividends
Intraday Trading
When you buy and sell the same stock on the same day, no shares are delivered to your demat account. Tax law treats the resulting profit or loss as speculative business income under PGBP, taxed at your slab rate.
Futures and Options
F&O trades are treated as non-speculative business income under PGBP, taxed at your slab rate. Unlike intraday, F&O losses can be set off against other business income, but not against capital gains. For a full explanation, see How are profits from intraday and F&O trading taxed?
This section covers two sheets: the F&O sheet and the Open Positions sheet.
Other Charges
Not every expense you incur as a trader is captured in the individual settlement sheets. Charges like your annual account maintenance fee or a call trade charge have no connection to a specific buy or sell transaction. The Other Charges sheet is where these sit.
The sheet has two sections: Direct Expenses and Indirect Expenses. Both are broken down across Delivery, Intraday, and F&O.
Tax filing intimidates most people not because the rules are impossible to understand, but because no one ever explained what the numbers actually mean. That is what this report does, and what this page tried to do alongside it.
This report is free, built by Quicko. If you want the next step handled too, like tax planning to save money, advance tax calculation, tax payment, and ITR filing with all these rules applied automatically, sign up on Quicko and explore its paid plans.
Questions? Answered.
What is a Tax P&L report?
Is the Tax P&L report the same as my broker's P&L statement?
Which ITR form do I need if I have capital gains from equity?
What is the difference between short-term and long-term capital gains on shares?
Why is my cost of acquisition in the report higher than what I actually paid?
Can I set off my F&O loss against salary income?
What is tax turnover for intraday and F&O, and why does it matter?
Why does a stock I sold appear in both the short-term and long-term columns?
What happens to dividends in the report?
Can I carry forward losses if I do not file my ITR by the due date?