Walmart Seller Guide - Accounting, Bookkeeping & Tax Resources
Seller Bookkeeping

Walmart Seller Hub

Complete accounting, bookkeeping & tax resources for Walmart Marketplace sellers

Welcome to the Walmart Seller Resource Center

Running a Walmart Marketplace business means managing product listings, handling buyer transactions, navigating marketplace fees, and complying with tax requirements across multiple states. This hub provides everything you need to master Walmart bookkeeping, accounting, and tax compliance.

What makes Walmart unique: Unlike Etsy or eBay, Walmart Marketplace focuses on mainstream retail products. Sellers must handle sales tax collection state-by-state, manage referral fees by category, and understand Walmart's specific fee structure. Accurate bookkeeping is critical to profitability.

Bookkeeping Basics

Master fundamentals of Walmart bookkeeping and financial management.

  • Setting up chart of accounts
  • Recording Walmart transactions
  • Reconciling payments & fees
  • Managing settlements & payouts
Read Guide

Walmart Fees Explained

Understand all fee categories impacting your profitability.

  • Referral fee categories
  • Fulfillment & shipping fees
  • Advertising & promotional costs
  • Return processing fees
Read Guide

Tax Compliance

Navigate sales tax and self-employment tax obligations.

  • Sales tax nexus rules
  • Tax code configuration
  • Self-employment tax liability
  • Quarterly estimated taxes
Read Guide

Accounting Software

Connect Walmart to QuickBooks, Xero, or automation tools.

  • QuickBooks Online integration
  • Xero setup & reconciliation
  • Link My Books automation
  • Spreadsheet tracking methods
Read Guide

Inventory & COGS

Track inventory costs and product profitability accurately.

  • Cost per item calculation
  • Inventory valuation methods
  • Profit by category analysis
  • Seasonal inventory planning
Read Guide

Financial Reports

Generate and understand your Walmart business financials.

  • Profit & Loss statements
  • Category profitability
  • Cash flow forecasting
  • YoY growth analysis
Read Guide

Complete Walmart Bookkeeping Guides

Step-by-step instructions for managing your Walmart finances

Walmart Bookkeeping 101

1. Set Up Separate Business Banking

Critical for tax compliance: Use a dedicated business bank account for all Walmart payouts and expenses. Never mix personal and business funds.

  • Open a business checking account
  • Set up transfers from Walmart to this account
  • Use a business credit card for inventory/supplies only
  • Keep all receipts and invoices organized

2. Understanding Walmart Seller Payouts

Walmart Settlement Process: Walmart pays sellers via direct deposit based on a weekly settlement cycle.

  • Payment Frequency: Weekly or twice weekly depending on sales volume
  • Processing Time: 2-3 business days after settlement
  • What's Deducted: All referral fees, fulfillment fees, and other charges before deposit
  • View Details: Check Seller Center → Financials → Settlement Reports

3. Create Your Chart of Accounts

Organize all transactions into proper accounting categories:

  • Revenue: Walmart Sales, Sales Tax Collected
  • Expenses: COGS, Referral Fees, Fulfillment Fees, Advertising, Shipping, Supplies, Return Processing
  • Assets: Inventory, Equipment, Cash
  • Liabilities: Sales Tax Payable, Self-Employment Tax Payable

4. Track Every Transaction

Record what your Walmart settlement statement shows:

  1. Sale date and gross amount
  2. Referral fee (varies by category: 6-15%)
  3. Fulfillment fee (if using WFS)
  4. Other fees (advertising, returns, etc.)
  5. Net amount deposited to bank

Example $100 Sale (Electronics, 8% referral fee):

  • Gross Sale: $100.00
  • Referral Fee (8%): -$8.00
  • Payment Processing: -$0.00 (Walmart covers)
  • Net to Account: $92.00

Weekly Walmart Bookkeeping Checklist

  • Download Walmart settlement reports
  • Reconcile bank deposits to Walmart payouts
  • Record all sales transactions in accounting software
  • Log inventory used (COGS)
  • Reconcile refunds and cancellations
  • Categorize all business expenses
  • Verify sales tax collected and payable by state

Understanding Walmart Marketplace Fees

