Skip to content

Main content

Controlled Stock Record Caller Balance Tool

Reconcile supplied stock ledger counts without certifying a regulated register.

Loading tool…

Description

Combine nonnegative opening+received-supplied+returned-destroyed for calculatedClosing and return recordedClosing minus that result.

Pharmacy traceability and monitoring records contain versions, time gaps, release flags, and ledger entries. Consistent metadata is useful evidence but does not establish product stability, correct preparation, or authorized release.

Combine nonnegative opening+received-supplied+returned-destroyed for calculatedClosing and return recordedClosing minus that result.

When to use this tool

Use Controlled Stock Record Caller Balance when you need a narrow pharmacy-record consistency check.

How to use the tool and how it works

  1. Enter opening, received, supplied, returned, destroyed, recordedClosing. Use the units and conventions below.
  2. Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
  3. Read calculatedClosing, discrepancy. Use the output convention below.

Combine nonnegative opening+received-supplied+returned-destroyed for calculatedClosing and return recordedClosing minus that result.1

Input fieldMeaning and unitsAccepted input
openingOpeningRequired. Safe integer; minimum 0.
receivedReceivedRequired. Safe integer; minimum 0.
suppliedSuppliedRequired. Safe integer; minimum 0.
returnedReturnedRequired. Safe integer; minimum 0.
destroyedDestroyedRequired. Safe integer; minimum 0.
recordedClosingRecorded ClosingRequired. Safe integer; minimum 0.
Output fieldInterpretationReturned shape
calculatedClosingCalculated ClosingRequired. Safe integer.
discrepancyDiscrepancyRequired. Safe integer.
json
{
  "input": {
    "opening": 100,
    "received": 20,
    "supplied": 30,
    "returned": 2,
    "destroyed": 5,
    "recordedClosing": 86
  },
  "output": {
    "calculatedClosing": 87,
    "discrepancy": -1
  }
}

Limitations and assumptions

  • Calculated closing can be negative; this is a caller-supplied controlled-stock ledger without authenticating transactions, meeting legal recordkeeping rules, or authorizing supply.
  • Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
  • Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.

Alternative or Complementary methods

Review the complete quality and traceability record through the responsible pharmacy process before acting on a discrepancy.

References

  1. Calculation and input contract: hospital-pharmacy/controlled-stock-record-caller-balance — tool.io

Similar or alternative tools

  • Cabinet Count Variance

    Return counted minus exclusions and that result minus expected, using an exact integer difference before numeric export.

  • Ward Stock Count Gap

    Subtract nonnegative integer expected from observed for gap.