Back To Main Page
                                
Customer Grouping (Click here)

































































































WealthERP SetUp Check List

Login Credentials

  • Once you register with WealthERP you will soon get a signup mail with your login ID and Password. Below is a sample of the startup mail.
  • After login in you will first have to change your password.

WealthERP Questionnaire

  • Also make sure you received the WealthERP Questionnaire, fill it and send it back. Below is a sample Questionnaire.

Set Up Guide

  • Along with the startup mail you will also receive a setup guide. Make sure you read it carefully before you proceed.

Sign Up process With R&T

  • You need to first register yourselves with each of the R&T’s separately.

CAMS

  • Go to www.camsonline.com
  • Click on “Online Distributors Services” Tab (Highlighted in Red).
  • Scroll down and click on the “Click here to register” link.
  • Fill up the Registration letter and send it to CAMS Registrar by post or courier.
  • NOTE: Normally you will receive the user ID and password from CAMS within a week time. 
  • Incase of any help contact the CAMS team email: helpdist@camsonline.com contact number: 044-30212664/665/666

Karvy

  • Go to www.karvymfs.com
  • Under client services, click on “distributors services” (Highlighted in Red).


  • Fill up the Registration letter and send it to Karvy Registrar by post or courier
  • Normally You will receive the user id and password from Karvy within a week time, otherwise you can follow them up

Franklin Templeton

f1
  • Select the appropriate option and register

Sundaram

  • Download and fill the file
  • Fill and send the form to sundaram.

Requesting Mail Back from R&T

R&T Name PROFILE/FOLIO TRANSACTIONS SIP / STP  Registration Trail Brokerage / Commission
CAMS WBR-9 WBR-2 WBR-49 WBR-6
KARVY MF SD-221* MF SD-221* MFSD-230 MFSD-205
FRANKLIN TEMPLETON MY TRANSACTION for a period MY TRANSACTION for a period Active SIP First Year Trail Fee
SUNDARAM ER-04 -Investor Static Data ER-02 Non Channel Report with SBBN Folio ER16 - SIP/STP procured for a period No separate File available
*MFSD-221 is a common combo file for both profile and transaction

CAMS

  • Go to www.camsonline.com
  • Click on Online “Distributors Services” Tab
  • On the next page click on “Distributor mail back service” in the right panel.
  • On the Distributor mail back service Page Enter your Registered Email ID in the Text box. Choose Funds from the List Box on the Page (Press 'ctrl' key for Multiple Selection) and click on “Next” button at the bottom
  • Click on “Grow your business” tab
  • Select WBR49 option, choose the desired format as DBF and click on “Next” button
  • Under “Customer service” Tab
  • Select WBR2 options, choose the desired format as DBF and click on “Next” button
  • Under “Your earning” tab
  • Select WBR6 options, choose the desired format as DBF and click on “Next” button
  • Under “Propriety data” tab
  • Select WBR9 option, choose the desired format as DBF and press “Next” button
  • Now on the “Query Parameters” Page, Select From Date and To Date on the Period Column & click on “Next” button.
  • On the Query Confirmation Page, Enter Password and click on “Overnight” button
  • Confirmation of Request page will display the Confirmation Request Number
  • Incase of any help contact the CAMS team email: helpdist@camsonline.com contact number: 044-30212664/665/666

Karvy

  • Go to www.karvymfs.com
  • Under client services, click on “Distributors services”
  • Login with your id and password sent to you by Karvy
  • Click on “Mail back reports”
  • Choose MFSD 201 Transaction Reports and click on “Click here” link
  • Enter the range of dates and select “All funds”
  • Enable the check box for the E-mail ID to which you want the reports to be delivered, Click on the “Submit” button
  • Enter the Self Extraction Password. (Remember this password as the same is required to Decrypt the file received from the R&T)
  • Confirmation page will open, showing the reference number.

Franklin Templeton

  • Go to www.franklintempletonindia.com
  • Click on “Advisor login”.
  • Enter your User ID and Password.
  • Go to “Mail Back Services” on the right hand side .
  • Choose your Transaction Feed between Periods, Click “Submit” button.  
  • A Zip file will be sent to your mailbox. Unzip the file and save as Excel Format.

Sundaram

  • Go to www.sundarambnpparibasfs.in
  • Click on the “Mail back service” under the distributor tab
  • Enter your User ID and Password to login
  • Click on the “Mail back Service” option

1

  • Select the ER02, ER04 and ER16 reports one at a time, file type DBF and click on “Request” button

1


1

MF Files Upload in WealthERP

ARN Settings

  • Before you can start with the uploads go to Admin >> Organization >> LOB >> add LOB
  • After the LOB is added you can Edit/View or delete it.

Reject Reasons

Reject Reason

Solution

WERP Broker Code was not found

Please add all the variations of the Broker Code received from the file in your Mutual Fund Intermediary LOB settings

