SIP Mining

Path: Business Analytics → SIP Mining

Overview

SIP Mining shows the SIP book of every client/investor in your organisation: all systematic plans (SIP, STP and SWP) in one place.

The main source is the RTA SIP Master, plus any records added manually. RTA data can sometimes be wrong or late, so you can add or correct records yourself and lock them so the RTA feed doesn't overwrite them.

You can view the data on screen or download it as XLS.

Report Configuration

Click Report Configuration to expand it. Choose a Mode, Type, Detail/Summary, ARN and View type, then click Apply. The options change depending on the Mode you pick.

Modes

• Currently Running: plans active today. Has a source toggle, RTA Master / Historical Transaction. Historical Transaction shows transaction data from the last 4 months.
• Procured: plans registered or started in a period. Choose Registration Date or Start Date, then a date range.
• Forthcoming: plans with an instalment due in the selected Next Date range.
• Prematurely Terminated: plans ceased before their end date, filtered by Cease Date range.
• Due for Maturity: plans ending in the selected End Date range.
• Expired: plans that ended in the selected End Date range.
• All: every plan.
• Potential Clients: clients with no currently running plan of the selected type, i.e. prospects for a new SIP/STP/SWP. Only Type and View type are available.
• Archived: records you have archived. The archived records data wont be shown in any broker or client reports

Example: To call clients whose SIP instalment is due next week, choose Forthcoming → Type: SIP → Next Date: next week → Apply.

Other filters

• Type: SIP / STP / SWP / All. Available in every mode.
• Detail / Summary (every mode except Potential Clients):
  • Detail: one row per plan.
  • Summary: totals grouped by the Group By you choose: Fund, Scheme, Category, Registrar, Branch, Region, Zone, Operation, Super RM, RM, Sub Broker, Service RM, Assistant RM, PMS RM, Family Head, Investor.
• Choose ARN: defaults to All My ARNs. Available in Detail view.
• View type: On Screen or XLS.

Reading the report

Detail view columns: each row is one systematic plan. A Total row at the top shows the total SIP amount. Use the search and sort icons on the column headers to narrow the list.

• Investor: the investor who holds the systematic plan.
• Family Head: the head of the family the investor is mapped to. Blank if the investor isn't mapped to a family.
• Folio: the folio number the plan is registered in.
• Scheme: the scheme the instalments go into. For an STP, the source scheme.
• Reg Date: the date the plan was registered with the RTA. This can be earlier than the Start Date.
• Start Date: the date the plan starts, i.e. the date of the first instalment.
• End Date: the date the plan ends, i.e. when the last instalment is due.
• Cease Date: the date the plan was stopped before its End Date. It's filled only for ceased plans, which appear under Prematurely Terminated.
• Last Transaction Date: the date of the most recent instalment processed.
• Next Date: the date of the next scheduled instalment.
• SIP Amount: the amount of each instalment.
• SIP Debit Date: the day the instalment is debited, based on the frequency. For a monthly SIP, 2 means the 2nd of every month.
• Frequency: how often the instalment runs: daily, weekly, fortnightly, monthly, quarterly or yearly.
• ARN: the ARN the plan is registered under.
• RTA Registration Code: the plan's registration number at the RTA (CAMS/KFin). Use it when you're raising a query with the RTA.
• RM / Sub Broker: the RM and sub broker mapped to the investor.
• Actions: the ⋮ menu with the option to edit the record.

Summary view columns: the Group By field, No. of SIPs, SIP Amount, No. of SIP Investors, Avg Amount per Investor.

Example: Group By Fund gives one row per AMC, e.g. Axis Mutual Fund: 85 SIPs, ₹3,88,500, 6 investors, ₹64,750 average per investor.

Potential Clients columns: Investor, PAN, Family Head, AUM, Email, Mobile, RM, Sub Broker.

Example: Sort by AUM to find high-AUM clients who have no running SIP and are worth a pitch.

Actions

Add Record

Click Add Record (top right) to open the Add Systematic Record form.

