{"example_only":true,"service":"etsy_currency_conversion_reconciler","note":"Illustrative output from synthetic product facts; paid results depend on supplied facts.","name":"Etsy Currency Conversion Fee + Payout Reconciler","marketplace":"etsy","input_summary":{"report_type":"seller-redacted Etsy currency-conversion sale rows","as_of_date":"2026-08-31","row_count":5,"payment_account_currency":"CAD","currency_pairs":["USD/CAD","EUR/CAD"],"basis":"seller-supplied sale amounts, exchange rates, fee rates, and recorded Payment-account amounts"},"output":{"row_count":5,"currency_pair_count":2,"total_reported_converted_gross":597.0,"total_recomputed_converted_gross":596.6,"total_reported_conversion_fee":15.44,"total_recomputed_conversion_fee":14.92,"total_recorded_post_fee_proceeds":581.31,"total_recomputed_post_fee_proceeds":581.68,"possible_fee_overcharge_exposure":0.52,"possible_proceeds_shortfall":0.75,"mismatch_row_count":3,"high_fee_exposure_count":1,"review_queue_preview":[{"priority_rank":1,"reference":"FX-VASE","currency_pair":"USD/CAD","computed_conversion_fee":2.7,"recorded_conversion_fee":3.2,"conversion_fee_discrepancy":0.5,"post_fee_proceeds_discrepancy":-0.5,"status":"review_multiple"},{"priority_rank":2,"reference":"FX-LAMP","currency_pair":"USD/CAD","computed_converted_gross":135.0,"recorded_converted_gross":135.4,"converted_gross_discrepancy":0.4,"status":"review_multiple"},{"priority_rank":3,"reference":"FX-DESK","currency_pair":"USD/CAD","post_fee_proceeds_discrepancy":-0.25,"recorded_identity_discrepancy":0.25,"status":"review_multiple"}],"currency_pair_summaries":[{"shop_currency":"USD","payment_account_currency":"CAD","row_count":4,"reported_conversion_fee":14.7,"recomputed_conversion_fee":14.18,"possible_fee_overcharge_exposure":0.52,"possible_proceeds_shortfall":0.75,"mismatch_row_count":3},{"shop_currency":"EUR","payment_account_currency":"CAD","row_count":1,"reported_conversion_fee":0.74,"recomputed_conversion_fee":0.74,"mismatch_row_count":0}],"publish_status":"draft_needs_review","safety":"Arithmetic on seller-supplied sale amounts, exchange rates, fee rates, and recorded Payment-account amounts only. No market rate is looked up, no applicability is decided, no charge is called wrong, and no listing, shop currency, deposit, payment setting, or account is changed."}}