The Outstanding Payment report generates a list of customers who currently have debits that consist of:
- Failed payment (a debit in which payment was unsuccessful, including failed rebills)
- Overdue or missed payment (a debit that was not billed due to an earlier failed payment or withdrawn authority by customer or invalid payment details such as wrong bank account number)
Details of debits that have been written off will not be listed in this report.
- At the site level, select Reports from the left navigation menu.
- In the Billing section of the Reports page, select Outstanding Payment.
- Select the Filter by preference for the report that you want to generate. By default, the report is filtered to display all customers with all types of membership status whose billing has stopped.
- If you wish to see a list of customers with an active membership status and outstanding payments in which rebill has been scheduled or billing still continues, make sure you select the correct options.
- Select Add (next to Filter by) to add more filtering options.
How to use the filter by, group by and sort by functions
- If you do not wish to group the data, select the Remove (trash bin) icon for Group by Customer's no.
The generated report is based on outstanding payment details as of the time it was generated. The report may consist of more than one page.
- Billing status can only be one of the following:
- Billing continues - Although the customer has at least one failed debit, billing will continue as usual.
- Billing stopped - The customer will no longer be billed until the outstanding payments are resolved. See: How do I recover a customer's outstanding payments?
- Rebill scheduled - A rebill was automatically scheduled for the failed debit (see the Payment Date column for the rebill date). Billing will continue as usual.
- Failed debit date is the date that particular debit has failed for the first time. This column will only have a value if the failed debit has a rebill scheduled. Else, it will be left blank as the payment date equals to the failed debit date.
- Payment date is the date of the failed or overdue payment.
- Payment status can only be one of the following:
- Failed - This status indicates that iconnect360 has failed to collect payment for the debit.
- Pending rebill - This status indicates that a rebill has been scheduled for the failed debit but it has not taken place yet.
- Rebill failed - This status indicates that iconnect360 has failed to collect payment for the rebill debit.
- Overdue - This status indicates that iconnect360 did not attempt to collect payment for the debit because billing has stopped due to outstanding payments.
- Failure reason - The reason the debit has failed.
- Payment amount - The amount the customer owes your organisation which includes regular payment and additional payment (excludes Ezypay fees).
- Ezypay fees - The amount the customer owes Ezypay which may include the customer paid transaction fee, load/setup fee and failed payment fee. Any Ezypay fees that are still outstanding after 90 days will automatically be reallocated to your organisation.
- Total outstanding - The sum total of the Payment amount and Ezypay fees. This is the total amount reflected in the debit.