Receivable / Payables (AR/AP) & Aging Report

Receivable / Payables (AR/AP) & Aging Report

Receivable / Payables & Aging - User Guide

1. Introduction 📊💰

Cash flow is the lifeblood of manufacturing operations. The Receivable / Payables (AR/AP) Report is the primary tool for credit controllers, sales teams, and treasury managers. It provides a multi-dimensional analysis of open debts, tracking how long funds have been outstanding, calculating interest penalties for overdue payments, projecting future cash inflows, and generating customer statement emails.

â„šī¸

Purpose of this Report:

  • Debt Recovery: Pinpoint exactly which customer invoices or supplier bills are overdue and calculate overdue days.
  • Aging Buckets: Automatically bucket debt into 0–30, 31–60, 61–90, 91–180, 181–360, and >360 days.
  • Interest & Penalties: Calculate financial loss and commercial interest penalties on overdue bills.
  • Cash Flow Forecasting: Project receivables maturing over the next 7, 14, 21, or 28 days.
  • Direct Party Statements: Send aged statements directly to authorized client contacts via email.

This report is essential for Credit Controllers, Accounts Receivable/Payable Accountants, and Finance Managers.


2. Report Types & Analysis Modules 🚀

The option screen supports 6 specialized report types:

A. Summary Report (ReportType = "A")

  • The 0–360 Aging View: Consolidates all open bills into standard aging buckets (Not Due, 0–30, 31–60, 61–90, 91–180, 181–360, and Above 360 Days).
  • Show Only Matched Option: Allows filtering to show only fully matched and settled invoices (available strictly when a single party is selected).
  • Output: Downloads as {Receivable/Payable}_Summary_Report.xlsx.

B. Interest on Overdue OS (ReportType = "B")

  • Penalty Calculation: Enter a contractual annual interest rate (between 1% and 25%) and an optional Grace Period (in days).
  • Opportunity Cost: Computes the exact monetary penalty accrued on delayed settlements.
  • Output: Downloads as {Receivable/Payable}_Interest_On_OverDue_OS_Report.xlsx.

C. Late Receipt Report (ReportType = "C")

  • Post-Payment Delay Audit: Analyzes receipts that were collected after their invoice due date.
  • Output: Downloads as {Receivable/Payable}_Late_Receipt_Report.xlsx.

D. Partywise Receipts / Payments (ReportType = "D")

  • Chronological Statement: A unified, statement-of-account view displaying all receipts or payments associated with the party without requiring control account filters.
  • Output: Downloads as {Receivable/Payable}_Partywise_Report.xlsx.

E. PO Details Report (ReportType = "E")

  • (Available for Receivables only)
  • Order Traceability: Reconciles open customer receivables against their original Purchase Order (PO) references and delivery dates.
  • Output: Downloads as Receivable_PO_Details_Report.xlsx.

F. Due Date Wise Report (ReportType = "F")

  • Cash Flow Projection: Segregates receivables and payables based on upcoming payment due dates, allowing treasury managers to plan supplier payouts against projected customer collections.
  • Output: Downloads as {Receivable/Payable}_Due_Date_Wise_Report.xlsx.

3. Filters & Aging Calculation Controls đŸ› ī¸

  • ArAp Type: Choose Receivable (R) or Payable (P).
  • Account Type: Filter by specific Control Accounts (e.g., Sundry Debtors Local, Sundry Debtors Export).
  • Report By: Run for All Parties (0), by Party Group (1), by a specific Party (2), or by Sales Officer (3) (Sales Officer filter is available for Receivables).
  • Scan Documents Based On:
    • Ref Date: Evaluates transactions according to the original invoice or bill date.
    • Doc Date: Evaluates transactions according to the ERP document posting date.
  • Compute Aging Based On:
    • Ref Date: Computes age from the date the invoice was raised.
    • Due Date: Computes age from the day the contractual credit period expired.
  • Show Only Due: Toggle "Yes" to exclude active invoices whose credit period has not yet elapsed.

4. Single-Party Email Statement Feature 📧

The system includes a secure email engine to dispatch aged statements directly to client accounts:

Operational Constraints & Pre-requisites

  1. Single Party Only: Statements can be emailed to one selected party at a time (bulk multi-party blasting is intentionally restricted to prevent accidental spam or cross-party confidentiality leaks).
  2. Summary Mode Only: Emailing is enabled exclusively when the report type is set to Summary (A) and the ArAp Type is Receivable (R).
  3. Contact Master Setup: The party must have an active contact record in Contact Master for their first branch (001) with:
    • A valid email address.
    • The Type of Contact set to Receivables or Multiple.
  4. Standard Instructions Template: A pre-configured email template must exist in Standard Instructions Master under the type for Receivable Email.

5. Validations and Business Rules âš ī¸

  • Date Window: To Date cannot be in the future (except for Due Date Wise Report F which projects future dates). From Date cannot precede the active financial year for Late Receipt and Partywise reports.
  • Interest Rate Range: When running the Interest on Overdue report, the interest rate must strictly be between 1% and 25%.
  • Show Only Matched Rule: Can only be enabled when a single party is selected in the filter.
  • Single-Party Email Gate: Attempting to click Email without selecting an individual party will halt with a validation error.

6. Best Practices / Tips 💡

  • Sales Officer Accountability: Run the receivable summary filtered by Sales Officer prior to monthly review meetings to evaluate the cash collection efficiency of individual sales personnel.
  • Due Date Aging for Credit Control: Always select Compute Aging Based On: Due Date when conducting customer follow-ups so you only pursue accounts that have genuinely breached their authorized credit period.
  • Grace Period Realism: Set a Grace Period of 2–3 days in the interest calculation to accommodate interbank NEFT/RTGS clearance delays.