AR Aging Bucket Classifier

Bucket actual receivables by caller increasing inclusive upper day edges, retaining negative days for not-yet-due invoices; no hardcoded aging labels, collectibility assumptions or overdue-date extraction.

Description

Receivables aging uses caller-defined inclusive upper day edges.

Receivables aging uses caller-defined inclusive upper day edges. Negative past-due days describe not-yet-due invoices rather than invalid ages.^[1]

The returned values include Invoice bucket indices, Amount totals by bucket minor. The How section below explains the calculation, input rules and interpretation.

When to use AR Aging Bucket Classifier

Use AR Aging Bucket Classifier when you need to evaluate the supplied records under the calculation and evidence rules below. No hardcoded labels, due-date extraction or collectibility inference is supplied.

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.

How to use AR Aging Bucket Classifier and understand its results

Gather the source balances and explicit accounting policy. Monetary inputs use integer minor units in one currency; for a currency with 100 minor units per major unit, 12345 represents 123.45. One basis point is 0.01 percentage points; 10000 basis points is 100%. Dates and posting signs follow the individual rules below.
Enter invoiceDaysPastDue, invoiceAmountsMinor, callerInclusiveUpperDayEdges using the field table and calculation rules, then run the tool.
Read invoiceBucketIndices, amountTotalsByBucketMinor. The explanation below defines the units, signs, ordering and any flags or placeholder values.
If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.

Input field	Meaning	Value type; see rules below	Requirement
invoiceDaysPastDue	Invoice days past due	list of number	Required
invoiceAmountsMinor	Invoice amounts minor	list of number	Required
callerInclusiveUpperDayEdges	Caller inclusive upper day edges	list of number	Required

Enter aligned nonempty signed safe-integer past-due days and nonnegative safe-integer amounts, plus 1–128 strictly increasing nonnegative safe-integer edges. Return zero-based invoice buckets and checked amount totals including the overflow bucket. Equality belongs to the corresponding edge’s bucket; negative ages enter the first bucket.

bucket=first edge≥daysPastDue; otherwise edgeCount

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output field	Meaning	Value type
invoiceBucketIndices	Invoice bucket indices	list of number
amountTotalsByBucketMinor	Amount totals by bucket minor	list of number

json

{
  "input": {
    "invoiceDaysPastDue": [
      -5,
      0,
      30,
      31,
      90
    ],
    "invoiceAmountsMinor": [
      10,
      20,
      30,
      40,
      50
    ],
    "callerInclusiveUpperDayEdges": [
      0,
      30,
      60
    ]
  },
  "output": {
    "invoiceBucketIndices": [
      0,
      0,
      1,
      2,
      3
    ],
    "amountTotalsByBucketMinor": [
      30,
      30,
      40,
      50
    ]
  }
}

Limitations and assumptions

No hardcoded labels, due-date extraction or collectibility inference is supplied.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Numeric lists are limited to 10,000 entries and string lists to 128 entries of at most 128 characters. Follow any smaller limits above. Missing fields without a declared default, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Aging Method Allowance Matrix Estimate Calculator: An aging allowance applies loss assumptions by bucket and compares the required credit balance with the existing signed allowance. Existing debit balances increase the adjustment. For a complementary task, use Obsolete Inventory Reserve Percent Lookup: Obsolescence reserve rates need a versioned caller policy. Inclusive aging bands must include an explicit overflow rate.

References

AR Aging Bucket Classifier — tool.io

Similar or alternative tools

Aging Method Allowance Matrix Estimate Calculator
An aging allowance applies loss assumptions by bucket and compares the required credit balance with the existing signed allowance. Existing debit balances increase the adjustment.
Obsolete Inventory Reserve Percent Lookup
Obsolescence reserve rates need a versioned caller policy. Inclusive aging bands must include an explicit overflow rate.