Trading Journal for Tax and ITR: Records to Prepare
Prepare your trading journal for tax and ITR review with broker records, actual charges and a clear period. See a reconciliation example and questions for a CA.
A trading journal can support tax and income-tax return (ITR) preparation by explaining your trades and helping you check records. Prepare the broker's execution history, contract notes, ledger, relevant bank records and your journal export for review together. OneTradeJournal records trades manually and estimates charges. Its totals do not determine taxable income, the correct return form or whether you need an audit.
Start by naming the period correctly
The Income Tax Department's transition FAQ distinguishes AY 2026-27 (assessment year) under the Income-tax Act, 1961 from Tax Year 2026-27 under the Income-tax Act, 2025. The Tax Year concept applies from 1 April 2026; the older law continues to govern years that began before that date. These labels are not interchangeable simply because they contain the same years.
Write the period on the folder and on each export. Ask your chartered accountant (CA) which period, law and forms apply to the records being prepared. Keep files for different periods separate; this guide does not give filing deadlines, tax rates or an audit-threshold shortcut.
What the Income Tax Department Says About the New Act
The Department's transition FAQ, opened on 28 Oct 2026, explains the change of law. It says the Income-tax Act, 1961 stands repealed on 1 April 2026 and the new Act takes effect from that date. It defines a tax year as a period of twelve months contained in a financial year, and says the term assessment year has been discontinued under the new Act. The FAQ also says the old Act's provisions continue to govern tax years beginning before 1 April 2026.
In practice, income earned in the financial year that began on 1 April 2025 maps to assessment year 2026-27 under the old Act, while income from the year starting 1 April 2026 falls under the new Act's tax year. A chartered accountant (CA) will tell you which forms and sections apply to which of your records. Label every export with the financial year and the law your CA names.
Terms You Will Meet at Filing Time
| Term | Plain meaning | Where it usually comes from |
|---|---|---|
| Contract note | The broker's document for each trading day, showing trades, prices and charges | Your broker |
| Ledger | The running account of money and charges between you and the broker | Your broker |
| Tax P&L or realised P&L statement | The broker's own summary of closed trades for a period | Your broker, if it offers one |
| Turnover | A figure worked out by rules, not simply the total value you traded. The correct method depends on the type of trade | Your CA, using the broker records |
| Books of account | Records that some people must keep and that may need an audit | Depends on your circumstances |
| Tax year or assessment year | The label for the period being reported | The Income Tax Department |
| ITR form | The return form you file, such as ITR-3 | Chosen with your CA |
Turnover is the term that confuses most people. A journal total, a bank balance and a turnover figure are different numbers answering different questions. Do not copy a turnover figure from a journal screen onto a return.
A records pack for your CA
| Suggested record | What it helps you check |
|---|---|
| Broker execution history and contract notes | Actual instruments, fills, quantities, dates and charged amounts. |
| Broker ledger and bank records | Deposits, withdrawals, charges and differences needing explanation. |
| Holding and open-position records | What remained open at the period boundary and what actually closed. |
| Separate expense documents | What an expense was and whether it relates to the activity being reviewed. |
| Journal export and notes | Your manual trade record, strategy labels and explanations for adjustments. |
Retain all relevant accounts, including a broker you stopped using. Keep option legs and futures distinguishable using the F&O record guide. For delivery positions, the stock journal checklist helps preserve the trade identity.
What the Department's Guide Says About ITR-3 and ITR-4
The Income Tax Department's guide for individuals with business or professional income says ITR-3 applies to individuals and HUFs with business or professional income who are not eligible for ITR-1, ITR-2 or ITR-4. It describes ITR-4 (SUGAM) as an optional form for resident individuals, HUFs and resident non-LLP firms with total income up to ₹50 lakh and business income computed on a presumptive basis under section 44AD, 44ADA or 44AE. It also says a person who has brought forward a loss, or has a loss to carry forward under any head of income, cannot use ITR-4.
The same guide describes Form 3CB-CD as the report for a taxpayer who is required to get accounts audited under section 44AB. It does not state the audit limits on that page, and neither do we. Ask a CA whether any audit or books requirement applies to you.
The point for your journal is that you should keep complete records, including losing periods, because loss treatment can affect which form is available.
A Monthly Habit That Makes Year-End Easier
- Download the broker's monthly statements and contract notes into a folder named by month.
- Export the month from your journal and save it next to them, with the period in the file name.
- Compare the number of closed trades in your journal with the broker's record and note any gap.
- Compare the journal's estimated charges with the charges on the broker's documents and write the difference down.
- Note any open positions at month end and any corporate actions on stocks you hold.
- Write a one-line note about anything unusual, such as a trade placed from another app.
Doing this once a month takes less time than rebuilding twelve months in March. It also catches missing trades while you still remember them.
Worked record check: estimated costs versus broker charges
Made-up example: gross trading result is ₹1,400. The journal uses ₹200 estimated costs, giving ₹1,400 - ₹200 = ₹1,200. Suppose the corresponding broker record shows ₹350 actual costs: the matched net result is ₹1,400 - ₹350 = ₹1,050. The difference is ₹1,200 - ₹1,050 = ₹150. Every amount is fictional; this is a record-checking exercise, not an observed product error or tax computation.
Keep an explanation of the difference and the source document used to resolve it. A trading profit, a bank transfer and a turnover calculation answer different questions. The example does not establish tax turnover, allowable deductions, loss treatment or the final tax payable.
A Fuller Month-End Reconciliation Example
The earlier example used one trade. Here is a made-up month of F&O trades. Every amount is invented to show the steps. It is not a tax computation.
| Line | Journal | Broker record | Difference |
|---|---|---|---|
| Closed trades | 42 | 43 | 1 trade missing from the journal |
| Gross trading result | ₹15,500 | ₹15,500 | ₹0 |
| Charges | ₹3,100 (estimate) | ₹3,540 (billed) | ₹440 |
| Net result | ₹12,400 | ₹11,960 | ₹440 |
Step one is the trade count. One trade is in the broker record but not in the journal, so find it before anything else. Step two is the gross result, which agrees here. Step three is charges. The journal estimates charges per trade using rates it knows, and a billed amount can differ. The ₹440 gap is the estimated total subtracted from the billed total: ₹3,540 minus ₹3,100. Write down the likely reasons, such as a rate difference, a charge the estimate does not include, or the missing trade, and keep the document that explains it.
Some debits, such as certain depository charges, may appear on the broker's funds statement and not on the contract note, so check both. Use the broker's documents as the reference for actual amounts.
Common Record Gaps and How to Close Them
| Gap | Why it matters | How to close it |
|---|---|---|
| Trades missing from the journal | Totals will not match the broker | Compare trade counts every month |
| Free plan one-trade-a-day limit | Days with more than one trade per market may be only partly logged | Label the journal as partial and rely on the broker record for the full set |
| Open positions at the period end | Profit may be unrealised | List them separately with the date |
| Charges estimated, not billed | Net result can differ | Use the billed amounts from broker documents |
| Old broker accounts | Records live in several places | Download and keep statements from every broker |
| No period label | Files get mixed across years | Put the financial year in every file name |
The charges rates themselves change over time. For the rates in force on a trade date, see the charges changelog and brokerage and charges explained. The securities transaction tax paid is a charge to record, and how it is treated in your return is a question for your CA.
Questions to resolve before selecting a return
- Which income categories apply to the actual transactions and circumstances?
- Which return and schedules apply to this period and the person's other income?
- How should turnover be worked out for the relevant purpose and records?
- Are any audit, books, loss-reporting or other filing requirements relevant?
- Which expense and tax-charge treatments are supported by the applicable law and documents?
For AY 2026-27, the Department's business/profession guide lists ITR-3 for individuals and Hindu Undivided Families (HUFs) meeting its conditions. That is a reference to official guidance, not a form choice based on this journal alone. Have a CA check eligibility and the current requirements.
OneTradeJournal exports CSV, JSON and TXT. Give the export alongside source records rather than describing it as a filing-ready return. A free-plan log may omit activity beyond its one-trade-per-day-per-market allowance. The free-plan guide and online-record guide explain that scope.
What to Bring to Your CA
- Contract notes and the ledger for every broker used in the period.
- Your journal export, with the period in the file name.
- A list of open positions at the start and end of the period.
- Bank statements showing deposits to and withdrawals from the broker.
- Records of other income, such as salary, interest or capital gains from other sources.
- Last year's return and any carried-forward loss details.
- Receipts for expenses you plan to ask about.
Ask the CA to say, in writing, how each type of trade in your records is classified, which return form is needed, and what the CA needs from you in future. The earlier question list on this page can be your agenda. For background on the labels, see capital gains vs business income, tax audit for traders and trader tax status.
What Your Journal Can and Cannot Do for Tax
A manual journal can organise your explanations. You log trades by hand, so you have your own reasons, strategies and notes, and OneTradeJournal exports to CSV, JSON or TXT so you can hand the data to an adviser. It estimates charges per trade. It does not connect to a broker, import statements or calculate your tax. It does not decide your return form, turnover or audit status.
Keeping a manual log also forces a review each time you enter a trade, which is when many missing records are noticed. The AI features can summarise your logged data, but the AI can be wrong and is not a tax tool.
This page is about preparing records. Tax law and forms change. Ask a chartered accountant what applies to you before you file.
Sources
- Income Tax Department: new Act transition FAQ, checked 15 Oct 2026.
- Income Tax Department: business/profession return guide, checked 15 Oct 2026.
- OneTradeJournal official features, checked 15 Oct 2026.
Related Topics
Related Articles
Free Trading Journal India: What You Can Log
Start a free trading journal in India with one trade per day per market. Learn what to record, how to check net results and which AI features require payment.
Trading Journal App India: Browser and Phone Guide
Use OneTradeJournal in a phone or computer browser or from the home screen. See what to look for in a trading journal app, manual entry, exports and privacy.
Trading Journal Excel vs App: Compare the Work
Compare an Excel trading journal with OneTradeJournal for manual logging, formulas, reports and exports, and test both on the same five-trade example.
Intraday Trading Journal: Copyable Session Template
An intraday trading journal template with fields, tags, a daily loss rule and a time-of-day review. Includes a worked options cost example. Copy and print it.
Trading Journal for Beginners in India: First Entry
Start a trading journal as a beginner in India: why it helps, a 5-step setup, a sample entry in rupees and what to check after your first 20 trades.
Trading Journal Template India: Excel and Sheets Build Guide
Free trading journal Excel for Indian equity and F&O: download the .xlsx with P&L, R-multiple and monthly summary formulas, or build your own in Sheets.
The trading journal for Nifty, Bank Nifty and Indian F&O. Track your trades, spot patterns, build discipline.
- Log one trade a day by hand, on purpose
- AI mentor finds your repeat mistakes
- Behavioural analytics catch tilt early
- Trading calendar with P&L heatmap
- Pre-trade checklist flags risks
Yearly ₹3,499 · No broker credentials