Walmart Marketplace Accounting Guide
Understand Walmart referral fees, WFS costs, export your Seller Center data, and import everything into QuickBooks — completely free with PrimeConnect.
Walmart Marketplace Fee Structure
No monthly subscription. You only pay when you sell — through referral fees and optional WFS fulfillment costs.
Referral Fees (Commission)
Walmart charges a referral fee on each sale, calculated as a percentage of the total sale amount (item price + shipping). Rates vary by product category:
- Apparel & Accessories15%
- Electronics8%
- Home & Garden15%
- Sporting Goods15%
- Personal Computers6%
- Tires & Wheels10%
- Range across all categories6% – 15%
No Monthly Subscription
Unlike Amazon ($39.99/mo for Professional sellers) or eBay store subscriptions ($4.95-$2,999.95/mo), Walmart Marketplace charges zero monthly fees. There is no subscription tier, no listing fee, and no account maintenance charge.
Cost advantage: A Walmart seller with $10,000/mo in sales saves $480/year in subscription fees compared to Amazon, before comparing referral rate differences.
Walmart Fulfillment Services (WFS) Fees
WFS is Walmart's fulfillment program (similar to Amazon FBA). Sellers ship inventory to Walmart's warehouses, and Walmart handles pick, pack, ship, and customer service. WFS fees are separate from referral fees:
Fulfillment Fees
Based on item weight and dimensions. Starts around $3.45 for standard items (under 1 lb). Oversize items incur higher rates.
Storage Fees
Monthly fee based on cubic feet of warehouse space used. Standard rate with peak season surcharges (Oct-Dec). Plan inventory levels to minimize.
Return Processing
Fee charged when a WFS item is returned and inspected at the warehouse. Varies by item size. Deducted from your next payment period.
How to Export Walmart Transaction Data
Two export methods from Walmart Seller Center cover all your accounting needs.
Payment Report Export
- Log into Walmart Seller Center
- Navigate to Reports in the left sidebar
- Select Payment reports
- Choose your date range (biweekly period recommended)
- Click "Download" to export as CSV
This report includes payment-level data: order revenue, referral fees, WFS fees, refunds, adjustments, and net payout amounts. Best for reconciling against bank deposits.
Order Detail Export
- Go to Orders in Seller Center
- Filter by status and date range
- Click "Export" or "Download"
- Choose CSV format
- Save the file for import into PrimeConnect
This report includes order-level data: buyer details, item descriptions, quantities, shipping addresses, and order status. Best for tracking individual sales and inventory movement.
Walmart Marketplace Accounting Challenges
Walmart's biweekly payout cycle and WFS program create specific bookkeeping hurdles.
Return Handling Complexity
Walmart has a generous return policy that allows customers to return most items within 90 days. For WFS items, Walmart handles the return directly, and the refund plus any fee credits appear in a future payment period — not the same period as the original sale. This timing mismatch creates accrual accounting challenges. You need to record a return reserve based on historical return rates, then reconcile actual returns as they appear in each biweekly payment report.
WFS Fee Tracking
Walmart Fulfillment Services charges multiple fee types — fulfillment fees (pick/pack/ship), monthly storage fees, return processing fees, and occasional inventory disposal fees. Each fee type needs separate tracking in QuickBooks because they impact your P&L differently. Storage fees are a monthly recurring cost regardless of sales, while fulfillment fees correlate directly with order volume. Mixing them into a single "WFS Fees" account obscures your true per-unit fulfillment cost.
Category-Based Fee Variations
Walmart's referral fees range from 6% (Personal Computers) to 15% (Apparel, Home & Garden). If you sell across multiple categories, you cannot apply a single flat rate to estimate fees — each order has a different effective commission rate. Your accounting must track the actual referral fee charged per order rather than an assumed average. PrimeConnect reads the exact fee from your Walmart payment report, eliminating estimation errors and ensuring accurate COGS recording.
Marketplace Facilitator Tax
Walmart collects and remits sales tax as a marketplace facilitator in all applicable states. While this simplifies your tax compliance, it creates an accounting wrinkle: the sales tax amount flows through your reports but is never actually deposited to your bank account. You need to track it separately in QuickBooks (as a pass-through) to avoid inflating your revenue figures. Failing to exclude collected-and-remitted tax from your income leads to overstated revenue and overpaid income taxes.
Walmart to QuickBooks Workflow
Follow these five steps to get your Walmart data into QuickBooks accurately.
Export from Walmart Seller Center
Download your payment report from Seller Center > Reports > Payment reports. Select the biweekly payment period you want to reconcile and export as CSV. This report contains all order payments, referral fees, WFS fees, refunds, and net payout amounts for the period.
Upload to PrimeConnect Converter
Open the Walmart to QuickBooks converter and drag-and-drop your CSV file. The tool automatically detects Walmart's column format and parses all transaction types — sales, referral fees, WFS fees, refunds, and adjustments. Everything runs in your browser with zero server involvement.
Configure Fee Splitting Options
Review the auto-detected settings. Enable fee splitting to break out referral fees and WFS fees (fulfillment, storage, return processing) as separate line items. This is critical for accurate COGS reporting — referral fees and fulfillment fees are COGS, while storage fees may be categorized as warehouse expense. Choose your QuickBooks edition for correct column mapping.
Download QuickBooks-Ready File
Preview the converted transactions, then download the QuickBooks-compatible CSV. Need a different format? Use PrimeConnect's CSV to IIF converter for QuickBooks Desktop or the CSV to QBO converter for Web Connect import.
Import & Reconcile in QuickBooks
Import the converted file into QuickBooks using the bank feed or file import workflow. Match each biweekly Walmart payout to the corresponding bank deposit. Categorize referral fees and WFS fulfillment fees as Cost of Goods Sold, WFS storage fees as Warehouse Expense, and refunds as contra-revenue entries.
QuickBooks Account Mapping for Walmart
Map each Walmart transaction type to the correct QuickBooks account.
| Walmart Transaction Type | QuickBooks Account | Account Type |
|---|---|---|
| Sale revenue | Walmart Sales Revenue | Income |
| Referral fee | Walmart Referral Fees | COGS |
| WFS fulfillment fee | WFS Fulfillment Fees | COGS |
| WFS storage fee | Warehouse & Storage | Expense |
| WFS return processing | WFS Return Processing | COGS |
| Refund | Walmart Sales Revenue (contra) | Income (negative) |
| Shipping revenue | Shipping Revenue | Income |
| Adjustment / correction | Walmart Adjustments | Other Income / Expense |
Walmart Marketplace Tax Considerations
Marketplace Facilitator Tax Collection
Walmart is classified as a marketplace facilitator in all US states that have enacted such legislation. This means Walmart calculates, collects, and remits sales tax on every Walmart Marketplace order — you do not need to manage sales tax compliance for these orders. The sales tax amount appears in your payment report but is never deposited to your bank account (Walmart remits it directly to the tax authority). In QuickBooks, do not record this tax as income — track it as a pass-through or exclude it entirely from your revenue calculations.
1099-K Reporting
Walmart is required to issue a 1099-K form to sellers who exceed the IRS reporting threshold ($5,000 in gross payments as of 2024). The 1099-K reports gross sales before referral fees, WFS fees, refunds, and adjustments. This number will be significantly higher than your actual net deposits. Accurate bookkeeping that separately tracks each fee type and refund is essential — your tax return should reconcile gross 1099-K income minus documented fees and refunds to arrive at your true taxable income.
WFS Inventory & Sales Tax Nexus
If you use Walmart Fulfillment Services, your inventory is stored in Walmart's warehouses across multiple states. In some jurisdictions, having inventory in a state creates sales tax nexus — meaning you may have filing obligations in states where your WFS inventory is stored, even for sales on non-Walmart channels. While Walmart handles marketplace facilitator tax for Walmart.com orders, your obligations for other sales channels (your own website, other marketplaces) may expand based on where WFS stores your inventory. Consult a tax professional to determine your multi-state filing requirements.
Walmart Marketplace Accounting Best Practices
Follow these six rules to keep your Walmart books clean year-round.
1. Reconcile Every Biweekly Payout
Walmart pays biweekly, so you should reconcile each payout against your Seller Center payment report immediately when the deposit hits your bank. Verify that gross sales minus referral fees, WFS fees, and refunds equals the net deposit amount. Flag any discrepancies immediately.
2. Separate WFS Fee Categories
Never lump all WFS fees into one account. Create separate QuickBooks accounts for fulfillment fees (COGS), storage fees (warehouse expense), and return processing fees (COGS). This gives you visibility into which cost component is growing and enables you to optimize inventory levels for storage cost reduction.
3. Track Referral Fees by Category
If you sell across multiple Walmart categories, track the effective referral rate per product line. An item in the 15% Apparel category has dramatically different margins than one in the 6% Personal Computers category. Use QuickBooks class tracking or sub-accounts to segment referral fee expense by category.
4. Monitor Return Rates
Walmart's 90-day return window means returns can appear long after the original sale. Track your return rate as a percentage of gross sales and set up a return reserve in QuickBooks (estimate 5-15% depending on category). Adjust the reserve quarterly based on actual return data from your payment reports.
5. Exclude Facilitator Tax from Revenue
Sales tax collected and remitted by Walmart as marketplace facilitator is not your revenue — it is a pass-through. Never record it as income in QuickBooks. If your Walmart payment report includes a tax column, either exclude it during import or record it in a "Sales Tax Collected (Walmart)" pass-through account that nets to zero.
6. Use a Dedicated Bank Account
Link your Walmart Marketplace payouts to a dedicated bank account, separate from other marketplace deposits (Amazon, eBay, etc.). This makes biweekly reconciliation straightforward — every deposit is a Walmart payout and nothing else. Create a matching bank account in QuickBooks for clean one-to-one matching.
Related PrimeConnect Tools
Everything you need to get Walmart data into QuickBooks — free.
Walmart to QuickBooks
Convert Walmart Seller Center payment reports to QuickBooks-ready CSV with commission splitting.
Convert free →CSV to IIF Converter
Convert CSV output to IIF format for QuickBooks Desktop import.
Convert free →CSV to QBO Converter
Convert CSV output to QBO (Web Connect) for direct QuickBooks bank feed import.
Convert free →Multi-Channel Merge
Combine Walmart exports with other platforms into one QuickBooks file.
Merge now →Analytics Dashboard
Compare Walmart fees and revenue against other platforms visually.
Analyze now →Ecommerce Accounting Hub
Central hub for all 11 platform converters and accounting guides.
View all tools →Related Platform Guides
Multi-channel seller? These guides cover accounting for other marketplaces Walmart sellers commonly use.
Amazon Accounting Guide
Settlement reports, FBA fees, multi-marketplace bookkeeping, and how to import Amazon transactions into QuickBooks.
Read guideeBay Accounting Guide
Managed payments accounting, Seller Hub exports, 13+ fee types, and how to reconcile eBay payouts in QuickBooks.
Read guideTikTok Shop Accounting Guide
Commission rates, affiliate fees, live shopping revenue, settlement exports, and QuickBooks import for TikTok Shop.
Read guideFrequently Asked Questions
How do I export my Walmart Marketplace transaction data?
Does Walmart charge a monthly subscription fee?
What are Walmart Fulfillment Services (WFS) fees?
How does Walmart handle sales tax?
Is the Walmart to QuickBooks converter free?
How do I handle Walmart returns in QuickBooks?
How often does Walmart pay marketplace sellers?
Can I import Walmart data into QuickBooks Desktop?
Convert Your Walmart Data to QuickBooks — Free
Upload your Seller Center payment report and get a QuickBooks-ready file in seconds. Referral fees and WFS costs split automatically. 100% browser-based.
Convert Walmart to QuickBooks →