{"example_only":true,"service":"walmart_sem_billing_reconciler","note":"Illustrative output from synthetic product facts; paid results depend on supplied facts.","name":"Walmart SEM Billing Charge + Credit Reconciler","marketplace":"walmart_us","input_summary":{"report_label":"Northwind Walmart SEM billing reconciliation — May 2026","reporting_currency":"USD","billing_row_count":7,"performance_period_count":4,"amount_match_tolerance":0.05,"minimum_gap_days":1,"basis":"synthetic seller-supplied billing-history rows (invoice date, billing window, status, signed amount, currency, payment mode) and aggregate SEM performance spend periods"},"output":{"reporting_currency_row_count":6,"excluded_currency_row_count":1,"charge_row_count":5,"credit_row_count":1,"non_success_row_count":1,"overlapping_charge_window_count":2,"amount_mismatch_count":1,"reconciled_charge_count":2,"comparison_suppressed_count":2,"gross_ad_spend_charges":585.5,"total_credits_and_adjustments":35.0,"net_signed_amount":-550.5,"net_ad_spend_after_credits":550.5,"compared_billed_charge_total":410.0,"compared_ad_spend_total":398.73,"compared_variance_total":11.27,"uncovered_performance_period_count":1,"uncovered_ad_spend_total":62.4,"coverage_gaps":[{"gap_start":"2026-05-22","gap_end":"2026-05-23","uncovered_days":2}],"reconciliation_queue_preview":[{"priority_rank":1,"row_reference":"BILL-2026-05-E","reconciliation_status":"non_success_status","issue_flags":["non_success_status","overlapping_charge_window"],"supplied_status":"FAILED","signed_amount":-95.5,"dollar_exposure":95.5},{"priority_rank":2,"row_reference":"BILL-2026-05-G","reconciliation_status":"currency_excluded","currency":"CAD","dollar_exposure":40.0},{"priority_rank":3,"row_reference":"BILL-2026-06-F","reconciliation_status":"overlapping_charge_window","comparison_state":"suppressed_overlap","dollar_exposure":80.0},{"priority_rank":4,"row_reference":"BILL-2026-05-B","reconciliation_status":"amount_mismatch","billed_charge":140.0,"matched_ad_spend":128.75,"spend_variance":11.25}],"publish_status":"draft_needs_review","safety":"Deterministic reconciliation of seller-supplied aggregate billing and spend rows only. No mismatch proves a Walmart invoice is incorrect, and no campaign, budget, bid, payment method, or listing is changed."}}