Teller Drawer Variance Limit Checker

Reconcile actual denomination counts with drawer cash-in/out ledger and caller over/short tolerance, retaining signed deficit; no finding of theft, cash authenticity or complete audit assurance.

Description

Drawer over/short compares counted denomination inventory with expected cash from the opening balance and ledger.

Drawer over/short compares counted denomination inventory with expected cash from the opening balance and ledger. A signed deficit differs from a tolerance flag.1

The returned values include Observed drawer minor, Expected drawer minor, Signed drawer over short minor, Within caller drawer tolerance. The How section below explains the calculation, input rules and interpretation.

When to use Teller Drawer Variance Limit Checker

Use Teller Drawer Variance Limit Checker when you need to evaluate the supplied records under the calculation and evidence rules below. No theft finding, authenticity or complete audit assurance 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 Teller Drawer Variance Limit Checker and understand its results

  1. 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.
  2. Enter cashDenominationsMinor, observedNoteCounts, openingDrawerMinor, recordedCashInMinor, recordedCashOutMinor, callerVarianceToleranceMinor using the field table and calculation rules, then run the tool.
  3. Read observedDrawerMinor, expectedDrawerMinor, signedDrawerOverShortMinor, withinCallerDrawerTolerance. The explanation below defines the units, signs, ordering and any flags or placeholder values.
  4. 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 fieldMeaningValue type; see rules belowRequirement
cashDenominationsMinorCash denominations minorlist of numberRequired
observedNoteCountsObserved note countslist of numberRequired
openingDrawerMinorOpening drawer minornumberRequired
recordedCashInMinorRecorded cash in minorlist of numberRequired
recordedCashOutMinorRecorded cash out minorlist of numberRequired
callerVarianceToleranceMinorCaller variance tolerance minornumberRequired

Enter aligned nonempty positive safe-integer denominations and integer note counts 0–1000000, nonnegative safe-integer opening balance, cash ledgers and tolerance. Cash-in/out lists may be empty. Require products and sums to remain safe integers. Return counted/expected money, signed variance and an inclusive absolute-tolerance flag.

observed=sum(denomination×count); expected=opening+sum(in)−sum(out); variance=observed−expected

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

Output fieldMeaningValue type
observedDrawerMinorObserved drawer minornumber
expectedDrawerMinorExpected drawer minornumber
signedDrawerOverShortMinorSigned drawer over short minornumber
withinCallerDrawerToleranceWithin caller drawer toleranceboolean
json
{
  "input": {
    "cashDenominationsMinor": [
      100,
      500
    ],
    "observedNoteCounts": [
      2,
      3
    ],
    "openingDrawerMinor": 1000,
    "recordedCashInMinor": [
      1000
    ],
    "recordedCashOutMinor": [
      200
    ],
    "callerVarianceToleranceMinor": 50
  },
  "output": {
    "observedDrawerMinor": 1700,
    "expectedDrawerMinor": 1800,
    "signedDrawerOverShortMinor": -100,
    "withinCallerDrawerTolerance": false
  }
}

Limitations and assumptions

No theft finding, authenticity or complete audit assurance 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. A successfully returned false flag is an evaluated outcome; its meaning is explained above.

Alternative or Complementary methods

Use Night Drop Envelope Reconcile Count Tool: Night-drop reconciliation distinguishes completed counts from uncounted envelopes. A zero discrepancy on an uncounted item is only a placeholder. For a complementary task, use ATM Cassette Replenishment Plan Calculator: ATM replenishment is constrained per cassette denomination. A capacity shortage leaves unfunded reserve or demand and can produce negative post-demand note counts.

References

  1. Teller Drawer Variance Limit Checker — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies