What you receive
- Recomputed fee, cap-applied flag, and gross-after-ad-fee for every order
- Recorded-versus-recomputed fee discrepancy with your own tolerance
- Contribution after your supplied product and fulfillment costs
- Queue ranked by fee mismatch, then negative and thin contribution
- Per-rate-band summaries and transparent rounding notes for human review
Who it is for
Etsy sellers, agencies, and finance teams checking a seller-supplied Offsite Ads export for miscapped fees or unprofitable attributed orders before a human reviews the Payment-account rows.
Delivery: usually a structured result, workbook, or ZIP depending on the tool.
How it stays safe
Friday performs arithmetic only on the order dates, listing aliases, currency, order totals, applicable rate percentages, per-order cap, recorded fees, and product and fulfillment costs you provide. It reads no Etsy account, Payment-account ledger, Offsite Ads record, or order and verifies no field. A fee discrepancy is between your supplied fields for human review—not a finding that a charge is wrong or that a refund or credit is available—and Friday decides no attribution or program eligibility. Friday opens no case, opts no shop in or out, changes no ad, listing, or price, does not publish listings, and does not modify a seller account.
Synthetic sample
See the deliverable structure before buying
{
"row_count": 5,
"total_order_total": 1045.0,
"total_computed_offsite_ads_fee": 119.35,
"total_recorded_offsite_ads_fee": 12.5,
"rows_with_recorded_fee": 2,
"total_fee_discrepancy": 0.5,
"fee_mismatch_count": 1,
"cap_applied_count": 1,
"rows_with_costs": 4,
"total_contribution": 85.9,
"negative_contribution_count": 1,
"thin_contribution_count": 1,
"negative_contribution_exposure": 4.6,
"review_queue_preview": [
{
"priority_rank": 1,
"reference": "NW-OA-001",
"listing_alias": "NW-CANDLE-08",
"rate_band": "15.0%",
"computed_offsite_ads_fee": 6.0,
"cap_applied": false,
"recorded_offsite_ads_fee": 6.5,
"fee_discrepancy": 0.5,
"contribution": 8.5,
"status": "review_fee_math"
},
{
"priority_rank": 2,
"reference": "NW-OA-003",
"listing_alias": "NW-MUG-12",
"rate_band": "12.0%",
"computed_offsite_ads_fee": 3.6,
"cap_applied": false,
"recorded_offsite_ads_fee": null,
"contribution": -4.6,
"status": "review_negative_contribution"
}
],
"publish_status": "draft_needs_review",
"safety": "Arithmetic on seller-supplied Offsite Ads fields only. A fee discrepancy is not a finding that Etsy charged incorrectly or that a credit is due, and no attribution, ad, listing, price, or account is decided or changed."
}
This sample uses synthetic facts. Your output is generated only from the facts you submit.