1. Export the file 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.
Why a raw Walmart recon report export fails in QuickBooks Online (journal entry 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 bank line.
The usual fix is one summary journal entry per payout: product sales and shipping on the sales side, refunds against sales, Walmart commission and shipping labels as fees, sales tax charged and kept by Walmart on their own lines, and exactly Total Payable on the bank line. You then match the bank line against the Walmart deposit in your bank feed.
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 QuickBooks Online (journal entry import) requires
- Each entry shares one Journal No. and date, and its debits equal its credits.
- Lines show product sales, shipping, refunds, Walmart commission, shipping labels, sales tax charged and kept by Walmart, and the payout that hit your bank.
- Account names must match your chart of accounts exactly; subaccounts as Parent:Sub.
- Up to 1,000 lines per file (we split bigger files without breaking an entry).
2. Before and after
Before: the Walmart Recon report CSV as downloaded
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...
After: what QuickBooks Online (journal entry import) receives
| Journal No. | Journal Date | Account Name | Debits | Credits | Description | Name |
|---|---|---|---|---|---|---|
| BR-20260318-1 | 03/18/2026 | Sales of Product Income | 88.99 | Product sales - Walmart payout 2026-03-01 to 2026-03-14 | ||
| BR-20260318-1 | 03/18/2026 | Sales of Product Income | 5.99 | Shipping charged to buyers - Walmart payout 2026-03-01 to 2026-03-14 | ||
| BR-20260318-1 | 03/18/2026 | Bank Charges & Fees | 12.75 | Walmart commission - Walmart payout 2026-03-01 to 2026-03-14 | ||
| BR-20260318-1 | 03/18/2026 | Sales of Product Income | 4.12 | Sales tax charged to buyers - Walmart payout 2026-03-01 to 2026-03-14 | ||
| BR-20260318-1 | 03/18/2026 | Sales of Product Income | 4.12 | Sales tax kept by Walmart (marketplace facilitator) - Walmart payout 2026-03-01 to 2026-03-14 | ||
| BR-20260318-1 | 03/18/2026 | Sales of Product Income | 10.00 | Refunds: product - Walmart payout 2026-03-01 to 2026-03-14 |
Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.
3. Import the converted file into QuickBooks Online (journal entry import)
- Make sure every account named in the file exists in your chart of accounts (or change the account names before downloading).
- In QuickBooks Online go to Settings (gear) > Import data > Journal entries.
- Upload this CSV and map Journal No., Journal Date, Account Name, Debits, Credits, Description and Name.
- Review and import. Each payout (or month) becomes one balanced entry.
Questions
- Which accounts does the Walmart journal entry use?
- Product sales, shipping and refunds go to the sales account, Walmart commission to the fees account, shipping labels to the fees account (or the shipping label account if you set one), tax Walmart did not keep to "Sales Tax / VAT Payable", and the payout to the bank account. Every name must exist in your QuickBooks chart of accounts.
- 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.
Other ways to convert Walmart recon report
- Walmart recon report to Xero
- Walmart recon report to a QuickBooks Online bank CSV
- Walmart recon report to Excel
Other exports to QuickBooks journal entry
- Stripe payouts to a QuickBooks journal entry
- Etsy payouts to a QuickBooks journal entry
- Airbnb payouts to a QuickBooks journal entry
- Gumroad payouts to a QuickBooks journal entry
- Square payouts to a QuickBooks journal entry
- Shopify Payments payouts to a QuickBooks journal entry
- Amazon settlement report to QuickBooks
- eBay transaction report to a QuickBooks journal entry
- Gusto payroll journal to a QuickBooks journal entry