Why doesn't your Walmart Marketplace payout match your sales?

Your Walmart Marketplace payout doesn’t match your sales because at least three layers sit between the two numbers, and each one can move the total without anything being wrong. First, the settlement data itself lives at two grains: one row per order line carrying summary money columns, and itemized amount-type rows inside each line. Summing across the wrong grain is the classic reconciliation trap, and it manufactures discrepancies out of clean data. Second, two correct charges look wrong on inspection: when Walmart funds part of a markdown, commission is computed on the reduced price, so your implied rate reads low; and marketplace-facilitator sales tax shows up on the report as withheld lines that were collected from the customer for the states, not from your earnings. Third, timing: a payout cycle and a sales period are different windows. Every order’s funds sit in a post-shipment hold before they become settlement-eligible, so a deposit almost never covers the same set of orders your sales dashboard counted for the period.

The tie-out that actually lands on the bank deposit: download the detailed payments report for the settlement cycle, stay on the order-line grain, sum Payable to Partner from Sale across every line in the cycle including refund lines, then subtract the statement’s reserve line, any Marketplace Capital repayment, and the lines whose hold had not cleared by the cycle boundary. What remains is the deposit. The rest of this article is that method in detail.

Why do the numbers change depending on which rows you sum?

Because the settlement report carries two grains of data at once, and they answer different questions. The order-line grain is one row per order line, with summary columns: Total tender to/from customer (everything the customer paid), Payable to Partner from Sale (your net for the line), Commission from Sale, and Commission Rate. The amount-type grain sits inside each line: money itemized into Amount type rows such as Product price, Shipping, the tax lines, Commission on product, Commission on shipping, and the withheld-tax variants. Revenue lives in the Product price and Shipping rows; commission lives in the commission rows; the line’s net lives in the summary column. Sum a summary column as if every amount-type row carried it, and you multiply your totals. Sum amount-type rows as if they were line totals, and you fragment them. Either way the result disagrees with the deposit, and the data was never wrong.

Two report versions compound this. The download link on the Statements screen offers a newer summarized version (a roll-up with fewer columns, fine for a cycle-level P&L) and the detailed, line-level version (sometimes called the reconciliation report). The detailed version is the one that supports a tie-out, a commission audit, or a tax reconciliation; the summarized one cannot answer line-level questions because the lines aren’t in it.

Two more grain rules. Refund rows (Transaction Type = refund) net against their original sale, so a sum that excludes them overstates net revenue; a full refund reverses the sale’s commission back to you, and a partial refund prorates both. And column names are stable-ish, not stable: Walmart renames and repackages report columns over time, and the summarized and detailed versions carry different sets. The names above are current as of June 2026; if the report in front of you differs, trust the report.

Why does the commission look wrong when it isn’t?

Because two legitimate mechanisms move the implied rate away from the rate on the label, and both live in named columns. The implied rate is Commission on product divided by Product price. When it comes out below the report’s own Commission Rate column, look at Total Walmart Funded Savings: that column is the portion of a markdown Walmart funded rather than you, and commission is taken on the price net of it. Divide by the reduced base (Product price minus the funded savings) and the rate usually snaps back to the stated one. A Reduced Referral Fee enrollment does the same thing by a different route: a genuinely lower promotional rate for the enrollment window. Neither is an error, and neither is worth a dispute.

The other direction matters more. Commission is charged on the total sales price, shipping included, so Commission on shipping is a real cost that a product-only check misses. And if the implied rate comes out above what you expect, read the Contract Category column, which is the authoritative record of the fee bucket you were charged under, and compare it against Spec Category, the catalog bucket from item setup. The two are not always the same string. A category that’s wrong because of Walmart’s mapping is disputable within a window measured from the order’s settlement date; a category that’s wrong because of the item’s own product-type setup is fixed forward in Item Setup, without a retroactive credit. The filing itself runs through Seller Center’s Help flow; the current window and the documentation Walmart asks for are the ones in Marketplace Learn’s dispute guide.

Where did the sales tax go?

To the states, through Walmart, by design. As a marketplace facilitator, Walmart calculates, collects, and remits sales tax on orders shipped to the jurisdictions where it’s registered, which as of June 2026 covers effectively every US state that has a statewide sales tax, plus DC, Puerto Rico, Hawaii, and Alaska localities. On the settlement report this tax flows through the withheld amount-type lines (Product tax withheld, Shipping tax withheld, and the fees variant): the customer paid it, Walmart kept it to remit, and it was never part of your earnings. It nets to zero for you.

