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
- 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).
- Summary Mode Only: Emailing is enabled exclusively when the report type is set to Summary (
A) and the ArAp Type is Receivable (R). - 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
ReceivablesorMultiple.
- 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 Datecannot be in the future (except for Due Date Wise ReportFwhich projects future dates).From Datecannot 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.