Export Client and Investment Data to Excel

--- 
+++ 
@@ -1,141 +1,156 @@
 ```
 
-### Section 1: Overview
+## Overview
 
-The Excel Export feature allows you to download client data, investment portfolios, and transaction details as formatted Excel files for analysis, reporting, and record-keeping. This feature transforms your platform data into professional spreadsheets that you can share with clients, use for presentations, or analyze offline.
+The Excel Export feature allows financial advisors to download comprehensive reports of client data and investment information in Excel format for offline analysis, client presentations, and regulatory compliance. The system generates formatted spreadsheets with proper styling and headers that can be easily shared with clients or used for detailed portfolio analysis.
 
-**Key capabilities:**
-• Generate SIP (Systematic Investment Plan) reports with investor details and payment schedules
-• Export portfolio summaries showing current investments, valuations, and performance metrics
-• Create transaction history reports with complete investment and withdrawal records
-• Download capital gains reports for tax planning and compliance
-• Export comprehensive client lists with contact information and portfolio status
-• Generate AUM reconciliation reports to verify asset under management balances
+• Export SIP (Systematic Investment Plan) details with investor names, scheme information, and frequency
+• Generate mutual fund portfolio summaries with current values and performance metrics
+• Create detailed transaction reports showing investment flows and withdrawals
+• Export capital gains analysis for tax planning and reporting purposes
+• Download complete client lists with contact information and portfolio details
+• Generate AUM (Assets Under Management) reconciliation reports for audit purposes
 
-### Section 2: Prerequisites and Access
+## Prerequisites and Access
 
-You need an active IFANOW advisor account with portfolio management access. All advisor roles can export Excel reports for their assigned clients. Navigate to the specific section (Portfolio, Clients, or Reports) where you want to export data, then look for the "Export" or "Download" options in the action menu or toolbar.
+You need an active IFANOW advisor account with portfolio management access. Navigate to **Portfolio Management** > **Reports** > **Export Options** in the main dashboard to access the Excel export functionality.
 
-### Section 3: How-To Steps
+## How-To Steps
 
-## How to Export SIP Reports
+### How to Export SIP Details Report
 
-Generate detailed reports of all Systematic Investment Plans for your clients. Select the SIP data you want to include from your portfolio view, choose the export format, and download a formatted Excel file containing investor names, scheme details, folio numbers, payment dates, frequencies, and amounts.
+Generate a comprehensive report of all Systematic Investment Plans for your clients.
 
-1. Go to Portfolio > SIP Management
-2. Select the clients or specific SIPs you want to include in the report
-3. Click "Export" and choose "SIP Report"
-4. Configure the date range and data fields to include
-5. Click "Generate Excel Report"
+1. Go to **Portfolio Management** > **Reports** > **Export Options**
+2. Click **SIP Report** from the export menu
+3. Select the clients whose SIP details you want to include
+4. Choose the date range for the SIP data
+5. Click **Generate Excel Report**
+6. The system creates an Excel file with investor names, scheme names, folio numbers, start/end dates, and frequency details
+7. Download the file from the generated link that appears
+8. The file is automatically saved to secure cloud storage for future access
 
-The system creates a downloadable Excel file with separate columns for investor names, scheme names, folio numbers, start dates, end dates, and payment frequencies. The file is automatically saved to your downloads and available for immediate use.
+### How to Export Mutual Fund Summary Report
 
-## How to Export Portfolio Summary Reports
+Create a summary of all mutual fund investments showing current positions and values.
 
-Create comprehensive investment summaries showing current holdings and performance. This report includes scheme names, units held, current valuations, NAV details, and withdrawal history for each investment.
+1. Navigate to **Portfolio Management** > **Reports** > **Export Options**
+2. Select **Mutual Fund Summary** from the available reports
+3. Choose the specific mutual fund schemes or select "All Schemes"
+4. Set the reporting date for NAV calculations
+5. Click **Generate Summary Report**
+6. The Excel file includes scheme names, balance units, withdrawals, current NAV, and NAV dates
+7. Download the generated file from the provided secure link
+8. Use this report for client reviews and portfolio analysis
 
-1. Navigate to Portfolio > Holdings
-2. Select the client portfolios to include
-3. Click "Export" and select "Portfolio Summary"
-4. Choose the reporting date and valuation method
-5. Click "Download Summary Report"
+### How to Export Transaction Details Report
 
-Your Excel file will contain organized tabs with investment details, including balance units, withdrawal amounts, current NAV, and NAV dates. Each row represents one investment holding with complete financial details.
+Generate detailed transaction history for mutual fund investments and redemptions.
 
-## How to Export Transaction History Reports
+1. Access **Portfolio Management** > **Reports** > **Export Options**
+2. Click **Transaction Report** from the export menu
+3. Select the transaction date range you need
+4. Choose specific clients or schemes, or select all
+5. Click **Generate Transaction Report**
+6. The system creates an Excel file with sub-category names, amounts invested, current values, balance units, withdrawals, and NAV information
+7. Download the file from the secure link provided
+8. This report is ideal for tracking investment flows and client activity
 
-Download complete transaction records for investment activities. This includes all purchases, redemptions, switches, and dividends with amounts and dates.
+### How to Export Capital Gains Report
 
-1. Access Portfolio > Transactions
-2. Set your desired date range using the filter options
-3. Select specific clients or choose "All Clients"
-4. Click "Export Transactions"
-5. Select "Excel Format" and confirm download
+Create capital gains analysis for tax planning and compliance purposes.
 
-The resulting spreadsheet organizes transactions by subcategory with columns for invested amounts, current values, balance units, withdrawals, and NAV information.
+1. Go to **Portfolio Management** > **Reports** > **Export Options**
+2. Select **Capital Gains Report** from the available options
+3. Choose the financial year or custom date range
+4. Select the clients for whom you need capital gains data
+5. Click **Generate Capital Gains Report**
+6. The Excel file includes balance units, NAV values, and calculated gains/losses
+7. Download the generated report from the secure link
+8. Share this report with clients for tax filing purposes
 
-## How to Export Capital Gains Reports
+### How to Export Complete Client List
 
-Generate tax-ready capital gains reports showing realized and unrealized gains. Perfect for year-end tax planning and client advisory meetings.
+Download a comprehensive list of all your clients with their contact and portfolio information.
 
-1. Go to Reports > Tax Reports
-2. Select "Capital Gains" report type
-3. Choose the tax year or custom date range
-4. Select clients for the report
-5. Click "Export Capital Gains Excel"
+1. Navigate to **Portfolio Management** > **Clients** > **Export Client Data**
+2. Select **All Clients Report** from the export options
+3. Choose which client fields to include (contact info, portfolio summary, etc.)
+4. Set any filters for client status or tags
+5. Click **Generate Client List**
+6. The Excel file includes names, contact details, PAN numbers, family members count, client codes, tags, last visit dates, and status information
+7. Download the file from the generated secure link
+8. Use this for client relationship management and compliance reporting
 
-The Excel file contains balance units and NAV data needed for capital gains calculations, formatted for easy review and tax preparation.
+### How to Export AUM Reconciliation Report
 
-## How to Export All Clients List
+Generate AUM reconciliation reports for audit and compliance purposes.
 
-Create a master client database export with contact information, portfolio status, and relationship details.
+1. Access **Portfolio Management** > **Reports** > **AUM Reconciliation**
+2. Click **Export AUM Recon Report**
+3. Select the reconciliation date and period
+4. Choose specific schemes or clients for the analysis
+5. Click **Generate Reconciliation Report**
+6. The Excel file includes investor names, scheme details, folio numbers, scheme codes, and balance units
+7. Download the report from the provided secure link
+8. Use this for internal audits and regulatory compliance
 
-1. Navigate to Clients > Client Management
-2. Use filters to select specific client groups if needed
-3. Click "Export All Clients"
-4. Choose the data fields to include
-5. Confirm and download the Excel file
+## Rules and Limits
 
-Your export includes client names, email addresses, mobile numbers, PAN details, family member counts, client codes, tags, last visit dates, client owners, and account status.
+• Excel exports are only available for clients assigned to your advisor account
+• Reports can only include data from the current financial year and previous two years
+• Maximum of 10,000 records per export to ensure file performance
+• Files are automatically deleted from cloud storage after 30 days
+• Only one export can be generated per report type every 5 minutes to prevent system overload
+• All exported files are encrypted and require login credentials to access download links
+• Client data exports require additional security confirmation for sensitive information
+• SIP reports only include active and recently ended SIPs, not cancelled ones from over 1 year ago
+• Transaction reports exclude internal fund switches unless specifically requested
+• Capital gains calculations use FIFO method unless client has specified alternative method
 
-## How to Export AUM Reconciliation Reports
+## Common Questions
 
-Generate Asset Under Management reconciliation reports to verify portfolio balances and identify discrepancies.
+**Q: Can I customize which columns appear in my Excel exports?**
+A: Currently, the column structure is standardized for each report type to ensure consistency. However, you can filter which clients or schemes are included before generating the report.
 
-1. Access Reports > Reconciliation
-2. Select "AUM Reconciliation" report
-3. Choose the reconciliation date
-4. Select the portfolios to analyze
-5. Click "Generate AUM Excel Report"
+**Q: How long do the download links remain active?**
+A: Download links are active for 30 days from generation. After that, you'll need to generate a new report. The links are also tied to your login session for security.
 
-The report includes investor names, scheme names, scheme codes, folio numbers, and balance units for comprehensive AUM verification.
+**Q: Can I schedule automatic Excel exports to be generated monthly?**
+A: Automatic scheduling is not currently available. You need to manually generate each export when needed. However, you can bookmark the export pages for quick access.
 
-### Section 4: Rules and Limits
+**Q: Why don't I see some clients in my exported reports?**
+A: You can only export data for clients assigned to your advisor account. If clients are managed by other advisors or have restricted access, they won't appear in your exports.
 
-• Export functions only work when you have selected data - empty datasets will return a "no content" message
-• All Excel files are automatically stored in secure cloud storage for 30 days
-• File names are automatically generated with timestamps to prevent overwrites
-• Maximum 10,000 records per export to maintain file performance
-• Reports can only include clients you have permission to access
-• Date ranges cannot exceed 5 years for transaction reports
-• Capital gains exports require complete NAV data to generate accurate calculations
-• Client list exports exclude sensitive information based on your permission level
+**Q: Can I export data for clients who are no longer active?**
+A: Yes, inactive clients appear in exports but are clearly marked with their status. You can filter them out during the export process if needed.
 
-### Section 5: Common Questions
+## Troubleshooting
 
-**Q: Why is my export showing "no content found" when I have data on screen?**
-A: This happens when no records are actually selected for export. Make sure you've checked the boxes next to the records you want to include, or verify that your date filters aren't excluding all data.
+**Problem:** Export fails with "No content found" message
+**Cause:** The selected date range or client filter returns no matching records
+**Fix:** Expand your date range or remove client-specific filters to include more data in the export
 
-**Q: Can I customize which columns appear in my Excel reports?**
-A: Yes, most export screens allow you to select which data fields to include. Look for "Configure Fields" or "Select Columns" options before generating your report.
+**Problem:** Download link shows "File not found" error
+**Cause:** The file may have expired after 30 days or the generation process failed
+**Fix:** Generate a new export report and use the fresh download link immediately
 
-**Q: How long are my exported files available for download?**
-A: Excel files are stored securely for 30 days after creation. You can re-download them from your Reports history during this period.
+**Problem:** Excel file appears corrupted or won't open
+**Cause:** Download was interrupted or browser cached an incomplete file
+**Fix:** Clear your browser cache, ensure stable internet connection, and re-download the file completely
 
-**Q: Can I export data for clients that aren't directly assigned to me?**
-A: Only if you have appropriate permissions. The system will only include clients you have access to view and manage based on your role settings.
+**Problem:** Missing client data in exported reports
+**Cause:** You don't have access permissions for certain clients or they have data restrictions
+**Fix:** Verify your advisor permissions with your administrator and confirm which clients are assigned to your account
 
-**Q: Why don't my capital gains calculations match the exported raw data?**
-A: The Excel export provides the raw balance units and NAV data - you'll need to apply your own calculation formulas. The platform's calculated gains may use different rounding or timing methods than manual Excel calculations.
+**Problem:** Export process takes too long or times out
+**Cause:** Large data set or system performance issues during peak hours
+**Fix:** Reduce the date range, filter to fewer clients, or try generating the report during off-peak hours
 
-### Section 6: Troubleshooting
+**Problem:** Generated Excel file has formatting issues
+**Cause:** Excel version compatibility or special characters in client data
+**Fix:** Open the file in the latest version of Excel or LibreOffice, and check for any special characters in names or scheme titles
 
-**Problem:** Excel file download fails or shows error message
-**Cause:** Large dataset size or temporary server connectivity issue
-**Fix:** Reduce your date range or number of selected records, then try the export again. If the issue persists, wait 5 minutes and retry.
+## Related Features
 
-**Problem:** Exported Excel file contains incomplete or missing data
-**Cause:** Data filters are too restrictive or some records lack required information
-**Fix:** Adjust your selection criteria and date ranges. For missing client data, verify that all required fields are populated in the client profiles.
-
-**Problem:** Cannot open or view the downloaded Excel file
-**Cause:** File corruption during download or incompatible Excel version
-**Fix:** Try downloading the file again. Ensure you're using Microsoft Excel 2016 or newer, or try opening with Google Sheets as an alternative.
-
-**Problem:** AUM reconciliation report shows unexpected balance discrepancies
-**Cause:** Timing differences between report generation and latest NAV updates
-**Fix:** Verify that all portfolios have current NAV data and re-run the reconciliation with the most recent business date.
-
-### Section 7: Related Features
-
-This feature integrates with Portfolio Management for investment data, Client Management for contact information, and Transaction Processing for financial records. The exported Excel files can be used with the Client Communication tools for sharing reports and with the Tax Planning module for year-end analysis. AUM reconciliation exports support the Compliance Reporting requirements for regulatory submissions.
+This Excel Export feature integrates with several other IFANOW modules to provide comprehensive reporting capabilities. It depends on the Client Management system for client data and relationships, the Mutual Fund Portfolio module for investment details and performance calculations, and the SIP Management feature for systematic investment plan information. The exported data is also used by the Reporting Dashboard for visual analytics and connects to the Document Management system for client communication. For complete portfolio analysis, use this feature alongside the Performance Analytics module and Risk Assessment tools.