Recon Batch · Sample report

Review required · USD · Example data. Flags show what needs a closer look. Check source records before raising a dispute.

Example: 60-order example · not customer results

59 orders included; 207 invoice rows included; 4 invoice rows need review.

Example data. Flagged amounts are not confirmed overcharges or recoverable money.

Validated supplier charges (net)$1713.17
Charges matched to supported orders$1636.42
Unmatched supplier charges$76.75
Supplier item costs$1329.92
Supplier fees (excluding credits)$388.25
Supplier credits (unallocated)$-5.00
Amounts flagged for review$135.69
Matched shipping and fulfillment costs$347.50
Customer shipping collected on compared orders$289.42
Shipping and fulfillment cost minus shipping collected$58.08
Order refunds (no SKU allocation)$106.97

The review total counts each flagged amount once. Shipping differences compare supplier costs with shipping collected from customers; a gap alone does not show a billing error. Credits, refunds, non-USD records, and unclear matches need separate review. Order-level refunds are not assigned to individual items.

Supplier charges to review

IDExceptionOrderSKUUSDSource recordsFindingAction
E00012Charge on canceled, unfulfilled, or refunded order#100915.95supplier_invoice: 32,33,34Supplier billed an order marked canceled, unfulfilled/restocked. Eligibility needs human review.Check fulfillment dates, cancellation/refund timing, and supplier agreement before disputing.
E00014Charge on canceled, unfulfilled, or refunded order#101045.74supplier_invoice: 35,36,37,38Supplier billed an order marked fully refunded. Eligibility needs human review.Check fulfillment dates, cancellation/refund timing, and supplier agreement before disputing.
E00016Product cost difference#1005SKU-A5.00supplier_invoice: 16Expected 12.00 per unit; at least one supplier unit cost differs.Review the source export and resolve before relying on this match.
E00017Quantity difference#1006SKU-Asupplier_invoice: 19Ordered 2; billed 3. Repeated rows included once in this comparison.Review the source export and resolve before relying on this match.
E00018Possible duplicate charge#1007SKU-Asupplier_invoice: 23,24Repeated order+SKU requires review; split shipments cannot be excluded without shipment-level evidence.Compare invoice IDs, shipments, and quantity totals before disputing repeated charges.
E00019Quantity difference#1007SKU-Asupplier_invoice: 23,24Ordered 2; billed 4. Repeated rows included once in this comparison.Review the source export and resolve before relying on this match.
E00020Possible duplicate charge#1008SKU-Asupplier_invoice: 27,28Repeated order+SKU requires review; split shipments cannot be excluded without shipment-level evidence.Compare invoice IDs, shipments, and quantity totals before disputing repeated charges.
E00021Quantity difference#1008SKU-Asupplier_invoice: 27,28Ordered 2; billed 4. Repeated rows included once in this comparison.Review the source export and resolve before relying on this match.
E00029Item not on order#1025UNORDERED-SKU9.00supplier_invoice: 212Billed SKU not present in the matched Shopify order.Review the source export and resolve before relying on this match.
E00030Unfulfilled item to review#1026SKU-Cshopify_orders: 40Billed SKU includes an unfulfilled line within a partially fulfilled order.Review the source export and resolve before relying on this match.

Supplier shipping and fulfillment vs customer shipping charges

