Use one row per returned SKU and observed condition group. Keep the original return reference on each row and give each group its own reference.
Match expected quantities against the original return instruction separately; do not duplicate an expected total on every group row.
Record physical activity and financial status independently. A refund reference does not confirm that goods have arrived or been approved for resale.
For a reconciled received group, received quantity = released quantity + held quantity + other quantity handled under an explicit instruction. Keep unresolved differences open.
Define which event starts each review clock. The suggested due time is an agreed internal review target, not a promised refund or handling deadline.
Use role names and internal references. Do not add customer addresses, payment details or personal data to a publicly shared worksheet.
The example is entirely invented. It demonstrates two received units: one released after approved handling and one still held for an accessory decision. It contains no actual customer, transaction, rate or service promise.
This worksheet is a record for reconciliation. It does not connect to Shopify, reserve inventory, issue refunds or instruct a warehouse automatically.