Walmart bookkeeping
Walmart Marketplace bookkeeping for US sellers
We turn each Walmart Marketplace reconciliation report into clean QuickBooks Online entries: sales, refunds, commissions, WFS fees and adjustments, reconciled to the payout in your bank.
How do you account for Walmart Marketplace sales?
Record the gross sales and refunds from the reconciliation report, then record Walmart's commission, Walmart Fulfillment Services (WFS) fees, advertising and adjustments as separate expenses. Sales tax Walmart collects as marketplace facilitator stays out of revenue. The net of all lines should equal the payout Walmart deposited.
The problem
Why the numbers never seem to match
Payouts that don't explain themselves
The reconciliation report mixes orders, returns, commissions and adjustments across many columns and periods.
Commissions hidden in net sales
Booking the payout as revenue understates your sales and hides what Walmart charges you.
Separate from your Amazon books
Without a consistent method, Walmart and Amazon numbers can't be compared, so you can't see which channel earns more.
Process
How we do it, every week
- 01
Pull the report
We collect the Walmart reconciliation report for each payout period.
- 02
Classify every line
Sales, returns, commissions, WFS fees, advertising and adjustments are summarized by type and item.
- 03
Post to your books
Sales receipts go to your inventory system and fees post as a journal entry in QuickBooks Online.
- 04
Reconcile & report
The net ties to the bank deposit, and Walmart appears as its own channel in your profit reports.
What you get
Books you can actually use
Weekly posting
Each Walmart payout posted and reconciled shortly after it lands.
Commission and fee detail
Walmart commissions, WFS and advertising on their own lines, so you know your real margin.
Channel comparison
Walmart next to Amazon, TikTok Shop and Shopify in one profit view.
Traceable entries
Every entry references the reconciliation report it came from.
Why us
Accountants who read settlement reports every week
Our RealTax accountants, controllers and CFOs already close the books for US ecommerce brands selling on Amazon, Walmart, TikTok Shop and Shopify, and the STELZAI developers automate the repetitive posting. Every entry traces back to the marketplace report it came from.
- Walmart Marketplace sellers, with or without WFS
- QuickBooks Online, with SOS Inventory for item-level sales
- Commissions, returns and adjustments booked separately
- Marketplace-collected sales tax kept out of revenue
- Same method as your Amazon and TikTok Shop books
FAQ
Questions sellers ask us
How do I record Walmart Marketplace fees in QuickBooks?+
Record gross sales and refunds as income, then post Walmart's commission, WFS fees, advertising and adjustments to separate expense accounts in a journal entry. The total should equal the payout.
Why doesn't my Walmart payout match my sales?+
Walmart deducts commissions, fulfillment fees, returns and adjustments before paying out, and payout periods don't line up with calendar months. Reconciling each report shows exactly where the difference goes.
Can you handle Walmart and Amazon together?+
Yes. Most of our sellers use both. We post them the same way so you can compare margins by channel.
What does it cost?+
It depends on the number of channels and payouts. After a short call you get a written scope and a fixed monthly price.
Related services
Make your Walmart payouts make sense
Send us one reconciliation report. We'll show you how it should look in QuickBooks.