Complete Walmart Fee Breakdown (2025)

Walmart's fee structure varies significantly by product category. Understanding each fee type is critical.

1. Referral Fee (Primary Fee)

  • Range: 6-15% of sale price, varies by category
  • Common Categories:
    • Electronics: 8%
    • General Merchandise: 10-12%
    • Home & Garden: 10%
    • Fashion & Accessories: 12-15%
    • Sporting Goods: 10%
  • Charged On: Final sale price including shipping (if included)

2. Walmart Fulfillment Services (WFS) Fee

  • Cost: Varies by product size and weight
  • Includes: Storage, picking, packing, and shipping
  • Optional: Use only if you want Walmart to handle fulfillment
  • Alternative: Use Seller Fulfilled (standard marketplace)

3. Advertising Fees (Optional)

  • Cost: Pay-per-click or cost-per-impression
  • Purpose: Promote products on Walmart.com search
  • Control: Completely optional and adjustable

4. Return Processing & Other Fees

  • Return processing fees (varies)
  • Payment processing fees (minimal/included)
  • Subscription fees (none for standard sellers)

Real Walmart Sale Example

Electronics Item (8% referral fee):

  • Sale Price: $75.00
  • Referral Fee (8%): -$6.00
  • WFS Fulfillment Fee (if used): -$3.50
  • Advertising Spend (if promoted): -$2.00
  • Net to You: $63.50

If your COGS is $30 and packing supplies $2:

Your Profit: $63.50 - $30 - $2 = $31.50 (42% margin)

Monthly Fee Review Checklist

  • Compare total fees charged by Walmart
  • Verify referral fee percentages by category
  • Audit WFS fulfillment fees (if applicable)
  • Review advertising spend vs. ROI
  • Check pricing adequacy (margin after fees)

Walmart Seller Tax Compliance

Sales Tax Obligations as Walmart Seller

Important: Walmart Marketplace sellers are responsible for sales tax collection and remittance state-by-state.

  • Your Responsibility: Set up correct tax codes in Seller Center
  • Walmart's Role: Helps collect and remit sales tax in 47 states (except Missouri)
  • Missouri Exception: YOU must collect and remit directly
  • Setup: Walmart provides tax code sheets to download from Help Central

Configuring Tax Codes in Walmart

  1. Go to Walmart Seller Center
  2. Navigate to Settings → Tax Configuration
  3. Download the tax code sheet for your state
  4. Apply correct tax codes to each product listing
  5. Test with a few products before bulk upload
  6. Monitor settings quarterly as laws change

Self-Employment Tax Obligations

As a Walmart Marketplace seller, you owe self-employment tax:

  • Rate: 15.3% (12.4% Social Security + 2.9% Medicare)
  • Threshold: Owed when net profit exceeds $400/year
  • Form: Schedule SE (filed with Form 1040)
  • Example: $30,000 net profit = $4,590 self-employment tax

Quarterly Estimated Taxes

If you expect to owe $1,000+ in taxes, file quarterly estimated taxes:

  1. Due Dates: April 15, June 15, September 15, January 15
  2. Use Form 1040-ES to calculate quarterly payments
  3. Underpayment Penalty: 0.5% per month if underpaid

1099-K Reporting

If you exceed payment processor thresholds, you'll receive 1099-K:

  • Current Threshold: $5,000+ in payment volume (changing to $20K in 2026)
  • What It Shows: Gross transaction volume (before fees)
  • Your Action: Report on Schedule C alongside business expenses to show actual profit

Deductible Business Expenses

The IRS allows you to deduct all business-related expenses:

  • COGS: Cost of inventory purchased
  • Walmart Fees: All referral, fulfillment, and advertising fees
  • Supplies: Packaging, labels, boxes, tape
  • Shipping: Out-of-pocket shipping costs
  • Equipment: Scale, label printer, shelving
  • Software: Accounting software, Walmart tools
  • Home Office: Percentage of rent/mortgage, utilities, internet (if dedicated space)
  • Professional Services: Accountant, legal fees

Record Keeping for IRS (3+ Years)

  • All Walmart settlement reports and invoices
  • Bank deposits and reconciliations
  • Receipts for inventory and supplies
  • Shipping receipts and documentation
  • 1099-K forms (if received)
  • Sales tax collected and remitted records

