The Clients menu is where you view, create, search, segment and manage all your investors. This guide explains the page layout and the most common tasks, such as creating a client, assigning a Sub Broker, uploading clients in bulk and using bulk actions.
1. Understanding the Clients page
Click Clients in the left menu to open the page. Client names, PAN numbers and RM names in the screenshots in this guide are blurred for privacy.
The page has the following parts:
- Tabs: Family Heads Only, All Clients and any custom segments you have created. The + icon next to the tabs adds a new segment.
- Create New Investor: adds a single client manually.
- Upload: adds many clients together from an Excel (.xls) file. Use sample file attached to see the format in which client data can be uploaded.
- Customize Columns: lets you choose which columns appear in the table.
- Client table: shows columns such as Name, Family Head, PAN, AUM, Created At, Service RM, Source, Assistant RM, PMS RM, Sub Broker, Birthday and UserName. Name, AUM and Created At can be sorted. Name, PAN, Service RM, Source, Assistant RM, PMS RM and Sub Broker have a search icon for filtering.
These filters can be used to find inactive clients (Clients which have zero AUM) and also filter out clients corresponding to one particular sub broker or RM. Using the excel export of clients multiple filters can be applied in the downloaded data to get the filtered out list of clients based on these parameters. - Checkboxes: at the start of every row, used to select clients for bulk actions.
- Actions (three dots): at the end of every row, for actions on a single client.
The Source column shows how a client was added, for example CAS Import, Clients Bulk Upload, Clients Menu, NSE Invest, UCC Creation, MF Upload, RTA Transactions Import or Insurance Bulk Upload.
2. How to create a new client
- Go to Clients.
- Click Create New Investor.
- Fill in the Personal Information section. Name and User Name are required.
- Fill in the Residential Address section.
- Fill in the optional details at the bottom of the form, if needed.
- Save the client. Click Go Back at the top of the form to return to the list without saving.
Fields available in the form
- Personal Information: Title, Name, PAN, App code, Email ID, Alternate Email ID, User Name, Mobile No, Phone No, Date of Birth, Birthday wish on, Anniversary.
- Residential Address: Address, City, State, Country, PIN.
- Other details: Client Rating, Review Frequency, Last Review Date, First Investment Date, Model Portfolio, File No, Add Tag (tags added in the tags master in settings shown to the admin user are visible here).
Tick Disable Emails next to the Email ID field if the client should not receive system emails.
3. How to upload clients in bulk
- On the Clients page, click Upload at the top right.
- In the Client Bulk Upload window, click Download Sample File and fill in your client data in that format.
- Drag the file into the box, or click Choose File and select it.
File rules
- Upload one file at a time.
- The supported file format is .xls.
- The file size must be less than 20 MB.
- The data must be in the first sheet, named Sheet1.
4. Row actions: Edit Profile, Go to Dashboard and Send Invitation
Click the three dots at the end of a client's row to see the actions for that client.
- Edit Profile: update the client's details, including Family Head, RM, Sub Broker and Service RM.
- Go to Dashboard: open the client's dashboard.
- Send Invitation: send the client an invitation to log in via email scheduler
5. How to create a client segment
A segment is a saved filter that appears as a tab on the Clients page.
- Click the + icon next to the tabs.
- Type a name in Enter Client Segment Name.
- Select an Attribute, for example Address, Email, Equity Code 1, File Number, Mobile, Name or PAN. (Other attributes like RM, Tag, AUM, Sub broker etc, will be added soon)
- Select an Operator: Like or Starts With. (other operators like is, >, =,< will be added soon)
- Type the Value to match.
- To add more conditions, click AND (all conditions must match) or OR (any condition can match).
- Click Save. The segment now appears as a tab.
6. How to customize columns
- On the Clients page, click Customize Columns.
- Tick the columns you want to see and untick the ones you do not.
- Drag the handle next to a column name to change its position.
- Click Apply. Click Cancel to discard your changes.
7. Bulk actions
Bulk actions let you update many clients at once. Select the clients using the checkboxes at the start of each row (use the checkbox in the header row to select all), and then choose the action you need.
Hierarchy and Sub Broker
- Set Family Head: links the selected clients to a family head.
- Reset Hierarchy: removes the broker users assigned to the client and maps it to admin broker user.
- Set Sub Broker: assigns the selected clients to a Sub Broker.
Relationship Managers
- Set RM: assigns an RM to the selected clients.
- Set Service RM / Unassign Service RM: assigns or removes the Service RM.
- Set Assistant RM / Unassign Assistant RM: assigns or removes the Assistant RM.
- Set PMS RM / Unassign PMS RM: assigns or removes the PMS RM.
Lock
- Set Lock: locks the selected clients' personal information. This action can be used in order to lock that client’s personal information from changing (like email, mobile) even when updated data is received from transaction files or RTA.
- Set Unlock: unlocks them.
Transactions
- Enable Online Transaction / Disable Online Transaction: allows or blocks online transactions.
- Enable Redemption / Disable Redemption: allows or blocks redemptions.
Communication
- Enable Communication / Disable Communication: turns communication (such as emails) on or off for the selected clients.
Login access
- Suspend Login: stops the selected clients from logging in.
- Reactivate Login: restores their login access.
Profile settings
- Set Model: assigns a model portfolio.
- Add Tag: adds a tag to the selected clients.
- Set Client Rating: sets the client rating.
- Set Portfolio Review Frequency: sets how often the portfolio is reviewed.
How to assign a Sub Broker to a client
For one client
- Go to Clients and click the three dots at the end of the client's row.
- Click Edit Profile.
- Select the Sub Broker from the Sub Broker dropdown and save.
For many clients
- Select the clients using the checkboxes.
- Choose the bulk action Set Sub Broker.
- Select the Sub Broker and confirm.
How to merge a client
In order to merge multiple clients, select the clients to be merged and in the actions dropdown shown on the top, select merge duplicates, then choose which member should the remaining clients be merged into and click on apply
8. Frequently asked questions
Q1. How do I create a client?
Click Create New Investor on the Clients page, fill in the required Name and User Name along with any other details, and save. See section 2.
Q2. How do I add many clients together?
Click Upload, download the sample .xls file, fill it in (data in Sheet1, file under 20 MB) and upload it. See section 3.
Q3. How do I assign a Sub Broker to a client?
Use the bulk action Set Sub Broker.
Q4. How do I assign or remove an RM, Service RM, Assistant RM or PMS RM?
Select the clients and use the matching Set or Unassign bulk action.
Q5. How do I make a client part of a family?
Use the bulk action Set Family Head, or set the Family Head field in the client's profile. To remove a client from a family/Edit the family members/ add a new member in the family, click on the current family head’s name, on the pop up click Family member, on this screen we can add an investor in the family, or ungroup the family using the button on the top right. Using the 3 dots button on each row, we can ungroup an individual member from the family or make another member the family head.
Q6. How do I merge duplicate clients?
In order to merge multiple clients, select the clients to be merged and in the actions dropdown shown on the top, select merge duplicates, then choose which member should the remaining clients be merged into and click on apply
Q7. How do I stop a client from transacting or redeeming?
Use Disable Online Transaction or Disable Redemption. Use the Enable actions to reverse them.
Q8. How do I block a client from logging in?
Use Suspend Login, and use Reactivate Login to restore access
Q9. How do I stop emails going to a client?
Use the bulk action Disable Communication, or tick Disable Emails in the client's profile.
Q10. How do I send a login invitation to a client?
Click the three dots at the end of the client's row and choose Send Invitation.
Q11. How do I find a specific group of clients?
Use the search icons in the column headers, or create a client segment.
Q12. A column I need is not showing. What should I do?
Click Customize Columns, tick the column and click Apply. This customize column option is only visible to the admin.
Q13. How do I tag clients or set a rating or review frequency in bulk?
Select the clients and use Add Tag, Set Client Rating or Set Portfolio Review Frequency.
Q14. How do I stop a client’s email or mobile number from changing when a transaction is imported from RTA file ?
Use Lock feature in actions in order to lock that client’s personal information from changing even when updated data is received from transaction files or RTA. Use unlock in order to reverse the change.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article