BooksReady

Walmart recon report to a QuickBooks Online bank CSV

In short: 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. QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Before you start: Upload this into a separate "Walmart" clearing account in QuickBooks, not your checking account: the last line moves the payout out to your bank. We have not imported the result into a real QuickBooks company.

Convert your file

Walmart recon report to QuickBooks Online (CSV)

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.

One email when it ships. The address is used for nothing else. Details.

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 QuickBooks Online

QuickBooks Online would import every row of the recon report into your checking account, including the PaymentSummary row, so the payout would be counted twice and nothing would match the deposit in your bank feed.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

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 requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

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 receives

After: walmart-recon-2026-03-18-to-2026-03-18-quickbooks-3col.csv
DateDescriptionAmount
03/18/2026Walmart payout 2026-03-01 to 2026-03-14: Product sales88.99
03/18/2026Walmart payout 2026-03-01 to 2026-03-14: Shipping charged to buyers5.99
03/18/2026Walmart payout 2026-03-01 to 2026-03-14: Walmart commission-12.75
03/18/2026Walmart payout 2026-03-01 to 2026-03-14: Sales tax charged to buyers4.12
03/18/2026Walmart payout 2026-03-01 to 2026-03-14: Sales tax kept by Walmart (marketplace facilitator)-4.12
03/18/2026Walmart payout 2026-03-01 to 2026-03-14: Refunds: product-10.00

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

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

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.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
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 does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert Walmart recon report

Other exports to QuickBooks Online (CSV)

Common import problems