Guides
My Account

Recon Report JSON

Overview

The Recon Report JSON API is a report of transactions, payouts, fees, refunds, and other financial activities in the JSON file format.

Endpoint

GET <https://marketplace.walmartapis.com/v3/report/reconreport/reconFileJson>

Functionality

This API helps you perform:

  • Settlement reconciliation
  • Order-level payment verification
  • Commission and fee auditing
  • Refund and adjustment tracking
  • ERP and accounting system integration

Request sample

curl --request GET \ --url https://marketplace.walmartapis.com/v3/report/reconreport/reconFileJson \ --header 'accept: application/json'

Modify your code

1. Add authentication headers

Include required Walmart Marketplace authentication headers, such as:

  • OAuth access token
  • Consumer ID (if applicable)
  • Correlation ID (recommended for tracing)

2. Automate reconciliation

For production workflows:

  • Schedule a daily reconciliation or settlement-cycle retrieval
  • Store retrieved JSON securely
  • Log transaction timestamps and reconciliation

Response sample

{ "reportData": [ { "Period Start Date": "12/11/2025", "Period End Date": "12/19/2025", "Currency": "USD", "Transaction Type": "PaymentSummary", "Total Payable": "0.74", "Transaction Description": "Deposited in account", "Transaction Posted Timestamp": "01/02/2025" }, { "Shipping Method": "Marketplace value", "Partner Item Name": "MTV Mens Kanji Throwback 90s Logo Short Sleeve Graphic T-shirt With Music Television up to Size 3XL", "Customer Order line #": "1", "Contract Category": "Apparel & Accessories", "Transaction Description": "Purchase", "Product Tax Code": "100", "Period Start Date": "\"\"", "Ship to Zipcode": "72712", "Ship to City": "Bentonville", "Transaction Key": "2020_12_19_317", "Transaction Posted Timestamp": "12/18/2020", "Ship Qty": "1", "Amount": "14.98", "Transaction Type": "Sale", "Partner GTIN": "12345678901234", "Ship to State": "AR", "Amount Type": "Product Price", "Fulfillment Type": "Seller Fulfilled", "Customer Order #": "12345123451234", "Purchase Order #": "1231231231231", "Product Type": "Bag Clips", "Partner Item Id": "sku-123", "Purchase Order line #": "1" } ], "nextOffset": 973, "totalRecords": 1, "description": "Number of Lines in file 479 "
}

Result

The API returns the following fields:

  • reportData: Provides report data with transaction-level entries.
  • nextOffset: Indicates additional data may be available.
  • totalRecords: Shows the number of records returned in the current response.
  • description: Provides metadata about the report file.

This format allows direct ingestion into financial systems without parsing CSV or binary files.

Next Steps

Recon report (Legacy)

The Recon report (Legacy) API generates transaction-level details about your account, such as IDs, adjustments, refunds, commissions, shipping fees, and settlement totals. The recon report is generated in CSV file format for legacy systems that aren’t JSON compatible.

Recon report

The Recon report provides data about your settlements, order transactions, commissions, shipping fees, taxes, adjustments, and refund information. This API has the latest API standards with more advanced functionality and improvements.

Available recon report dates (Legacy)

The Available recon report dates (Legacy) provides date ranges available to download in the recon report.

Available recon report dates

The available recon report dates provides the date ranges available to download in the recon report.

Payment statement report

The Payment statement report Is a high-level overview of the payouts on your account after the settlement cycle has closed.

Performance report

The Performance report details the payment performance on your account, so you can see how payments are performing during the current cycle.

Updated about 2 hours ago