Accounting Software Integration

Best Accounting Software for Walmart Sellers

1. QuickBooks Online (Industry Standard)

  • Cost: $30-200/month
  • Best For: Sellers with $50K-$500K annual revenue
  • Integration: Link My Books or manual import
  • Pros: Full accounting features, tax-ready reports
  • Cons: Steeper learning curve

2. Xero (International & Clean Interface)

  • Cost: $13-70/month
  • Best For: International sellers, simpler tax situations
  • Integration: Link My Books or direct
  • Pros: Excellent reconciliation, mobile app
  • Cons: Fewer US-specific tax features

3. Link My Books (Automation Favorite)

  • Cost: $15-50/month
  • Purpose: Auto-syncs Walmart sales to QB/Xero
  • Benefit: Saves 5-15 hours/month vs manual entry
  • Recommendation: QB Online + Link My Books = best combo

Setup Process (Link My Books + QuickBooks)

  1. Sign up for QuickBooks Online
  2. Visit Link My Books website
  3. Connect your Walmart Seller account
  4. Authorize Link My Books to access QB
  5. Map Walmart fee categories to QB accounts
  6. Enable automatic daily/weekly syncing
  7. Review & approve transactions in QB weekly

Manual Walmart Reconciliation (Spreadsheet)

  1. Download settlement reports from Walmart Seller Center
  2. Create spreadsheet: Date | Gross | Referral Fee | WFS Fee | Net Deposit
  3. Match weekly transactions to bank deposits
  4. Record net as revenue, itemize fees separately
  5. Track COGS by product sold
  6. Do this weekly—don't let transactions accumulate

Inventory & COGS Tracking

Why COGS Tracking Matters for Walmart

COGS = Cost of Goods Sold = what you paid for each item. Accurate tracking:

  • Shows which products are truly profitable after all fees
  • Identifies underpriced items (critical after Walmart fees)
  • Required for tax deductions
  • Reveals which categories to focus sourcing efforts

Calculating Cost Per Item on Walmart

Wholesale Items: Per-unit cost from wholesale supplier

Liquidation/Bulk Purchases: Total cost ÷ number of units

Branded/Retail: Your acquisition cost

Example: Retail Arbitrage on Walmart

  • Purchase price from wholesale: $20/unit
  • Walmart sale price: $45.00
  • Referral fee (10%): -$4.50
  • WFS fulfillment fee: -$2.50
  • Net to you: $37.50
  • - COGS: $20.00
  • - Packing supplies: $0.50
  • Profit: $17.00 (38% margin)

Inventory Valuation Methods

  • FIFO (First-In-First-Out): Oldest inventory valued first (best for most Walmart sellers)
  • LIFO (Last-In-First-Out): Newest inventory valued first (tax advantage)
  • Weighted Average: Average cost of all units (simplest)

Managing Slow-Moving Inventory

  • Items not selling in 60+ days: Reduce price or bundle
  • Dead SKUs: Remove from Walmart or use alternative channels
  • Write-offs: Deduct at cost loss if unsaleable
  • Don't: Keep low-velocity inventory tying up capital

Financial Reporting & Analysis

Essential Walmart Financial Reports

1. Profit & Loss Statement (P&L)

Structure for Walmart:

  • Gross Walmart Revenue: Total sales
  • - COGS: Cost of items sold
  • = Gross Profit
  • - Walmart Fees: Referral, WFS, advertising
  • - Shipping Costs: Out-of-pocket costs (if not WFS)
  • - Supplies: Packaging, labels, supplies
  • - Other Expenses: Software, equipment, professional services
  • = Net Profit

2. Category Profitability Analysis

Compare profit by product category:

  • Category | Items Sold | Revenue | Referral Fee % | Total Fees | Net Profit | Profit Margin
  • Identify highest margin categories for sourcing focus
  • Show where to reduce prices or eliminate categories

3. Cash Flow Tracking

  • When do you purchase inventory vs. when items sell?
  • How long until Walmart deposits hit your bank?
  • Seasonal patterns in sales and cash needs
  • Planning for inventory peaks/valleys

