What you receive
- Cent-rounded commission and payment-processing fee recomputes
- Independent recorded-fee and net-proceeds comparisons
- Fee-and-net, fee-only, and net-only review bands
- Directional exposure totals that never cancel each other
- Commission versus payment-processing component summaries
Who it is for
TCGplayer sellers and bookkeepers checking seller-redacted completed-order rows against the fee terms shown in their own source records before a human reviews any payout question.
Delivery: usually a structured result, workbook, or ZIP depending on the tool.
How it stays safe
Friday performs arithmetic only on seller-supplied sale dates, references, listing and SKU aliases, currency, proceeds-before-fees basis, fee bases, percentages, flat amounts, recorded deductions, and recorded net proceeds. It reads no TCGplayer account, Seller Portal, sales report, payout record, order, listing, or fee schedule and verifies no source field. TCGplayer alone determines the applicable fee structure, bases, taxes, shipping treatment, refunds, and actual net proceeds. A difference is a bookkeeping review lead, not proof of a wrong charge, missing payout, refund, credit, or amount owed. Friday opens no case, files no dispute, requests no credit, moves no money, changes no listing, price, shipping, payout, or seller account, and does not publish listings.
Synthetic sample
See the deliverable structure before buying
{
"row_count": 5,
"mismatch_count": 3,
"fee_mismatch_count": 2,
"net_proceeds_mismatch_count": 2,
"high_exposure_count": 1,
"total_proceeds_before_fees": 196.0,
"total_recomputed_commission_fee": 19.6,
"total_recorded_commission_fee": 19.6,
"total_recomputed_processing_fee": 6.4,
"total_recorded_processing_fee": 6.65,
"total_recomputed_fee": 26.0,
"total_recorded_fee": 26.25,
"total_recomputed_net_proceeds": 170.0,
"total_recorded_net_proceeds": 169.5,
"possible_fee_overcharge": 0.5,
"recorded_below_recomputed_fee": 0.25,
"possible_net_proceeds_shortfall": 0.5,
"recorded_above_recomputed_net_proceeds": 0.0,
"review_queue_preview": [
{
"priority_rank": 1,
"reference": "NW-TCG-001",
"status": "review_fee_and_net_mismatch",
"commission_fee_discrepancy": 0.25,
"processing_fee_discrepancy": 0.0,
"net_proceeds_discrepancy": -0.25,
"possible_fee_overcharge": 0.25,
"possible_net_proceeds_shortfall": 0.25
},
{
"priority_rank": 2,
"reference": "NW-TCG-003",
"status": "review_fee_mismatch",
"commission_fee_discrepancy": -0.25,
"processing_fee_discrepancy": 0.25,
"total_fee_discrepancy": 0.0
},
{
"priority_rank": 3,
"reference": "NW-TCG-002",
"status": "review_net_mismatch",
"net_proceeds_discrepancy": -0.25
}
],
"component_summaries": [
{
"component": "commission",
"recomputed_amount": 19.6,
"recorded_amount": 19.6,
"possible_overcharge": 0.25,
"recorded_below_recomputed": 0.25,
"mismatch_count": 2
},
{
"component": "payment_processing",
"recomputed_amount": 6.4,
"recorded_amount": 6.65,
"possible_overcharge": 0.25,
"recorded_below_recomputed": 0.0,
"mismatch_count": 1
}
],
"publish_status": "draft_needs_review",
"safety": "Arithmetic on seller-supplied fee terms, recorded deductions, and net proceeds only. It reads no TCGplayer account or payout record, embeds no fee schedule, claims no charge wrong or payout owed, files no dispute, moves no money, publishes no listing, and changes nothing."
}
This sample uses synthetic facts. Your output is generated only from the facts you submit.