What you receive
- Per-return expected refund or collection from supplied values
- Remaining refund due and remaining collection due, kept separate
- Arithmetic-mismatch queue for settlements the math cannot support
- Partially-processed, even-exchange, and settled context bands
- Status summaries with outstanding and unexplained totals
Who it is for
Shopify merchants and bookkeepers reviewing a month of returns and exchanges where partial processing and return fees make double refunds or missed collections easy to miss.
Delivery: usually a structured result, workbook, or ZIP depending on the tool.
How it stays safe
Friday performs arithmetic only on seller-supplied return dates, references, order aliases, currency, returned-item values, exchange-item values, return-shipping fees, restocking fees, already-issued refunds, and already-collected balances. It reads no Shopify admin, order, return, refund, or payment record and verifies no source field. Shopify alone determines return eligibility, the actual return fees, refund amounts, and amounts to collect. A queue entry is a bookkeeping review lead, not proof that a refund is owed, a balance is collectible, or a settlement was wrong. Friday decides no eligibility, issues no refund or invoice, reserves no inventory, contacts no customer, files no dispute, moves no money, changes no order, return, payout, or store account, and does not publish listings.
Synthetic sample
See the deliverable structure before buying
{
"row_count": 6,
"mismatch_count": 1,
"refund_due_count": 1,
"collection_due_count": 1,
"partially_processed_count": 1,
"even_exchange_count": 1,
"settled_count": 1,
"high_exposure_count": 4,
"total_returned_item_value": 345.0,
"total_exchange_item_value": 135.0,
"total_return_shipping_fees": 22.0,
"total_restocking_fees": 25.5,
"total_expected_refunds": 192.5,
"total_refunds_issued": 108.5,
"total_remaining_refund_due": 107.0,
"total_expected_collections": 30.0,
"total_balance_collected": 0.0,
"total_remaining_collection_due": 30.0,
"possible_over_refund_total": 23.0,
"possible_over_collection_total": 0.0,
"review_queue_preview": [
{
"priority_rank": 1,
"reference": "NW-RET-005",
"status": "review_arithmetic_mismatch",
"expected_refund": 23.0,
"refund_issued": 46.0,
"possible_over_refund": 23.0
},
{
"priority_rank": 2,
"reference": "NW-RET-001",
"status": "customer_refund_due",
"expected_refund": 66.0,
"remaining_refund_due": 66.0
},
{
"priority_rank": 3,
"reference": "NW-RET-002",
"status": "merchant_collection_due",
"expected_collection": 30.0,
"remaining_collection_due": 30.0
},
{
"priority_rank": 4,
"reference": "NW-RET-004",
"status": "partially_processed",
"expected_refund": 81.0,
"refund_issued": 40.0,
"remaining_refund_due": 41.0
}
],
"status_summaries": [
{
"status": "review_arithmetic_mismatch",
"row_count": 1,
"outstanding_amount": 0.0,
"unexplained_amount": 23.0
},
{
"status": "customer_refund_due",
"row_count": 1,
"outstanding_amount": 66.0,
"unexplained_amount": 0.0
},
{
"status": "merchant_collection_due",
"row_count": 1,
"outstanding_amount": 30.0,
"unexplained_amount": 0.0
}
],
"publish_status": "draft_needs_review",
"safety": "Arithmetic on seller-supplied return, exchange, fee, refund, and collection amounts only. It reads no Shopify admin, order, return, refund, or payment record, decides no return eligibility, issues no refund or invoice, contacts no customer, moves no money, publishes no listing, and changes nothing."
}
This sample uses synthetic facts. Your output is generated only from the facts you submit.