This is why gross tender and your deposit can never agree. Total tender to/from customer includes tax the deposit will never include, so any reconciliation that starts from gross tender has to remove the withheld lines before comparing. For the rare jurisdictions Walmart doesn’t cover, collected tax is passed through to you and the remittance obligation comes with it; that’s a question for your accountant, not a report error.

How do you tie a payout to the bank deposit?

Four steps, all on the detailed report, all on the order-line grain.

1. Pull the right file. Statements screen, download link, detailed version, for the one settlement cycle you’re reconciling. The Transactions tab is fine for looking up a single recent order by PO or order number, but it only reaches back a limited window; the downloadable report is the durable record.
2. Sum the net column. Add Payable to Partner from Sale across every line in the cycle, refund lines included. This column already nets out commission and withheld tax per line, which is exactly why it’s the one that ties: it is “what Walmart will pay you,” line by line.
3. Subtract the statement-level items. A Payment Reserve appears as a single line on the statement (multiple reserves can be combined into it). A Marketplace Capital repayment is deducted from the payout each cycle. And any line whose post-shipment hold had not cleared before the cycle boundary is deferred to the next settlement, so it’s in your sum but not in this deposit.
4. Compare to the bank. What remains should be the deposit.

One mini-reconciliation, hypothetical but concrete. A line shows Product price $40.00, Shipping $6.00, Product tax $3.45 withheld, Total Walmart Funded Savings $8.00, Commission on product $4.80, Commission on shipping $0.90, and a Commission Rate column reading 15%. The naive implied rate is 4.80 ÷ 40.00, or 12.0%, which looks like a miscategorization. Adjust the base for the funded savings: 40 − 8 = 32, and 4.80 ÷ 32 is 15.0%, matching the report’s own stated rate. The gap was Walmart-funded promotion, not error. The line’s net: 40 + 6 − 4.80 − 0.90 = $40.30 payable, with the $3.45 of tax withheld netting to zero. Now the cycle: the payable column sums to $1,400 but the bank shows $1,240. The $160 gap has three usual homes: a Capital repayment line, the reserve line, or $160 of lines still inside their hold, which will surface in the next cycle’s deposit. A hold-timing difference explains most of these gaps, so the walk through those three candidates usually ends at a next-cycle arrival date, not an error.

Why is a correct deposit still smaller than the period’s sales?

Because sales and settlements are counted on different clocks, and Walmart’s structure inserts several delays between them. A sale registers when the order is placed; the money doesn’t enter the payment pipeline until after the order is marked Shipped, and the balance appears on the statement with a lag after that, not at order time. Every order’s funds then sit through a post-shipment hold before they’re settlement-eligible, and they release into the next settlement after the hold clears, so where a ship date lands relative to the cycle boundary decides which deposit carries it. The cycle cadence itself is set at account approval and shown on your Statements page, along with the scheduled settlement date; those are the numbers to work from, and if what you see inside Seller Center differs from anything here, trust the portal.

Newer accounts carry one more layer: a new-seller payment hold that defers each order’s funds beyond the standard hold until the account clears both a time-since-first-shipment gate and a cumulative-payments gate. It isn’t a sign of trouble and it can’t be appealed away; it’s a standard onboarding control, and it’s a common reason a launching seller’s first weeks of sales arrive as a trickle of deposits. Separately, a Payment Suspension stops all disbursement while an account is under review (triggers Walmart cites include compliance issues and performance reviews, the same performance machinery that can also unpublish listings), and a “final settlement” line means account-level action has been taken and the question is no longer a reconciliation question at all.

None of this changes the tie-out. It changes which cycle a given order’s money lands in. When the method above leaves a residual, the residual is almost always an order whose hold pushed it across a boundary; walk that order’s ship date through the hold and the next settlement date on your Statements page, and the “missing” money usually has an arrival date.

What about the statement in front of you right now?

The method here is durable; the particulars on your statement are not. Column names shift between report versions, reserve lines appear and release on Walmart’s schedule, and the holds on your account depend on its age and standing. Retail Reason exists for exactly that moment: ask it the question in front of you (“what is this reserve line,” “why is this cycle short,” “is this commission rate right for this category”) and get a direct answer, dated, with a confidence class, so you know which parts are firm and which to re-check in Seller Center. No person sits between the question and the answer. It answers questions and checks plans; it does not file disputes or touch your account. See pricing, or contact Matt.