Walmart Marketplace Accounting: A Multi-Channel Seller Case Study

The setup

The seller: a home and kitchen brand doing roughly $4.2M in annual revenue at the time of Walmart launch. The split was 72% Amazon, 25% Shopify, 3% miscellaneous (eBay clearance). 18 active SKUs, with the top 4 driving 60% of revenue.

The plan: launch the top 12 SKUs on Walmart Marketplace with Walmart Fulfillment Services (WFS) on 4 of them and seller-fulfilled (via 3PL) on the other 8. The hypothesis: Walmart's growing marketplace traffic would convert at decent margins for a recognized brand, and the customer base wouldn't fully overlap with Amazon.

The first surprise: settlement timing

Amazon settles roughly every 14 days. Walmart settles every 14 days too, but the settlement structure is different. Walmart batches differently:

• Each settlement period covers all sales orders, refunds, adjustments, and fee items within the window
• The deposit lands 5-7 business days after the end of the settlement period
• The settlement detail report is downloaded from Seller Center; there is no native daily summary

The seller's bookkeeper, who had been booking Amazon settlements for years, initially booked Walmart settlements as one lump (the deposit) per period. That worked for cash flow but lost all the detail: per-channel fees, returns, WFS specifically vs seller-fulfilled. Fix: the bookkeeper had to switch to settlement-detail booking per Walmart deposit, same way as Amazon. After ConnectBooks integration, this happens automatically.

The second surprise: fee structure

Walmart's fees are simpler than Amazon's in some places and more punishing in others.

• Referral fee: 15% standard, same as Amazon. (Some categories higher; few are lower.)
• WFS fulfillment fee: Comparable to FBA on similar product size, sometimes 5-15% lower
• WFS storage fee: $0.75 per cubic foot (Jan-Sep), $2.25 per cubic foot (Oct-Dec)
• No placement fee equivalent: Walmart distributes its own inbound at no extra charge to the seller
• Returns fee: Higher per-return cost than Amazon, but Walmart's return rate ran lower in the seller's data

The fee math: per-unit Walmart fees ran 8-12% lower than per-unit Amazon fees on the same SKUs. That was a real margin tailwind on the Walmart sales, even with lower volume.

The third surprise: returns workflow

Walmart returns are seller-managed in some categories, Walmart-managed in others. For WFS items, Walmart handles the entire returns workflow (receive, inspect, refund). For seller-fulfilled items, the seller handles refunds and arranges for the return shipment.

The accounting impact: WFS returns flow through the settlement as a refund + fulfillment fee charge. Seller-fulfilled returns flow as a refund only, with the inventory return handled at the seller's warehouse separately. The chart of accounts needs separate "Returns, Walmart WFS" and "Returns, Walmart SF" accounts to track the two streams.

The per-channel P&L

Six months into Walmart, ConnectBooks' per-channel P&L showed the seller:

• Amazon contribution margin: 24.8% (depressed by tariff-driven landed cost increases)
• Shopify contribution margin: 38.6% (own-checkout, lower fees)
• Walmart WFS contribution margin: 26.3%
• Walmart SF contribution margin: 22.1% (3PL fulfillment cost ate into the margin advantage)

The decision that came out of the data: keep the top 4 SKUs on WFS where the math worked, pull the other 8 SKUs off seller-fulfilled because the 22.1% margin didn't cover the operational complexity of running two fulfillment models for one channel. Walmart became a 4-SKU WFS-only channel.

The fourth surprise: customer overlap was minimal

One of the hypotheses behind the Walmart launch was that Walmart customers weren't the same as Amazon customers. Six months in, the seller could see that maybe 5-10% of Walmart customers had also bought from them on Amazon. The rest were net-new revenue.

This is the case for most established brands launching on Walmart: marketplace customers self-segment by platform preference more than by brand. Adding Walmart to the channel mix grew the total customer base, didn't cannibalize Amazon meaningfully.

The fifth surprise: inventory planning got harder

With three sales channels and two fulfillment locations (WFS for Walmart, FBA for Amazon, both fed by the same supplier orders), inventory allocation became a real planning problem.

ConnectStock handled the accounting cleanly: each location had its own lot ledger, units transferred between locations with cost basis preserved, COGS posted from the right lot when units sold. The harder problem was the forecasting: how many units to send to WFS vs FBA vs hold at 3PL for SF. That's not an accounting problem; that's an operations problem. But the accounting clarity made the operations problem solvable.

What worked and what didn't

• Worked: WFS for top SKUs, careful per-channel chart of accounts, ConnectBooks automation from day one (avoided the manual settlement-booking pain Amazon had taken years to fix)
• Worked: Treating Walmart as net-new customers rather than a cannibalization risk
• Didn't work: Trying to run 8 SKUs as seller-fulfilled at the same time as WFS. The margin was too thin and the operational complexity wasn't worth it
• Didn't work: Underweighting the Walmart-specific advertising program. The seller initially set ads at parity with Amazon ACoS and got modest traffic. Walmart Connect has different bid dynamics and required a separate calibration

The accounting takeaways for any Walmart launch

• Settlement-detail booking from day one. Don't lump deposits.
• Per-channel and per-fulfillment-method P&L. Walmart WFS and Walmart SF are different businesses.
• Returns accounts split by fulfillment method.
• Per-channel inventory ledger (ConnectStock handles this).
• Marketplace-facilitator sales tax: Walmart is a facilitator in essentially all sales tax states. Same net-zero treatment as Amazon.
• Watch the first three months of channel-level contribution margin before committing capital to more SKUs.

Is Walmart Marketplace worth adding for a $2M+ Amazon seller?

Yes, in most cases, especially for branded products with recognizable names. Walmart marketplace customers are largely net-new. The accounting is well-handled by ConnectBooks. The main risks are inventory planning complexity and Walmart Connect ad calibration.

Should I use WFS or seller-fulfilled?

For most SKUs, WFS produces better contribution margin and is operationally simpler. Seller-fulfilled makes sense for oversize products where WFS fees are punishing, or for SKUs with very high return rates where seller-managed returns produce a better customer outcome.

How long does Walmart Marketplace setup take?

Approval: 2-6 weeks depending on category and brand. Initial listing creation: 1-2 weeks. WFS shipment to first inbound: 3-4 weeks. Realistic total from approval to first sale: 6-10 weeks.

Take Control of Your E-Commerce Business with ConnectBooks

Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.

Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo