Walmart Marketplace Accounting: How to Connect Walmart to QuickBooks or Xero (2026 Guide)

Walmart Marketplace is not accounting software. If you are selling on Walmart.com and your QuickBooks numbers never match your Seller Center reports, the reason is that Walmart tracks your store performance and QuickBooks tracks your business financials — and you need both, connected, to run clean books.

TL;DR: Walmart Marketplace handles your orders, fee deductions, and biweekly payouts. QuickBooks Online or Xero handles your actual accounting. Neither platform talks to the other by default. SyncTools bridges the gap: every Walmart sale, referral fee, WFS fulfillment charge, and refund posts to the correct account in QuickBooks or Xero automatically — no CSV exports, no manual entry.

What Walmart Marketplace Actually Does (and Doesn’t Do)

Walmart Marketplace is a third-party seller platform embedded within Walmart.com, the largest retailer in the world. Walmart had over 150,000 active third-party Marketplace sellers as of 2024 and generated approximately $75 billion in gross merchandise value through its eCommerce channel (Walmart FY2025 Annual Report, 2025). Unlike Amazon, Walmart charges no monthly subscription fee to sell on Marketplace — but the per-transaction referral fee structure makes fee tracking critical.

Walmart’s Seller Center financial reporting covers:

• Transaction reports — order totals, referral fees, and adjustments per item
• Payout summaries — net amounts disbursed after Walmart deducts fees and refunds
• Remittance reports — line-by-line breakdown of each payout cycle
• WFS reports — fulfillment, storage, and shipping charges if you use Walmart Fulfillment Services

What Walmart Seller Center does not do:

• Maintain a general ledger or chart of accounts
• Produce a P&L statement or balance sheet
• Calculate your net profit after inventory costs, shipping supplies, or overhead
• File sales tax returns or reconcile tax remittances per state
• Connect to QuickBooks, Xero, or any accounting software natively

The result: every seller must either manually export Walmart reports and enter data into their accounting software — a process that breaks down fast once volume picks up — or use an integration that bridges Walmart Seller Center to QuickBooks or Xero automatically.

Walmart’s zero-subscription model is attractive to new sellers, but it creates a bookkeeping trap: because there’s no monthly fee line item to notice, sellers often underestimate how much they’re paying Walmart until they look at a full year of referral fees. A $250K/year Walmart seller paying a 12% average referral rate is handing Walmart $30,000 annually — money that must appear as an expense, not a revenue reduction, for the P&L to be accurate.

Related: eCommerce bookkeeping guide — accounting fundamentals every online seller needs before connecting any integration.

How Walmart Marketplace Payouts Work

Walmart processes seller disbursements on a 14-day cycle. Once Walmart confirms order delivery, funds enter a brief settlement hold and then disburse to your registered bank account via ACH. New sellers face an initial 14-day hold before their first payment, which is Walmart’s fraud and chargeback buffer. After consistent selling history, established sellers may qualify for accelerated payout schedules.

What arrives in your bank account is not gross sales. It is the net result of several deductions:

• Gross sales — the full price the customer paid, including any shipping charges
• Referral fee — Walmart’s commission (6–20% depending on product category, applied to the total sale price including shipping)
• WFS fees — if you use Walmart Fulfillment Services, pick & pack, shipping, and storage fees are deducted before payout
• Walmart Connect charges — advertising costs incurred during the period are netted from your payout
• Refunds and returns — any customer refunds processed during the cycle reduce your disbursement directly
• Marketplace facilitator tax — sales tax collected and remitted by Walmart in 46 states is a pass-through; it is not your income

On a $100 product sale with a 15% referral fee in the Apparel category, Walmart deducts $15 before the payout. Add WFS fulfillment fees of $8–12 for a lightweight item and a return rate of 5%, and your effective net-per-unit can be significantly lower than the gross sale figure in your Seller Center dashboard.

The biweekly cycle means most sellers have two settlement periods per month. Recording payout dates rather than order dates can shift revenue recognition by up to two weeks, which matters for monthly P&L accuracy. The correct approach is to use an integration that records transactions at the order date (accrual) or consistently at the payout date (cash basis) — whichever matches your accounting method — rather than letting the entry date be whatever day you remember to log in and export.