IDExceptionOrderSKUUSDSource recordsFindingAction
E00031Shipping and fulfillment cost difference#10010.76supplier_invoice: 3,4Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00032Shipping and fulfillment cost difference#10020.76supplier_invoice: 7,8Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00033Shipping and fulfillment cost difference#10030.76supplier_invoice: 10,11Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00034Shipping and fulfillment cost difference#10040.76supplier_invoice: 14,15Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00035Shipping and fulfillment cost difference#10050.76supplier_invoice: 17,18Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00036Shipping and fulfillment cost difference#10060.76supplier_invoice: 21,22Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00037Shipping and fulfillment cost difference#10070.76supplier_invoice: 25,26Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00038Shipping and fulfillment cost difference#10080.76supplier_invoice: 30,31Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00039Shipping and fulfillment cost difference#10090.76supplier_invoice: 33,34Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00040Shipping and fulfillment cost difference#10100.76supplier_invoice: 37,38Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00041Shipping and fulfillment cost difference#10110.76supplier_invoice: 40,41Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00042Shipping and fulfillment cost difference#10120.76supplier_invoice: 44,45Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00043Shipping and fulfillment cost difference#10130.76supplier_invoice: 47,48Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00044Shipping and fulfillment cost difference#101514.76supplier_invoice: 50,51Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00045Shipping and fulfillment cost difference#10160.76supplier_invoice: 54,55Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00046Shipping and fulfillment cost difference#10170.76supplier_invoice: 57,58Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00047Shipping and fulfillment cost difference#10180.76supplier_invoice: 61,62Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00048Shipping and fulfillment cost difference#10200.76supplier_invoice: 68,69Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00049Shipping and fulfillment cost difference#10210.76supplier_invoice: 71,72Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00050Shipping and fulfillment cost difference#10220.76supplier_invoice: 75,76Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00051Shipping and fulfillment cost difference#10230.76supplier_invoice: 77,78Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00052Shipping and fulfillment cost difference#10240.76supplier_invoice: 81,82Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00053Shipping and fulfillment cost difference#10250.76supplier_invoice: 84,85Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00054Shipping and fulfillment cost difference#10260.76supplier_invoice: 88,89Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00055Shipping and fulfillment cost difference#10270.76supplier_invoice: 91,92Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00056Shipping and fulfillment cost difference#10280.76supplier_invoice: 95,96Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00057Shipping and fulfillment cost difference#10290.76supplier_invoice: 98,99Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00058Shipping and fulfillment cost difference#10300.76supplier_invoice: 102,103Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00059Shipping and fulfillment cost difference#10310.76supplier_invoice: 105,106Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00060Shipping and fulfillment cost difference#10320.76supplier_invoice: 109,110Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00061Shipping and fulfillment cost difference#10330.76supplier_invoice: 112,113Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00062Shipping and fulfillment cost difference#10340.76supplier_invoice: 116,117Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00063Shipping and fulfillment cost difference#10350.76supplier_invoice: 119,120Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00064Shipping and fulfillment cost difference#10360.76supplier_invoice: 123,124Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00065Shipping and fulfillment cost difference#10370.76supplier_invoice: 126,127Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00066Shipping and fulfillment cost difference#10380.76supplier_invoice: 130,131Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00067Shipping and fulfillment cost difference#10390.76supplier_invoice: 133,134Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00068Shipping and fulfillment cost difference#10400.76supplier_invoice: 137,138Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00069Shipping and fulfillment cost difference#10410.76supplier_invoice: 140,141Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00070Shipping and fulfillment cost difference#10420.76supplier_invoice: 144,145Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00071Shipping and fulfillment cost difference#10430.76supplier_invoice: 147,148Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00072Shipping and fulfillment cost difference#10440.76supplier_invoice: 151,152Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00073Shipping and fulfillment cost difference#10450.76supplier_invoice: 154,155Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00074Shipping and fulfillment cost difference#10460.76supplier_invoice: 158,159Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00075Shipping and fulfillment cost difference#10470.76supplier_invoice: 161,162Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00076Shipping and fulfillment cost difference#10480.76supplier_invoice: 165,166Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00077Shipping and fulfillment cost difference#10490.76supplier_invoice: 168,169Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00078Shipping and fulfillment cost difference#10500.76supplier_invoice: 172,173Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00079Shipping and fulfillment cost difference#10510.76supplier_invoice: 175,176Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00080Shipping and fulfillment cost difference#10520.76supplier_invoice: 179,180Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00081Shipping and fulfillment cost difference#10530.76supplier_invoice: 182,183Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00082Shipping and fulfillment cost difference#10540.76supplier_invoice: 186,187Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00083Shipping and fulfillment cost difference#10550.76supplier_invoice: 189,190Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00084Shipping and fulfillment cost difference#10560.76supplier_invoice: 193,194Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00085Shipping and fulfillment cost difference#10570.76supplier_invoice: 196,197Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00086Shipping and fulfillment cost difference#10580.76supplier_invoice: 200,201Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00087Shipping and fulfillment cost difference#10590.76supplier_invoice: 203,204Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.
E00088Shipping and fulfillment cost difference#10600.76supplier_invoice: 207,208Supplier shipping and fulfillment compared with customer shipping collected. This is not a proven billing error or a directly exported Shopify COGS total.Review contribution margin and supplier rates; a customer shipping subsidy can be intentional.

