Dues From Member Report
Dues From Member Report (Outstandings) - User Guide
1. Introduction 📊
The Dues From Member Report is a critical financial monitoring tool. It provides a centralized view of all unpaid maintenance, interest, and other society charges across the entire membership. It is the primary document used to identify and manage “Defaulters.”
ℹ️
Purpose of this Report:
- Liquidity Assessment: Understand exactly how much money is currently owed to the society.
- Defaulter Management: Rank members by their outstanding balance to prioritize recovery follow-ups.
- Accounting Accuracy: Reconcile member-wise outstandings against the global “Sundry Debtors” balance in the Balance Sheet.
- Historical Tracking: Monitor the growth or reduction of arrears over a specific financial period.
2. Analysis Use Cases 🚀
A. Defaulter List Preparation
- Process: Accountants typically generate this report at the start of every month.
- Result: A list of members with high arrears that is then presented to the Managing Committee for action (e.g., sending legal notices or stopping services).
B. Audit Support
- Process: Provide this report to the society auditor as the “Outstanding Member Schedule.”
- Result: Validates the “Receivables” item on the Balance Sheet.
C. Penalty Verification
- Process: Use the splitting of “Principal” and “Interest” in the report to ensure late payment penalties are being calculated correctly as per society bylaws.
3. Data Visibility & Insights 🔍
The report provides a column-by-column breakdown of the society’s receivables:
| Data Category | Key Fields Visible |
|---|---|
| Member Identity | Member Name, Flat Number, Building/Wing. |
| Financial Split | Arrears (Principal), Arrears (Interest), Total Arrears. |
| Current Performance | Current Month Bill, Interest on Current Bill. |
| Grand Totals | Final Closing Balance (Total Net Due). |
4. Source Transactions 🔄
The “Total Due” is a running balance derived from:
- Opening Outstandings: Initial balances from system migration.
- 📅 Monthly Invoices: Increases the “Principal” due.
- 📉 Interest Calculations: Increases the “Interest” due.
- 🧾 Voucher Receipts: Decreases the dues (typically follows FIFO logic for clearing old arrears first).
5. Using the Report Interface 🛠️
Selection Filters
- From Date: The start of the financial year (system-calculated).
- To Date: The “Cut-off” date for the report. Note: Usually set to ‘Today’ for real-time reporting.
Generation Mode
- Print (Excel): Generates a high-fidelity Excel file. The Excel format is preferred as it allows the Managing Committee to “Sort” members from highest-to-lowest dues instantly.
6. Best Practices / Tips 💡
- Sort by Net Due: In the Excel version, use the ‘Sort’ feature on the Final Balance column to identify the Top 10 Defaulters for immediate action.
- Monitor the Interest Ratio: If a member’s “Arrears Interest” is significantly higher than their Principal, it indicates a long-term defaulter who may require legal intervention (Section 101 proceedings).
- Verify Receipts: Before running the Dues report, ensure that all Daily Collection Reports for the month have been finalized and receipts posted.
- Monthly Publication: Many societies find it effective to publish a summarized version of this report on the notice board to encourage timely payment.