Change of Broker

Change of Broker Report

This report lists every change of broker transaction, both incoming and outgoing:

• Transfer In: Folios moved to you from another broker (ARN).
• Transfer Out: Folios moved from you to another broker (ARN).

Module: Broker Portal
Navigation path: Business Analytics > Change of Broker
Report type: Folio transfers between distributors (ARN changes)
Output formats: On-screen view, XLS

What is the Change of Broker report?

The Change of Broker report lists the folios whose distributor (ARN) changed during a selected period. It covers both directions:

• Change of Broker In: folios that moved to your ARN from another distributor.
• Change of Broker Out: folios that moved from your ARN to another distributor.

For each folio, the report shows the amount as on the transfer date. This is the value of the holding when it was transferred, not its current market value.

How to access the Change of Broker report

1. Go to Business Analytics.
2. Select Change of Broker.
3. Under Mode, choose Change of Broker In or Change of Broker Out.
4. Set the Transfer Date range and, if needed, select a user.
5. Choose the View Type (On Screen or XLS).
6. Click Apply.

Report configuration

1. Mode

• Change of Broker In: shows folios transferred in to you.
• Change of Broker Out: shows folios transferred out from you.

2. Filters

• Transfer Date (mandatory): the start and end dates of the period. Only transfers made within this range are shown.
• Select User: limits the report to the clients mapped to a specific user, such as an RM or sub-broker.

3. View Type

• On Screen: shows the report in the portal.
• XLS: downloads the report as an Excel file.

Columns in the report

ColumnWhat it showsTransfer DateThe date the folio was transferredInvestorThe name of the investor who holds the folioFamily HeadThe head of the investor’s familySchemeThe scheme in the transferred folioFolioThe folio numberARNThe ARN linked to the transferAmountThe value of the holding as on the transfer date

• Total row: the sum of the Amount column across all rows.
• Sorting: every column can be sorted.
• Searching: the Scheme and Folio columns have a search box.

FAQs: Change of Broker Report

Q1. What does the Change of Broker report show?
It shows the folios whose distributor (ARN) changed during the selected period, either to you or away from you.

Q2. What is the difference between Change of Broker In and Change of Broker Out?
Change of Broker In shows folios that moved to your ARN from another distributor. Change of Broker Out shows folios that moved from your ARN to another distributor.

Q3. What does the Amount column show?
The value of the holding as on the transfer date.

Q4. Is the Amount the current value of the folio?
No. It is the value on the transfer date. The current value can differ because of NAV changes and any transactions after the transfer.

Q5. What does the Total row show?
The sum of the transfer-date amounts for all folios in the report, for the selected mode and period.

Q6. Is the Transfer Date filter mandatory?
Yes. You need to choose a start date and an end date before applying the report.

Q7. How do I see all transfers since I started?
Set the start date of the Transfer Date range to a date before your first transfer, for example 01-01-2000, and the end date to today.

Q8. How do I see transfers for one RM or sub-broker only?
Use the Select User filter and choose that user.

Q9. Can I download the report?
Yes. Choose XLS as the View Type and click Apply.

Q10. How do I find a specific folio or scheme in the report?
Use the search icon on the Folio or Scheme column header.

Q11. Can I sort the report?
Yes. Click the sort arrows on any column header. For example, sort by Amount to see the largest transfers first, or by Transfer Date to see the most recent ones.

Q12. How can I see how much AUM I gained or lost through broker changes in a period?
Run the report in Change of Broker In mode and note the Total. Then run it in Change of Broker Out mode for the same period. The difference between the two Totals is your net gain or loss on transfer-date values.

Q13. Why does one investor appear in several rows?
Each row is one folio and scheme. If an investor moved several schemes or folios, each one gets its own row.