- 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
- Payout or transaction reference shared by both files. Exact, case-sensitive match.
- component
- The fee type, e.g. referral_fee. Each fee component matches separately.
- currency
- USD, GBP, EUR or CAD. Currencies never combine or convert.
- value
- Nonnegative decimal, at most 2 places. No commas or symbols. Negative reversals are unsupported; prepare a documented net amount separately.
- 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.