Commission Dashboard
Upload your AUM report to calculate expected trail commissions
📭

Upload your AUM report and set commission rates to get started.

Monthly History
Month-on-month trail commission trends
📅

No history yet. Calculate this month, export the CSV, then upload it next month to build history.

Upload Reports
Only the AUM report is needed. Export directly from WealthMagic.
📊
AUM Report ← Only file needed
📊
Click or drag AUM Report here
WealthMagic → "Folio No. Wise AUM List" → Export Excel
Columns needed: AMC · Fund · Folio No. · AUM
📅
Previous Month CSV (optional — for history)
📂
Click or drag last month's CommissionIQ export
The CSV you exported from this app last month.
App stacks months → shows trends in History tab.
How stacking works:
Calculate Mar → Export → Save as CommissionIQ_Mar_2025.csv
Next month upload that CSV here alongside fresh AUM → History tab shows both months
⚙️
Processing Options
🧮
How Commission is Calculated
Trail (Month) = AUM × Annual Rate % ÷ 12
✅ AUM used directly from WealthMagic report (already current)
✅ No transaction adjustment needed — WealthMagic updates within 1–2 days
✅ Rate Master maps each AMC + Fund → your agreed annual trail %
✅ Results grouped by AMC for easy reconciliation
Rate Master
Map each AMC + Fund to your agreed annual trail %. Set up once, update only when rates change.
💡 How to set up: Add one rate per AMC + Fund combination. The AMC and Fund names must match exactly what appears in your WealthMagic AUM report. If a fund has no rate, it will show "No Rate" and be excluded from commission totals.
0 rates
Folio Detail
Investor-level breakdown of AUM and expected trail commission.
🔍

Process your AUM report first.