PAN is null in external source file

Please add PAN Number to this record and reprocess, make sure that all records in the file have a PAN Number

Investor Name null in external file

Please add Customer Name to this record and reprocess

Data translation for Transaction Type could not be done

The Transaction Type for this record could not be identified. Please contact Cust care for assistance

WERP AMC Code was not found

The Product Code specified for this record is not available in the system. Please contact Cust care for assistance.

WERP code for the Scheme/Scrip was not found

The Product Code specified for this record is not available in the system. Please contact Cust care for assistance.

Transaction Number is null in external file

Transaction Number field is null in the file. Please make sure that all transactions have a transaction number and re upload

Scheme Code is null in external file

The Product Code in null in the external file. Please make sure that all records have a Product Code

New Folio/Customer found

Click on the "Map Folios" button in the Rejected Transactions page. Select all the folios belonging to a Customer and Click on the "Map to WERP Customer" button. Incase of existing Customer Search and Map to Customer else Add New Customer.

Customer already exists. Duplicate record

Record already exists. No action required

Transaction already exists. Duplicate record

Record already exists. No action required

Customer and Folio already exists. Duplicate record

Record already exists. No action required

Folio already exists. Duplicate record

Record already exists. No action required

Transaction already exists. Probable Duplicate.

Record already exists but with slight variations in the No. of Units and/or amount in Decimal column. These transactions are to be verified one by one and uploaded is not an actual duplicate Else Deleted in an actual duplicate.

Folio/Profile Upload

Folio Upload
  • After you receive all the files from the R&T
  • Go to Admin >> Operations >> Uploads >> Start Upload
    • Step1: Select the Extract type, Branch and External Source
    • Step2: Click on “Browse” button
    • Step3: Select the file you wish to Upload
    • Step4: Click on “Upload” Button to start upload
fu
Folio Cleansing/Exception Handling
  • After the upload is done, check your upload history
  • If the PAN number doesn’t exist then type the PAN and hit the “Save” button, if the customer exist then do the mapping by pressing “map to customer button” and finally reprocess.
  • If wealthERP broker code not found then select the record and click on “Add broker code”
Folio Reconcile
  • Go to Admin >> Operation >> Uploads >> Uploads history, make a note of the process id.
  • Go to Admin >> Queries >> Account, and search for the same process id and check the count for that particular process ID.
Profile Reconcile
  • Go to Admin>> Operation >> Uploads >>uploads history, make a note of the process id.
  • Go to Admin >> customer/prospect >> customer list, and search the same process id and check the count for that particular process ID.

NOTE: Repeat the above process for each R&T and all the files

Transaction Upload

Transaction Upload/Cleansing
  • Go to Admin >> Operations >> Uploads >> Start Upload
  • Upload the transaction file using the same procedure like above, transaction file does not require any cleansing.
Transaction Reconcile
  • Go to Admin>> Operation >> Uploads >>uploads history, make a note of the process id.
  • Go to Admin >> Queries >> Transaction
  • Click on MF Transaction and search the same process id and check the count for that particular process ID.

Overall Upload Reconcile

AUM Reconcile
  • First check the date in your R&T Folio file, and then make sure you do valuation for that date. For valuation go to admin >> Operation >> Valuation. Select Mutual fund, input the same dates and then click on “Valuation” for that date. (Wait for 30 minutes after valuation)
  • Next, make a note of the total Rupee balance in the folio files which you uploaded. Then, go to Admin >> AUM & Holding >> Customer holding. Select the same date and check if the AUM matches the Rupee Balance of your folio files.

Other Uploads

MF SIP Uploads

  • Go to Admin >> Operations >> Uploads >> Start Upload. Upload the SIP file using the same procedure.
  • To Reconcile Go to Admin >> Queries >> MF SIP MIS, and check if the SIP is added.

EQ Uploads

  • Go to Admin >> Operations >> Uploads >> Start Upload. Here first we need to upload the equity trade account file and then upload the equity transaction file. Upload all the files using the same procedure.
  • Go to Admin >> Operations >> Uploads >> Upload history, To check for rejects or the number of accounts that are added.
  • To check for a particular customer, Go to admin >> customer/prospect >> customer list. Select profile of a particular customer.
  • In the customer module, go to Assets >> equity >> view equity account
NOTE: If you are not able to upload the you can forward all the files to cust care for uploads.

Change Login Id / Password

  • To change login id / Password, Click on settings on the main tab as shown below.
  • Make your selections
  • Change Password
    • Enter your current password
    • Enter your new password
    • Click on the “Save” button
  • Change Login ID
    • Enter your current Login ID
    • Enter your new Login ID
    • Click on the “Save” button

WealthERP Settings

Theme

  • Go to Admin >> Settings >> Theme
  • Theme color of software can be changed from "Setup Theme Option". As of Now Eight themes are available Black & White, Blue, Dessert, Green, Maroon, Purple, Yellow and Light Purple. Applying any theme will be applicable to Admin/RM/BM/Customer Logins.

