Import Motilal Oswal trades into your QbarTrade journal.
Follow one clear two-part process: export the Trade Details & Summary Excel report from Motilal Oswal BizOps, then upload, validate and confirm the executions inside QbarTrade.
This guide covers
Use the BizOps historical Trade Details & Summary report rather than a holdings, ledger or tax-summary file. Generate separate reports when your history spans multiple exchanges or date ranges.
Click to watch the import, validation and review workflow in QbarTrade.
What happens after import?
How to download Motilal Oswal Trade Details & Summary.
Sign in to Motilal Oswal
Open the Motilal Oswal investment portal or RIISE Web and sign in to the trading account whose historical executions you want to journal.
Open the back-office reports
From Reports, open Other Reports → Client Dashboard and select BO Reports. The back-office reporting window may open separately.
Choose Trade Details & Summary
Inside BO Reports, open Reports → Trade → Trade Details & Summary. Select the required date range and exchange or segment, then generate the report.
Download or request the Excel report
Use the available Excel export or statement-request option after the report loads. Keep the original workbook, headers and trade rows unchanged before uploading it to QbarTrade.
Use the BizOps trade report. Open Reports → Other Reports → Client Dashboard → BO Reports, then select Reports → Trade → Trade Details & Summary.
Keep the Excel workbook unchanged. Generate the report for the required date and exchange, then upload the original exported or emailed Excel file without altering its headers or worksheets.
Upload and validate your Motilal Oswal trades.
Follow these 12 steps inside QbarTrade to transform Motilal Oswal execution 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 Motilal Oswal report
Select Add file and upload the original Excel Trade Details & Summary report downloaded or received from Motilal Oswal BizOps.
Assign the broker account
Select the Motilal Oswal broker account that produced the report. This keeps broker-specific trades and analytics organised correctly.
Review the mapped executions
QbarTrade displays the mapped rows before final import. Review the exchange, instrument, product, side, quantity, trade price, trade time, segment, entry, exit, 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 actual trade executions.
Remove report-only rows
Delete report headings, totals, blank rows, disclaimers or any other lines that are not execution records.
Merge related executions
Select related rows and use Merge when several executions belong to one completed trading idea. QbarTrade can preserve each entry, scale-up, scale-down and exit leg 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 execution 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 execution rows
Review which report rows contain usable trade data and identify rows that require broker, exchange 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 order and trade context
Retain the underlying execution legs, including trade time, trade quantity, trade price, buy or sell side and related order identifiers.
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 Motilal Oswal executions.
A position may include multiple entries, quantity additions, partial exits and a final close. The Motilal Oswal report can show these as separate execution rows with their own trade price, quantity, time and order identifiers. QbarTrade lets related rows be combined into one round-trip while preserving the underlying legs.
Round-Trip Example
Common Motilal Oswal trade-report import issues.
The wrong Motilal Oswal report was uploaded
Use BO Reports → Reports → Trade → Trade Details & Summary for execution-level history. A holdings report, ledger, capital-gains summary or margin statement serves a different purpose.
Only the current-day Trade Book is visible
The trading platform Trade Book is useful for completed trades, but historical imports should be generated from the BizOps back-office Trade Details & Summary report.
The exchange or segment is missing
Check the exchange filter used while generating the report. Motilal Oswal accounts may include NSE, BSE, NSE F&O, currency derivatives, MCX and other enabled exchanges.
Some historical trades are missing
Check the selected from and to dates and the exchange filter. Generate additional reports when your activity spans different periods or exchanges.
The Excel file was edited or converted
Upload the original BizOps workbook. Renaming headers, deleting worksheets, converting date or number formats, or copying rows into a new workbook can prevent accurate mapping.
An instrument or contract is not linked
Search for and select the correct equity, futures, options, currency or commodity instrument. Pay close attention to expiry, strike price and option type for derivative contracts.
The P&L does not match Motilal Oswal
Check the same date range and exchange, open versus closed positions, gross versus net P&L, brokerage and charges, and whether every related entry and exit has been included and merged.
Scale-in trades appear separately
Select only the executions 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 trade report records executions. A journal explains performance.
| Aspect | Motilal Oswal Trade Report | QbarTrade Journal |
|---|---|---|
| Primary function | Historical execution and trade record | Complete round-trip review |
| Execution fields | Exchange, symbol, side, quantity, price and time | Execution data plus strategy context |
| Derivative details | Instrument, expiry, strike and option type | Grouped position and setup review |
| Position grouping | Individual execution rows | Merged trading ideas |
| Analytics focus | Broker execution reporting | Strategy and performance analytics |
| Workflow depth | Audit and broker records | Notes, behaviour and review workflow |
Motilal Oswal provides the broker execution record. 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.
Motilal Oswal Trade Import FAQ
Which Motilal Oswal file should I import into QbarTrade?+
Use the Trade Details & Summary report from Motilal Oswal BizOps. It is available through the back-office reporting area and is designed to provide historical transaction and execution rows.
How do I download Motilal Oswal Trade Details & Summary?+
Sign in to the Motilal Oswal investment portal, open Reports → Other Reports → Client Dashboard → BO Reports, then go to Reports → Trade → Trade Details & Summary. Select the date and exchange, generate the report and use the available Excel export or statement-request option.
What information can a Motilal Oswal Trade Book contain?+
Motilal Oswal's official Trade Book data model includes fields such as exchange, symbol, product type, instrument type, strike price, option type, expiry date, trade price, trade quantity, buy or sell side, order ID, trade number and trade time.
Can I import Motilal Oswal equity, F&O, currency and commodity trades?+
Motilal Oswal supports trading across Equity, Derivatives, Commodities and Currencies. Generate the relevant historical report for each enabled exchange or segment and review the mapped instruments before confirming the import.
What is the difference between Trade Book and Trade Details & Summary?+
The Trade Book displays completed executions and their trade details. Trade Details & Summary is the historical BizOps back-office report used to generate execution records across a selected period and exchange.
Should I use the Motilal Oswal Capital Gains report?+
Use Trade Details & Summary when the goal is to import execution-level trades. Capital Gains and Tax P&L reports are useful for tax reporting and realised gain calculations but may group or summarise transactions differently.
Can I import older Motilal Oswal trades?+
Yes. Choose the required date range in Trade Details & Summary. Generate separate reports when your history spans multiple periods or exchanges.
Why are some Motilal Oswal 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. Derivative rows may also require the correct expiry, strike or option type.
Can I merge multiple Motilal Oswal executions?+
Yes. When several execution 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 Motilal Oswal?+
Check the date range, exchange, open versus closed positions, gross versus net P&L, brokerage and taxes, and whether every relevant execution has been included and grouped correctly.
Should I upload a Motilal Oswal contract note?+
Use the Trade Details & Summary Excel report for this multi-period import workflow. Contract notes are official day-wise confirmations and are better used to reconcile trade and charge details.
Does importing trades allow QbarTrade to place Motilal Oswal 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 Motilal Oswal account.
FROM TRADE DETAILS TO TRADING INSIGHT
Import the executions. Review the decisions.
Bring your Motilal Oswal execution history into QbarTrade, organise related fills, add strategy and risk context, and review the patterns behind your results.