Healthy Walmart Margins

  • Gross Profit Margin 60%+: Excellent (low COGS)
  • Gross Profit Margin 40-60%: Acceptable
  • Gross Profit Margin <40%: Watch sourcing costs closely
  • Net Profit Margin 20%+: Excellent profitability
  • Net Profit Margin 10-20%: Good—standard for retail sellers
  • Net Profit Margin <10%: Low profitability—review pricing & expenses

Top 5 Walmart Seller Bookkeeping Mistakes

  • Not tracking COGS by SKU: Recording only net Walmart deposits inflates profit. Track every item's cost separately.
  • Ignoring sales tax setup: If you don't configure correct tax codes, you're collecting wrong amounts. Verify setup quarterly.
  • Forgetting self-employment tax: You owe 15.3% on profit. Set aside 30-40% monthly for taxes.
  • Mixing personal & business finances: One bank account = IRS audit risk. Separate accounts now.
  • Waiting until year-end to reconcile: Weekly reconciliation catches errors early. Don't let statements pile up.

Walmart Marketplace Facts & Statistics

10M+

Walmart Marketplace active SKUs

60K+

Third-party sellers on Walmart

6-15%

Referral fee range by category

$0

Monthly subscription fee (free)

8%

Average referral fee (Electronics)

2-3 Days

Payment processing time after settlement

Walmart Seller FAQ

What percentage of my Walmart sales do I actually keep?

After Walmart's referral fee (6-15% depending on category), you typically keep 85-94% of the sale price. For example, on a $100 electronics sale with 8% referral fee, you net $92. Then subtract your COGS, fulfillment costs, and packaging. If COGS is $40 and fulfillment is $3, your profit is $49 (49% margin). Walmart fees are significantly lower than other marketplaces.

How does Walmart handle sales tax collection?

Walmart collects and remits sales tax on behalf of sellers in 47 states (all except Missouri). However, YOU must configure correct tax codes in Seller Center. Walmart provides a tax code sheet to download. Tax is collected at checkout and deducted from your payout before deposit. Missouri sellers must collect and remit tax themselves.

What about self-employment taxes on Walmart income?

You owe 15.3% self-employment tax on your net Walmart profit (after business expenses). If profit exceeds $400/year, file Schedule SE with your tax return. If you expect to owe $1,000+, file quarterly estimated taxes to avoid penalties. Always consult a tax professional to calculate your exact obligation.

How long does Walmart take to pay me?

Walmart settles weekly, typically every Wednesday. Funds are deposited to your bank account within 2-3 business days of settlement. You can check settlement schedule and pending payouts in Walmart Seller Center under Financials → Settlements. High-volume sellers may receive twice-weekly deposits.

Should I use Walmart Fulfillment Services (WFS)?

WFS charges fulfillment fees but gets your items Prime-eligible and Prime-Fast shipping, which drives more sales. Use WFS if: 1) Your product margins are 30%+, 2) You want Amazon-like convenience, 3) You're scaling. Use Seller-Fulfilled if: 1) Margins are tight, 2) You have low shipping costs, 3) You're bootstrapping. Model both scenarios for your products.

Do I need accounting software for Walmart?

Under $30K revenue: Spreadsheets work. $30K-$100K: Use QuickBooks Online ($30-60/month) + Link My Books ($15-30/month). Over $100K: Hire a bookkeeper ($200-500/month). ROI is huge—most sellers save 5x the software cost through better pricing and tax deductions.

How do I reconcile Walmart settlement reports?

1) Go to Walmart Seller Center → Financials → Settlements. 2) Download the settlement report. 3) Compare payout amount to your bank deposit. 4) Verify all fees (referral, fulfillment, advertising) were deducted correctly. 5) If discrepancies exist, check for refunds or returns. Reconcile weekly.

What records must I keep for the IRS?

Keep for minimum 3 years (7 if significant unreported income): All Walmart settlement reports, bank deposits, receipts for inventory/supplies/expenses, shipping records, 1099-K forms (if received), sales tax collected and remitted. Digital copies are acceptable. Proper record-keeping prevents thousands in penalties if audited.