Learn how to utilize the Walmart US API to retrieve a reconciliation report.
Note: This guide assumes that you have already setup the base structure of the project such as retrieving the access tokens. If you already haven’t done so, please refer to Walmart’s guide for access tokens.
What is a reconciliation report?
In the context of the Walmart US API, the Payment Reconciliation Report (often called the “Recon Report”) is a detailed financial statement that breaks down every single transaction related to a specific payment deposit.
It is not just a sales report. Its primary purpose is to help you “reconcile” the final payment amount you receive from Walmart with the orders you shipped. It meticulously details all the debits and credits to your account for a given period, including:
- Net Payout: The final calculated amount paid to you.
- Sales: The amount collected from the customer for your products.
- Commissions: The fees Walmart charges for each sale.
- Shipping: Shipping fees collected (and any shipping credits or charges).
- Taxes: Sales tax collected by Walmart.
- Adjustments: This is a critical category that includes returns, refund processing fees, cancellation penalties, and other corrections.
How to retrieve the report via the API?
Step 1
The first step to retrieve a report is to check the report dates that are available for a report. You cannot request a report that has not been generated.
Endpoint: https://marketplace.walmartapis.com/v3/report/reconreport/availableReconFiles?reportVersion=1
Find out the headers required and the response structure for this endpoint here: https://developer.walmart.com/us-marketplace/reference/getavailablev1reconreportdates-1
Step 2
After you get the available dates, you will need to download the report and save it to your local folder because it is available for only 30 days.
Endpoint: https://marketplace.walmartapis.com/v3/report/reconreport/reconFile?reportVersion=v1
Query PArams
| Query | Explanation |
|---|---|
| reportDate | The report date in MMddyyyy format, Even though the available recon reports endpoint responds in yyyyMMdd format. |
Headers
| Header | Value Expected |
|---|---|
| WM_SEC.ACCESS_TOKEN | <Your token value> |
| WM_QOS.CORRELATION_ID | <Random UUID> |
| WM_SVC.NAME | Walmart Service Name |
| Accept | application/octet-stream |
GET https://marketplace.walmartapis.com/v3/report/reconreport/reconFile?reportVersion=v1&reportDate=10152025
Host: marketplace.walmartapis.com
WM_SEC.ACCESS_TOKEN: e...A
WM_QOS.CORRELATION_ID: a1b2c3d4-e5f6-7890-g1h2-i3j4k5l6m7n8
WM_SVC.NAME: Walmart Service Name
Accept: application/octet-streamResponse
The response returned by an endpoint is a zip file which contains the csv.