Cycle Count Variance in a Bonded Spirits Warehouse
A bonded warehouse holding imported distilled spirits conducts its monthly cycle count. The book balance is 12,480 cases; the physical count is 12,462 cases. During reconciliation, staff identify three items. First, 6 cases sit in an outbound staging lane with pick tickets but were excluded from the physical count. Second, 4 cases were destroyed after bottle breakage two weeks ago, but the destruction entry was never posted. Third, 2 cases were transferred to another bonded warehouse, but the transfer-out entry is still pending. The warehouse manager must determine the adjusted book balance, adjusted physical count, and unexplained shortage before signing the reconciliation. The customs bond is in place, and the warehouse's internal shortage threshold requires a report for any unexplained variance above 0.04% of book inventory. The manager also must decide whether to post the pending entries before or after the count and how to document the result.
1. Calculate the adjusted book balance, adjusted physical count, and unexplained shortage. Does the variance exceed the internal reporting threshold?
Read the worked answer
Adjusted physical = 12,462 + 6 staging cases = 12,468. Adjusted book = 12,480 - 4 destroyed - 2 transferred = 12,474. Unexplained shortage = 12,474 - 12,468 = 6 cases. Threshold: 0.04% x 12,480 = 4.99 cases, so 6 cases exceeds the threshold and requires an internal shortage report. The 6 staging cases should be counted once physically verified; the destroyed and transferred cases should be posted with supporting evidence. The 6 unexplained cases remain the only reportable shortage unless further evidence explains them.
2. What entries, evidence, and report should support the reconciliation before the manager signs it?
Read the worked answer
Post the 4 destruction and 2 transfer entries before finalizing the reconciliation if the supporting documents are complete; otherwise disclose them as pending adjustments. Evidence should include the destruction certificate or photos, transfer document, staging pick tickets, count sheets, and system audit trail. Prepare a shortage report showing gross variance 18, adjustments 12, net 6, and the threshold calculation. Do not 'plug' the 6 cases to zero. If the 6 are later found, post a found-inventory entry with location and reason, reverse the shortage report if permitted, and update the audit trail so the correction is visible.
3. Six weeks later, the 6 missing cases are found on a mislabeled pallet inside the bonded area. How should the manager correct the record and report?
Read the worked answer
Verify physical identity and location, photograph the pallet, and post a found-inventory adjustment. The adjusted book remains 12,474; physical becomes 12,474; unexplained shortage becomes zero. Notify customs and the bondholder that the shortage report is corrected, and retain the original report and correction. The key is not to delete the original variance; use a reversing entry so the audit trail shows the investigation. If the cases had been outside the bonded area or showed tampering, treat the matter as a security incident, not just a count error, and investigate access and movement records.