Financials - Collections Delinquencies (Preview)
These metrics are used in the Analytics Currency (AC), Ledger Currency (LC), and Document Currency (DC) fact folders in subject areas, where applicable. Analytics currency and exchange rate type are configured during product implementation. Exchange rate date basis uses the ledger currency conversion rate date where available; if not available, the transaction accounting date, adjustment apply date, receipt application accounting date, dispute date, or promise date is used based on the underlying transaction type. Metrics in these folders show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| Current Amount (AC) | Shows current (not-yet-due) amount, analytic currency. |
| Delinquent Amount (AC) | Shows delinquent (past-due) amount, analytic currency. |
| Outstanding Amount (AC) | Total outstanding amount (all open), analytic currency. |
| Disputed Amount (AC) | Shows disputed invoice amount, analytic currency. |
| Undisputed Delinquent Amount (AC) | Shows undisputed delinquent amount (past due minus disputed), analytic currency. |
| Effective Delinquent Amount (AC) | Shows effective delinquent amount = due remaining minus unapplied/on-account cash, analytic currency. |
| Current Amount (LC) | Shows current (not-yet-due) amount, ledger currency. |
| Delinquent Amount (LC) | Shows delinquent amount, ledger currency. |
| Outstanding Amount (LC) | Total outstanding amount, ledger currency. |
| Disputed Amount (LC) | Shows disputed amount, ledger currency. |
| Undisputed Delinquent Amount (LC) | Shows undisputed delinquent amount, ledger currency. |
| Effective Delinquent Amount (LC) | Shows effective delinquent amount net of cash, ledger currency. |
| Number of Delinquencies | Number of delinquencies per account. |
| Newly Delinquent Count | Shows count of newly delinquent records. |
| Delinquent Customer Account Count | Shows distinct count of delinquent customer accounts. |
| Aging Amount Line 1- Not Yet Due (AC) | Shows aging bucket amount: Not yet due (current). |
| Aging Amount Line 2 (AC) | Shows aging bucket amount: 1st past-due bucket. |
| Aging Amount Line 3 (AC) | Shows aging bucket amount: 2nd past-due bucket. |
| Aging Amount Line 4 (AC) | Shows aging bucket amount: 3rd past-due bucket. |
| Aging Amount Line 5 (AC) | Shows aging bucket amount: 4th past-due bucket. |
| Aging Amount Line 6 (AC) | Shows aging bucket amount: 5th past-due bucket. |
| Aging Amount Line 7 (AC) | Shows aging bucket amount: 6th past-due bucket. |
| Aging Bucket Current Distribution % (AC) | Shows current amount as % of total. |
| Aging Bucket 2 Distribution % (AC) | Shows aging bucket 2 as % of delinquent (past-due) amount. |
| Aging Bucket 3 Distribution % (AC) | Shows aging bucket 3 as % of delinquent (past-due) amount. |
| Aging Bucket 4 Distribution % (AC) | Shows aging bucket 4 as % of delinquent (past-due) amount. |
| Aging Bucket 5 Distribution % (AC) | Shows aging bucket 5 as % of delinquent (past-due) amount. |
| Aging Bucket 6 Distribution % (AC) | Shows aging bucket 6 as % of delinquent (past-due) amount. |
| Aging Bucket 7 Distribution % (AC) | Shows aging bucket 7 as % of delinquent (past-due) amount. |
| Aging Amount Line 1 - Not Yet Due (LC) | Shows aging bucket amount: Not yet due (current). |
| Aging Amount Line 2 (LC) | Shows aging bucket amount: 1st past-due bucket. |
| Aging Amount Line 3 (LC) | Shows aging bucket amount: 2nd past-due bucket. |
| Aging Amount Line 4 (LC) | Shows aging bucket amount: 3rd past-due bucket. |
| Aging Amount Line 5 (LC) | Shows aging bucket amount: 4th past-due bucket. |
| Aging Amount Line 6 (LC) | Shows aging bucket amount: 5th past-due bucket. |
| Aging Amount Line 7 (LC) | Shows aging bucket amount: 6th past-due bucket. |
| Aging Bucket Current Distribution % (LC) | Shows current amount as % of total. |
| Aging Bucket 2 Distribution % (LC) | Shows aging bucket 2 as % of delinquent (past-due) amount. |
| Aging Bucket 3 Distribution % (LC) | Shows aging bucket 3 as % of delinquent (past-due) amount. |
| Aging Bucket 4 Distribution % (LC) | Shows aging bucket 4 as % of delinquent (past-due) amount. |
| Aging Bucket 5 Distribution % (LC) | Shows aging bucket 5 as % of delinquent (past-due) amount. |
| Aging Bucket 6 Distribution % (LC) | Shows aging bucket 6 as % of delinquent (past-due) amount. |
| Aging Bucket 7 Distribution % (LC) | Shows aging bucket 7 as % of delinquent (past-due) amount. |
| Delinquency Rate % | Shows delinquency rate % (past-due / total). |
| Credit Limit Utilization % | Shows credit limit utilization % (note: credit-limit currency caveat). |
| Open Invoice Amount (AC) | Shows open Invoice amount, analytic currency. |
| Open Debit Memo Amount (AC) | Shows open Debit Memo amount, analytic currency. |
| Open Chargeback Amount (AC) | Shows open Chargeback amount, analytic currency. |
| Open Credit Memo Amount (AC) | Shows open Credit Memo amount, analytic currency. |
| Disputed Invoice Amount (AC) | Shows disputed Invoice amount, analytic currency. |
| Open Invoice Amount (LC) | Shows open Invoice amount, ledger currency. |
| Open Debit Memo Amount (LC) | Shows open Debit Memo amount, ledger currency. |
| Open Chargeback Amount (LC) | Shows open Chargeback amount, ledger currency. |
| Open Credit Memo Amount (LC) | Shows open Credit Memo amount, ledger currency. |
| Disputed Invoice Amount (LC) | Shows disputed Invoice amount, ledger currency. |
| Open Invoice Count | Shows open Invoice count. |
| Open Debit Memo Count | Shows open Debit Memo count. |
| Open Chargeback Count | Shows open Chargeback count. |
| Open Credit Memo Count | Shows open Credit Memo count. |
| Disputed Invoice Count | Shows disputed Invoice count. |
| Original Invoice Amount (AC) | Shows original Invoice Amount, analytic (reporting) currency. |
| Credited Amount (AC) | Shows credited Amount, analytic (reporting) currency. |
| Adjusted Amount (AC) | Shows adjusted Amount, analytic (reporting) currency. |
| Disputed Amount (AC) | Shows Disputed Amount in Analytics Currency |
| Applied Amount (AC) | Shows applied Amount, analytic (reporting) currency. |
| Predelinquent Amount (AC) | Shows predelinquent Amount, analytic (reporting) currency. |
| Delinquent Amount (AC) | Shows Amount Due Remaining in Analytics Currency for Delinquent transactions |
| Current Amount (AC) | Shows Amount Due Remaining in Analytics Currency for transactions that are not due yet |
| Undisputed Delinquent Amount (AC) | Shows the remaining delinquent balance in analytics currency after subtracting the delinquent amount currently under dispute. If there is no disputed delinquent amount, the metric returns 0. |
| Undisputed Overdue AR (AC) | Shows undisputed Overdue AR, analytic (reporting) currency. |
| Resolved Amount (AC) | Shows resolved Amount, analytic (reporting) currency. |
| Outstanding Amount (AC) | Shows Amount Due Remaining in Analytics Currency irrespective of whtether it is delinquent or not |
| Active Disputed Balance (AC) | Shows active Disputed Balance, analytic (reporting) currency. |
| Original Invoice Amount (LC) | Shows original Invoice Amount, ledger currency. |
| Credited Amount (LC) | Shows credited Amount, ledger currency. |
| Adjusted Amount (LC) | Shows adjusted Amount, ledger currency. |
| Disputed Amount (LC) | Shows Amount in Dispute in Ledger Currency |
| Applied Amount (LC) | Shows applied Amount, ledger currency. |
| Predelinquent Amount (LC) | Shows predelinquent Amount, ledger currency. |
| Delinquent Amount (LC) | Shows Amount Due Remaining in Ledger Currency for Delinquent transactions |
| Current Amount (LC) | Shows Amount Due Remaining in Ledger Currency for transactions that are not due yet |
| Undisputed Delinquent Amount (LC) | Shows the remaining delinquent balance in ledger currency after subtracting the delinquent amount currently under dispute. If there is no disputed delinquent amount, the metric returns 0. |
| Undisputed Overdue AR (LC) | Shows undisputed Overdue AR, ledger currency. |
| Resolved Amount (LC) | Shows resolved Amount, ledger currency. |
| Outstanding Amount (LC) | Shows Amount Due Remaining in Ledger Currency |
| Active Disputed Balance (LC) | Shows active Disputed Balance, in ledger currency. |
| Original Invoice Amount (DC) | Shows original Invoice Amount, document currency. |
| Credited Amount (DC) | Shows credited Amount, document currency. |
| Adjusted Amount (DC) | Shows adjusted Amount, document currency. |
| Disputed Amount (DC) | Shows disputed Amount, document currency. |
| Applied Amount (DC) | Shows applied Amount, document currency. |
| Predelinquent Amount (DC) | Shows predelinquent Amount, document currency. |
| Delinquent Amount (DC) | Shows delinquent Amount, document currency. |
| Current Amount (DC) | Shows current Amount, document currency. |
| Undisputed Delinquent Amount (DC) | Shows undisputed Delinquent Amount, document currency. |
| Undisputed Overdue AR (DC) | Shows undisputed Overdue AR, document currency. |
| Resolved Amount (DC) | Shows resolved Amount, document currency. |
| Outstanding Amount (DC) | Shows outstanding amount in invoice transaction currency. |
| Active Disputed Balance (DC) | Shows outstanding Amount, document currency. |
| Delinquent Invoice Count | Shows delinquent invoice count. |
| Total Scored Invoice Count | Total scored invoice count. |
| Current Invoice Count | Shows current invoice count. |
| Predelinquent Invoice Count | Shows predelinquent invoice count. |
| Delinquent Customer Count | Shows the number of distinct customer accounts with at least one open delinquent payment schedule. |
| Total Scored Customer Count | Total scored customer count. |
| Current Customer Count | Shows current customer count. |
| Resolved Invoice Count | Shows resolved invoice count. |
| Cure Count | Shows cure count (delinquencies cured). |
| Dunning Sent Count | Shows dunning sent count. |
| Lifetime Delinquency Count per Account | Shows lifetime delinquency count per account. |
| Average Days Past Due | Average days past due. |
| Weighted Average Days Past Due (WADPD) | Shows weighted average days past due (by amount). |
| Maximum Days Past Due | Shows maximum days past due. |
| Average Days Delinquent | Average days delinquent (portfolio). |
| Delinquency Count Rate % | Shows delinquency count rate %. |
| Unpaid Reason Coverage % | Shows unpaid reason coverage %. |
| Resolution Method - Payment % | Shows resolution method - payment %. |
| Resolution Method - Credit Memo % | Shows resolution method - credit memo %. |
| Resolution Method - Write-Off % | Shows resolution method - write-off %. |
| Adjustments Rate % | Shows adjustments rate %. |
| Unapplied Receipt Amount (AC) | Shows unapplied Receipt Amount, analytic currency. |
| On-Account Receipt Amount (AC) | Shows on-Account Receipt Amount, analytic currency. |
| Unapplied Receipt Amount (LC) | Shows unapplied Receipt Amount, ledger currency. |
| On-Account Receipt Amount (LC) | Shows on-Account Receipt Amount, ledger currency. |
| Unapplied Receipt Amount (DC) | Shows unapplied Receipt Amount, document currency. |
| On-Account Receipt Amount (DC) | Shows on-Account Receipt Amount, document currency. |
| Collectible Promise Count | Shows collectible promise count. |
| Broken Promise Count | Shows broken promise count. |
| Currently-Pursued Broken Promise Count | Shows currently-pursued broken promise count. |
| Promise Amount Committed (AC) | Shows the total promise amount committed in analytics currency for promises that are currently collectable. |
| Broken Promise Amount (AC) | Shows broken Promise Amount, analytic currency. |
| Promise Remaining Amount (AC) | Shows promise Remaining Amount, analytic currency. |
| Promise Amount Committed (LC) | Shows promise Amount Committed, ledger currency. |
| Broken Promise Amount (LC) | Shows broken Promise Amount, ledger currency. |
| Promise Remaining Amount (LC) | Shows promise Remaining Amount, ledger currency. |
| Promise Amount Committed (DC) | Shows promise Amount Committed, document currency. |
| Broken Promise Amount (DC) | Shows broken Promise Amount, document currency. |
| Promise Remaining Amount (DC) | Shows promise Remaining Amount, document currency. |
| Promise Kept Rate % | Shows promise kept rate %. |
| Broken Promise Rate % | Shows broken promise rate %. |
| Broken Promised Amount % | Shows broken promised amount %. |
| Broken Promise Recovery Rate % | Shows promise recovery rate %. |
| Clean Promise Fulfillment Rate % | Shows clean promise fulfillment rate %. |
| Avg Days Promise to Fulfilment | Average days promise-to-fulfilment. |
| Remaining Amount Not Promised (AC) | Shows the portion of the open delinquent balance, in analytics currency, that is not covered by an active collectable promise to pay. |
| Remaining Amount Not Promised (LC) | Shows the portion of the open delinquent balance, in ledger currency, that is not covered by an active collectable promise to pay. |
| Remaining Amount Not Promised (DC) | Shows the portion of the open delinquent balance, in document currency, that is not covered by an active collectable promise to pay. |
| Active Dispute Count | Shows active dispute count. |
| Dispute Cycle Time (Days) | Shows dispute cycle time (days). |
| Avg Dispute Cycle Time (Days) | Average dispute cycle time (days). |
| Dispute Resolution Rate % | Shows dispute resolution rate %. |
| Dispute Raise Amount (AC) | Shows dispute Raise Amount, analytic currency. |
| Dispute Resolution Amount (AC) | Shows dispute Resolution Amount, analytic currency. |
| Active Disputed Balance (AC) | Shows Amount In Dispute in Analytics Currency |
| Dispute Raise Amount (LC) | Shows dispute Raise Amount, ledger currency. |
| Dispute Resolution Amount (LC) | Shows dispute Resolution Amount, ledger currency. |
| Active Disputed Balance (LC) | Shows Amount In Dispute in Ledger Currency |
| Dispute Raise Amount (DC) | Shows dispute Raise Amount, document currency. |
| Dispute Resolution Amount (DC) | Shows dispute Resolution Amount, document currency. |
| Active Disputed Balance (DC) | Shows Amount In Dispute in Document Currency |
| Adjustments Count | Shows adjustments count. |
| Adjustments Amount (AC) | Shows adjustments amount, analytic currency. |
| Adjustments Amount (LC) | Shows adjustments amount, ledger currency. |
| Adjustments Amount (DC) | Shows adjustments amount, document currency. |
| Days Delinquent to Write-Off | Shows days delinquent to write-off. |
| Avg Days Delinquency to Adjustment | Average days delinquency to adjustment. |