{"example_only":true,"service":"etsy_shipping_cost_reconciler","note":"Illustrative output from synthetic product facts; paid results depend on supplied facts.","name":"Etsy Collected-Shipping vs Label-Cost Reconciler","marketplace":"etsy_us","input_summary":{"report_type":"seller-redacted Etsy shipping collections and supplied costs","period_start":"2026-08-01","period_end":"2026-08-10","row_count":6,"reporting_currency":"USD","amount_tolerance":0.02,"high_subsidy_threshold":5.0},"output":{"row_count":6,"total_shipping_collected":29.0,"total_label_cost":35.25,"total_packaging_cost":5.75,"total_shipping_cost":41.0,"net_shipping_gap":-12.0,"shipping_subsidy_exposure":15.0,"shipping_surplus":3.0,"shortfall_count":4,"free_shipping_row_count":2,"free_shipping_subsidy":12.5,"buyer_paid_shortfall_count":2,"buyer_paid_shortfall":2.5,"high_subsidy_count":2,"review_queue_preview":[{"priority_rank":1,"reference":"NW-SHIP-001","shipping_profile_alias":"FREE-SHIPPING","shipping_collected":0.0,"total_shipping_cost":7.5,"shipping_subsidy":7.5,"status":"review_free_shipping_subsidy"},{"priority_rank":3,"reference":"NW-SHIP-002","shipping_profile_alias":"STANDARD","shipping_collected":5.0,"total_shipping_cost":7.0,"shipping_subsidy":2.0,"status":"review_buyer_paid_shortfall"}],"profile_summary_preview":[{"shipping_profile_alias":"FREE-SHIPPING","row_count":2,"shipping_subsidy":12.5,"shipping_surplus":0.0,"shortfall_count":2},{"shipping_profile_alias":"STANDARD","row_count":3,"shipping_subsidy":2.5,"shipping_surplus":2.0,"shortfall_count":2}],"publish_status":"draft_needs_review","safety":"Comparison of seller-supplied shipping collections, label costs, and packaging costs only. A negative gap is not whole-order loss or proof a profile or label charge is wrong, and nothing is purchased or changed."}}