Email/SMS Account

  • Go to Admin >> Settings >> Email/SMS Account
  • Advisor can send Mutual Fund Reports, Equity Reports, Financial Planning Reports, Customer Logins, Staff Logins etc to the customers/staffs. To send a report from Advisor's own email id first SMTP needs to be Setup. Please get the information of SMTP Host, SMTP Port from your email service provider, fill your email id and password then click to Test Credentials. It will validate if the information provided by you is correct or not. Once it will be validated please click to "Save" button so that this Email id can be used for all your communication with Customers
Note:- Make sure "SMTP Authentication Required" checkbox is checked as shown in below image.
  • Here are some commonly used email service provider's SMTP details.


Setup customer Category

  • Go to Admin >> Settings >> Setup customer category
  • Setup customer category is used to categorize your customers. Each category of customer is given a category code

Associate Category

  • Go to Admin >> Settings >> Associate category
  • Associate Category is Prerequisite step if you want to categorize your associate branches. Here you can Add/Edit/Delete categories which will be available in Associate Category dropdown during adding an Associate Branch. After filling category code and category description please click “Save” button.

Alert configuration

  • Go to Admin >> Settings >> Alert configuration
  • "Alert Configuration Setup" Can be done by Admin which will be applied to all Customers. Birthday reminder, Maturity Date reminder, SIP Reminder, SIP Confirmation, Anniversary Reminder etc can be set from "Alert Configuration" Screen as shown below. To Edit any reminder just select the Alert from Screen and click to Edit Default and Change accordingly. After any change click on Apply Alert.

Organization Profile

  • Go to Admin >> Organization >> Profile >> edit profile
  • Clicking on Edit profile will open a edit form there you can change or update organization profile information. You can change or upload a new logo by clicking on  "Click To Change Logo" link. Select box will open, select the logo and click to Submit.

User Management

Staff User Management

  • Go to admin >> operation >> user management >> Staff user management
  • For staffs, you can disable their account by just resetting the password but not sending the credentials to them. If they want the password to be changed and shared with them then you can reset and send via automated mail to the staff.

Customer User Management

  • Go to admin >> operation >> user management >> customer user management
  • For a new customer you can generate and send login details to the customers email id
  • In case a customer forgets password; the admin can select the customer and click on “Reset and send login details” button.

Customer Grouping

  • Go to Customer/Prospects >> Customer Grouping >> Add Grouping
  • Go to add option, Group Account Setup form will open. Now Select RM name, Staff Code and Branch will be displayed for selected RM, Now Type Some later in "Pick Parent Customer" Field a customer list belongs to selected RM will open matching the word you have entered select the Customer name that you want to make Parent. As soon as Parent customer will be selected PAN Number and Address Associated with that Customer will be displayed below.
  • Now type customer name in "Pick Member Customer" Field, choose the Member customer name from search result dropdown as shown below. Now Select the relationship from Relationship Dropdown.
  • Note:
    • Once Group Account is setup, Associated Members will be displayed to be selected as Nominee, Joint Holding Members, and Co-Borrowers etc. in other Places.
    • If any member once selected as Parent Customer it will not be available in Member Customer list. So Parent Customer cannot be a Member Customer for any other parent customer.
    • Member associated with any Parent can never be a Parent Customer.
    • Once a Customer is Associated to any Parent Customer he/she cannot be associated to any other Parent Customer.
  • Disassociate Group Account: Now if you want to de-associate any member ship then simply search parent customer select the Parent Member Combination for which you have to de-associate the relationship and click on the  “Disassociate” button as shown below

Reports

  • Admin->Customer/Prospects->Reports

MF Reports

  • Mutual Fund Reports can be Viewed, Downloaded & Sent by Email in PDF format. As you can see the below screenshot, here Group Selection shows all the Group Customer Reports.
  • Bulk Mail Feature is also available for Mutual Fund Reports. Here you can send multiple Mutual Fund Reports to Multiple Customers in just one Click. As shown in below screen shot there are three selections, Group Selection shows all Group Head Customers who will get his associates report also if chosen, Individual Without Group selection shows all Customer who are not associated to any customer with any relationship, All Individual Selection shows all the customers and they get their individual reports

Multi Asset Reports

  • Multi Asset Report can be Viewed, Downloaded & Sent by Email in PDF format. As you can see the below screenshot, here Group Selection shows all the Group Customer Reports.

Equity Reports

  • Equity Report can be Viewed, Downloaded & Sent by Email in pdf format. As you can see the below screenshot, here Group Tab shows all the Group Customer Reports

FP Reports

  • FP Report can be Viewed, Downloaded & Sent by Email in PDF format. As you can see the below screenshot, here Group Tab shows all the Group Customer Reports