ORIGINAL COMPANY-CONTEXT PRACTICE
Reconcile returnable containers separately from beverage sales
Original practice scenario: A hypothetical beverage distributor tracks filled bottles, returned empties, damaged containers and deposits. Explain the data grains and controls for a reusable-container report.
Written for independent practice using company context; this is not a verified question from a company interview.
A REASONED APPROACH
Model answer.
Keep physical container movements and monetary deposit entries separate, linking them through explicit references. Beverage volume, container count and deposit balance are different measures with different adjustments.
Work through it
- Identify container type, route, counterparty and movement event, preserving receipt, dispatch, damage and correction categories without converting every event into a sale.
- Aggregate physical flows independently, then compare opening containers plus receipts minus dispatches and authorized losses with closing observations.
- Prepare deposit accounting at its own transaction grain and reconcile linked container movements, returning unmatched references and contract exceptions for review.
Tradeoffs to discuss
- Detailed event tracking supports investigation but increases capture requirements; aggregate route counts are simpler while leaving more ambiguity about individual losses.
Common pitfalls
- Do not assume every container type carries the same deposit or holds the same volume.
- A returned empty is not negative beverage demand and should not cancel an unrelated sales line.