Free · No account required · CSV template tool

Return Match

Compare expected return quantities with received quantities by return reference and SKU.

Switching tools or leaving this page clears the working session. Download results first.

Marketplace context

Use payout references for bank matching, transaction plus fee type for Fee Check, and return reference plus SKU for Return Match. Report requirements

1. Prepare the two templates

Copy values from your source exports into these exact columns. Retain original reports separately. This tool does not recognize native marketplace headers, calculate contractual fees, convert currencies, or infer missing references.

Column definitions and matching rules

row_id: A unique ID for each source record within each file. Duplicate IDs block the run.
account: Stable seller account/provider ID. Must match exactly between the two files.
reference: Return reference, not simply the order ID.
component: The product SKU. Returns match by reference and SKU.
currency: Use UNIT for all quantity rows.
value: Nonnegative whole-unit quantity.
state: Expected: ready or pending. Actual: ready only. Include only posted/confirmed actual records. Pending expectations remain pending even if values match.
Grouping: One expected row per account/reference/component/currency. Several distinct actual rows may match it, for partial receipts. Duplicate-looking events with different row IDs require your review.

Both files must cover the same scope and cutoff. Missing matches can mean timing, incomplete evidence or mismatched keys. They are not automatically discrepancies owed to you. Maximum 10,000 records and 2 MB per file. No tolerance is applied: a one-cent difference is shown.

2. Add your prepared CSVs

Expected returnsReceived returns

I prepared these records from documented sources, checked for duplicates, and used the same account, period, currency and matching references in both files. Expected values are my responsibility.

These files are processed in this browser and are not uploaded or saved to your account. Download your result before leaving. The existing inventory workspace has a separate upload-and-save workflow.