How to Reconcile AliDropship Order Costs Against Store Payouts
Margin trouble rarely shows up as a single bad order. It shows up as a payout that feels smaller than the sales dashboard promised. The fix is a monthly reconciliation routine where you take one closed settlement period and prove, order by order, that supplier cost plus fees plus shipping equals what actually landed in your bank account. Stores running on AliDropship have an advantage here, because order data, supplier cost and tracking all sit in the same system instead of being scattered across three exports you have to stitch together by hand.
Pick a period that has finished settling. A week that ended at least three days ago is ideal, because most shipping exceptions, chargebacks and refunds have already posted by then. Export every order from that window with the supplier price, the shipping charge, the payment processing fee and any refund or partial refund applied to it. Then pull the matching settlement report from your payment processor so you have the payout side of the ledger. Two files, one fixed period, joined on order number.
Build three columns for each order. The first is what the customer paid, including any shipping collected at checkout. The second is what you paid out: product cost, shipping cost, payment fee and a per-order share of your app subscriptions. The third is the difference between them. Most sellers only ever look at total revenue and total spend, which hides the uncomfortable fact that a slice of orders lost money while the store average still looked healthy. Per-order contribution is the only number that tells you which products deserve more traffic.
Work the exceptions next. Every order where the gap is negative or suspiciously positive needs a reason written next to it. A negative gap usually means a shipping upgrade you forgot to bill, a refund issued after the supplier had already shipped, or a currency conversion you never priced in. A suspiciously positive gap often means the customer paid for a faster service than the supplier actually delivered, which is a promise you cannot afford to break twice. Count how often each reason appears across the period.
Turn the repeat offenders into standing rules. If shipping upgrades are costing you four points of contribution, sell the upgrade as a paid option at checkout instead of absorbing it silently. If refunds after shipment keep showing up, tighten the cancellation window shown on the product page and confirm stock before the order is pushed to the supplier. If currency drift is the pattern, rebuild your price floor in the currency you actually settle in. Every rule should remove a line item you can verify again next month, rather than just producing a feeling that things improved.
Run the routine once a month and keep twelve periods stacked in one sheet. The trend matters far more than any single month, because a slow drift in processor fees or supplier prices will never trigger an alert, yet it will quietly take two points of margin over a year. The DTCwise AliDropship listing at /tool/alidropship keeps current pricing and feature notes, and the Dropshipping category at /category/dropshipping keeps the current shortlist with ratings and pricing.