Related: multi-channel inventory accounting — how to track COGS across Amazon, Shopify, and Walmart simultaneously.

Walmart Referral Fees by Category

Walmart’s referral fee structure determines your largest recurring expense on the platform. Unlike Amazon, Walmart does not charge a fulfillment-adjacent fee structure at the referral level — it’s a flat percentage of the total sale price, including any shipping you charge the customer.

Representative referral rates as of 2025–2026:

Category	Referral Fee
Electronics	6–8%
Cameras & Photo	8%
Computers	6%
Musical Instruments	6%
Tires & Wheels	10%
Home & Garden	8–15%
Toys & Games	15%
Apparel & Accessories	5–15%
Sports & Outdoors	8–15%
Beauty & Personal Care	8%
Health & Household	8%
Baby	8–15%
Pet Supplies	8%
Office Products	8%

Each of these referral fees must be recorded as an expense (not a revenue deduction) in QuickBooks for accurate margin reporting. Recording referral fees as negative revenue is technically acceptable but hides your true gross revenue and your true cost structure simultaneously — a problem at tax time and when calculating category-level margins.

Walmart Fulfillment Services (WFS) Accounting

Walmart Fulfillment Services is Walmart’s answer to Amazon FBA: you ship inventory to Walmart fulfillment centers, and Walmart handles pick, pack, and shipping for customer orders. WFS listings get a “Fulfilled by Walmart” badge and priority placement in search results.

WFS introduces three categories of fulfillment costs that require dedicated accounting treatment:

1. Pick & Pack / Weight-Based Shipping Fees WFS charges a per-unit fulfillment fee based on the shipping weight of the item. These fees are deducted from your payout and must be recorded as fulfillment expense (or COGS if you treat fulfillment as a product cost). They are not referral fees and should not be mapped to the same expense account.

2. Storage Fees Walmart charges monthly storage fees per cubic foot for inventory held in WFS facilities. Long-term storage fees apply to units stored over 365 days. Storage fees accrue monthly and are deducted in your next payout cycle. Record these as inventory storage expense — a period cost separate from COGS unless you capitalize storage as an inventory cost under your accounting policy.

3. Returns Processing Fees When a WFS customer initiates a return, Walmart processes it and may charge a returns processing fee. These appear in your remittance report as deductions. Record as returns processing expense.

Sellers who move from FBW (Fulfilled by Walmart from your own warehouse) to WFS often experience an accounting whiplash: suddenly there are three new expense categories appearing in each remittance report, and the payout no longer maps cleanly to a simple gross sales minus referral fee formula. The first month on WFS is when most sellers discover their expense accounts weren’t set up correctly. Setting up dedicated QuickBooks accounts for each WFS cost type before your first WFS payout eliminates this scramble.

Walmart Connect Advertising Accounting

Walmart Connect is Walmart’s advertising platform. Sponsored Products ads appear in Walmart.com search results and category pages. Unlike Amazon Sponsored Products, Walmart Connect charges are typically deducted directly from your Marketplace payout rather than billed separately.

Walmart Connect costs to record:

• Sponsored Products CPC spend — cost-per-click charges from search result placements
• Display advertising — off-site display ads on third-party publishers in the Walmart DSP network (billed separately via invoice in most cases)
• Brand Amplifier / Spotlight ads — premium placement products billed via campaign

Map Walmart Connect Sponsored Products spend to an Advertising Expense account — separate from your referral fees and WFS costs. Keeping ad spend in a dedicated account lets you calculate true advertising cost of sale (ACoS) per campaign, which is the core metric Walmart Connect optimizes against.

Sales Tax: Is Walmart a Marketplace Facilitator?

Yes. Walmart Marketplace acts as a marketplace facilitator in all 46 US states (plus Washington D.C.) that have enacted marketplace facilitator laws. Walmart collects and remits sales tax on behalf of third-party sellers for qualifying transactions — you do not need to register, collect, or remit in states where Walmart is the facilitator.

This has critical implications for your QuickBooks setup:

The sales tax Walmart collects and remits is not your income. It passes through your Walmart account but Walmart settles it with state tax authorities directly. If you record marketplace facilitator tax as revenue, you overstate income by the full tax amount. If you try to back it out manually each quarter, you create compounding reconciliation errors.

