A supplier invoice can have the right total number of orders and still contain expensive mistakes. One canceled order may remain billed, a replacement shipment may have been charged as a new sale, and a promised credit may never have reached your account. A quick comparison with store revenue will not reveal those differences.
Supplier reconciliation means matching each billed item and shipping charge to an accepted supplier order, then checking payments and credits separately. The customer’s payment, the supplier’s charge and the movement of money through a prepaid wallet are different records. Mixing them together makes both overcharges and missing charges harder to identify.
Start with a matching key that survives the whole order
Keep the store order number, supplier order number, line identifier and shipment reference together. A customer name is a poor matching key: the same customer can place several orders, and names may be abbreviated differently across systems.
A store order can also produce several supplier orders or several shipments. Build the reconciliation at the lowest useful level, usually the supplier order line plus any related shipment charges. Preserve those relationships instead of forcing every invoice row into one row per customer checkout.
For each line, retain the accepted quantity, currency, agreed unit cost and any approved change. The accepted cost matters more than today’s supplier feed. A current feed may contain a newer price that was never agreed for the order under review.
Use three separate checks
| Check | Compare | Typical discrepancy |
|---|---|---|
| Order against invoice | Accepted items, quantities, prices and shipping terms | Wrong price, duplicated line or unexplained surcharge |
| Invoice against payment | Invoice amount, credit notes and money applied | Duplicate payment or payment allocated to the wrong invoice |
| Return or cancellation against credit | Supplier acceptance, expected amount and issued credit | Approved refund that never reaches the ledger |
A difference is a question to resolve, not automatic proof of wrongdoing. For example, a shipping adjustment may be valid under the agreed terms. It still needs an explanation and a connection to the correct parcel.
A small example shows why totals are not enough
Suppose a supplier accepted three orders. Order A contains two units at $12 each with $5 shipping, so its expected charge is $29. Order B totals $23. Order C was canceled and the supplier confirmed cancellation before dispatch, with no charge under the agreement. The expected total is $52.
The invoice shows $29 for A, $23 for B, a second $5 shipping line for A and $17 for C. The total is $74. The $22 difference has two causes that need different evidence: a possible duplicate shipping charge and a canceled order still being billed.
If the supplier later issues a $17 credit, the remaining unexplained difference is $5. Closing the entire query because “a credit arrived” would leave that second issue unresolved. These figures are an illustrative example, not typical supplier fees.
Do not count a wallet top-up as another purchase
A prepaid supplier wallet adds a second layer. You transfer money in, the supplier deducts order charges, and credits may return to the wallet rather than your bank. The top-up funds purchases; it should not be counted again as an additional product cost in an operational margin calculation.
A basic wallet check is: opening balance plus top-ups plus credits, minus deductions and withdrawals, equals the expected closing balance. Keep currency conversion and wallet fees separate so they do not disguise missing order credits.
Reconcile each currency first. Converting every row at a different rate before matching can create apparent discrepancies that are actually exchange-rate differences. The accounting treatment of balances, fees and taxes should follow the business’s accounting policy.
Give replacement shipments their own reason code
A replacement can look exactly like a new purchase in the supplier portal. Link it to the original order and record why it exists: missing item, transit damage, wrong variant or another agreed reason. Attach the supplier’s decision about who pays for the item and the additional shipping.
Do not assume every replacement is free, or that every return receives a full credit. Compare the charge with the agreement for that particular case. A written resolution prevents a support conversation from disappearing when the next invoice arrives.
Keep a credit register until money or an offset actually arrives
Track the case reference, supplier acceptance date, expected credit, document received and where the credit was applied. Separate “supplier agreed” from “credit issued” and “credit applied.” Those stages can happen on different dates.
For a partial return, show the returned quantity rather than marking the whole order as refunded. For a credit already applied to an invoice, prevent it from being claimed again. The same discipline protects against underpayment as well as overpayment.
Send a discrepancy list someone can act on
One clear row per issue is usually more useful than a long email about a wrong total. Include the invoice and line reference, expected amount, billed amount, difference, reason and supporting record. Ask the supplier to confirm whether the resolution will be a corrected invoice, a credit or a justified charge.
Before releasing payment, route unresolved amounts through the agreed approval process and payment terms. Once a case is resolved, update the original row with the evidence and final amount. A reconciliation is finished when each difference has a documented outcome, not merely when the spreadsheet happens to balance.
admin
Author of practical guides to dropshipping, ecommerce, automation, and growing an online business.