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:

  1. Records new Investment Certificates (Inception).
  2. Monitors Live vs. Matured portfolios in real time.
  3. 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:

  1. Investment Banks: Defines the financial institutions where funds are placed (e.g., State Bank of India, HDFC Bank).
  2. Investor Names: Identifies the investing entity or trust (e.g., Parent Company, Sister Entity, or Gratuity Trust).
  3. 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 Date is 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 Date must always be strictly later than the Start Date.
  • Status Integrity: An investment maintains an active Live status 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.