How to automate CAMS and KFintech mailback reports
If you are a mutual fund distributor in India, registrar mailback reports are the backbone of your back office. Your clients' transactions, SIP registrations, investor details and holdings all reach you through reports from the two registrar and transfer agents (RTAs): CAMS and KFintech. Between them they service the schemes of nearly every AMC, so almost every distributor has to deal with both.
This guide explains how mailbacks work, why handling them by hand is so time-consuming, and what an automated workflow looks like.
What are mailback reports?
A mailback is a report that an RTA emails to the address registered against your ARN. You can request reports on demand or schedule them to arrive regularly. Typical reports cover:
- Transactions — purchases, redemptions, switches, STPs, SWPs and SIP instalments for a period.
- Investor static details — name, PAN, contact details, bank account, nominee and KYC status, folio by folio. (At CAMS this is the WBR9 report.)
- SIP registrations — active, ceased and upcoming SIPs.
- AUM / holdings — client-wise and scheme-wise balances.
How CAMS and KFintech deliver reports differently
The two RTAs don't send reports in the same way, which is part of what makes manual work painful:
- CAMS generally sends reports as password-protected ZIP attachments. Inside you may find Excel, text or DBF files depending on the report.
- KFintech often sends an email with a link to download the report, rather than an attachment. The file has to be fetched from that link before it can be opened.
Column names, formats and scheme codes also differ between the two, so their data can't simply be stacked together in one sheet.
The manual workflow (and what it costs)
- Request or wait for the report.
- Find the email, download the attachment or follow the link.
- Unzip with the correct password.
- Open the file, clean the columns, and paste it into your master Excel.
- Repeat for the other registrar, then reconcile duplicates and mismatches.
Even at 20–30 minutes a day, that is 10+ hours a month — and errors creep in. The biggest cost is often invisible: a ceased SIP or a changed bank mandate that you only notice weeks later.
What an automated workflow looks like
Automation removes every step between "report arrives" and "data is in your dashboard":
- Inbox monitoring — new mailback emails from CAMS and KFintech are detected automatically.
- Retrieval — attachments are saved and KFintech links are followed to fetch the file, with checks that the download is a valid file.
- Unpacking and parsing — ZIPs are opened with your stored passwords, and each report type is parsed into a common format.
- Consolidation — CAMS and KFintech records are merged by investor PAN, folio and scheme into one book.
- Alerts — changes that need your attention, like a stopped SIP, surface on a dashboard instead of being buried in a sheet.
Doing it with MFD Platform
MFD Platform was built by a distributor to do exactly this. CAMS and KFintech mailback files are read and loaded automatically — from your connected mailbox (read-only access) or files you upload — and turned into one view per client and family, a SIP and STP register, transactions and capital gains statements. Re-loading a file never creates duplicates.
Coming soon: forward registrar emails to your own private address, so no mailbox access is needed at all, and one-click requests for your full history from CAMS and KFintech.