How Warehouses Calculate ATS: Rules, Formulas And Reconciliation

ATS The abbreviation for available to sell, commonly used in ecommerce inventory management. This article focuses on the operational mechanics — the rules, formulas, and reconciliation steps fulfillment teams use to keep ATS aligned with the physical inventory.

Calculating ATS requires three decisions: which system is your authoritative source; which transaction types increase or reduce available stock; and the timing rules for when those transactions change stock status. Warehouse teams must document those decisions and enforce them through WMS/ERP configuration and process controls.

Define Your Authoritative Source

Choose one system as the single source of truth for ATS. Many operations select the WMS because it is closest to physical events (receiving, putaway, picking). Others choose an ERP or OMS that coordinates financials and channel publishing. The key is consistency — every downstream channel should read ATS from the same authoritative feed.

Transaction Types And Their Effects

Map every inventory transaction to an ATS effect. The mapping should include receipts, purchase orders, open sales orders, transfers, returns, quality holds, and manual adjustments. Each mapping should state a status change (available, reserved, blocked) and the moment that change occurs.

• Receipt Cleared: Increase ATS only when goods are inspected and put away or marked available by the WMS.
• Sales Order Committed: Decrease ATS when the order is confirmed and allocated in the WMS/OMS.
• Transfer Out/In Transit: Typically reduce ATS for the source location; do not increase ATS at the destination until received and cleared.
• Returns: Exclude returns from ATS until inspected and restocked, unless your business policy allows virtual restock earlier.

Common ATS Formulas With Examples

Below are two practical formulas used in the field. Choose the one that matches your risk tolerance and channel requirements.

• Conservative ATS: ATS = On‑Hand − Committed − Holds. Use when marketplace penalties for late shipments are severe.
• Aggressive ATS: ATS = On‑Hand − Committed − Holds + Cleared Inbounds + Cleared Returns. Use when you can reliably clear receipts fast and want to maximize sellable stock.

Example: On‑hand 500, committed 120, holds 10, cleared inbound 80, cleared returns 5. Conservative ATS = 500 − 120 − 10 = 370. Aggressive ATS = 370 + 80 + 5 = 455.

Reconciling ATS With Physical Counts

Reconciliation is a disciplined cadence of cycle counts, exception investigation, and corrective actions. Start with high‑velocity SKUs because discrepancies there cause the greatest customer impact. Use root cause analysis when counts differ: receiving errors, mispicks, unrecorded disposals, or system mapping mistakes.

• Cycle Count Strategy: Prioritize ABC classes and high‑turn SKUs to keep ATS reliable where it matters most.
• Investigations: Log and track count variances to identify recurring process failures (e.g., missing receipts or incorrect unit of measure).
• Corrective Actions: Update SOPs, retrain staff, and fix system mappings rather than repeatedly adjusting numbers.

Integration Considerations

Real‑time or near‑real‑time integrations between WMS, OMS, and sales channels minimize ATS drift. If real‑time is impossible, shorten sync intervals and implement event‑based updates for critical transactions like allocations and receipts.

Message queues, webhooks, or EDI events should be monitored for failures. A single missed allocation message can leave ATS overstated and create oversells across multiple channels.

Operational Controls That Support Accurate ATS

Processes are as important as technology. Define exception workflows for situations such as partial shipments, damaged receipts, and urgent channel holds. Standardize how staff apply holds and how quickly those holds are removed or converted.

• Hold Policy: Document reasons for holds and maximum duration before disposition.
• Allocation Rules: Set priority rules (e.g., wholesale orders over marketplace) and automate them where possible.
• Audit Trail: Ensure every change to ATS has an auditable user or system event to simplify root‑cause analysis.

In short, the ATS calculation is an operational discipline: decide a single source of truth, map transactions to availability states, reconcile frequently, and automate integration points to keep your sellable inventory accurate and reliable.