ISIN + Scrip Name
These connect the FMV source to the exact stock shown in CG. FMV review becomes clearer when the platform can match the sale row to an active script-level FMV source or when the FMV value is entered manually during review.
Input Files
Daily MIS Sales
.xls / .xlsx
Click to select file
NSDL Statements
.xls (multiple files)
Click to select files
Selected NSDL Files
Detected clients:
Uploading Files...
0 / 0
✓
All files uploaded successfully
Cost data retrieved from Master Data
⚠
Sales & FIFO Allocations
0
Clients
0
Sales
0
ISINs
0
NA Legs
Click on a row to expand and view FIFO allocation legs
| # | Sale Date | Client | ISIN | Security | Qty | Expand |
|---|
Capital Gains Statement
Run History
No runs found. Run FIFO allocation first.
Short Term
0
Gross Gain
0
BF Applied
0
Net Gain
Long Term
0
Gross Gain
0
BF Applied
0
Net Gain
0
Total Rows
0
NA Rows
| SALE (Per Leg) | PURCHASE | CAPITAL GAINS | REMITTANCE | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Client Code | Client Name | ISIN Code | Scrip Name | Deal Date | Qty | Gross Rate | Gross Value | Brok Rate | Brokerage | Sale Value excl STT | STT | STT Net Value | Rounding | Net Remittance | Purchase Date | Qty | Rate | Brok/sh | Rate+Brok | Cost | FMV 31/01/18 | Sec 55 Cost | Capital Gain/Loss | Nature | BF Set-Off | Net CG | TDS | Net Remit after TDS | Actions |
Loading CG Statement...
No CG Statement data available. Run FIFO allocation first.
MIS Combined
-
Total Entries
-
Clients
Last upload: -
Delta Upload Guide
Additive OnlyUse delta upload for new MIS Combined purchase rows. Existing rows are kept, exact duplicates are skipped, and nothing is overwritten automatically.
What happens during delta upload
- New purchase rows are inserted into MIS Combined.
- Exact duplicates are skipped and can be downloaded in a separate duplicate workbook.
- Existing history is not deleted or overwritten automatically.
BF Set-offs
-
Opening Entries
-
Setoff Entries
-
Clients
Last upload: -
Upload Brought Forward
Loss HistoryUpload the Brought Forward loss file containing opening balances and historical set-offs. Sheet2 will be parsed for CA's prior year data.
No file selected
Sheet2 will be parsed for opening balances and setoff history
Uploading...
TDS Rates
23.92%
Short Term
14.95%
Long Term
FY 2025-26
Configure TDS Rates
Tax CalculationSet TDS (Tax Deducted at Source) rates for Short Term and Long Term capital gains. These rates are applied to calculate TDS in the CG Statement.
Demerger Rules
0
Total Rules
0
Active
0
Inactive
Last update: Never
Configured Demerger Rules
Configure parent-child demerger rules used by FIFO, CG, Matrix and Demerger Review flows. Uploaded MIS and NSDL files use these rules; they are not inferred automatically.
Click row to edit
| Parent | Child | Record | Credit | Ratio | Split | Status |
|---|---|---|---|---|---|---|
| Loading rules... | ||||||
FMV Reference Master
0
Total Records
0
Active
0
Inactive
Last update: Never
Configured FMV Sources
Configure ISIN-level FMV source records for grandfathering. These mapped values drive the FMV review flow in the CG table. Raw quotation rows can be imported separately and linked later.
Click row to edit
| ISIN | Scrip | Type | FMV | FMV Date | Exchange | Status |
|---|---|---|---|---|---|---|
| Loading FMV records... | ||||||
Imported FMV References
Import rows from Market Quotation_Equity and keep them as unmapped references until they are linked to an ISIN later. These rows are not used in runtime CG calculations until they become configured FMV sources.
Stored as references only
Total Imported: 0
Unmapped: 0
Mapped: 0
Last import: Never
| Scrip | Normalized | FMV | Quote Date | Exchange | Mapping | Matched ISIN |
|---|---|---|---|---|---|---|
| Loading imported FMV references... | ||||||
User Access
0
Total Users
0
Active
0
Inactive
Last update: Never
Configured Platform Users
Manage developer admin, customer admin, and customer user logins. Role presets control which modules are visible in the platform.
Click row to edit
| Role | Overrides | Access Profile | Status | Updated | |
|---|---|---|---|---|---|
| Loading users... | |||||
MIS Combined Delta Upload
Add only new purchase rows. Existing rows stay in place and exact duplicates are skipped.
No file selected
Uploading...
Total rows: -
Processed: -
Add Demerger Rule
Capture the corporate-action rule used to derive child inventory and parent cost split.
Add FMV Source
Capture the FMV reference used to apply Section 112A grandfathering for a specific ISIN.
Add User
Create a platform login and assign one of the role presets.
FMV Grandfathering Example
How FMV configuration and review work
The platform keeps the current basis visible, shows the suggested FMV basis separately, and keeps FMV review explicit. Please compare the current basis and the suggested FMV basis before saving the final choice.
Practical FMV flow in this platform
For most NRI Form 15 workflows, FMV matters only for pre-31-Jan-2018 listed equity purchases. Master Data stores the script-level FMV source, and FMV review in the CG table shows the current basis, the suggested FMV basis, and any manual FMV entered during review.
Primary Sheet
Market Quotation_Equity
Use Case
Listed equity shares sold through brokers
FMV Date
31-01-2018
Decision Surface
CG table FMV comparison modal
Why each field matters
FMV Price + Date
These provide the gross FMV basis used for grandfathering. For listed equity, this usually comes from the quoted market price as on 31-Jan-2018, but the current basis remains visible until the review choice is saved.
Exchange / Source Sheet
These preserve where the FMV came from so the quotation source can be traced during review. For broker-driven equity cases, the primary source is usually Market Quotation_Equity.
Source Document / Notes
These preserve audit context. FMV is not just a number; the platform should explain where it came from and whether the saved result uses the current basis, the suggested FMV basis, or a manual FMV value.
How the platform presents FMV
- Show the current basis first so the row is visible without FMV.
- Show the suggested FMV basis separately when an FMV source exists.
- Please compare the current basis and the suggested FMV basis before saving the review result.
- If FMV is not configured, please keep the current basis or enter the FMV value manually.
- Persist the chosen outcome with an audit trail.
The CG table should show the effective cost actually being used, not raw FMV blindly. The modal is where the FMV comparison and choice happen.
What the FMV modal shows
Option
What it means
Where it comes from
Outcome
Current Basis
No FMV applied
Original purchase cost
Can remain in use
Suggested FMV Basis
Configured FMV source exists
Master Data & statutory logic
Can be selected
Manual FMV
Configured source missing or needs override
User input in modal
Row-only or save as source
This keeps the platform aligned with a cautious review workflow: configuration in Master Data, comparison in CG, and an explicit saved result before relying on FMV.
Demerger Rule Example
How demerger configuration works
Uploads give transaction facts. The demerger rule supplies the tax logic that MIS and NSDL files cannot infer safely on their own.
Real example: ITC -> ITC Hotels
Use the official corporate-action document to configure the parent-child relation, dates, ratio and cost split that the engine applies during FIFO and CG runs.
Parent ISIN
INE154A01025
Child ISIN
INE379A01028
Record Date
06-01-2025
NSDL Credit Date
14-01-2025
Ratio
10 : 1
Cost Split
86.49% / 13.51%
Why each field matters
Effective Date
Official corporate-action reference date. Keep it for audit traceability and source-document matching.
Record Date
Entitlement boundary. Only parent shares still held on this date are eligible for the child shares.
NSDL Credit Date
Inventory availability boundary. Child shares must not be used in FIFO before they actually appear in NSDL.
Fraction Policy
Defines how fractional child entitlements are handled lot-by-lot when entitlement is not a whole number.
How the ITC example is calculated
- Find parent shares surviving on the record date.
- Apply the configured ratio to derive child entitlement.
- Split surviving parent cost using the configured parent/child percentages.
- Carry the parent acquisition date to the child lot for holding-period classification.
MIS and NSDL uploads provide the facts. The demerger rule tells the platform how to translate those facts into tax cost basis.
Largest remainder + FIFO tie-break
Lot
Entitlement
Floor
Remainder
Lot A
10.4
10
0.4
Lot B
8.3
8
0.3
Lot C
6.9
6
0.9
After flooring, 24 shares are assigned. If the actual credited total is 26, the remaining 2 shares go to the biggest remainders first: Lot C, then Lot A.
If two lots have the same remainder, the older FIFO lot gets priority.
BF Statement
Loading BF Statement...
Short Term
Opening Balance
0
Closing Balance
0
Long Term
Opening Balance
0
Closing Balance
0