The observation unit is one bank lockbox file submitted for import during the frozen window; missing and conflicted evidence remain explicit outcomes.
Research question and boundary
Lockbox Import Reconciliation Completeness protocol note 1: This protocol will measure whether lockbox imports retain complete file, control-total, reject, duplicate, variance, and approval evidence. It evaluates local administrative evidence and does not authorize posting, credit, collection, tax, legal, refund, payment, or customer decisions.
Lockbox Import Reconciliation Completeness protocol note 2: Register the question, systems, workflow versions, dates, population rules, exclusions, primary outcome, subgroup plan, and stop criteria before viewing results. Preserve dated amendments.
Population and sampling frame
Lockbox Import Reconciliation Completeness protocol note 3: The observation unit is one bank lockbox file submitted for import during the frozen window. Build the frame from stable identifiers and retain canceled, superseded, failed, unresolved, corrected, and restricted records.
Lockbox Import Reconciliation Completeness protocol note 4: If a census is impractical, use a reproducible random sample with predeclared strata and a published seed. Do not replace an incomplete selected record with a cleaner example.
Data dictionary and lineage
Lockbox Import Reconciliation Completeness protocol note 5: Capture file key, bank source, receipt count, control total, import batch, rejects, duplicates, variance, review, release, and reconciliation result. Define allowed values, authoritative source, observation time, transformation, missing-state codes, and adjudication for every field.
Lockbox Import Reconciliation Completeness protocol note 6: Keep absent, inaccessible, disputed, not applicable, overwritten, and indeterminate as distinct states. Link derived values to the read-only extract and transformation log.
Reviewer reliability
Lockbox Import Reconciliation Completeness protocol note 7: Train reviewers on cases outside the scored sample, lock the dictionary, and independently double-code a blinded overlap set. Retain confidence and initial choices before discussion.
Lockbox Import Reconciliation Completeness protocol note 8: Publish raw agreement, category-specific disagreement, chance-adjusted agreement where suitable, adjudication counts, and every rubric clarification. Weak agreement is a measurement result.
Primary analysis
Lockbox Import Reconciliation Completeness protocol note 9: Compare bank channel, file type, replacement status, volume band, exception presence, and result. Report counts, denominators, missingness, and uncertainty with rates; for elapsed time show medians, quartiles, age bands, and unresolved observations.
Lockbox Import Reconciliation Completeness protocol note 10: The primary outcome is the proportion of eligible files with every predeclared reconciliation element and no unresolved variance. Keep evidence quality separate from operating performance because missing documentation cannot prove that an event occurred or failed.
Sensitivity checks
Lockbox Import Reconciliation Completeness protocol note 11: Recalculate under strict source-only evidence and the declared adjudication rule. Bound inaccessible units once as missing and once as adverse, then repeat after removing linked duplicates.
Lockbox Import Reconciliation Completeness protocol note 12: Preserve the registered result when alternatives look more favorable. Explain the changed assumption, number of units moved, and whether the operational recommendation reverses.
Privacy and limitations
Lockbox Import Reconciliation Completeness protocol note 13: The central limit is that matching control totals can coexist with duplicated, omitted, rejected, or misidentified receipt records. Also assess selection, channel-specific missingness, system clocks, retrospective corrections, workflow changes, correlated accounts, and reviewer learning.
Lockbox Import Reconciliation Completeness protocol note 14: Replace customer, employee, bank, and transaction identifiers with study keys. Restrict the linkage table, minimize free text, log access, and suppress sensitive small cells.
Evidence quality checks
Lockbox Import Reconciliation Completeness protocol note 15: Trace a stratified quality sample back to file key, bank source, receipt count, control total, import batch, rejects, duplicates, variance, review, release, and reconciliation result. Confirm that extraction preserved the source event, actor, version, time zone, and later correction; a derivative spreadsheet is not independent confirmation.
Lockbox Import Reconciliation Completeness protocol note 16: Record every failed link, inaccessible artifact, conflicting value, and reviewer query in an evidence-quality log. Retain the affected observation in its missing or disputed category.
Governance and replication
Lockbox Import Reconciliation Completeness protocol note 17: Separate data custody, coding, adjudication, and operational approval where practical. Disclose conflicts and require an authorized owner for any use beyond the registered purpose.
Lockbox Import Reconciliation Completeness protocol note 18: Give a second analyst the frozen extract, dictionary, and transformation log without private notes. Compare replicated counts and exceptions, explain differences, and version the final package.
Reporting and responsible use
Lockbox Import Reconciliation Completeness protocol note 19: Publish frame construction, observation count, exclusions, coverage, dictionary, missingness, reliability, primary estimate, groups, sensitivities, counterexamples, and limitations.
Lockbox Import Reconciliation Completeness protocol note 20: Use findings for a bounded process trial with an owner, duration, review date, rollback condition, and privacy check. Do not use this study alone for discipline, surveillance, or automated consequential decisions.
Sources
Put the protocol into operational context.
Discuss the queue, evidence, ownership, and safeguards that apply to your workflow.
Discuss your workflow