Investment Management
Investment Module - User Guide
1. Introduction đ
The Investment module is a dedicated registry for managing the company’s financial assets, primarily Fixed Deposits (FDs), Bonds, Mutual Funds, and other term-based investments. It provides a structured workflow to track principal deployed, rates of interest (ROI), and maturity dates, ensuring the finance and treasury team never misses a renewal or redemption window.
âšī¸
In the overall business flow:
- Records new Investment Certificates (Inception).
- Monitors Live vs. Matured portfolios in real time.
- Facilitates one-click Renewals to preserve financial continuity and audit history.
Typically, this module is used by Treasury Managers, Finance Directors, and Compliance Officers.
2. Getting Started with Investment đ
Accessing the Module
Navigate to Finance > Transactions > Investments. The workspace is organized into two primary tabs:
- Live Investments: Active certificates currently earning interest.
- Matured Investments: Certificates that have reached their maturity date and require action (Rollover/Renewal or Bank Redemption).
Core Classification Setup
To register investments, three quick master categorizations are utilized:
- Investment Banks: Defines the financial institutions where funds are placed (e.g., State Bank of India, HDFC Bank).
- Investor Names: Identifies the investing entity or trust (e.g., Parent Company, Sister Entity, or Gratuity Trust).
- Investment Types: Categorizes instrument types (e.g., Fixed Deposit, Term Deposit, Bond, Mutual Fund).
3. Features & Benefits â¨
đ Lifecycle & Yield Tracking
- Maturity Monitoring: Automatically shifts records from “Live” to “Matured” tabs once the
End Dateis reached. - ROI Tracking: Logs the contracted annual interest rate for yield comparisons across different banking partners.
- Maturity Value Tracking: Computes expected proceeds (Principal + Interest) to assist cash flow planning.
đ Renewal Workflow
- Seamless Rollover: When an FD matures, use the Renew action to roll it over into a fresh investment certificate. The system assigns a new sequential investment number while maintaining a permanent link to the originating certificate.
đ Reporting & Analysis
- Consolidated Excel Export: Generates an audit workbook containing both Live and Matured tabs with comprehensive financial breakdowns.
4. Complete Flow đ
Step 1: Record New Investment
- Click Create New. System auto-assigns the sequential Invest No.
- Select the Investor Entity, Bank, and Investment Category.
- Input the certificate number under FD No / Details and enter the Principal Amount.
Step 2: Define Dates & Financial Terms
- Set the Start Date and End Date (maturity date).
- Input the contracted ROI (%) and expected Maturity Amount.
- Add relevant operational Notes (e.g., “Lien marked for Bank Guarantee”).
Step 3: Maturity & Renewal
- Monitor the Matured tab regularly.
- To renew, click Renew on the matured row, update the new interest rate and tenure, and save.
5. Validations and Business Rules â ī¸
Integrity Checks & Limits
- Duplicate Certificate Prevention: The system strictly prevents creating two “Live” investments with identical FD Numbers.
- Master Safeguards: Master categories (Banks, Investor Names, Types) are capped at 999 entries for high-speed indexing.
- Deletion Protection: You cannot delete a Bank, Investor Name, or Investment Type if it is currently linked to any active investment record.
Date & Financial Logic
- Chronology Rule: The
End Datemust always be strictly later than theStart Date. - Status Integrity: An investment maintains an active
Livestatus until its maturity date arrives or it is renewed/closed.
6. Related Reports đ
- đš Live Investment Register: Audit list of all capital currently deployed across financial institutions.
- â Matured Investment Schedule: Actionable schedule of instruments pending redemption or reinvestment.
7. Best Practices / Tips đĄ
- Lien Documentation: Always specify in the Notes field if an FD is pledged with a bank as collateral for Letters of Credit (LC) or Bank Guarantees (BG).
- Entity Separation: Use Investor Names to distinguish between parent company funds and subsidiary/trust investments.