Compliance Report for Mutual Fund Distributors: DDQ, Form A1, MF AUM Data and Investor Logs in One Place
Written by Sagar Sahu●November 06, 2026●3 min read
Compliance is the part of the distribution business nobody enjoys and nobody can skip. An AMC asks for your annual due diligence questionnaire. A regulator audit lands and you are asked for AUM splits, folio counts and exit-load details. A client complains that a redemption went to the wrong bank account, and you need to find out what changed and when. In most MFD offices, each of these requests triggers a scramble through Excel sheets, RTA files and email threads.
A single compliance report for mutual fund distributors removes that scramble. In Wylth®, the Compliance Report brings four working areas under one roof: Business Compliance, MF AUM Compliance, Missing Folio Details and Investor Log. This guide walks through what each tab does and how it fits into a distributor’s day-to-day routine.
Why MFDs Need a Compliance Report Built Into Their Software
Most distributors handle compliance reactively. The data exists, but it is spread across back-office reports, RTA downloads and individual client records. That creates three recurring problems:
Last-minute preparation. Annual questionnaires and audit requests are answered by hand, ARN by ARN, which is slow and error-prone.
Data gaps nobody sees. Missing dates of birth, bank details, mobile numbers, emails or nominees stay hidden until they cause a rejected transaction or a client complaint.
No trail. When a client disputes something, there is no quick way to see who did what and when.
A compliance module inside your wealth-tech platform addresses all three, because the data it needs is already in the system.
The Four Tabs of the Wylth® Compliance Report
TabWhat it gives youBusiness ComplianceARN, SIF, KYD, EUIN and NISM validity tracking, plus Distributor Due Diligence (DDQ) and Annual Declaration (DSC / Form A1) with upload historyMF AUM ComplianceAUM, folio, investor, SIP, turnover and redemption data, downloadable to ExcelMissing Folio DetailsTwo sub-views that flag folios with missing or inconsistent informationInvestor LogSearchable activity trail for any investor
Tab 1: Business Compliance
Business Compliance is the first tab. It tracks your registrations and covers the two annual documents an MFD is most often asked to produce and submit.
ARN, SIF, KYD and EUIN Validity at a Glance
Business Compliance opens with a card for each ARN (and RIA registration) in your business. Each card shows, in one line:
ARN validity date, with expired registrations highlighted in red.
SIF validity, where applicable.
KYD status (Know Your Distributor), such as Completed or Not available.
EUINs registered, with a count of how many are expiring within 30 days and how many have expired.
MF + SIF AUM for that registration.
Every view is stamped with an “As on” date, so you always know how current the numbers are. If you hold more than one registration (for example an ARN and an RIA code), each gets its own card, and an expired registration is flagged in red right on the card.
Expand a card to see every EUIN holder under the ARN, with their EUIN validity and NISM validity, and add a new RM or EUIN from the same screen. Expiring and expired items are colour-flagged, so renewals are no longer discovered at the last minute.
Distributor Due Diligence (DDQ)
The Distributor Due Diligence (DDQ) questionnaire is something every distributor has to complete each financial year, ARN by ARN. In Wylth®, you pick the financial year and click Generate DDQ; the questionnaire is pre-filled from the data already in your system, so you are not retyping the same business details again. The card shows where you stand, for example “6 of 6 sections complete” and its status (Draft or submitted), and you can Continue a saved draft later.
Below it, Historic DDQ forms keeps your records in one table, with the review FY, status, submission date and form. You can upload the signed or submitted PDF (max 5 MB) against a financial year, so last year’s and this year’s DDQ are always in one place. From there you can submit it to the AMC or upload it on the portal where it is required.
Annual Declaration (DSC) and Form A1
Alongside the DDQ, Wylth® handles the Annual Declaration (DSC). The card tells you which form applies (for example, Form A1 for a non-individual ARN holder with sub-brokers), the financial year, whether it has been submitted, and the due date. The workflow is deliberately simple:
Select the financial year and click Generate & download Form A1.
Print it and sign it.
Click Upload to store the signed PDF (max 5 MB) in the Submission history, which tracks the form, status, acknowledgement and submitted-on date.
Submit it where required, and use the Check receipt on AMFI-CAMS SD-Enquiry link on the same card to confirm it was received.
The result is that your signed declaration is no longer sitting in a drawer or a single email attachment. It is retained, with its status and due date, in the same system as the rest of your compliance records.
Tab 2: MF AUM Compliance
When an audit takes place, the auditor typically asks the distributor for a standard set of business data. The MF AUM Compliance tab generates it on demand. You select the ARN and the Financial Year, tick the reports you need (AUM Report, Portfolio Turnover Ratio, Redemption Report, or All), and click Generate report. Each report can be downloaded to Excel.
AUM Report
The AUM Report shows, for the selected ARN and financial year:
AUM split by Equity, Debt, Liquid and Others, with a total, broken down by Individual and Non-Individualinvestors.
Active folios, number of investors and active SIP folios.
An Unclassified row for holdings whose folio is not mapped to a client account, so nothing is silently dropped from the totals.
Portfolio Turnover Ratio
Shows opening AUM, closing AUM, average AUM, total purchases (including SIP) and total sell (including SWP), and the resulting PTO ratio for the financial year. You can exclude Arbitrage, ELSS, Debt or Liquid funds from the calculation.
Redemption Report
Lists the financial year’s redemptions, including how many carried an exit load, so exit-load questions can be answered with facts.
Because this report is generated from the same data that drives your dashboards and client records, the numbers stay consistent with what you see everywhere else in the platform. If you want the bigger picture on keeping your book visible in one place, read our post on complete AUM visibility.
Tab 3: Missing Folio Details
Incomplete folio data is one of the most common, and most avoidable, sources of service trouble: a bounced redemption, an unreachable client, a nominee dispute later. The Missing Folio Details tab has two sub-tabs that turn those hidden gaps into a work list.
1. Missing Folio Details
A summary card shows how many folios are flagged out of your total (for example, “104 flagged of 355”). The list beneath it shows, for every flagged folio, the client, RM name, folio number, folio name, AMC, the exact missing details and the folio valuation (with its as-on date). You can filter by client, RM, folio number, folio name, AMC or missing detail, and sort by valuation to fix high-value folios first. Folios not mapped to any client account are included and clearly tagged Unmapped. The missing details it flags include:
Date of birth
Bank account number
Mobile number
Email ID
Nominee details
Other key fields
Each gap is shown as a tag (for example, Mobile Number or Nominees), so your team knows precisely what to collect from which client.
2. Client Discrepant Folios
Many investors hold multiple folios, and the details do not always match across them. For each such client, the view lists the RM, masked PAN, number of folios and exactly what mismatches (Bank Account, IFSC, Email, Mobile or Nominee), with a one-click view of the folios involved. It shows which folio carries different information. For example, one folio may have a different bank account while the other five are identical. You see the mismatch at a glance and can correct it with the client instead of discovering it during a payout.
Together, these two views are a ready-made data-cleanup agenda for your operations team. Risk profile changes, meanwhile, are traceable in the Investor Log described below.
Tab 4: Investor Log
The Investor Log is the audit trail. You can search the log of any investor and see their recent activity, including:
Mutual fund orders placed
Fixed deposit investments made
Username or password changes
Risk profile updates
MF investment account activity, such as a UCC created or updated through BSE, NSE or MFU
You search by investor name or PAN, and the log shows the investor’s PAN, their RM and the number of entries. Each entry is time-stamped and tells you what happened, through which channel and who did it. For example:
An MF order shows the type (such as Purchase), amount, scheme and plan, the order status, the channel (such as CRM Web), the exchange (such as BSE), the RM, and who placed it.
An MF account update shows details such as a bank mandate amount, the bank account (masked), the exchange and whether the scan image has been uploaded.
A risk profile entry shows the assessed category, the score and the validity date.
A fixed deposit entry shows the amount, the issuer, tenure, rate, maturity date and status.
A username or password entry shows, for example, that a reset was requested and whether it was completed.
A new MF account entry shows the exchange, the UCC and its approval status.
When a client says “I never changed that,” or when your team needs to confirm what happened on an account, the answer is one search away rather than a round of internal phone calls.
A Simple Compliance Routine for Distributors
Software works best when it is paired with a rhythm. A practical way to use the Compliance Report:
Annually: Generate each ARN’s DDQ, download the PDF, retain it, and submit it as required. Do the same for Form A1 once signed.
Before any audit or data request: Open MF AUM Compliance and export the figures instead of compiling them manually.
Monthly: Work through the two Missing Folio Details sub-tabs and clear the gaps first on your largest clients, starting with bank account and nominee mismatches.
Whenever a dispute arises: Search the Investor Log first to establish the sequence of events.
For a broader look at how automation reduces this kind of manual work across the business, see our complete guide to automating your MFD business, and our overview of back-office software for mutual fund distributors.
What This Means for Your Practice
A compliance report does not replace professional judgement or your obligations under the applicable regulations. What it does is give you clean, current, ARN-wise records so that the people responsible for compliance spend their time reviewing and fixing, not collecting and typing. It also makes your practice easier to scale: adding clients or ARNs does not multiply the paperwork in the same proportion.
Explore how the Compliance Report fits with CRM, reporting, order placement and the rest of the stack on the Wylth® platform page, or read our overview of wealth management software for MFDs, IFAs and RIAs in India.
Frequently Asked Questions
What is a compliance report for mutual fund distributors?
It is a consolidated set of reports that helps distributors prepare regulatory and AMC documentation, answer audit data requests, find incomplete client records and review investor activity. In Wylth®, it has four tabs: Business Compliance, MF AUM Compliance, Missing Folio Details and Investor Log.
How does the DDQ work in Wylth®?
Choose the financial year and click Generate DDQ. The questionnaire is pre-filled ARN-wise from the data in the system, you can save it as a draft and continue later, and you can upload the final PDF (max 5 MB) into the Historic DDQ forms table for record maintenance before submitting it to the AMC or portal.
What is Form A1 (Annual Declaration, DSC) and how do I use it in Wylth®?
Form A1 is the annual declaration form that applies to a non-individual ARN holder with sub-brokers. In Wylth® you click Generate & download Form A1, print and sign it, upload the signed PDF to the submission history, and submit it as required. The card also shows the due date and links to the AMFI-CAMS SD-Enquiry page to check the receipt.
What data does the MF AUM Compliance tab provide?
Select an ARN and financial year and it generates an AUM Report (Equity, Debt, Liquid and Others for individual and non-individual investors, with active folios, number of investors and active SIP folios), a Portfolio Turnover Ratio report and a Redemption Report showing redemptions with exit load. Each can be downloaded to Excel.
How does the Missing Folio Details report help my operations team?
It lists folios with missing details such as date of birth, bank account, mobile number, email and nominee. It also flags clients whose details differ across their own folios, such as bank account, IFSC, email, mobile or nominee.
What can I see in the Investor Log?
You can search any investor and see recent activity such as mutual fund orders, fixed deposit investments, username or password changes, risk profile updates, and UCC creation or updates through BSE, NSE or MFU.
Ready to move your compliance records out of spreadsheets and into one system? Visit www.wylth.com or write to contact@wylth.com to see the Wylth® Compliance Report in action.
Wylth® — Your Wealth, Our Priority.
