Open-MFD CRM User Guide

Welcome to the Open-MFD CRM. This tool is designed to help Mutual Fund Distributors (MFDs) manage their clients, track investments, and integrate with MFU (Mutual Fund Utilities) seamlessly.

🚀 Getting Started

The tool runs in your web browser. When you launch it, you will see a side navigation menu to switch between different sections.

📊 1. Dashboard

The Dashboard is your command center, now organized into two primary tabs for better clarity.

📊 Distributor Overview

This tab gives you an eagle-eye view of your entire business.

Key Metrics: View your Total AUM, Active Clients count, SIP Book, and Overdue Tasks count at a glance.
Tasks Overview: Manage all your actions in one place:
- ⚠️ Overdue Tasks: Lists tasks past their due date across all clients.
- 🕒 Current Tasks: Displays all 'Pending' and 'In Progress' tasks.
- Interactive Updates: You can update task statuses (e.g., from 'Pending' to 'Completed') directly from these tables. The associated client name is shown for each task.

👤 Client Overview

This tab is dedicated to deep-diving into individual client profiles.

Your Clients Table: A summary table listing your onboarded clients with their Name, PAN, Mobile Number, and Email ID. The table displays up to 5 clients at a time for better readability.
Client Selection: Select a client by clicking their name directly in the table, or use the searchable dropdown below the table for a detailed view.
Portfolio & Interaction Center:
- Portfolio & CANs: View metrics like Net Investment, Total Gain, XIRR, and detailed holdings.
  - Transaction Management: Click on any transaction row in the portfolio table to edit its details (e.g., date, amount, NAV) or delete it entirely.
  - CAN Selection / Management: Use the dropdown below the PAN to:
    - View the total aggregate portfolio ("ALL Folios").
    - Filter holdings by a specific CAN.
    - ➕ Add New CAN: Register a new CAN for the client directly from the dropdown.
    - ⚙️ Manage CANs: View and delete existing CANs.
- Notes: A dedicated space for meeting logs.
- Tasks: Create and track investor-specific actions. (Updates here are synced with the Distributor Overview).
- Documents: Manage client files.
- Deleting a Client Profile:
- To permanently remove a client, expand the "📝 Edit Client Profile" section.
- Scroll to the bottom to find the "⚠️ Dangerous Zone".
- Check the box "I understand that this action is permanent and irreversible".
- Click "🗑️ Delete Client Profile". This will delete all their CANs, folios, transactions, notes, tasks, and documents.

👤 2. Client Management

Use this section to onboard new clients. You can choose between Manual Entry for individual clients or Bulk Import for mass onboarding.

👤 Manual Entry

Onboard clients one-by-one by filling out the form:

Full Name *: Enter the name as it appears in records.
Phone Number *: Mobile or landline contact.
PAN: (Optional) 10-character Permanent Account Number.
Email: (Optional) Contact email address.
MFU CAN: (Optional) Common Account Number.
Submit: Click "Onboard Client" to save.

📁 Bulk Import

Mass onboard clients using Excel, CSV, or ODS files.

Download Template: Click "📥 Download Template Excel" to get a pre-formatted file with the correct headers.
Prepare Your Data:
- Name * and Phone * are mandatory for every row.
- Optional fields include PAN, Email, and MFU CAN.
Upload File: Drag and drop or browse for your file (supports .xlsx, .csv, .ods).
Preview & Process: Review the preview of the first few rows, then click "🚀 Process Bulk Import".
Review Results: The system will report how many clients were added and list any errors (e.g., missing data or duplicate PANs) found in specific rows.

* Required fields for onboarding.

📈 3. Investment Tracking

This section allows you to record physical or digital transactions.

Select Client: Choose from the list of onboarded clients.
Folio Management:
- Select an existing folio or click "Add New Folio".
- For new folios, provide the Folio Number and the AMC Name (e.g., SBI Mutual Fund).
Record Transaction:
- Scheme: Select the mutual fund scheme.
- Transaction Type: Choose from PURCHASE, REDEMPTION, SIP, STP, SWP.
- Amount/NAV: Enter the transaction amount. The NAV is automatically fetched from AMFI based on the transaction date and smartly updated, but you can override it if needed.
- Submit: Click "Submit Transaction" to update the portfolio.

📈 4. Scheme Management

This dedicated section helps you manage mutual fund schemes efficiently: - Smart NAV Updates: Automatically fetche the latest NAVs directly from AMFI, avoiding redundant calls. - Edit/Delete Schemes: Directly modify or remove existing schemes from your database. - RTA Code Mapping: Mutual fund schemes now store RTA codes to facilitate automated transaction imports from MFU statements.

🔗 5. MFU Integration

This section is dedicated to connecting with MFU APIs. - Current Status: This feature is under development. Once active, it will allow you to pull client data and transactions directly from MFU.

⚙️ 6. Settings

View your local database path.
Reset Database: (Warning) This will delete all clients and transactions.

🛠️ 7. Advanced Configuration & Portable Build

Environment Variables (.env)

You can customize the application behavior using the .env file in the root directory:

DB_PATH: Specify a custom database file (e.g., DB_PATH=test_scalability.db).
MFU_API_KEY: Your credentials for future MFU integration.

Portable Distribution

To create a "no-install" version of the CRM for another computer:

Run python build_scripts/build_windows.py.
Find the generated ZIP file in the dist/ folder.
Extract and run Start_CRM.bat on any Windows PC.

👑 Project Leadership

This is an open-source project led by its BDFL (Benevolent Dictator For Life), @rmaries.

For support, contributions, or feature requests, please visit the GitHub repository.