Refunds, missing matches, and records to review

IDExceptionOrderSKUUSDSource recordsFindingAction
E00001Source record needs review#1019shopify_orders: 29Order currency must be USDReview the source export and resolve before relying on this match.
E00002Source record needs review#1016SKU-Dsupplier_invoice: 52Supplier currency must be USD; amount excluded from USD totalsReview the source export and resolve before relying on this match.
E00003Source record needs review#1016SKU-Esupplier_invoice: 53Supplier currency must be USD; amount excluded from USD totalsReview the source export and resolve before relying on this match.
E00004Source record needs review#1017supplier_invoice: 56Invalid SKU; identifiers are never trimmed or rewrittenReview the source export and resolve before relying on this match.
E00005Source record needs review#1018SKU-Fsupplier_invoice: 59Arithmetic mismatch: Quantity * Unit Cost + explicit Fees != Line Total BilledReview the source export and resolve before relying on this match.
E00006Charge without a matching order#1019SKU-A24.00supplier_invoice: 63No unique supported Shopify order matches this exact reference (or account-level fee).Obtain the correct order export or verify the account-level charge.
E00007Charge without a matching order#10194.50supplier_invoice: 64No unique supported Shopify order matches this exact reference (or account-level fee).Obtain the correct order export or verify the account-level charge.
E00008Charge without a matching order#10191.25supplier_invoice: 65No unique supported Shopify order matches this exact reference (or account-level fee).Obtain the correct order export or verify the account-level charge.
E00009Charge without a matching order#9999SKU-A12.00supplier_invoice: 209No unique supported Shopify order matches this exact reference (or account-level fee).Obtain the correct order export or verify the account-level charge.
E00010Charge without a matching order35.00supplier_invoice: 210No unique supported Shopify order matches this exact reference (or account-level fee).Obtain the correct order export or verify the account-level charge.
E00011Credit to review#1022-5.00supplier_invoice: 211Credit retained in signed invoice ledger; not automatically netted against a disputed SKU.Review the source export and resolve before relying on this match.
E00013Refund needs item details#101096.97shopify_orders: 15,16Order-level refund has no SKU allocation; expected quantities and costs are unchanged.Obtain refund line-item detail; do not prorate the order-level refund across SKUs.
E00015Refund needs item details#101210.00shopify_orders: 18,19Order-level refund has no SKU allocation; expected quantities and costs are unchanged.Obtain refund line-item detail; do not prorate the order-level refund across SKUs.
E00022Missing invoice match#1014SKU-B16.50shopify_orders: 21Fulfilled Shopify SKU has no accepted supplier item billing row.Obtain the supplier invoice; quarantined rows do not establish a match.
E00023Missing invoice match#1014SKU-C5.10shopify_orders: 22Fulfilled Shopify SKU has no accepted supplier item billing row.Obtain the supplier invoice; quarantined rows do not establish a match.
E00024Missing item match#1016SKU-D36.00shopify_orders: 24Fulfilled Shopify SKU has no accepted supplier item billing row.Obtain the supplier invoice; quarantined rows do not establish a match.
E00025Missing item match#1016SKU-E3.99shopify_orders: 25Fulfilled Shopify SKU has no accepted supplier item billing row.Obtain the supplier invoice; quarantined rows do not establish a match.
E00026Missing item match#1017SKU-E7.98shopify_orders: 26Fulfilled Shopify SKU has no accepted supplier item billing row.Obtain the supplier invoice; quarantined rows do not establish a match.
E00027Missing item match#1018SKU-F15.00shopify_orders: 27Fulfilled Shopify SKU has no accepted supplier item billing row.Obtain the supplier invoice; quarantined rows do not establish a match.
E00028Missing item match#1023SKU-E7.98shopify_orders: 35Fulfilled Shopify SKU has no accepted supplier item billing row.Obtain the supplier invoice; quarantined rows do not establish a match.

Source file references

The detailed report includes source rows, records needing review, and definitions for each total.