Suspense Account Clearance Aging Checker
Audit signed uncleared suspense rows against explicit inclusive aging threshold, exposing gross aged exposure even when debit/credit balances cancel; no automatic writeoff or cleared status from net zero.
Description
Suspense balances can cancel while leaving gross uncleared exposure.
Suspense balances can cancel while leaving gross uncleared exposure. Aging should therefore retain absolute amounts as well as net balance.1
The returned values include Net suspense balance minor, Gross uncleared exposure minor, Aged uncleared line indices, Gross aged exposure minor. The How section below explains the calculation, input rules and interpretation.
When to use Suspense Account Clearance Aging Checker
Use Suspense Account Clearance Aging Checker when you need to evaluate the supplied records under the calculation and evidence rules below. No automatic clearance or writeoff follows from a zero net balance.
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 Suspense Account Clearance Aging Checker 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 signedSuspenseLineAmountsMinor, observedUnclearedAgesDays, callerAgingThresholdDays using the field table and calculation rules, then run the tool.
- Read netSuspenseBalanceMinor, grossUnclearedExposureMinor, agedUnclearedLineIndices, grossAgedExposureMinor. 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 |
|---|---|---|---|
| signedSuspenseLineAmountsMinor | Signed suspense line amounts minor | list of number | Required |
| observedUnclearedAgesDays | Observed uncleared ages days | list of number | Required |
| callerAgingThresholdDays | Caller aging threshold days | number | Required |
Enter aligned nonempty signed safe-integer amounts and integer ages 0–36600, plus integer threshold 0–36600. Return net balance, gross exposure, zero-based inclusively aged indexes and gross aged exposure with checked sums.
net=sum(signedAmounts); gross=sum(abs(amounts)); aged when age≥threshold Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.
| Output field | Meaning | Value type |
|---|---|---|
| netSuspenseBalanceMinor | Net suspense balance minor | number |
| grossUnclearedExposureMinor | Gross uncleared exposure minor | number |
| agedUnclearedLineIndices | Aged uncleared line indices | list of number |
| grossAgedExposureMinor | Gross aged exposure minor | number |
{
"input": {
"signedSuspenseLineAmountsMinor": [
100,
-100
],
"observedUnclearedAgesDays": [
90,
100
],
"callerAgingThresholdDays": 90
},
"output": {
"netSuspenseBalanceMinor": 0,
"grossUnclearedExposureMinor": 200,
"agedUnclearedLineIndices": [
0,
1
],
"grossAgedExposureMinor": 200
}
}Limitations and assumptions
No automatic clearance or writeoff follows from a zero net balance.
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 Month End Close Countdown Days Checklist Tool: Close-checklist due dates are caller offsets from period end. Signed remaining days distinguish future tasks from incomplete overdue tasks. For a complementary task, 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.
References
-
Suspense Account Clearance Aging Checker — tool.io
Similar or alternative tools
- Month End Close Countdown Days Checklist Tool
Close-checklist due dates are caller offsets from period end. Signed remaining days distinguish future tasks from incomplete overdue tasks.
- 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.