How to Handle Partial Shipments in Wholesale Invoicing: Reconcile Order vs Actual Shipped Quantity

2026-11-17

wholesale inventory management software

The warehouse receipt shows a few items still pending, but the store treats them as available stock. To handle partial shipments properly, wholesale invoicing software must track three numbers separately: order quantity, shipped quantity, and pending quantity. A customer order does not mean goods have left the warehouse; only what has actually shipped should count as dispatched.

Deducting the Full Order at Invoicing Distorts Stock in Both Directions

A typical case: a customer orders a batch, the warehouse ships what is available first, and the rest waits for replenishment. If you deduct the full order quantity when invoicing, the recorded stock will be lower than what is physically in the warehouse. If you wait until the whole order ships before deducting, goods already sent may be sold to the store or allocated to another order.

The reason is that confirming an order and delivering goods are two separate actions. Order quantity represents what the customer wants; shipped quantity represents what has actually been delivered; pending quantity is the gap between the two. Merging them into one number makes it impossible later to tell whether a discrepancy came from a missed shipment, a changed order, or a recording error.

When reconciling, pick one incomplete order and check: ordered quantity, each shipment quantity, cumulative shipped quantity, and remaining pending quantity. Then compare against stock movements. Stock changes should correspond to actual shipments. When they do not match, check shipment records, cancellations, and quantity changes first, then adjust stock.

Shared Wholesale and Retail Stock: Keep Available and Pending Separate

Wholesale shipments and store retail can share the same stock, but available quantity cannot be determined by looking only at what is physically in the warehouse. Quantity already committed to wholesale customers but not yet shipped must also be tracked separately. Otherwise, the store may sell pending shipments; if pending is treated as already shipped, available stock will be underestimated.

When managing wholesale and retail inventory together, check three nodes along one order: after order confirmation, can pending quantity be queried; after each shipment, is the shipment quantity recorded and remaining quantity updated; does store retail reflect in the same stock record. When cross-warehouse or cross-store transfers are involved, distinguish outbound, in-transit, and inbound to avoid recording internal movements as customer shipments.

If store inventory software shows only total stock, staff can still register orders, shipments, and retail sales separately, but someone must continuously maintain cumulative quantities. When selecting a system, include this manual maintenance time in the calculation. Merchants with frequent partial shipments or multiple stores sharing stock need to confirm whether each node can be traced back to its original record. When business is simple and orders usually ship in full at once, a spreadsheet may be sufficient.

Wholesale Invoicing Software Must Demonstrate Partial Shipments to Prove It Works

To judge whether wholesale invoicing software can clearly manage partial shipments, do not just look at whether it can create orders. Request a demonstration of one order shipped in two batches: can each shipment quantity be traced, are cumulative shipped quantity and remaining pending quantity clear, does stock change according to actual shipments, and if the customer cancels the pending balance, is the change record preserved.

Each shipment should link to the original order. When the customer changes quantity or cancels unshipped portions, update the pending balance and leave a change record. When returned goods come back, register them according to the actual return action. Replacing the old order with a new one may break the correspondence between promised quantity and actual shipped quantity. If the inventory management system shows only order total or final status, it is insufficient to verify this process.

Ailit is an intelligent inventory management system serving small and midsize wholesale and retail merchants globally, supporting separate tax display and customizable print templates. If local invoicing requires separate tax display or document layout adjustments, include these in your selection checklist. They do not prove the system updates shipped and pending quantities with each shipment; you still need to verify with actual orders. Demonstrations take staff and supplier time. If orders usually ship in full and manual records reconcile reliably, paper forms or spreadsheets may cost less to maintain.

Frequently Asked Questions

Should wholesale invoicing software deduct stock when the order is placed or when it ships?

Update stock according to actual shipped quantity and record each shipment. Order confirmation quantity and pending quantity track customer commitments; they do not mean goods have left the warehouse.

With shared wholesale and retail stock, how do you avoid selling pending shipments to the store?

Make pending wholesale order quantities and actual stock changes queryable separately, and record store sales in the same stock record. If the system shows only total stock, a pending shipment list must be maintained separately. When multiple stores or people share stock, reconciling this list must be included in daily work.

What records should be kept when a customer cancels unshipped quantity?

Update pending quantity after cancellation and retain quantities before and after the change, making it easy to reconcile with the original order and shipped records. When orders usually complete in one shipment and cancellations are rare, a spreadsheet may be sufficient. When multiple people handle orders together, traceability is more worth checking.

How do you judge whether an inventory management system is suitable for partial shipments?

Use one order to demonstrate multiple shipments. Check whether each shipment, cumulative shipped quantity, remaining pending quantity, and stock changes correspond item by item. Ailit's tax display and customizable print templates do not prove partial shipment management capability; judge by demonstration results.

Related reading recommendations

item

Inventory Management Pain Points: Why Wholesale Merchants Lose Track of Stock

Read the full article
item

How to Handle Partial Shipments in Wholesale Invoicing: Reconcile Order vs Actual Shipped Quantity

Read the full article
item

How to Choose Inventory Management Software for Wholesale and Retail: Keep Purchases, Sales and Stocktakes Connected

Read the full article
Dedicated online consultant
Contact us anytime if you encounter any problems.
whatsapp:
+852-84041268
Working days: 9:00- 18:00
(UTC+8 Beijing Time)
WeChat online customer service
Need to send an image/text? Contact our support.
+852-84041268
Working days: 9:00- 18:00
(UTC+8 Beijing Time)