Walmart recon report to Xero

1. Export the file from Walmart Seller Center

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

Why a raw Walmart recon report export fails in Xero

Xero cannot read the PaymentSummary row next to hundreds of item rows, and importing every row into your bank account would show amounts your bank never saw. The usual fix is a Walmart clearing account: the payout's lines go in, and the payout goes out to your bank.

Xero imports the CSV line by line, so title rows above the table, balance rows, currency symbols in the amount, or separate gross, fee and net columns end up rejected or imported as the wrong amount.

What is unusual about the Walmart recon report file

• 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.

What Xero requires

• Header matches Xero's template: *Date, *Amount, Payee, Description, Reference, Check Number.
• One signed amount column: money out negative, decimal point, no symbols.
• Up to 100,000 rows per file.

2. Before and after

Period Start Date,Period End Date,Total Payable,Currency,Transaction Key,Transaction Posted Timestamp,Transaction Type,Transaction Description,Cust...
03/01/2026,03/14/2026,65.84,USD,,03/18/2026,PaymentSummary,Deposited in HYPERWALLET account,,,,,,,,,,,,,,,,,,,,,
,,,,2026_03_03_000101,03/03/2026,Sale,Purchase,1000000000001,1,2000000000001,1,49.99,Product Price,1,15,,sku-sample-1,00000000000011,Sample Mug,203...
,,,,2026_03_03_000101,03/03/2026,Sale,Purchase,1000000000001,1,2000000000001,1,5.99,Shipping,1,15,,sku-sample-1,00000000000011,Sample Mug,2038345,T...
,,,,2026_03_03_000101,03/03/2026,Sale,Purchase,1000000000001,1,2000000000001,1,-7.50,Commission on Product,1,15,,sku-sample-1,00000000000011,Sample...
,,,,2026_03_03_000101,03/03/2026,Sale,Purchase,1000000000001,1,2000000000001,1,-0.90,Commission on Shipping,1,15,,sku-sample-1,00000000000011,Sampl...
,,,,2026_03_03_000101,03/03/2026,Sale,Purchase,1000000000001,1,2000000000001,1,4.12,Product tax,1,15,,sku-sample-1,00000000000011,Sample Mug,203834...
,,,,2026_03_03_000101,03/03/2026,Sale,Purchase,1000000000001,1,2000000000001,1,-4.12,Product tax withheld,1,15,,sku-sample-1,00000000000011,Sample ...
,,,,2026_03_05_000102,03/05/2026,Sale,Purchase,1000000000002,1,2000000000002,1,39.00,Product Price,1,15,,sku-sample-2,00000000000012,Sample Bowl,20...

3. Import the converted file into Xero

1. In Xero open Accounting > Bank accounts and choose the account.
2. Click Manage account > Import a statement.
3. Choose this CSV and click Import.
4. Check the column mapping (Date, Amount, Payee, Description, Reference) and confirm the date format if asked.

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.

Which date format does Xero need?

Xero lists both month-first and day-first dates as accepted and asks you to confirm the format when it is unclear. Choose United States for MM/DD/YYYY or Elsewhere for DD/MM/YYYY, and confirm the same format in Xero if it asks.

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.

Can I import more than one month at once?

Yes. Xero imports the whole statement file you give it. Keep each file to one bank account in Xero, and avoid overlapping a period you already imported so you do not have to delete duplicate statement lines.

Other ways to convert Walmart recon report

• Walmart recon report to a QuickBooks journal entry
• Walmart recon report to a QuickBooks Online bank CSV
• Walmart recon report to Excel

Other exports to Xero (CSV)

• Import a Venmo statement CSV into Xero
• Import a Cash App CSV into Xero
• Import a PayPal activity CSV into Xero
• Import a Stripe balance report CSV into Xero
• Import a Etsy monthly statement CSV into Xero
• Import a Airbnb earnings CSV into Xero
• Import a Gumroad payout CSV into Xero
• Import a Square transactions CSV into Xero
• Import a Shopify Payments transactions CSV into Xero
• Amazon settlement report to Xero
• eBay transaction report to Xero
• Import a Wise statement CSV into Xero
• Import an MT940 statement into Xero
• Import a camt.053 statement into Xero