Back-Office Software for MFDs: A Buyer's Checklist

Choosing back-office software is one of the larger operational decisions a mutual fund distributor (MFD) makes. Once your client book, transaction history and brokerage records live in a system, moving out is slow and painful. This checklist is meant to help you evaluate any vendor on the same footing, with the questions that matter in daily work rather than the features that look good in a demo.

It is deliberately neutral. Use it to build your own shortlist and score sheet.

1. Data ingestion: how does information get in?

Everything else depends on data arriving correctly and on time.

RTA mailback feeds

• Does the software import transaction and brokerage feeds from both CAMS and KFintech?
• Is ingestion automatic (for example, reading feeds from a dedicated mailbox) or does someone on your team have to download and upload files manually?
• How often are feeds processed: daily, several times a day, or only on demand?
• What happens when a feed fails or arrives late? Do you get an alert?

CAS import for held-away assets

Clients often hold folios under other distributors or in direct plans. A Consolidated Account Statement (CAS) shows these. Ask whether the software can import a CAS PDF and show those holdings separately from your own book, so your AUM and brokerage figures stay clean. Our guide to held-away assets and the CAS explains why that separation matters.

2. Data accuracy and reconciliation

A good-looking report built on wrong units is worse than no report.

• How are units and NAVs checked against RTA records?
• Where do unmatched or rejected rows go, and who sees them?
• How are PANs mapped to folios, and how are folios without a PAN handled?
• Can you group clients into families, and can you correct a wrong grouping yourself?
• Is there a reconciliation report you can run monthly?

Ask the vendor to show you a real exception screen, not just a clean dashboard.

3. Reports your team and clients will use

List the reports you send most often and check each one live.

• Portfolio valuation by client, family and scheme, as on a date you choose.
• Returns shown as absolute return and XIRR. Ask how XIRR handles SIPs, switches and partial redemptions; our explainer on how to calculate XIRR for a mutual fund SIP gives you a way to spot-check the numbers.
• Capital gains split into short-term and long-term, with grandfathering where it applies.
• SIP, STP and SWP reports: active, ending soon, ceased, bounced.
• Brokerage reports by AMC, scheme, client and month.

Check that dates follow DD-MM-YYYY and amounts use lakh and crore formatting if that is what your clients expect.

4. Client portal and mobile app

• Can clients log in to see their portfolio and download statements themselves?
• Is the portal branded with your firm's name and ARN details?
• Can you control which reports clients see?
• How do clients recover a forgotten password, and is two-factor login available for them too?

5. Client-service workflows

Daily service is where software saves the most time. Ask whether the system surfaces:

• SIP bounces and failed instalments
• KYC status issues and missing nominations
• SIPs and STPs ending in the next 30 days
• Birthdays and anniversaries, with opt-out respected

6. Brokerage reconciliation

Trail commission arrives across many AMCs and months. Ask whether the software compares expected brokerage with what was received, flags gaps by AMC, and keeps history across financial years such as FY 2025-26. See our piece on trail commission for mutual fund distributors for background.

7. Security and data protection

You hold PANs, bank details and contact information. Ask directly:

• Is two-factor login available for staff?
• Can you give each staff member a role with limited access?
• Is there an audit log of who viewed or changed what?
• Where is data stored? Is it hosted in India?
• Is data encrypted in transit and at rest?
• How often are backups taken, and has a restore been tested?

8. Data ownership and export

Ask, in writing: if you stop using the product, can you export all clients, folios, transactions and brokerage history in CSV or Excel? How long does it take, and is there a fee?

9. Pricing model

Pricing is usually per client, per AUM slab, per user, or a mix. Ask about:

• Onboarding and data migration fees
• Charges for SMS, email or WhatsApp messages
• Add-on modules priced separately
• Price changes when you cross a client or AUM slab
• Annual increase terms

10. Support, onboarding and roadmap

• Who migrates your historical data, and how is it verified?
• What are support hours and response times?
• Is training included for new staff?
• How quickly are regulatory changes, such as new tax rules or SEBI circulars, reflected in reports?

A simple scoring table

Score each vendor from 1 to 5 on each row, multiply by the weight, and add up.

Adjust the weights to your practice. A solo MFD might weight pricing higher; a firm with ten staff might weight roles and audit logs higher.

Questions to ask in the demo

1. Show me a day's CAMS and KFintech feeds being processed, including a failed row.
2. Pick one client and reconcile their units with the RTA statement in front of me.
3. Run a capital gains report for FY 2025-26 for a client with switches.
4. Show me how a staff member with limited access sees the system.
5. Show me the audit log for a client record.
6. Export my entire data set: what do I get?
7. What did your last regulatory update change, and how long did it take to ship?

Back-office software such as IntelliWealthPro can automate much of this work, but the aim of this checklist is that you choose with clear evidence, whichever vendor you pick.

Information only. Not investment advice. Mutual fund investments are subject to market risks; read all scheme-related documents carefully.