Reconcile a multivendor customer order by recording expected and billed costs separately for each supplier, matching charges to item, order or parcel references, and tracking credits until they actually post. Delivery completion does not by itself settle supplier balances.
Close the customer order and the supplier balances
A customer buys two products in one checkout. You pay two dropshipping suppliers to fulfill the order, and each sends its own billing record. When both parcels arrive, the store marks the order delivered. The buyer still has to check whether each supplier charged the agreed amount, whether any freight was billed twice, and whether promised credits came through.
Set up a reconciliation sheet before you start selling products from multiple suppliers in the same basket. Give each supplier charge a place to land and assign someone to review the differences. The sheet should let a teammate answer three questions from the records alone. What did we expect to pay? What did we actually pay? What is still open?
Record the agreed charges before releasing orders
Keep one row per supplier order line, with the store order number repeated across all rows for that checkout. Include the supplier name, supplier order reference, product variant, quantity, currency, and agreed unit cost. If the same supplier bills freight once per parcel, give freight a separate row linked to that parcel or supplier order. This keeps the fee from being copied onto every item.
Keep the quote or rate sheet version beside the expected charge. The U.S. International Trade Administration describes a pro forma invoice as a quotation in invoice form and identifies item prices, payment terms, a delivery point, and a validity date as useful entries. Use those details to establish your expected charges, then record the supplier's actual bill in its own column. For a standing price list, confirm which date determines the rate when a customer order reaches the supplier.
International Trade Administration guidance on pro forma invoices
ChengBridge product sourcing support
Match charges to the event that triggered them
Ask each supplier which fees apply per item, per order, or per parcel, and what triggers each fee. Capture currency and the original billed amount before converting it for reporting. If a weekly statement combines dozens of orders, ask for the underlying order references and a breakdown of any adjustment. When the statement has a single freight total, request the parcel detail or document the allocation method you agreed with the supplier.
Keep estimated and billed costs separate. The International Trade Administration's landed cost guidance includes the product price, freight, insurance, applicable duties and taxes, and other fees. Use those categories to check which amounts belong in your order record and who pays each one. Keep a pending estimate visible until the corresponding bill arrives or the responsible party confirms the charge is settled.
International Trade Administration guidance on estimating landed cost
Compare shipping quotes using actual parcel scenarios
Hypothetical example of a duplicate freight charge
A store sells a desk mat and a cable sleeve in one checkout. Supplier A's agreed charge is $12 for the mat plus $5 to ship it. Supplier B's agreed charge is $4 for the sleeve plus $3 to ship it. The expected supplier total is $24. Supplier A bills $17 as expected. Supplier B bills $10 and lists the same $3 freight fee twice under one parcel reference. The two bills now total $27.
The buyer asks Supplier B to confirm the duplicate and attaches the quote, statement lines, and parcel reference. Supplier B agrees to put a $3 credit on the following week's statement. The buyer records $27 billed and $3 in credit pending. Once the credit appears against the supplier account, the buyer links it to the original order and closes the difference at $24. The record preserves both the original bill and the correction, so a teammate can explain the numbers later.
Give each open difference an owner
Decide who investigates a discrepancy, who can approve a documented extra cost, and who verifies that a credit posted. Include a due date and a link to the evidence on each open entry. Keep customer refunds and supplier credits in separate columns. A refund may already have gone to the customer while the supplier is still reviewing your request. Checking both columns keeps the customer resolution and the supplier balance visible.
Review recurring differences by supplier and charge type. If an agreed handling fee appears on every statement but is missing from your expected charges, update the rate sheet used for future orders and date the revision. If the fee is still disputed, retain the original rate and follow up using the affected order references.
Brief your fulfillment partner on returns and delivery exceptions
Checklist before your first multivendor settlement
Run one mixed basket through the sheet using the billing format each supplier expects to send. If a teammate can match the charges and follow a credit through to settlement, use the same fields for live orders. When contacting ChengBridge about sourcing support, share a redacted sample basket and the supplier charges you need to track.
Contact ChengBridge about multivendor sourcing support
- Confirm which order, item, and parcel references each supplier can include on its bill.
- Save the applicable rate sheet and record how each fee is triggered and billed.
- Assign an owner and a review date to each disputed charge or promised credit.
- Match credits to the original supplier order and confirm they appear on the account.
- Close each supplier balance once its charges and adjustments are accounted for.