Shopify invoice reconciliation
How to Reconcile Supplier Invoices in Shopify: PO + Receiving Checklist
A Shopify supplier-invoice reconciliation compares three records: what you agreed to buy on the purchase order, what your team recorded as received, and what the supplier billed. Review identity, quantity, unit price, tax, adjustments, and totals before payment approval. A difference is not automatically an error, but it needs an explanation and source evidence.
The three records you need
1. The Shopify purchase order
The PO establishes the supplier, products, agreed quantities, unit costs, tax values, payment terms, currency, and adjustments. Treat the ordered PO as the agreement the supplier was expected to fulfil, not as proof that the goods arrived.
2. The receiving record
In Shopify’s current workflow, receiving happens through the inventory transfer linked to the PO. Staff can accept or reject quantities, receive partial shipments, and process later shipments separately. This record answers “What did we actually receive?”
3. The supplier invoice
The invoice is the supplier’s request for payment. It may use a supplier SKU, abbreviated description, pack quantity, tax presentation, or line order that differs from Shopify. Preserve the original document rather than relying only on a retyped total.
Shopify documents these records separately in its guidance for purchase orders ↗, linked transfers ↗, and the invoice process ↗.
A six-step Shopify invoice-reconciliation checklist
Step 1: Confirm the invoice’s identity
Check supplier, invoice number, invoice date, currency, and referenced PO. Search for the same supplier and invoice number before continuing. Distinguish a corrected or reissued invoice from a second payable document.
Step 2: Select the ordered PO
Use the PO the supplier confirmed, not an editable draft. If commercial terms changed outside Shopify, retain the approval rather than silently editing the history to make the invoice match.
Step 3: Bring in the receiving record
Use accepted quantities for the relevant shipment or shipments. Shopify supports partial receipts and rejected items, so an order for 20 units might legitimately show only 12 accepted today. Its receiving guidance ↗ recommends prompt verification and documented discrepancies.
Step 4: Match invoice lines to Shopify lines
Start with supplier or variant SKUs. Then consider description, quantity, pack size, unit, and price together. Do not force a match just because descriptions look similar.
- Matched: evidence supports the same item and agreed values.
- Discrepant: the item matches, but quantity, unit price, tax, or another billed value differs.
- Uncertain: available evidence cannot connect the lines safely.
Step 5: Recalculate line and invoice totals
Calculate quantity × unit price for each line, then account for discounts and tax as shown on the document. Reconcile subtotal, tax, shipping, fees, credits, rounding, currency, and the final total.
Step 6: Create an exception list for human review
The useful output is not a blanket “approved” status. It is a short, source-cited list that gives a person enough evidence to decide the next step.
What evidence to retain for each discrepancy
| Exception | Compare | Evidence to retain |
|---|---|---|
| Quantity mismatch | Invoiced vs. accepted quantity | PO line, receiving line, invoice line |
| Unit-price mismatch | Invoiced vs. agreed PO price | PO cost, invoice price, approved change |
| Tax mismatch | PO tax vs. invoice tax | Both tax lines and applicable policy context |
| Duplicate risk | Supplier, invoice number, amount, date | Both invoice records |
| Uncertain line match | SKU, description, pack size, unit | Candidate lines and reason for uncertainty |
Only after exceptions are resolved should your existing approval and payment process continue.
What to do when Shopify and the invoice do not match
Do not change inventory merely to make the numbers agree. First determine which source record is wrong or incomplete.
- If receiving is wrong, verify the physical count and correct it through Shopify’s documented receiving workflow.
- If quantity or price is billed incorrectly, request an explanation, corrected invoice, or credit through your normal supplier process.
- If the PO omitted an agreed freight charge, document the commercial change and apply your payment policy.
- If two lines cannot be matched confidently, leave them unresolved rather than guessing.
Shopify’s invoice-processing sequence places accuracy checking and discrepancy resolution before approval and payment. The comparison finds the issue; the retailer retains authority.
Spreadsheet method versus a discrepancy checker
A spreadsheet can work when volume is low and documents use consistent SKUs. Shopify’s Stocky transition guidance describes exporting a reconciliation report to CSV and multiplying received quantities by invoice prices.
The process becomes harder to reproduce when suppliers change descriptions, invoice partial shipments, mix pack and each units, add tax or fees inconsistently, or send a possible duplicate. The risk is no longer just arithmetic; it is losing the source trail behind a match.
LineQuery is being developed for this narrow check. It compares the invoice with PO and optional receiving records, flags the five discrepancy types, and presents source-line evidence. It does not approve payment, email the supplier, or update inventory. See the review workflow, or diagnose a live problem with the supplier-invoice discrepancy guide.
Straight answers
Frequently asked questions
Can Shopify automatically match a supplier invoice to a purchase order?+
Shopify records purchase orders and linked receiving activity, but its current Stocky migration guidance describes reconciling a vendor invoice by exporting data and using a spreadsheet. Creating or receiving a PO does not itself validate the supplier invoice.
Should I compare an invoice with the PO or with received stock?+
Use both. The PO shows what you agreed to buy and the receiving record shows what arrived. Comparing only the invoice and PO can miss short shipments; comparing only the invoice and receipt can miss an unapproved price.
What if the supplier invoice has no PO number?+
Match cautiously using supplier, date, currency, product identifiers, quantities, and amounts. If more than one PO is plausible, mark the result uncertain and ask a person to select the correct source record.
Does an invoice mismatch always mean the supplier is wrong?+
No. The PO may be outdated, receiving may be incomplete, an approved change may be missing, or the invoice may use a different unit. A mismatch is a review signal, not a verdict.