The supplier's commercial invoice arrives, the total looks about right, and the balance is due before the goods ship. It is tempting to pay and move on. Then the cartons reach the warehouse with one SKU short, or a freight charge shows up on the invoice that nobody agreed to, and the unit cost you priced your listing on quietly changes.
Reconciling a supplier invoice to a purchase order is the habit that catches those problems while you can still fix them. I run it on every supplier bill before money goes out, whether the stock is headed to Amazon FBA, a Shopify warehouse, or a 3PL. Below is the five-step routine I use, how to handle the differences you find, and where software can take some of the typing off your plate.
TL;DR
- Reconcile against three documents together: the purchase order, the supplier invoice, and the receiving record. Accountants call this a three-way match.
- Match line by line on supplier, SKU, quantity, unit price, and currency before you look at the total.
- Check every charge beyond the product price, such as freight, duty, discounts, credits, and tax, and decide which ones belong in landed cost.
- Give each difference a reason, an owner, and a decision, then approve, hold, or dispute the specific line.
- SupplyAutomate reads supplier invoices and files them against the purchase order with freight bills and customs entries so you can calculate landed cost. It has no Shopify, Amazon, or QuickBooks connection, so payment and bookkeeping stay in your own tools.
Step 1: Collect The Invoice, Purchase Order, And Receiving Record
Start by gathering every document tied to the purchase. Reconciliation gets slow when the invoice sits in one inbox, the PO lives in a spreadsheet, and the receiving count is inside a 3PL portal. Pulling them into one place first saves a lot of back and forth.
Here is what I collect before comparing any numbers:
- The final supplier invoice, with its invoice number and currency.
- The approved purchase order, with each SKU, quantity, unit price, and the agreed terms.
- The receiving record from your warehouse, 3PL, prep center, or Amazon inbound shipment.
- Any change order, updated quote, freight bill, customs entry, or credit note for the order.
Check document dates next. Many suppliers send a proforma invoice before production and a final commercial invoice after packing. Pay against the final one, and keep the proforma on file because it often explains why a price changed. If you pay on deposit and balance terms, 30/70 payment terms with Chinese suppliers covers how each payment ties to these documents.
Then confirm the supplier name and legal entity match your vendor record. A similar trading name can belong to a different factory or a different bank account, which matters when several suppliers make similar products. How to organize supplier invoices has a simple filing setup that keeps all of this under one PO.
If one of the three documents is missing, put the invoice on hold until it turns up. Filling the gap with an assumption is how overpayments slip through.
Step 2: Match Supplier, SKU, Quantity, And Unit Cost
Now compare the invoice to the PO line by line. Start with identity, then quantity, then price. A total-only check can hide two errors that cancel each other out, so the line view is worth the extra minutes.
Match the supplier name, PO number, invoice number, currency, and payment terms first. Then match each SKU. Supplier item codes often differ from your internal SKUs, so a simple cross-reference table saves you from guessing when the same product has two names.
Quantity deserves a careful read. Confirm the unit on the invoice, whether that is pieces, cartons, cases, or sets. A supplier might bill 20 cartons while your PO says 240 pieces, and those can describe the same shipment. Write the conversion down next to the line so the next person can follow it.
| Check | What to compare | Common difference | What to do |
|---|---|---|---|
| Supplier identity | Invoice vendor and PO vendor | Different legal entity or bank details | Pause payment and confirm with the supplier |
| SKU | Supplier code and your SKU | Revised code or similar item | Use your approved SKU map |
| Quantity | Invoiced units and received units | Short shipment or carton conversion | Check the receiving record |
| Unit price | Invoice price and PO price | Price change without approval | Ask for a revised invoice or record the approval |
| Currency | Invoice currency and PO currency | Different currency or rate | Apply the conversion rule you agreed |
Use the receiving record to tell a partial delivery from a billing error. As an example, if the PO is for 1,000 units and 800 arrived, an invoice for 800 is fine. An invoice for 1,000 needs proof that the other 200 shipped or a credit before you pay it.
Once every line has a status, label it clearly. Matched, short received, overbilled, underbilled, and waiting for approval each tell the next reviewer exactly what to do. For a broader look at matching tools, invoice matching software for ecommerce sellers compares the options.
Step 3: Check Freight, Duty, Discounts, Credits, And Tax
The product lines can match perfectly while the amount due still differs. That is why the third step looks at everything beyond the unit price.
Separate product charges from logistics charges first. Look for freight, insurance, export fees, inspection fees, and handling. Some of these belong on the supplier invoice under your Incoterm, and others should arrive as separate bills from your forwarder or customs broker. FOB vs EXW vs DDP for FBA sellers explains which side pays what under each term.
Then check discounts and credits. A volume discount may apply to the whole PO or only to certain SKUs. A credit note might cover damaged stock from an earlier order. Apply each one to the purchase it belongs to so your cost records stay clean.
Tax gets its own look. Confirm the rate, the base it applies to, and any exemption against your records, and ask the supplier for supporting detail if the treatment differs from previous invoices.
This is also the moment to think about landed cost. The factory price on the invoice is the first piece. Freight, duty, and samples for the order complete the picture of what each sellable unit cost you. Landed cost per unit and allocate freight cost across multiple SKUs show how to spread those charges, and keeping the same allocation method from one PO to the next keeps your margins comparable. If a freight bill arrives weeks after the invoice, how to track shipping and manufacturing costs covers keeping the cost open until it lands.
Step 4: Investigate Differences And Approve Or Dispute
A variance is any difference between the PO, the invoice, and the receiving record. Each one needs a reason and someone responsible for resolving it. Sorting them into groups first makes the conversation with the supplier much shorter:
- Quantity: the billed units differ from what was ordered or received.
- Price: the unit price changed without a matching PO update.
- Item: the invoice lists the wrong SKU, pack size, or description.
- Charge: freight, tax, or a fee appears without agreed terms.
- Timing: the invoice belongs to another shipment or should carry an earlier credit.
Before contacting the supplier, look for an approved explanation in the PO history, your chat thread, the latest quote, and the receiving notes. A price change may be valid if someone on your team agreed to it before production. In that case, update the PO so the record matches what was agreed.
When you do raise it, write a specific note with the PO line, the expected amount, the billed amount, the difference, and what you need. Something like "SKU A-104 shows 500 units billed and 450 received, please issue a credit for 50 units" gets a quicker answer than a general complaint about the total.
Some teams set a small tolerance so that rounding differences pass without review. If you use one, write it down and keep it tight on unit prices, because a small percentage on a large order can still move your margin. When the evidence supports the amount, approve it. When one line is off, hold or dispute that line and let the clean lines move forward if the supplier can issue a partial credit.
Record the final decision with the invoice, for example "approved after 50-unit credit." That note helps the next payment review and makes repeat supplier errors easy to spot. If several people share this work, best accounts payable automation software for ecommerce covers tools that route exceptions to the right person.
Step 5: Keep The Records Together With SupplyAutomate
Manual matching is manageable with a handful of suppliers. It gets heavier with more SKUs, currencies, partial shipments, and separate freight and duty bills. That is the part SupplyAutomate is built for.
You upload supplier invoices, packing lists, freight bills, and customs entries, and SupplyAutomate reads the key values from each document and files them against the purchase order. You can track the parcel or ocean container on the same record, calculate landed cost from factory price, freight, duty, and samples, and export the result to CSV or Excel. That way the reconciliation happens on one record with every document attached.
SupplyAutomate has no Shopify, Amazon, WooCommerce, QuickBooks, or Xero connection and does not sync orders or stock. You still pay suppliers through your bank, receive stock in your warehouse or store tools, and enter costs in your accounting system yourself. If you post invoices to QuickBooks, how to get supplier invoices into QuickBooks Online and landed cost in QuickBooks cover that side.
A good way to start is with one supplier and one order that has a wrinkle, such as a partial receipt, a credit note, or a separate freight bill. Those cases tell you far more about a workflow than a clean sample invoice. Current plans are on the pricing page.
FAQ
What Does It Mean To Reconcile A Supplier Invoice To A Purchase Order?
It means comparing the supplier's bill with the approved PO and the record of what you received. You check the supplier, SKUs, quantities, unit prices, currency, and any extra charges. When they agree, the invoice is ready for payment.
What Is A Three-Way Match?
A three-way match compares the purchase order, the supplier invoice, and the receiving record. The PO shows what you agreed to buy, the invoice shows what the supplier wants paid, and the receiving record shows what arrived. Any difference becomes a variance to resolve.
What Should I Do If The Invoice Is Higher Than The PO?
Check for freight, tax, discounts, credits, and approved PO changes first. If the extra amount has no supporting record, hold the invoice and ask for a revised bill or written approval. Note the difference by line so the supplier can correct the exact issue.
Can Invoice Matching Be Automated For Amazon FBA And Shopify Sellers?
Parts of it can. Software can read supplier documents and keep them on the same record as the purchase order, which removes most of the retyping. SupplyAutomate works from the documents you upload and has no Amazon or Shopify connection, so receiving and sales data stay in those tools.
What Is The Difference Between Invoice Cost And Landed Cost?
Invoice cost is what the supplier charges for the goods and any listed charges. Landed cost adds the other costs of getting the stock to you, such as freight, duty, and samples, spread across the sellable units. Landed cost vs COGS explains how both relate to your books.
Related Guides
- How To Organize Supplier Invoices
- Invoice Matching Software For Ecommerce Sellers
- Invoice Processing Software
- Best Accounts Payable Automation Software For Ecommerce
- Creating A Purchase Order
- Purchase Order Management For Amazon FBA Sellers
- 30/70 Payment Terms With Chinese Suppliers
- FOB Vs EXW Vs DDP For FBA Sellers
- Landed Cost Per Unit
- Allocate Freight Cost Across Multiple SKUs
- How To Track Shipping And Manufacturing Costs
- How To Get Supplier Invoices Into QuickBooks Online
- Landed Cost Vs COGS
