Brokerage Analyzer
Upload your monthly WBR77 brokerage statement and WBR39 scheme master to see AMC-wise and scheme-wise brokerage rate ranges, weighted averages, and totals in seconds.
100% Private — Your Data Never Leaves Your Browser
All file parsing, calculations and report generation happen entirely inside your browser tab on your own device. No data is uploaded, transmitted, or stored on any server. Once you close this page, every piece of information is gone. Investor names, folio numbers and brokerage figures present in your WBR77 are processed locally and never seen by MFD Central or any third party.
Don't have your WBR files yet? Download WBR77 & WBR39 (step-by-step PDF) — an 11-step walkthrough from the CAMS Distributor Mailback to your email inbox.
First-time user? Download the Reader's Guide (PDF) — explains every number, the flag categories, and how to verify a flag before acting.
Step 1 — Upload Both Files
Accepts .xls or .xlsx. Tip: if your file is .xls and feels slow, open it in Excel and Save As .xlsx — parses ~3× faster.
Click or drop your brokerage file
e.g., MAY_BROKERAGE.xls
Click or drop your scheme master file
e.g., ALL_SCHEME_CODES.xls
Upload a second WBR77 to see how rates, brokerage and book vintage moved between the two periods.
Click or drop the second month's brokerage file
Must be a different period from the first file
Reading files…
Summary
Net Brokerage
—
Wt-Avg Rate
—
Gross Received
—
AMCs
—
Schemes
—
Book Vintage
How aged are the SIPs and investments that earned your trail this period.
Weighted-Avg Book Age
—
Across every ₹1 of trail, the underlying investment's age.
New Business Contribution (Last 12 Months)
—
—
No AMC or scheme matches your search.
Try a different keyword.