Reconcile Shopify Purchase Orders and Transfers

Treat the purchase order as the commercial agreement and the linked transfer as the physical movement record. Shopify explicitly separates these responsibilities. Capture purchase order number, supplier, destination, status, line items, supplier SKUs, ordered quantities, unit costs, tax, payment terms, and order total. Capture transfer number, origin, destination, status, shipments, tracking, expected arrivals, received actions, and cost adjustments in a second table.

Do not expect the two records to remain identical after linking. Shopify allows operators to update them independently, add transfer items that were not on the purchase order, and unlink records without undoing receiving or cost adjustments. Record the link event and current association from both sides. If a transfer was created before the purchase order, confirm supplier origin and matching items before linking it rather than forcing a convenient but incorrect relationship.

For each SKU, compare purchase-order quantity with transfer quantity, shipped quantity, accepted quantity, rejected quantity, canceled quantity, and remaining quantity. Keep each supplier shipment separate because Shopify supports multiple shipments and partial receiving. Add carrier, tracking number, shipped date, expected arrival, received date, receiving location, receiver, and source document. One final transferred status should not erase the sequence needed to explain a late or partial receipt.

Receive against physical evidence. Shopify lets the operator accept, reject, or cancel units on the transfer. Accepted units become available at the destination; rejected units are recorded but do not add to available stock; canceled units from a supplier-origin transfer are removed rather than returned to an internal origin location. Match each action to the packing slip, count, inspection result, and supplier communication so the inventory consequence is deliberate.

Compare the supplier invoice with purchase-order item cost, tax, discounts, and terms. Then reconcile shipment-level freight, customs duties, and other adjustments on the linked transfer. Shopify lets operators add these adjustments to individual shipments and aggregates them in the transfer cost summary. Keep the original supplier product cost separate from logistics and border costs so reviewers can explain both the purchase agreement and the cost to receive the inventory.

Do not assume that transfer cost adjustments automatically create a weighted-average product cost or accounting entry. Shopify documents a static cost-per-item field and recommends external costing or a reconciliation workflow when weighted-average or landed-cost allocation is required. Define the accounting handoff: source currency, exchange rate policy, allocation method, invoice reference, payable status, and ledger destination. Get finance approval before changing valuation logic.

Classify differences as supplier quantity change, purchase-order edit, transfer-only item, multiple shipment, receiving error, rejection, cancellation, freight adjustment, duty adjustment, wrong destination, duplicate receipt, unlink event, invoice variance, or unknown. Open the timelines on both records and compare the change time with warehouse and supplier evidence. Correct the record that owns the fact rather than editing both sides until totals happen to match.

Pay special attention to destination and supplier changes. Shopify allows most purchase-order details to be edited after the order is marked Ordered, while transfer origin or destination becomes constrained after later workflow states. A commercial change may therefore require a new or corrected movement plan instead of rewriting a shipment already in progress. Preserve the prior record and reason so the receiving team does not act on an obsolete instruction.

Close the operational side when every expected unit is accepted, rejected, canceled, or still documented as outstanding, the transfer status reflects reality, and destination inventory agrees with the receiving count. Close the commercial side when supplier quantities, item costs, tax, discounts, freight, duties, credits, and payable evidence agree with the approved invoice. These milestones can happen at different times; use explicit statuses instead of one vague complete flag.

Export a final reconciliation with purchase-order and transfer IDs, supplier, destination, SKU, ordered, transferred, accepted, rejected, canceled, outstanding, item cost, shipment adjustments, invoice value, variance, and owner. Attach packing slips, photos or inspection evidence when appropriate, invoice references, and supplier credits. Restrict access according to financial and supplier-data policy while keeping enough evidence for operations to reproduce the unit movement.

Review open reconciliations by age and materiality. Escalate a long-outstanding shipment, repeated supplier shortage, unexplained received-unit variance, or unallocated cost adjustment to the correct owner. Trend vendor and lane exceptions only after definitions remain consistent. Do not claim margin impact from an unposted transfer adjustment. The verified result is that purchasing, receiving, inventory, and payable records tell a consistent story with visible exceptions and a named next action. Reopen the reconciliation when a late supplier invoice, credit memo, duty bill, or receiving correction changes the approved evidence. Keep the original close version and append the new event instead of silently replacing it. This gives finance and operations a shared chronology and prevents a later cost adjustment from being mistaken for an unexplained inventory variance.