The correct approach: map Walmart-collected tax to a Sales Tax Payable clearing account — a current liability. At the end of each settlement period, SyncTools posts the pass-through tax to this clearing account. When Walmart remits to the state, the clearing balance zeroes out. Your P&L never sees a dollar of pass-through tax as income.

For sellers who also sell on their own website or in states where Walmart is not the facilitator (rare, but possible in specific B2B scenarios), you remain responsible for sales tax collection and remittance on those transactions. Use SyncTools to keep Walmart-facilitated tax and self-collected tax in separate accounts.

Related: eCommerce sales tax compliance guide — economic nexus, marketplace facilitator rules, and multi-state filing for 2026.

1099-K: Does Walmart Report Your Sales to the IRS?

Yes. Walmart issues a 1099-K for US sellers who receive more than $20,000 in gross payments and exceed 200 transactions in a calendar year. This threshold was permanently restored by the One Big Beautiful Bill Act signed in July 2025, reversing the IRS’s attempted reduction to $600 that had been in regulatory limbo since 2022.

What the 1099-K covers:

• Gross payment volume — the total of all customer payments processed through Walmart Marketplace, before any fee deductions
• Not net income — the 1099-K reports gross receipts, not profit. Your actual taxable income is gross Walmart sales minus all expenses (referral fees, WFS costs, COGS, advertising, etc.)

If your Walmart 1099-K shows $300,000 in gross receipts but your referral fees are $36,000, your WFS costs are $24,000, and your COGS are $180,000, your Walmart-sourced income for tax purposes is roughly $60,000 — not $300,000. This distinction is why accurate expense tracking matters far more than gross sales tracking.

Sellers below the 1099-K threshold still owe income tax on profits. The threshold only determines whether Walmart files the form.

QuickBooks Chart of Accounts for Walmart Sellers

Before connecting any integration, set up dedicated accounts in QuickBooks to capture each Walmart transaction type cleanly. Mixing Walmart activity with other channels makes it impossible to calculate per-channel margins.

Income accounts:

• Walmart Gross Sales (Income → Sales)

Contra-revenue:

• Walmart Refunds / Returns (Income → Sales Returns & Allowances)

Cost of goods sold / Expense accounts:

• Walmart Referral Fees (COGS → Platform Fees)
• Walmart WFS Fulfillment Fees (COGS → Fulfillment Costs, or Operating Expense → Fulfillment)
• Walmart WFS Storage Fees (Operating Expense → Inventory Storage)
• Walmart Returns Processing (Operating Expense → Returns Processing)
• Walmart Connect Advertising (Operating Expense → Advertising & Promotion)

Liability:

• Sales Tax Payable — Walmart (Current Liability)

Asset (clearing account):

• Walmart Clearing (Bank-type asset — used to bridge the gap between gross sales and net payout)

The clearing account is the mechanism that makes Walmart payout reconciliation work. SyncTools records gross sales to Walmart Gross Sales and posts fees to their respective expense accounts. The net entry lands in Walmart Clearing. When Walmart’s biweekly ACH hits your bank account, you match it against the Walmart Clearing balance — which should be zero after the match.

How to Connect Walmart Marketplace to QuickBooks or Xero

Step 1: Build your Walmart chart of accounts

Set up the income, expense, liability, and clearing accounts listed above before running your first sync. Changing the account structure mid-year creates reconciliation work that compounds quickly.

Step 2: Connect Walmart Marketplace in SyncTools

Sign up at app.synctools.ai and select Walmart Marketplace as your source platform. SyncTools connects via Walmart’s Seller Partner API, which requires you to authorize the connection from your Seller Center account. The authorization grants SyncTools read-only access to your transaction data, orders, fees, and remittance reports — SyncTools never writes to or modifies your Walmart store.

Step 3: Connect QuickBooks Online or Xero

Authorize QuickBooks Online (or Xero) via OAuth from within SyncTools. SyncTools pulls your existing chart of accounts and presents a pre-populated mapping recommendation for each Walmart transaction type.

Step 4: Configure fee-level account mapping

