01 Scope
Daily reconciliation covers new and cancelled orders, fulfillment status, shipped quantity, tracking, and available inventory. Monthly reconciliation adds channel totals, warehouse shipments, and customer billing.
02 Daily Controls
| Object | Fields |
|---|---|
| Orders | Channel order ID, OMS status, amount, line count, and quantity. |
| Inventory | SKU, On Hand, Committed, Available, and update time. |
| Shipments | Shipment, carrier, tracking, ship date, and confirmation status. |
03 Resolve Differences
Use the same channel, warehouse, time zone, and date range before export. Build an exception list by order or SKU and classify timing differences, mapping errors, duplicate events, failed callbacks, and manual adjustments. Retain before-and-after data and logs.
04 Governance
Each discrepancy needs an owner, impact scope, root cause, corrective action, and closure time. Escalate bulk differences, customer complaints, and financial impact.