Does the journal entry match my Walmart payout?

The converter adds every row and compares the result with Total Payable from the PaymentSummary row, and the bank line always uses Total Payable. If the rows add up to something else, a warning names the difference and the gap goes to the clearing account. We have not confirmed this check on a complete real report yet.

How is the sales tax Walmart collects booked?

Where Walmart collects and pays the tax as marketplace facilitator, the report has the tax and the same amount withheld, so the two lines net to zero. Tax Walmart did not keep is named in a warning and goes to "Sales Tax / VAT Payable", not to income.

Why is commission positive on a refund?

When Walmart refunds an order it gives back the commission it took, so the commission row on a refund is positive. The converter keeps each row's own sign, so the commission line is what Walmart actually kept.

Walmart Marketplace recon report converter

Walmart's recon report is a CSV with one PaymentSummary row (the period, the currency and Total Payable, the payout) and one row per part of each order line: product price, shipping, commission, tax and tax withheld, plus adjustments such as shipping label charges.

Convert a Walmart Marketplace recon report

Walmart recon report to QuickBooks journal entry

Choose file

Recon (reconciliation) report .csv for one payment period

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

What is in a Walmart recon report?

Each row has a Transaction Type (Sale, Refund, Adjustment), an Amount Type (Product Price, Shipping, Commission on Product, Commission on Shipping, Product tax, Product tax withheld, Shipping tax, Shipping tax withheld, Fee/Reimbursement) and a signed Amount. One sale line is usually four to eight rows. The PaymentSummary row carries Total Payable, the amount Walmart paid out for the period.

The converter adds every row and compares the result with Total Payable. If they differ, a WARNING names the difference and the gap goes to the clearing account; the bank line always uses Total Payable.

Rows are grouped into named lines: product sales, shipping charged to buyers, refunds, Walmart commission (given back on refunds), shipping labels, sales tax charged to buyers, and sales tax kept by Walmart as marketplace facilitator.

What is not confirmed or not handled: only part of one real report is public, so the total check has not been confirmed on a complete real report. The entry is dated on the PaymentSummary row's posted date, which we read as the payout date. Adjustments other than shipping label charges, and amount types we have not seen, are kept on their own line and listed in a warning. One report per file. The JSON form of the report is refused. We have not imported the converted files into a real QuickBooks or Xero account yet.

Choose where it is going

How to export from Walmart Seller Center

In Walmart Seller Center open Payments and find the payment period you want.
Download the reconciliation (recon) report for that period as CSV.
Upload that file here as downloaded, without opening and re-saving it in a spreadsheet.

What to know about Walmart recon report files

The first row after the header is a PaymentSummary row with the period dates, the currency and Total Payable (the payout); every other row is one part of an order line: Transaction Type (Sale, Refund, Adjustment), Amount Type (Product Price, Shipping, Commission on Product, Commission on Shipping, product and shipping tax and tax withheld, Fee/Reimbursement) and a signed Amount.
Every row is added up and compared with Total Payable. If they differ, you get a WARNING with the difference and the gap goes to the clearing account. We have not seen a complete real report, so the check itself is not yet confirmed on real data.
The report becomes named lines (product sales, shipping, refunds, Walmart commission, shipping labels, sales tax charged and kept by Walmart as marketplace facilitator) plus the payout, all dated on the PaymentSummary row's posted date.
Commission on a refund is positive (Walmart gives it back), so commission is read with its own sign, never forced negative.
Adjustment rows other than shipping label charges, and any Amount Type we have not seen, are kept on their own line and listed in a warning. One report and one payout per file; several PaymentSummary rows are refused. The JSON form of the report is refused by name: download the CSV.
Bank-style files (.qbo, .qfx, .ofx, QuickBooks Online CSV, Xero CSV) go into a separate Walmart clearing account, not your checking account: the last line moves the payout to your bank.

Questions

Does the journal entry match my Walmart payout?: The converter adds every row and compares the result with Total Payable from the PaymentSummary row, and the bank line always uses Total Payable. If the rows add up to something else, a warning names the difference and the gap goes to the clearing account. We have not confirmed this check on a complete real report yet.
How is the sales tax Walmart collects booked?: Where Walmart collects and pays the tax as marketplace facilitator, the report has the tax and the same amount withheld, so the two lines net to zero. Tax Walmart did not keep is named in a warning and goes to "Sales Tax / VAT Payable", not to income.
Why is commission positive on a refund?: When Walmart refunds an order it gives back the commission it took, so the commission row on a refund is positive. The converter keeps each row's own sign, so the commission line is what Walmart actually kept.