In SyncTools account mapping, assign each Walmart transaction type to the correct QuickBooks account:

• Walmart sales → Walmart Gross Sales
• Referral fees → Walmart Referral Fees (COGS)
• WFS fulfillment fees → Walmart WFS Fulfillment Fees
• WFS storage fees → Walmart WFS Storage Fees
• Walmart Connect spend → Walmart Connect Advertising
• Refunds → Walmart Refunds
• Marketplace facilitator tax → Sales Tax Payable — Walmart (clearing)

Step 5: Reconcile on each payout cycle

After each biweekly Walmart payout, confirm that your Walmart Clearing account balance equals the net payout deposited to your bank. SyncTools posts journal entries automatically — the clearing account should zero out when you match the ACH deposit in QuickBooks Bank Feeds.

Common Walmart Accounting Mistakes

Recording the net payout as revenue. The biweekly Walmart deposit is gross sales minus three to five layers of fees. Recording it as revenue understates sales, hides your referral fee expense, and gives you a P&L that looks cleaner than reality until your margins compress.

Mixing WFS fees with referral fees. Both appear in your remittance report as deductions, but they are economically different costs. Referral fees are a cost of selling on Walmart; WFS fees are a cost of fulfillment. Separating them lets you calculate true platform cost vs. true fulfillment cost — and decide whether WFS makes economic sense for each SKU.

Treating marketplace facilitator tax as income. Walmart collects tax on your behalf and remits it to the state. It flows through your account but is never your money. Recording it as income and then reversing it quarterly is extra work that creates reconciliation risk. Map it to a clearing liability from day one.

Using a single “Walmart Income” account. One catch-all account makes it impossible to calculate gross margin, measure advertising efficiency, or understand why your net payout is dropping. A five-minute account setup at the start saves hours of forensic accounting later.

Ignoring return velocity. Walmart’s customer-friendly return policy means return rates in categories like apparel can run 15–25%. Returns that are not mapped correctly in QuickBooks cause your refund contra-revenue account to balloon silently. SyncTools posts each return to the correct account at the transaction level — you see return cost in your P&L each period rather than discovering it during year-end cleanup.

Walmart Marketplace vs. Amazon: Accounting Differences

Sellers who manage both Walmart and Amazon channels often ask how the accounting differs. The biggest differences:

Factor	Walmart Marketplace	Amazon
Monthly seller fee	None	$39.99/month (Professional)
Referral fee structure	6–20% flat on sale + shipping	6–17% with variable closing fees
Fulfillment option	WFS (optional)	FBA (commonly used)
Payout cycle	Biweekly	Biweekly
Advertising platform	Walmart Connect (netted from payout)	Amazon Ads (separate billing)
1099-K threshold	$20,000 / 200 transactions	$20,000 / 200 transactions
Sales tax facilitation	Yes (46 states + DC)	Yes (46 states + DC)

The main accounting implication: Amazon Ads are billed separately from your seller account and create a separate payable, while Walmart Connect charges are netted from your Marketplace payout. This means Walmart’s remittance report is a single document that captures all Walmart costs, while Amazon requires reconciling two separate billing streams.

Related: Amazon seller accounting guide — the complete guide to Amazon fees, FBA reconciliation, and QuickBooks setup for Amazon sellers.

Walmart Marketplace Accounting: Key Takeaways

Walmart Marketplace is a major revenue channel — but it is not an accounting system. The biweekly payout you receive is a net figure bundling gross sales, referral fees, WFS costs, advertising charges, refunds, and pass-through tax into a single ACH deposit. Recording that deposit as income is wrong in every direction that matters.

The correct setup:

1. Separate QuickBooks accounts for each Walmart transaction type before your first sync
2. Map marketplace facilitator tax to a clearing liability — never income
3. Separate WFS fees from referral fees for true fulfillment cost visibility
4. Use SyncTools to automate the sync so every Walmart transaction posts to the right account without manual exports

With the right account structure and an automated integration in place, Walmart Marketplace accounting reduces to a biweekly reconciliation check: confirm your Walmart Clearing account balances against the ACH deposit, and your books are current.

Integration guides:

