Below are points on what should be on the report and how it is work.
It only prints customers with ineligible balances, if customers do not have any balances in above 61 days column, those customers’ would not appear on this report. So it’s possible and likely that the ineligible total balance would be higher than the eligible balance.
When the ineligible balance is greater than 80% of the TOTAL overall balance, it falls under the "Over 20%" rule and the entire TOTAL balance becomes the Ineligible balance.
The ineligible report is used to provide the bank with good A/R numbers for financing purposes, so they can consider "Eligible" A/R when extending credit.
There is a list of accounts that can and will be skip found in TCL (CT MASTER OTHER.INELIG.ACCTS). These accounts will never appear on the ineligible report.
Customers with a total ineligible balance <= 0 are skipped.
Each invoice is analyzed individually, if the Invoice date is 120 days older than the aging date, or if the Due date is 60 days older than the aging date, the invoice is included in the group that makes up the ineligible report. This can produce "partial balances" as all invoices will not be included necessarily for the customer.
