Night Drop Envelope Reconcile Count Tool

Reconcile actual night-drop declarations and completed counts by distinct envelope, retaining uncounted evidence rather than treating missing counts as zero cash; sentinel gaps require availability flags.

Description

Night-drop reconciliation distinguishes completed counts from uncounted envelopes.

Night-drop reconciliation distinguishes completed counts from uncounted envelopes. A zero discrepancy on an uncounted item is only a placeholder.^[1]

The returned values include Signed counted minus declared by envelope minor, Count evidence available flags, Uncounted envelope ids, Counted subset net difference minor. The How section below explains the calculation, input rules and interpretation.

When to use Night Drop Envelope Reconcile Count Tool

Use Night Drop Envelope Reconcile Count Tool when you need to evaluate the supplied records under the calculation and evidence rules below. No missing-as-zero-cash assumption, authenticity or audit completion is supplied.

Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.

How to use Night Drop Envelope Reconcile Count Tool and understand its results

Prepare observed financial records and verified caller terms. Use one currency for integer minor-unit money and preserve leading zeros in identifier text. One basis point is 0.01 percentage points. Resolve dates, local clocks, counting rules and evidence flags as specified.
Enter envelopeIds, declaredEnvelopeAmountsMinor, countedEnvelopeAmountsMinor, countCompletedFlags using the field table and calculation rules, then run the tool.
Read signedCountedMinusDeclaredByEnvelopeMinor, countEvidenceAvailableFlags, uncountedEnvelopeIds, countedSubsetNetDifferenceMinor. 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
envelopeIds	Envelope ids	list of string	Required
declaredEnvelopeAmountsMinor	Declared envelope amounts minor	list of number	Required
countedEnvelopeAmountsMinor	Counted envelope amounts minor	list of number	Required
countCompletedFlags	Count completed flags	list of number	Required

Enter aligned nonempty unique nonblank envelope IDs, nonnegative safe-integer declared/counted money and binary count flags. Require counted amount exactly zero when the count flag is zero. Return signed gaps, copied evidence flags, uncounted IDs and signed counted-subset net difference.

gap_i=counted_i?countedAmount_i−declaredAmount_i:0; total=sum(knownGaps)

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

Output field	Meaning	Value type
signedCountedMinusDeclaredByEnvelopeMinor	Signed counted minus declared by envelope minor	list of number
countEvidenceAvailableFlags	Count evidence available flags	list of number
uncountedEnvelopeIds	Uncounted envelope ids	list of string
countedSubsetNetDifferenceMinor	Counted subset net difference minor	number

json

{
  "input": {
    "envelopeIds": [
      "A",
      "B"
    ],
    "declaredEnvelopeAmountsMinor": [
      100,
      200
    ],
    "countedEnvelopeAmountsMinor": [
      90,
      0
    ],
    "countCompletedFlags": [
      1,
      0
    ]
  },
  "output": {
    "signedCountedMinusDeclaredByEnvelopeMinor": [
      -10,
      0
    ],
    "countEvidenceAvailableFlags": [
      1,
      0
    ],
    "uncountedEnvelopeIds": [
      "B"
    ],
    "countedSubsetNetDifferenceMinor": -10
  }
}

Limitations and assumptions

No missing-as-zero-cash assumption, authenticity or audit completion 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; string lists to 128 strings of at most 128 characters each. The rules above may impose smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Teller Drawer Variance Limit Checker: Drawer over/short compares counted denomination inventory with expected cash from the opening balance and ledger. A signed deficit differs from a tolerance flag. For a complementary task, use Positive Pay Issue Mismatch Checker: Positive-pay matching compares check ID, amount and payee against the issue ledger. Distinct mismatch witnesses explain a failed aggregate match.

References

Night Drop Envelope Reconcile Count Tool — tool.io

Similar or alternative tools

Teller Drawer Variance Limit Checker
Drawer over/short compares counted denomination inventory with expected cash from the opening balance and ledger. A signed deficit differs from a tolerance flag.
Positive Pay Issue Mismatch Checker
Positive-pay matching compares check ID, amount and payee against the issue ledger. Distinct mismatch witnesses explain a failed aggregate match.