Walmart recon report to a Xero manual journal

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 (manual journal import)

Your bank receives one Walmart payout per period, after commission, shipping labels and refunds. Entering the payout as income understates sales and hides the fees. A journal entry per payout puts each kind of amount on its own line and exactly Total Payable on the payout clearing line.

Xero's bank statement import puts every line into one bank account, so a payout split into sales, fees and refunds needs either a clearing account in Xero or a journal. A manual journal per payout (or per month when the export does not link sales to payouts) books gross sales, fees, refunds and payments you sent to their own accounts, and the payout amount to a payout clearing account: a current asset account that is not a bank account, because Xero does not let manual journals post to bank or credit card accounts. When the deposit arrives in your bank feed, reconcile it in Xero against that payout clearing account (Receive Money coded to it), and the clearing account goes back to zero. Xero imports the journals as drafts, and you post them after checking.

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 (manual journal import) requires

• Columns as in Xero's manual journal template: Narration, Date, Description, AccountCode, TaxRate, Amount and two pairs of tracking columns.
• Narration and Date on the first row of each journal; the rows below with both left blank belong to the same journal.
• Dates as dd mmm yyyy (05 Mar 2026) or dd/mm/yyyy.
• Account codes, not names (for example 200). Debits positive, credits negative; each journal adds up to zero.
• No bank or credit card accounts: the payout is booked to a payout clearing account (a current asset), and the bank feed deposit is reconciled against it.
• Up to 300 lines per file (we split bigger files without breaking a journal). Journals are in your base currency.

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 (manual journal import)

1. Make sure every account code in the file exists in your Xero chart of accounts (enter your codes in the options before downloading). The payout clearing code must be a current asset account, not a bank or credit card account: Xero does not accept those in a manual journal.
2. In Xero, in the Accounting menu, select Manual journals.
3. Click Import, then Browse, and select this CSV.
4. Click Import, review the message, then click Complete Import. The journals arrive as drafts.
5. Open the Draft tab and check each journal: add a tax rate to each line if the file has none, and tick "Show journal on cash basis reports" if you report on a cash basis (the template has no column for it). Then select the journals and click Post.
6. When the deposit (or the net pay withdrawal) appears in your bank feed, reconcile it against the payout clearing account (Receive Money or Spend Money coded to that account), not against sales.

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 payout clearing 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 does the payout reach my bank account in Xero?

Xero does not accept bank or credit card accounts in a manual journal, and a journal line cannot be reconciled against a bank feed line anyway. So each journal books the payout to a payout clearing account, a current asset account you create (for example Payouts in transit), not a bank account. When the deposit appears in your bank feed, reconcile it against that clearing account (Receive Money coded to it). Do not code the deposit to sales: the journal has already booked the sales, so that would count them twice.

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.

What is not confirmed yet?

Xero's template download needs a Xero login, so we have not compared the exact header text (including the asterisks Xero puts on required columns) with a freshly downloaded template; the column names follow Xero's help page. We have also not confirmed Xero's default account codes, which tax rate names exist in each country, or whether imported journals arrive with "Show journal on cash basis reports" ticked. We have not imported the result into a real Xero organisation. Check the first journal before importing many.

Other ways to convert Walmart recon report

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

Other exports to Xero manual journal

• Stripe payouts to a Xero manual journal
• Etsy payouts to a Xero manual journal
• Airbnb payouts to a Xero manual journal
• Gumroad payouts to a Xero manual journal
• Square payouts to a Xero manual journal
• Shopify Payments payouts to a Xero manual journal
• Amazon settlement report to a Xero manual journal
• eBay transaction report to a Xero manual journal
• Gusto payroll journal to a Xero manual journal