MIS Combined Rows
Review and append buy/sell rows directly from the sorted workbook.
| Select a client and script to load MIS Combined rows. |
Rejection Summary
Rows rejected during MIS Combined and BF imports.
Select a client to view recent rejection files.
Append Rows
Paste rows from the MIS Combined workbook in the order shown.
Multi-line paste is supported. The grid expands automatically when you paste more than 20 rows.
Prefer the CLI importer for the full workbook. This button is limited to ≤1,000 rows and should only be used when you cannot access the server.
Configurable MIS Upload
Parse broker exports, map headers, and validate MIS Combined rows before ingest.
Drop a MIS workbook here or click to browse
XLSX / CSV supported · Only the first sheet is parsed.
No file selected.
Do you wish to skip uploading transaction data for any client?
Clients detected after column selection. Toggle "Remove from upload" to exclude specific clients.
Upload a MIS workbook to detect client codes.
Preview
First 50 rows shown. Validation runs across the full workbook.
Upload a MIS file to view the parsed rows.
Column mapping & validation
Priority: templates > manual choices > auto-detect. Use re-run to refresh suggestions when a template doesn't fit.
MIS Upload History
Track who uploaded what, when, and how many rows succeeded.
| Run | Clients | Inserted / Failed | Status | Template / File |
|---|---|---|---|---|
| Login to view upload history. | ||||
CA Schedule Ingestion
CA capital gains template is the final set-off authority. Dry-run before applying lots.
| Run | Client | Status | Rows | Lots | File | When |
|---|
No CA schedule runs yet. Use the CLI helper to run a dry-run, then apply lots.
Daily Pack
Provide MIS Combined, NSDL, BF, and CA template paths, then trigger the pipeline.
Provide server-side file paths; leave blank to reuse what is already ingested. This triggers the MIS → NSDL → BF → CA → analyzer pipeline and surfaces the same reports without altering raw uploads.
Pipeline Run
Trigger the MIS → NSDL → BF → CA → analyzer pack for the selected client.
| Run | Status | Started | Ended | Duration | Steps | Report |
|---|---|---|---|---|---|---|
| No pipeline runs yet. | ||||||
Daily Report
CA-facing snapshot of the latest pipeline run.
CA-covered sales
—
Matched to CA templateComputed (no CA)
—
Reliant on computed gainsPrior-period holdings
—
No prior-period salesQuantity issues
—
NSDL deltas / corp actionsPending sales
—
Unallocated: —Missing CA coverage
ISIN/date sets still awaiting CA mapping.
| ISIN | Security | Dates | Computed | CA covered | Total sales |
|---|---|---|---|---|---|
| No CA gaps detected. | |||||
Prior-period holdings
Sales drawing on inherited opening inventory (CA confirmation needed).
| Sale date | ISIN | Security | Quantity | Gain status | Lot type |
|---|---|---|---|---|---|
| No prior-period holdings flagged. | |||||
Corp-action suspected
Signals from NSDL reconciliation mismatches.
| ISIN | Security | Classification | Buy Δ | Sell Δ | Signals |
|---|---|---|---|---|---|
| No corp-action suspects. | |||||
Pending sales & unallocated
Sales awaiting CA coverage or allocation.
| Sale date | ISIN | Security | Quantity | Unallocated | Status |
|---|---|---|---|---|---|
| No pending sales with open quantities. | |||||
NSDL Reconciliation
Compare NSDL closing balances against platform holdings (report-only).
| ISIN | Status | Platform Qty | NSDL Closing | Δ | As of | Statement |
|---|
NSDL Back-Traversal
Start from NSDL closing balance to see which BUYs stay open (report-only).
| # | Date | Row Ref | Qty | Open Portion | Consumed | Open After | Status | Description |
|---|---|---|---|---|---|---|---|---|
| Run back-traversal to view NSDL purchase consumption. | ||||||||
BF Loss Snapshot
Select a client to view brought-forward losses.
Select a client to view brought-forward losses.
Holdings Snapshot
Holdings and BF balances for the selected client.
Allocation Results
Totals update as you sort or filter the grid below.
| Purchase Date | Quantity | Buy rate | Sell rate | ||
|---|---|---|---|---|---|
| Run an allocation query to see rows. | |||||
| Totals | Quantity0 | Sale Value0 | Gain0 | ||
Raw response
Awaiting API response.