• Walmart Marketplace QuickBooks Online Integration — complete setup, account mapping, and WFS fee handling for QuickBooks users
• Walmart Marketplace Xero Integration — Xero account structure, tracking categories, payout reconciliation, and step-by-step setup for Walmart sellers using Xero
• Walmart Dynamics 365 Business Central Integration — G/L mapping, VAT posting groups, and dimension assignments for Business Central users
• Walmart NetSuite Integration — segment-aware sync and summarized journal entries for high-volume Walmart sellers on NetSuite
• Walmart Sage Integration — Sage account mapping with multi-currency support for UK-based Walmart sellers
• Walmart Zoho Books Integration — Zoho Books setup with Zoho One ecosystem compatibility

Frequently Asked Questions

Does Walmart Marketplace have built-in accounting software?

Walmart Marketplace Seller Center includes transaction reports, payout summaries, and fee statements — but it is not accounting software. It does not maintain a general ledger, produce a profit and loss statement or balance sheet, or calculate your true eCommerce profit after all costs. For proper books, Walmart sellers use QuickBooks Online or Xero alongside Walmart Seller Center, connected via a sync tool like SyncTools.

How do Walmart Marketplace payouts work for accounting?

Walmart Marketplace pays sellers on a biweekly cycle. Payouts are gross sales minus the Walmart referral fee (6–20% depending on category), minus any Walmart Fulfillment Services (WFS) fees if you use Walmart’s fulfillment network, minus refunds processed in the period. New sellers face a 14-day payment hold before their first disbursement. Recording the net deposit as revenue understates gross sales and misclassifies fees as negative income. The correct method is to record gross Walmart sales and post each fee type as a separate expense.

What Walmart Marketplace fees need to be recorded in QuickBooks?

Walmart sellers need to record the referral fee (6–20% of the sale price depending on category), Walmart Fulfillment Services fees if you use WFS (including pick & pack, weight-based shipping, and storage fees), Walmart Connect advertising spend, return processing fees, and any subscription fees for approved add-on services. Each fee type should map to a separate QuickBooks expense account for accurate margin reporting. SyncTools handles this mapping automatically during setup.

Is Walmart Marketplace a marketplace facilitator for sales tax?

Yes. Walmart Marketplace acts as a marketplace facilitator in all US states that have enacted marketplace facilitator laws (currently 46 states plus Washington D.C.). Walmart collects and remits sales tax on behalf of third-party sellers for qualifying transactions. The sales tax Walmart collects appears in your transaction reports but is never your income — it should be recorded to a Sales Tax Payable liability account and zeroed out when Walmart remits to state authorities.

How do I connect Walmart Marketplace to QuickBooks Online?

Walmart Marketplace connects to QuickBooks Online via SyncTools. After authorizing both platforms via OAuth, SyncTools reads your Walmart Seller Center transaction data — sales, referral fees, WFS fees, advertising costs, and refunds — and posts each transaction type to the correct QuickBooks account automatically. Setup takes 15 to 30 minutes. No CSV exports or manual data entry required.

Does Walmart issue a 1099-K?

Yes. Walmart issues a 1099-K for US sellers whose gross payment volume exceeds $20,000 and who complete more than 200 transactions in a calendar year. This threshold was permanently restored by the One Big Beautiful Bill Act signed in July 2025. Sellers below this threshold still owe income tax on profits — the 1099-K threshold only affects whether Walmart files a form with the IRS.

Does Walmart Marketplace charge a monthly seller fee?

No. Unlike Amazon (which charges $39.99/month for a Professional selling account), Walmart Marketplace has no monthly subscription fee. Walmart charges only per-transaction referral fees (6–20% depending on category) plus optional WFS fulfillment fees. The absence of a monthly fee makes Walmart attractive to new sellers, but referral fees still represent a significant per-sale cost that must be tracked as an expense in your accounting system.

Connect Walmart Marketplace to QuickBooks with SyncTools →

Step-by-step integration guides:

• Walmart QuickBooks Integration: Step-by-Step Setup Guide — detailed account mapping, payout reconciliation, and common setup mistakes to avoid
• Walmart Xero Integration — step-by-step guide to connecting Walmart Marketplace to Xero with the correct chart of accounts and payout reconciliation