Import Kotak Securities trades into your QbarTrade journal.
Follow one clear two-part process: download the Gain & Loss Statement Excel file from Kotak Neo, then upload, validate and confirm the transactions inside QbarTrade.
This guide covers
Kotak Neo provides the Gain & Loss Statement in Excel and PDF. Use the original Excel version for QbarTrade and download separate files when your history spans multiple financial years.
Click to watch the import, validation and review workflow in QbarTrade.
What happens after import?
How to download your Kotak Neo Gain & Loss Statement.
Sign in to Kotak Neo
Open the Kotak Neo web platform or app and sign in to the Kotak Securities trading account whose historical transactions you want to journal.
Open Reports & Statements
On Neo Web, open Profile → Reports. In the Kotak trading app, use More → Tools & Resources → Reports & Statements.
Choose Gain & Loss Statement
Open Gain & Loss Statement, select the required financial year and transaction type, then generate the transaction-wise report.
Download the Excel report
Kotak Neo provides Excel and PDF download options. Use the original Excel file for QbarTrade import and keep its worksheets, headers and columns unchanged.
Use Gain & Loss Statement. Open Profile → Reports → Gain & Loss Statement on Neo Web, or More → Tools & Resources → Reports & Statements in the Kotak trading app.
Choose Excel, not PDF. The official report supports both formats. Keep the downloaded Excel workbook unchanged so QbarTrade can map the transaction-wise rows accurately.
Upload and validate your Kotak Securities trades.
Follow these 12 steps inside QbarTrade to transform Kotak Neo transaction-wise Gain & Loss rows into a clean, reviewable trading journal.
Open Trades
From the QbarTrade sidebar, open Trades.
Open the import menu
Use the three-dot menu beside the Add button and select Import trades.
Add the Kotak Neo Excel file
Select Add file and upload the original Gain & Loss Statement Excel file downloaded from Kotak Neo.
Assign the broker account
Select the Kotak Securities broker account that produced the statement. This keeps broker-specific trades and analytics organised correctly.
Review the mapped rows
QbarTrade displays the mapped transactions before final import. Review the instrument or contract, side, quantity, segment, entry, exit, duration, stop-loss, P&L and strategy fields.
Resolve validation warnings
Rows may be marked valid, invalid, needs broker or needs instrument. Correct missing information or remove rows that do not represent usable trade transactions.
Remove report-only rows
Delete report headings, totals, blank rows, disclaimers or any statement content that is not an actual trade record.
Merge related executions
Select related transactions and use Merge when several entries and exits belong to one completed trading idea. QbarTrade can preserve the individual legs inside the combined round-trip.
Edit trade details
Use the edit action to correct the instrument or contract and add the broker account, strategy, notes, stop-loss price, charges or taxes where required.
Save the changes
Save the edited row after confirming that the corrected transaction information is accurate.
Confirm the import
When the valid rows are ready, select Confirm & Import to add them to the QbarTrade trading journal.
Review imported trades
Return to the Trades page and use the All filter to review imported open and closed trades.
Turn execution rows into reviewable trades.
Validate transaction rows
Review which statement rows contain usable trade data and identify rows that require broker or instrument information.
Connect executions into round-trips
Combine related entries, additions, reductions and exits so the complete position can be reviewed as one trading outcome.
Preserve individual trade legs
The completed round-trip can retain its underlying fills, helping you understand how the position was built, adjusted and closed.
Add strategy context
Assign a strategy so later analysis can compare outcomes across your repeated trading setups.
Add risk and cost details
Add stop-loss, brokerage, charges or taxes where required so the journal reflects more than gross price movement.
Analyse performance
Evaluate Net P&L, win rate, profit factor, expectancy, average R multiple, maximum drawdown, equity curve, daily net P&L, average win, average loss, streaks, weekday performance and top traded symbols.
One trading idea can contain several Kotak Securities transactions.
A position may include multiple entries, additions, partial exits and a final close. These can appear as separate transaction rows in the Gain & Loss Statement. QbarTrade lets related rows be combined into one round-trip while preserving the underlying legs for audit and review.
Round-Trip Example
Common Kotak Neo Gain & Loss import issues.
A PDF was uploaded instead of Excel
Kotak Neo provides both Excel and PDF options for the Gain & Loss Statement. Use the original Excel file because a PDF does not preserve spreadsheet rows and columns for structured import.
The wrong Kotak Neo report was selected
Use Gain & Loss Statement for the transaction-wise financial-year report. A ledger, DP transaction report, holdings statement or Bill-cum-Transaction report serves a different record-keeping purpose.
A contract note was uploaded
Kotak Neo contract notes provide official daily trade-level and charge details, but the revised format is password-protected PDF. Use the Excel Gain & Loss Statement for import and the contract note for reconciliation.
Some historical transactions are missing
Check the selected financial year and transaction type. Download additional Gain & Loss statements when your history spans multiple financial years or different transaction categories.
The P&L does not match Kotak Neo
Check the financial year, transaction type, open versus closed positions, gross versus net P&L, charges, taxes and whether all related entries and exits have been included and merged correctly.
An instrument or contract is not linked
Search for and select the correct NSE, BSE, futures, options or commodity instrument. Unlinked rows may have limited chart or analytics functionality.
Summary or total rows were imported
Remove headings, totals and other report-only lines during QbarTrade validation before confirming the final import.
Scale-in trades appear separately
Select only the transactions that belong to the same completed position and use Merge to create one round-trip.
A row has the wrong strategy
Open the row editor and assign the strategy that accurately represents the original trading setup.
A Gain & Loss Statement records results. A journal explains performance.
| Aspect | Kotak Neo Gain & Loss | QbarTrade Journal |
|---|---|---|
| Primary function | Transaction-wise gain and loss report | Complete round-trip review |
| Reporting period | Selected financial year and transaction type | Flexible trade review and analytics |
| Risk tracking | Executed transaction and charge data | Risk and stop-loss context |
| Position grouping | Individual statement rows | Merged trading ideas |
| Analytics focus | Broker P&L and reporting | Strategy and performance analytics |
| Workflow depth | Financial record keeping | Notes, behaviour and review workflow |
Kotak Neo provides the broker transaction-wise report. QbarTrade builds on those rows to deliver round-trip journaling, strategy context and decision analytics.
RELATED BROKER IMPORT GUIDES
Import trades from another broker
Choose your broker to view the exact report-download and QbarTrade import steps.
Kotak Securities Trade Import FAQ
Which Kotak Securities file should I import into QbarTrade?+
Use the Gain & Loss Statement available in Kotak Neo under Profile → Reports. Download the Excel version because it preserves the structured transaction-wise rows needed for import.
How do I download the Kotak Neo Gain & Loss Statement?+
On Neo Web, sign in, open Profile → Reports → Gain & Loss Statement and choose the Excel download. In the Kotak trading app, open More → Tools & Resources → Reports & Statements → Gain & Loss Statement.
What information does the Gain & Loss Statement contain?+
Kotak Neo describes it as a transaction-wise gain and loss statement for a selected financial year. The report can also include charges and can be filtered by the available transaction type in your account.
Can I import Kotak Securities equity, F&O and commodity trades?+
Kotak Neo supports Equity, F&O and Commodity trading records. Download the relevant Gain & Loss statement for the required financial year and transaction type, then review segment and instrument mapping before confirming the import.
Should I download Excel or PDF from Kotak Neo?+
Download Excel for QbarTrade import. PDF is suitable for reading and record keeping, but it does not preserve structured spreadsheet cells for trade mapping.
What is the difference between the Kotak Neo Trade Book and Gain & Loss Statement?+
A Trade Book records completed trades, including trade price, time and quantity. The Gain & Loss Statement is a downloadable transaction-wise financial-year report designed to show realised results and charges.
Can I use a Kotak Neo contract note for trade import?+
Use the Excel Gain & Loss Statement as the primary import file. Contract notes are official daily PDF records and, from April 1, 2025, can show individual trade-level executions across segments, making them useful for reconciliation rather than spreadsheet import.
Can I import older Kotak Securities trades?+
Yes. Select the required financial year and transaction type. Download separate Gain & Loss statements when your history spans multiple financial years.
Why are some Kotak Neo rows marked invalid?+
A row may contain a heading, total or non-trade line, or it may be missing a broker account or mapped instrument. Correct the missing information or remove the row if it is not an actual transaction.
Can I merge multiple Kotak Securities executions?+
Yes. When several rows belong to one completed position, select them and merge them into one round-trip while retaining the underlying entry and exit legs.
Why does imported P&L differ from Kotak Neo?+
Check the financial year, transaction type, open versus closed positions, gross versus net P&L, brokerage and taxes, and whether every relevant transaction has been included and grouped correctly.
Does importing trades allow QbarTrade to place Kotak Neo orders?+
No. File import is used only for journaling and analysis. It does not give QbarTrade permission to place, modify or execute orders in your Kotak Securities account.
FROM GAIN & LOSS TO TRADING INSIGHT
Import the executions. Review the decisions.
Bring your Kotak Securities trading history into QbarTrade, organise related transactions, add strategy and risk context, and review the patterns behind your results.