Overview
The Publisher Platform reporting system has been completely revamped to provide you with faster, more accurate, and reliable business data. This guide will help you understand and navigate the new reports available to you.
Reports covered in this guide
Overview
Subscription Meta Reports
These are your primary subscriber-level reports. There are two variants - one for Flat Fee plans and one for AuM-based plans. Both share most fields; the differences are highlighted below.
Subscription Meta - Flat Fee
Field | Description |
Name | Full name as on PAN, captured in the subscription flow |
Email | Registered email address |
Contact | Registered mobile number |
PAN | PAN as shared in the subscription flow |
DOB | Date of birth as shared in the subscription flow |
State | State as shared in the subscription flow |
Risk Profile | Assessed risk profile (RIA managers only) |
RM Email | Relationship Manager's email, if applicable |
SCID | Unique identifier for the subscribed model portfolio |
smallcase Name | Name of the subscribed model portfolio |
Status | Current lifecycle state - see status definitions below |
Plan Type | Plan type: Flat Fee |
Plan Duration | Subscription validity (e.g. 1 month, 3 months, 6 months, 1 year) |
Plan Amount | Total subscription price before discounts |
Auto Onetime | Auto = will renew automatically · Onetime = expires unless renewed |
Start Date | Date the subscription became active |
Last Requested Access Date | Most recent date the user requested access (REQUESTED_ACCESS users only) |
End Date | Scheduled end date of the current subscription cycle |
Grace Period End Date | Final date of temporary access for unpaid/expired users |
Plan Payment Status | PAID · PENDING · FAILED - payment status for the flat-fee subscription |
Payment Method | UPI, Netbanking, Card, etc. |
Payment Gateway | Gateway used to process the payment |
Payment Amount | Actual amount paid after discounts and offsets |
Offer Code | Coupon code applied, if any |
Offer Discount | Discount amount availed via the offer code |
Investment Status | Invested · Blank · Exited - portfolio investment status as of today |
Smallcase Bought Date | Date the user first invested in the model portfolio |
Networth | User's current consolidated net worth (if available) |
PnL | Cumulative profit or loss for this portfolio |
Attribution | Acquisition source of the subscription |
Subscription Meta - AuM
All fields from the Flat Fee report are present, with the following additions and replacements:
Field | Description |
Plan Charge Ratio | Percentage fee applied to the user's average net worth to determine the monthly AuM fee |
Upfront Amount | One-time upfront fee charged at the start of subscription |
AuM Fees | Fee charged based on the user's invested AuM for the current cycle |
Pending Amount | Outstanding subscription amount due from the user |
Offset Balance | Remaining offset balance after applying upfront payment to current cycle charges |
Offset Consumed | Portion of the upfront amount used to pay charges in the current cycle |
Offset Enabled | Whether the upfront amount can be applied toward future AuM fees |
Upfront Payment Status | PAID · PENDING · FAILED - status of the upfront fee payment |
AuM Fees Payment Status | PAID · PENDING · FAILED - status of the AuM fee payment |
AuM vs Flat Fee: AuM plans use Plan Charge Ratio x Avg. Networth to calculate monthly fees. The offset mechanism allows the upfront payment to fund future AuM fees until the balance is exhausted. |
Subscription Status Definitions
The Status field is central to subscriber management. Here is the complete reference:
Status | Has Access? | What it means |
SUBSCRIBED | Yes | Subscription is active. Users have full access to research content. |
UNSUBSCRIBED | No | Subscription ended - expired, cancelled, or payment failed. |
REQUESTED_ACCESS | No | The user started the subscription flow but payment/validation is still pending. |
GRACE_PERIOD | Yes (temp) | Subscription expired but temporary access continues until the Grace Period End Date. |
SUBSCRIBED_USER_CANCELLED | Yes (until end) | User cancelled but retains access until the scheduled End Date. |
Payments Report
The Payments Report provides transaction-level data for every payment event. It complements the Subscription Meta Reports with deeper payment, mandate, and invoice detail.
Field | Description |
name | User name from subscription contact form |
email | User email from subscription contact form |
smallcase_name | Name of the smallcase |
subscription_status | User's subscription status at time of payment |
plan_type | AuM or Flat Fee |
plan_duration | Duration of the plan (1m for all AuM plans) |
auto_onetime | Whether the user opted for auto-renewal |
start_date | Subscription start date |
end_date | Subscription end date |
payment_method | UPI, Netbanking, Card, etc. |
plan_amount | Plan amount (upfront amount for AuM cycles) |
plan_charge_ratio | Charge ratio for AuM subscriptions |
aum_fees | AuM fee charged for the cycle (AuM plans only) |
payment_amount | Final amount paid after promo discounts |
debit_trigger_date | Date on which payment debit was triggered |
debit_response_date | Date of the latest debit response/status update |
mandate_id | E-mandate ID (Digio payment method only) |
mandate_limit | Maximum limit of the mandate (Digio only) |
mandate_status | Status of the e-mandate (Digio only) |
UMRN | Unique Mandate Registration Number (Digio only) |
payment_status | Current payment status |
payment_status_reason | Reason for payment status, if applicable |
referrer_name | Referrer attributed to this subscription, if any |
invoice_url | URL to the subscription invoice PDF (expires 5 days after report generation) |
upfront_fee_invoice_url | URL to the upfront fee invoice PDF (expires 5 days after report generation) |
⚠ Invoice URLs expire: Both invoice_url and upfront_fee_invoice_url expire 5 days after the report is generated. Download or share invoices promptly. |
Renewal Metrics
Track when subscribers renew relative to their expiry date. Use this report to measure renewal rates and identify re-engagement opportunities.
Field | Description |
Publisher_ID | Unique identifier for the publisher |
End_Date | Date the subscription was originally set to expire |
Eligible Users | Total subscriptions eligible for renewal on the End_Date |
D0 Renewed Subs | Subscriptions renewed on the exact day of expiry |
D7 Renewed Subs | Subscriptions renewed within 7 days of expiry (cumulative, including D0) |
D30 Renewed Subs | Subscriptions renewed within 30 days of expiry (cumulative, including D0 and D7) |
>D30 Reactivated Subs | Subscriptions renewed 31+ days after expiry |
How to calculate renewal rate: Divide D0 / D7 / D30 Renewed Subs by Eligible Users to get renewal rates at each interval. For example, D7 Renewed Subs ÷ Eligible Users gives your 7-day renewal rate. |
Business Performance
A portfolio-level summary that lets you track growth, engagement, and investor activity across your smallcases for any selected date range.
Field | Description |
SCID | Unique identifier for the smallcase |
smallcase_name | Name of the smallcase |
plan_type | Flat Fee or AuM |
new_signups | Users who filled the subscription contact form in the selected date range (includes both REQUESTED_ACCESS and SUBSCRIBED) |
new_subscriptions | Users who subscribed for the first time in the selected date range |
total_signups | Total users who ever filled the contact form, up to the selected end date |
total_active_subscriptions | Total active subscriptions as of the selected end date |
total_completed_subscription_cycles | Total subscription cycles that completed as of the selected end date |
total_subscription_cycles | Total subscription cycles that started in the selected date range |
total_investors | Subscribed users currently invested (as of report download date - date-range-independent) |
total_aum | Sum of current net worth across all subscribed users (as of report download date - date-range-independent) |
Date range caveat: total_investors and total_aum always reflect the current state as of when you download the report — they are not filtered by the date range you selected. |
Referrer Performance
Understand which referrers and acquisition channels are driving subscriptions and investor activity for each portfolio.
Field | Description |
referrer | Referrer attributed to the subscription |
SCID | Unique identifier for the smallcase |
smallcase_name | Name of the smallcase |
plan_type | Flat Fee or AuM |
new_subscriptions | First-time subscribers attributed to this referrer in the selected date range |
total_active_subscriptions | Active subscriptions attributed to this referrer as of the selected end date |
total_investors | Subscribed users attributed to this referrer who are currently invested |
total_aum | Sum of current networth of subscribed users attributed to this referrer |
total_completed_subscription_cycles | Completed subscription cycles attributed to this referrer as of the end date |
total_subscription_cycles | Subscription cycles that started via this referrer in the selected date range |
KYC Reports
Track Know Your Client document availability and status for each of your subscribers. This report is particularly important for regulatory compliance.
Field | Description |
Name | Subscriber's full name |
Email | Subscriber's email address |
PAN | Subscriber's PAN |
DOB | Subscriber's date of birth |
KYC Docs requested On | Date on which the KYC document request was made |
KYC Docs available | Yes / No — whether KYC documents are available |
KYC Docs not available reason | Reason documents are unavailable (e.g. DOB not as on PAN, Pending from NDML) |
Chargeable request | Yes / No — whether the request incurs a charge |
Common KYC unavailability reasons: "DOB not as on PAN" means the date of birth submitted does not match PAN records. "Pending from NDML" means the document is awaited from the NDML registry. Chargeable requests (Yes) are those where re-fetching the document incurs a cost. |
Rebalance Report
A point-in-time snapshot of your model portfolio's constituents and their target weights. This report is generated after each rebalance event.
Field | Description |
NSE Ticker | NSE ticker symbol of the constituent security |
Security Name | Full name of the security |
Segment | Sector/segment classification (e.g. IT Services & Consulting, Private Banks) |
Weight | Target weight of the security in the portfolio (as a percentage) |
Usage: Use this report to confirm post-rebalance portfolio composition. The weights in this report reflect the new target allocation after the rebalance. Cross-check with subscriber investment status in the Subscription Meta Report to identify subscribers who may not have acted on the rebalance update. |
Index Series
Daily time-series data tracking your portfolio's indexed performance against a benchmark. Values are indexed to 100 at the portfolio's launch date, making it easy to compare relative performance.
Field | Description |
Date | Trading date |
[Portfolio Name] | Indexed value of your portfolio on that date (base = 100 at launch) |
[Benchmark Name] | Indexed value of the benchmark on the same date (e.g. NIFTY 100) |
Reading this data: A portfolio value of 178.26 means the portfolio has returned 78.26% since inception (in index terms). Comparing the portfolio column to the benchmark column on any date shows relative outperformance or underperformance. |
SEBI Periodic Reporting
A compliance-focused report for RIA managers, tracking client relationship counts and fees collected over a selected reporting period. Segmented by client type (Individual vs Non-Individual).
Field | Description |
Publisher | Unique identifier for the publisher |
Client Type | Individual or Non-Individual |
Number of Clients at end of previous period | Active client relationships at the end of the preceding period |
Number of Clients acquired during the period | New clients whose relationship started in the selected period |
Number of Client relationships that ended during the period | Clients whose relationship concluded in the selected period |
Number of Clients at end of the period | Active client relationships at the end of the selected period |
Details of Fees collected (in Rs.) for Clients | Total fees collected from all clients during the selected period |
Compliance note: This report is designed for submission in SEBI periodic compliance filings. Verify the data carefully and cross-reference with your subscription records before submitting. |
BSEASL Report
The BSEASL Report is a comprehensive regulatory compliance report. It contains sensitive client data and must be reviewed carefully before any submission to regulators.
⚠ Handle with care: This report contains sensitive fields including full PAN numbers and financial details. The columns MUST be reviewed before submitting to regulators. If in doubt, contact the smallcase team before submitting. |
Field | Description |
Sr. No | Sequential number assigned to each record |
Client Code | Unique identifier: 'CL' + zero-padded serial + last 2 chars of PAN + first 2 chars of name |
Client Type | Individual or Non-Individual - based on 4th character of PAN (P = Individual) |
Client Name | Client name as per PAN |
Type of Entity | Manager's business type - to be filled in by the manager before submission |
Client Pan card | Full PAN of the client - remove before submission |
Client pan card (masked) | Masked PAN showing only the last two characters - safe to retain |
Clients Risk Score | Risk rating for this specific account, as selected by the client at time of subscription |
Multiple Risk Profile | Client's overall risk profile - remove before submission |
Bank A/c. of clients with Bank Name | Hard-coded as 'Not Applicable' |
Bank A/c. of clients with Bank A/c. No. | Hard-coded as 'Not Applicable' |
Fee Mode Fixed or AUA | Whether the client is charged a Fixed fee or an AuA-based fee |
Period of Fees | Total number of months a client paid fees, after accounting for any refunds |
Product type | Name of the portfolio purchased by the client |
Product Risk Score | Risk level assigned to the specific portfolio purchased by the client |
% MAX AuA | Fee % on max invested amount during inspection period |
% AuA | Fee % on invested amount for AuA-based portfolio |
Total AUA Amount (Rs.) during inspection period (MAX) | Client's maximum investment amount during the inspection period |
Total AUA Amount (Rs.) during inspection period | Client's latest investment amount during the inspection period |
Fee Invoiced (excl. taxes) | Total fees excluding taxes invoiced to the client during the inspection period |
Fee Invoiced (incl. taxes) | Total fees including taxes invoiced to the client during the inspection period |
Fees Received (within inspection period) | Total fees including taxes actually received from the client during the inspection period |
Agreement Date | Client's first subscription date for the particular portfolio |
Agreement Expiry Date | End date of the client's last subscription cycle (for unsubscribed clients only) |
Agreement Status | Active: currently subscribed or Agreement Expiry Date beyond inspection period · Inactive: unsubscribed with expiry within inspection period |
Key notes: Any client who paid a fee in a given financial year is included in that period's report.
Agreement Date = first subscription date.
Refunds are factored in and amounts are adjusted accordingly.
Type of Entity must be filled in by the manager before submission. |
Invoice & Investment Adviser Agreement
Two additional document types are generated per subscriber at the time of subscription. These are accessible via URLs in the Payments Report.
Invoice
A per-transaction invoice is generated for each subscription payment. It includes the publisher's GSTIN, billing details, subscription description, amounts, GST breakdown, and total. The invoice_url and upfront_fee_invoice_url fields in the Payments Report link directly to these PDFs.
Investment Adviser Agreement
A digitally confirmed Investment Adviser Agreement is generated per subscriber at the time of subscription. It captures:
Adviser and client details (name, email, SEBI registration, PAN)
Subscription details (portfolio name, start date, frequency, type, fee structure)
Full terms covering scope of services, advisory fees, risk factors, liability, termination, and dispute resolution
Agreements are digitally confirmed via OTP and are timestamped. Retain these as part of your regulatory record-keeping obligations under the SEBI IA Regulations 2013.
Factsheet & Model Portfolio Report
Two investor-facing documents are available for each portfolio. Both now refresh within 15 minutes of a data update.
Factsheet
A one-page summary of your portfolio designed for investor communication. Includes:
Portfolio name, type, asset class, volatility label, investment horizon
Rationale and methodology summary
Constituent list with sector classifications and weights
Sectorwise and holdings distribution charts
Ratios (PE, PB, Sharpe, Dividend Yield) vs. comparable index
How-to-subscribe and how-to-invest guides
Definitions, disclosures, and manager registration details
Model Portfolio Report
A detailed technical report on your portfolio, issued on the report date. Includes the full methodology, constituent-wise rationale with individual PE/PB/dividend data, performance definitions, and comprehensive general and manager disclosures.
