Opening Outstanding Master

Opening Outstanding Master

Opening Outstanding (Dues & Payables) - User Guide

ℹ️

📈 Business Impact

The Opening Outstanding module is the bridge between your old system and the new one. Accurately migrating these balances ensures that members are billed for their rightful arrears and vendors are paid their correct dues, maintaining financial trust and eliminating reconciliation disputes.


âš¡ Quick Start: Migrating Arrears

  1. Access: Navigate to System Tools > Opg Os Index.
  2. Type: Choose between Member (for maintenance arrears) or Vendor (for pending bills).
  3. Entry: Select the Member/Vendor, enter the Principal Amount and Interest Amount (if applicable).
  4. Dr/Cr:
    • Dr: For money owed to the society (Members).
    • Cr: For money the society owes others (Vendors).

🗺️ Migration Workflow

graph LR
    Manual[Previous Outstandings] --> OpgOs[Opening Outstanding Entry]
    OpgOs --> Ledger[Member/Vendor Ledgers]
    Ledger --> Inv[New Invoices with Arrears]
    Ledger --> Pmt[Payments to Vendors]
    
    style OpgOs fill:#f9f,stroke:#333,stroke-width:2px

1. Introduction 📝

The Opening Outstanding Master allows you to record “Historical Debt.” When you start using ERP Crystal, members might already owe months of maintenance. This module lets you bring that specific amount forward so it appears on their first digital invoice.


2. Usage in Transactions 🔄

  • 📄 Invoices: Arrears entered here appear in the “Brought Forward” or “Arrears” section of the member’s bill.
  • 🧾 Voucher Receipts: Any payment made by a member is first adjusted against these opening outstandings.
  • 💳 Vendor Payments: Ensures you don’t overpay a contractor by including their opening credit balance in payment calculations.

3. Related Reports 📊

  1. 🏛️ Arrears Register: A list of all members and their migrated outstanding balances.
  2. 📋 Outstanding Dues Report: Combines these opening balances with new invoices to show a “Total Due” position.
  3. 📉 Payable Report: Shows migrated vendor dues as the oldest aging bucket.

4. Key Fields Highlights 🔍

  • Account Name: Choose a specific Member or Vendor.
  • Principal vs Interest: Separating these is vital for societies that calculate “Interest on Interest” (compound) vs simple interest.
  • Dated: The date of migration (e.g., April 1st).

5. Validations and Error Handling ⚠️

Validation Type What is checked? Error Message / Action
Balance Overwrite If trying to enter a second opening balance for the same person. System prevents double entry to ensure Trial Balance consistency.
Active Member If the member is marked “Inactive” in the master. They will not appear in the Opg Os selection list.

6. Best Practices / Tips 💡

ℹ️
  • Use the Import Tool: Migrating 500 members manually is tedious. Use the Opg Os Import tool to upload your arrears from a CSV file.
  • Double Check Arrears: Once imported, send a “Balance Confirmation” or small draft statement to members to ensure they agree with the migrated figures.
  • Set Interest Separately: For proper tax and interest calculation logic, always keep the migrated principal and interest in their respective fields.
  • Single Point Entry: Do not enter opening balances via Journal Vouchers if you want them to appear correctly in the member-wise “Arrears” section of the invoice; use this Opg Os module instead.