Aging Method Allowance Matrix Estimate Calculator
Apply explicit caller aging-bucket loss basis points with per-bucket half-up minor-unit rounding and true-up against signed existing credit allowance; not the existing single percent-of-AR estimate or a certified impairment model.
Description
An aging allowance applies loss assumptions by bucket and compares the required credit balance with the existing signed allowance.
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.1
The returned values include Modeled loss by bucket minor, Required allowance minor, Signed allowance adjustment minor. The How section below explains the calculation, input rules and interpretation.
When to use Aging Method Allowance Matrix Estimate Calculator
Use Aging Method Allowance Matrix Estimate Calculator when you need to evaluate the supplied records under the calculation and evidence rules below. No certified impairment model, automatic rates or single-percent receivables substitution 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 Aging Method Allowance Matrix Estimate Calculator 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 bucketReceivablesMinor, callerLossRateBasisPoints, existingAllowanceCreditBalanceMinor using the field table and calculation rules, then run the tool.
- Read modeledLossByBucketMinor, requiredAllowanceMinor, signedAllowanceAdjustmentMinor. 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 |
|---|---|---|---|
| bucketReceivablesMinor | Bucket receivables minor | list of number | Required |
| callerLossRateBasisPoints | Caller loss rate basis points | list of number | Required |
| existingAllowanceCreditBalanceMinor | Existing allowance credit balance minor | number | Required |
Enter aligned nonempty nonnegative safe-integer receivables and integer rates 0–10000 plus a signed safe-integer existing credit allowance. Return independently rounded bucket losses, required total and signed true-up, with half ties away from zero.
loss_i=roundMinor(bucketAR_i×lossBps_i/10000); adjustment=sum(losses)−existingCredit Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| modeledLossByBucketMinor | Modeled loss by bucket minor | list of number |
| requiredAllowanceMinor | Required allowance minor | number |
| signedAllowanceAdjustmentMinor | Signed allowance adjustment minor | number |
{
"input": {
"bucketReceivablesMinor": [
1000,
2000
],
"callerLossRateBasisPoints": [
100,
500
],
"existingAllowanceCreditBalanceMinor": 60
},
"output": {
"modeledLossByBucketMinor": [
10,
100
],
"requiredAllowanceMinor": 110,
"signedAllowanceAdjustmentMinor": 50
}
}Limitations and assumptions
No certified impairment model, automatic rates or single-percent receivables substitution 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 AR Aging Bucket Classifier: Receivables aging uses caller-defined inclusive upper day edges. Negative past-due days describe not-yet-due invoices rather than invalid ages. 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
Similar or alternative tools
- AR Aging Bucket Classifier
Receivables aging uses caller-defined inclusive upper day edges. Negative past-due days describe not-yet-due invoices rather than invalid ages.
- Obsolete Inventory Reserve Percent Lookup
Obsolescence reserve rates need a versioned caller policy. Inclusive aging bands must include an explicit overflow rate.