Troubleshooting: “No Collection Efficiency Count”

Scenario

1. The application to the invoice has already been completed.

2. See instructions here on how to allocate Advance/Accrued payments

3. On the AR Aging report, the account with an advance payment has no collection efficiency tagging

Parameters

1. Payment Transaction: Advance/Accrued payment, credit memo, billable payment (e.g., October 2025)

2. Invoice Transaction: Due for the month (e.g., December 2025)

Transaction Checking

1.  Access the Payment Transactions

• Go to Manage Payments → Billable Payments

• On the search bar, enter the account number of the account that has an issue with collection efficiency tagging

2. Review Payment List

   • Payment transactions of the account are displayed.

3.  Open the Relevant Payment Transaction

   • Select the latest payment (e.g., October 2025).

4. Check Application History

   • Scroll to the bottom of the transaction

   • Click the Application History tab.

Application History Results

1. If Application History Shows Entries

   • This confirms the invoice is already allocated:

   • Review Allocation Details

     • • Invoice No. and Bill Date—the reference number and bill date (usually the covered period) of the invoice that has been allocated

       • Type and Invoice Description - Item type and short description (usually the covered period) of the invoice

       • Application Date—Date when the payment was allocated to the invoice

       • Invoice Amount—Original invoice amount

       • Amount Paid - Amount applied during allocation

       • Withholding Amount—the taxable amount that was deducted from the payment 

         • • Auto creation of a credit memo will be generated

       • SC/PWD Amount—the SC/PWD amount that was deducted from the payment 

         • • Auto creation of a credit memo will be generated

       • VAT Reversal SC/PWD Amount—the SC/PWD amount that was reversed 

         • • Auto creation of a credit memo will be generated

       • Application Status—Allocation status

1. • Proceed to AR Aging Report – Payment Status Checking.

2. If Application History Shows No Records

   • This confirms the invoice has no allocation

   • No collection efficiency count tagging on the AR Aging Report

AR Aging Report – Payment Status Checking

1. Current Payment Tagging:

   • The month of the payment application date is the same as the month of the invoice bill date. 

     • • Payment Application Date : December 11, 2025

       • Invoice Bill Date: December 1, 2025

       • Payment Status: Current

       • Collection Efficiency Count: 1

2. Arrears Payment Tagging:

   • The month of the payment application date is at least one month later than the invoice bill date. 

     • • Payment Application Date: December 11, 2025

       • Invoice Bill Date: November 1, 2025

       • Payment Status: Arrears

       • Collection Efficiency Count: 1

3. Advance Payment Tagging:

   • No payment application exists for the current month, December 2025

Example 1:

3. • • • Payment Application Date: November 11, 2025 (latest application)

       • Invoice Bill Date: November 1, 2025

       • Payment Status: Advance

       • Collection Efficiency Count: 0

Example 2:

3. • • • Payment Application Date: December 11, 2025 (latest application)

       • December 2025 Invoice : Not yet generated

       • Payment Status: Advance

       • Collection Efficiency Count: 0

3. • The latest application was in a previous period with no succeeding applications.

     • • Payment Application Date: December 11, 2025  (latest application)

       • Invoice Bill Date: No pending invoice to allocate

       • Payment Status: Advance

       • Collection Efficiency Count: 0