1. Choose SIP / STP / SWP.
2. Fill in Investor, ARN and Scheme. For STP, pick a Source Scheme and a Target Scheme instead.
3. Enter Registration Date, Start Date, End Date, Amount, Frequency (Daily, Weekly, Fortnightly, Monthly, Quarterly, Yearly), Debit Date, Registration Code and, if relevant, Cease Date.
4. Tick Lock if the record should not be overwritten by the RTA SIP Master.
5. Click Save.

The record appears in whichever mode its dates fit. For example, a plan whose end date has passed shows under Expired.

When to use: a new registration that hasn't shown up in the RTA feed yet, or a plan the RTA has recorded wrongly.

Lock

The Lock checkbox is in both the Add and Edit forms. A locked record is not auto-updated from the RTA SIP Master. Tick it whenever you correct a record by hand, or the next RTA sync may overwrite your changes.

Edit Record

In the Actions column, click ⋮ → Edit to open Edit Systematic Record.

• Read-only: Investor, ARN, Scheme.
• Editable: Registration/Start/End Date, Amount, Frequency, Debit Date, Registration Code, Cease Date.
• Checkboxes: Lock and Archived.

Archive

Open the record with Edit, tick Archived, then click Save. The record moves to Archived mode and is hidden from every other SIP Mining mode and from all other SIP reports. Use this for duplicate or invalid records.

Bulk Update Cease Date

1. Tick the plans in the Select column. A Choose Action dropdown appears.
2. Choose Update Cease Date.
3. Enter the cease date and click Apply.

The cease date is updated for every selected plan at once. Use this when several plans have stopped but the RTA feed hasn't caught up.

FAQs

How do I see the SIP dates of all my clients? Choose Currently Running mode, Type SIP, keep the toggle on Detail and click Apply. Every running SIP is listed with its dates: Start Date (first instalment), Next Date (next instalment), SIP Debit Date (debit day), Last Transaction Date (latest instalment processed) and End Date. Choose All mode instead to include stopped and expired plans, or select XLS to download the full list.

How do I see which clients have an instalment coming up? Choose Forthcoming mode and select the Next Date range, e.g. the next 7 days. The list shows every plan with an instalment due in that period.

A client's SIP is missing or shows wrong details. Why? The RTA SIP Master can be late or wrong. Add or edit the record manually and tick Lock.

I archived a plan and it's gone from my other SIP reports. Is that expected? Yes. Archived records only appear in Archived mode. To bring a record back, open it from Archived mode and untick Archived.

Will my manual changes be overwritten by the RTA data? Only if the record isn't locked. Tick Lock in the Add/Edit form, and the RTA SIP Master won't update that record.

What is the difference between RTA Master and Historical Transaction in Currently Running mode? RTA Master shows running plans as recorded in the RTA SIP Master. Historical Transaction works them out from the transactions of the last 4 months instead. That helps when the SIP Master is outdated.

How do I find clients who don't have an SIP? Choose Potential Clients mode, select the Type (SIP/STP/SWP) and click Apply. You get every client with no currently running plan of that type, along with their AUM, email and mobile, so you can reach out.

How do I see my SIP book by AMC, RM or Sub Broker? Switch the toggle to Summary and pick the Group By, e.g. Fund, RM or Sub Broker. Each row shows the number of SIPs, SIP amount, number of investors and average amount per investor.

How do I see the SIPs registered last month? Choose Procured mode, set the toggle to Registration Date and pick last month's date range. To see plans by when the first instalment started, use Start Date instead.

What is the difference between Prematurely Terminated and Expired? Prematurely Terminated means the plan was stopped (ceased) before its end date. Expired means the plan ran until its end date.

Why can't I see the Choose ARN filter? The ARN filter only appears in Detail view. It is hidden once you switch to Summary.

How do I mark several SIPs as stopped at once? Tick them in the Select column, then go to Choose Action → Update Cease Date, enter the date and click Apply.

Can I change the investor or scheme of an existing record? No. Investor, ARN and Scheme are read-only in the Edit form. Archive the wrong record and add a new one with the correct details.

Can I add an STP or SWP manually? Yes. In Add Record, select STP or SWP at the top of the form. For an STP, choose both a Source Scheme and a Target Scheme.

Can I download the report? Yes. Select XLS under View type before clicking Apply.