Generate Interest Invoice

Generate Interest Invoice - User Guide

---

⚡ Quick Start: 3-Minute Interest Billing

1. Navigate: Go to Sales > Generate Interest Invoice.
2. Review Period: Set the From Date and To Date for calculating the interest.
3. Set Date: Choose the Invoice Date for the new interest bills.
4. Rate: Verify the system-calculated interest Rate (e.g., 21% per annum).
5. Print & Generate: Click Print to download a detailed report and generate invoices for all defaults.

---

🗺️ Interest Billing Process

graph TD
    Start[Set Calculation Range] --> Analyze[Scan All Member Outstanding]
    Analyze --> Filter[Exclude Non-Defaulters]
    Filter --> Calc[Apply Interest Rate @21%]
    Calc --> GST[Map to Interest Service Group]
    GST --> Save[Generate S1 Invoice]
    Save --> Lock[Update System generated Status]
    
    style Calc fill:#f9f5ff,stroke:#6941c6
    style Lock fill:#fef3f2,stroke:#f04438

---

✅ Prerequisites Checklist

• Service Group Link: A specific “Interest” service group must be configured with an active Tariff Code.
• Lock Check: Ensure no Multiple Invoice job is currently running.
• Financial Year: Calculation dates must be within the active financial year’s range.

---

1. Introduction 📝

The Generate Interest Invoice module performs complex calculations on members’ defaulted balances. It identifies which invoices were not paid within their due dates and applies a defined interest rate on the principal outstanding amount.

---

2. Key Features ✨

🚫 Interest-on-Interest Prevention

The system is designed with financial integrity in mind. During calculation, it:

• Separates the Interest Outstanding from the Principal Outstanding.
• Only bills interest on the Chargeable Principal amount.
• This prevents unfair compounding of interests which may not be permitted in some society bylaws.

🏠 Member Cleanup

The generation process includes an automated Account Reconciliation step:

• If a member has a zero total outstanding but still has “DUE” interest invoices from the past, the system automatically marks them as RECD (Received) to clean up the member’s ledger.

---

3. Validations & Error Handling ⚠️

Validation Type	Logic	Action
Concurrency Lock	If InterestInvoicesGeneratedUpto status is ‘Y’.	Blocks new generation with a “Please wait” alert.
Service Group Map	If no service group of type ‘I’ (Interest) exists.	“Interest Service Group needs to be selected”.
Date Sequence	Cannot calculate interest for a period already generated.	System checks the sysparameters for the last run date.
Zero Interest	If a member owes less than the minimum interest threshold.	Does not generate an invoice for that member.

---

4. Interface Walkthrough 🔄

---

5. Reports & Outputs 📊

1. Interest Generation Report (Excel): A detailed spreadsheet showing:
   • Member ID & Name (with Wing/Flat details).
   • Original Outstanding.
   • Previous Interest Due.
   • Current Interest Calculated.
2. 📄 Interest Invoice: A formal GST invoice with a custom note (e.g., “Interest @21% on [Chargeable Amount]”).

---

6. Security & Deletion 🔍