Investment Management - User Guide

ℹ️

📈 Business Impact

The Investment Management module is critical for the long-term sustainability of your society. By tracking Corpus Funds, Fixed Deposits (FDs), and Shares in one place, you ensure that every rupee of interest is accounted for and that maturity dates are never missed.

⚡ Quick Start: 3-Minute Entry

Masters:
- Navigate to Finance > Invest Name Master and add the Investor name (e.g., General Fund, Sinking Fund).
- Go to Finance > Invest Bank Master and add the Bank name.
Create Investment:
- Go to Finance > Investment.
- Enter the Invest No (e.g., FD Number).
- Set the Start Date, End Date, Principal Amount, and ROI (Rate of Interest).
Save: Click Save. The investment is now listed in the Live Investments register.

🗺️ Investment Lifecycle

graph LR
    Master[Masters: Bank/Type] --> Live[Record Live Investment]
    Live --> Mature[Monitor Maturity Alerts]
    Mature --> Renew[Renew Investment]
    Renew --> NewLive[Link Renewal No]
    
    style Master fill:#fefce8,stroke:#eab308
    style Live fill:#f0fdf4,stroke:#16a34a
    style Mature fill:#fef2f2,stroke:#ef4444

✅ Prerequisites Checklist

Bank Master: Add any bank where the society holds investments.
Invest Code Master: Define the type of investment (e.g., FD-Fixed Deposit, SA-Savings Account, EQ-Equity).
Investment Certificate: Keep your FD certificates ready for principal and maturity amount data.

1. Introduction 📝

Societies often have significant corpus funds that are invested to earn interest. Core Features:

Maturity Tracking: Automatic calculation of maturity amounts based on the principal and ROI.
Status Management: View all Live vs Matured vs Renewed investments at a glance.
Duplicate Control: Prevents entering the same FD Number twice for the same bank.

Note: Investment amounts are separate from your regular bank balance until they are encashed and recorded via a Receipt Voucher.

2. Advanced Features 🛠️

🔄 Renewal Workflow

When an FD matures, you can use the Investment Renew feature:

The system creates a linked new investment with the matured amount as the principal.
The original investment is marked as “Matured”, preserving its history for audit audits.
This creates a direct “paper trail” from the very first investment to its latest renewal.

📅 Automatic Maturity Alerts

The system uses the ROI (Rate of Interest) and End Date to calculate:

The Expected Maturity Amount.
The total holding period in days.
The status will automatically flag as “Mature” once the system date exceeds the End Date.

📥 Bulk Portfolio Upload

For societies with hundreds of individual FDs, use the Excel Import utility:

Download Model: Get the standard .xlsx template.
Fill Column Headers: Principal, ROI, Start/End dates.
Validate: Errors (Z1-Z6) flag incorrect bank codes or non-numeric ROI formats.
Confirm: Uploaded data is instantly cross-referenced against your masters.

3. Reports & Audits 📊

📄 Live Register: A consolidated list of all active society capital.
📄 Investment Certificate Report: A printable report detailing every investment’s specifics for society files.
📊 Excel Export: A summary report that displays principal totals for easy year-end accounting.

4. Validations & Rules ⚖️

Validation	Rule
Date Paradox	End date cannot be before the Start Date.
ROI Limit	Interest rates must be between 0.01% and 99.99%.
Principal Format	Principal amount must be a positive number up to ₹9,99,99,99,999.
Delete Control	Investments cannot be deleted if they are linked to renewals or payments.

5. Tips for Success 💡

ℹ️

Use Notes: Record the specific purpose of the fund (e.g., “Corpus for New Elevator”) in the Notes field.
Investor Names: Keep your Investor Names aligned with your society’s bye-laws (e.g., Sinking Fund, Repairs & Maintenance Fund).
Monitor Dates: Regularly check the Investment Index for any matured FDs that need to be renewed to avoid interest loss.

Transfer of Fund Bank Reconciliation Statement (BRS)