What Makes Walmart Marketplace Reconciliation Different?

Walmart Marketplace is a closed-loop marketplace — unlike payment gateways (Stripe, PayPal, Square), Walmart itself controls the entire payment process. Customers pay Walmart directly. Walmart deducts its referral fees, WFS fees, adjustments, and taxes, then remits the net balance to the seller biweekly through a payout provider. Sellers never receive gross revenue directly.

Key facts that shape every Walmart Marketplace reconciliation:

• Walmart is the payment processor, not the seller. There is no external gateway to connect. Walmart collects from customers, deducts all fees, and pays the seller the net.

• Biweekly settlement cycle. Settlement cycles close on alternate Fridays at midnight Pacific Time. Shipment notices received after the cutoff are settled in the following cycle.

• Payout arrives via a third-party provider. US sellers receive payouts through Marketplace Wallet, Hyperwallet, Payoneer, or PingPong — not directly from Walmart. Bank deposits will be labeled by the payout provider, not "Walmart."

• New sellers face a payment hold. For each order fulfilled within the initial period, payment is received approximately 28 days after the order ships.

• Walmart is a marketplace facilitator in nearly all US states. Walmart calculates, collects, remits, and refunds sales tax across all listed states (MN and WA since 2018; all remaining states through 2023). Sellers must NOT record this tax as their own Sales Tax Payable.

• No monthly subscription or listing fees. Walmart charges referral fees only — a percentage of the gross sale deducted at payout.

• Individual sync only in PayTraQer. PayTraQer syncs Walmart in individual (per-order) mode — one Sales Receipt per order, with itemized product, shipping, discount, and tax detail. There is no consolidated summary mode for Walmart.

Walmart Marketplace Fee Structure

All Walmart fees are deducted from gross sales before the seller receives a payout. Understanding each fee type is essential for accurate QBO account mapping.

Referral Fees

Referral fees are category-specific and calculated on the total sales price including item price, shipping, handling, gift wrap, and other charges — not just the item price. Selected examples from Walmart's official pricing page:

Walmart Fulfillment Services (WFS) Fees

WFS fees apply only to sellers using Walmart's fulfillment centers and are deducted from the same settlement payout as referral fees. Key 2026 rates:

• Standard fulfillment: $3.45 for ≤1 lb., scaling to $17.55 + $0.40/lb. for ≥51 lb.

• Storage: $0.75/cubic foot/month (January–September); $0.75–$2.25/cubic foot/month in peak season (October–December)

• Long-term storage (>12 months): $2.25/cubic foot/month

Map WFS fees to a separate Walmart WFS Fees and Walmart WFS Storage expense account — never lump with referral fees or COGS.

Other Settlement Deductions

• Refunds and returns: Walmart refunds customers directly; the payout is reduced by the refunded item plus return shipping costs

• Chargeback/dispute deductions: Disputed amounts are deducted from the payout; credited back if the dispute is won

• Adjustments: Manual corrections (pricing errors, compliance holds) appear as separate line items in the settlement report

Walmart Sales Tax: The Most Critical Accounting Rule

Walmart is a marketplace facilitator in virtually all US states with a sales tax law. This single fact is the most common source of expensive bookkeeping errors on Walmart.

The wrong approach: PayTraQer syncs a $9 tax amount from a Walmart order → bookkeeper maps it to Sales Tax Payable → seller files and pays $9 to the state → Walmart also remits $9 to the same state. The state has been paid twice.

The correct approach: Map all Walmart tax to a pass-through account — Walmart Marketplace-Facilitated Tax (Other Current Liability). This account nets to $0 because Walmart both collects and remits. The seller files nothing for these transactions.

Exception: For any state where Walmart does not currently remit, map that state's tax to your regular Sales Tax Payable. After 2023 this is rare for US sellers, but verify the current state list in Walmart Seller Center annually before tax configuration.

Transaction Types and QBO Mapping

Order-Level (from Walmart connector)

Settlement-Level Deductions

Step 1 — Prerequisites and QBO Chart of Accounts

Clearing Account

QBO → Accounting → Chart of Accounts → New → Account Type: Bank → Detail Type: Checking → Name: Walmart Bank Account → Save and Close.

Income and Expense Accounts

Reports to Pull Before Reconciling

From Walmart Seller Center → Payments:

• Payment Summary / Settlement Report — gross sales, referral fees, WFS fees, adjustments, refunds, net payout; primary reconciliation source

• Transaction Report — line-item detail of every order, refund, fee, and adjustment within the settlement

• Payment Statement — the official ACH transfer record; used as the "bank statement equivalent" for reconciling the Walmart Bank Account clearing account

Step 2 — Connecting Walmart to PayTraQer

1. QBO → Apps → Find Apps → search PayTraQer → Get app now → authorize

2. PayTraQer → Connectors → eCommerce Connectors → Walmart → Connect

3. Sign in with Walmart Seller Center credentials to authorize API access

4. PayTraQer downloads the last 60 days of orders automatically on first connection

5. For older data: use Download Historical Transactions with a custom date range
   No gateway connector needed. Unlike BigCommerce, WooCommerce, or Ecwid, Walmart handles both order and payment in one system. Only the Walmart eCommerce connector is required in PayTraQer.

Step 3 — Configuring PayTraQer Settings

Sales Settings

PayTraQer → Settings → Walmart → Sales Settings:

• Bank Account: Walmart Bank Account

• Income Account: Walmart Sales

• Customer: Common Customer (Walmart Customer) — keeps QBO clean; individual customer records are impractical at marketplace volume

• Payment Method: Walmart

Shipping, Discount, and Tax Settings

• Shipping Item: Walmart Shipping → Income Account: Walmart Shipping Income

• Discount Item: Walmart Discount → Account: Walmart Discounts

• Tax: Map all Walmart tax → Walmart Marketplace-Facilitated Tax (NOT Sales Tax Payable) — configure before the first sync

Fees Settings

• Referral Fee: Walmart Referral Fees

• WFS Fulfillment Fee: Walmart WFS Fees (WFS sellers only)

• WFS Storage Fee: Walmart WFS Storage (WFS sellers only)

• Adjustment: Walmart Adjustments

Payout Settings

PayTraQer → Settings → Walmart → Payout tab:

• "Do you want to process the payouts/settlements?": Toggle Yes

• "Transfer the sales to this settlement account": Business Checking

When Yes: PayTraQer creates a Transfer — Credit Walmart Bank Account, Debit Business Checking — for the net payout amount. This is what matches the bank feed deposit.

Step 4 — Syncing Transactions

Manual Sync

1. PayTraQer → Connectors → Walmart → Transactions Dashboard

2. Set date range → click Download Transactions

3. In Not Synced tab, verify a sample:

   • Deposit account: Walmart Bank Account ✓

   • Shipping: Walmart Shipping Income ✓

   • Discount: negative contra-revenue ✓

   • Tax: Walmart Marketplace-Facilitated Tax (NOT Sales Tax Payable) ✓

   • Referral fees: Walmart Referral Fees ✓

   • WFS fees (if present): Walmart WFS Fees ✓

4. Select transactions → Sync to QuickBooks

Automatic Sync

PayTraQer → Settings → Auto-Sync → ON. Walmart orders sync into QBO in real time.

Duplicate Detection

PayTraQer flags duplicates automatically. If a Walmart order was already synced, PayTraQer shows an error and stops — do not force-sync flagged duplicates.

Verify in QBO

QBO → Chart of Accounts → Walmart Bank Account → View Register. Expect individual Sales Receipts per order, fee entries, refund entries, adjustment entries, and biweekly Bank Transfers to Checking. Running balance should approach $0.00 after each payout Transfer.

Traceless Rollback

Wrong settings? PayTraQer → Synced tab → select transactions → Rollback. Transactions return to Not Synced tab for re-sync after correcting settings.

Step 5 — Matching the Bank Feed

When the Walmart payout arrives in your bank account:

1. QBO → Banking → For Review (Business Checking)

2. Find the deposit — labeled by the payout provider: "HYPERWALLET," "PAYONEER," "PINGPONG," or "MARKETPLACE WALLET" — not "Walmart"

3. PayTraQer's Transfer matches the net payout amount exactly → QBO suggests Match

4. Click Match
   Never click "Add." The payout is fully recorded through the clearing account. Adding it creates duplicate income.

Bank Rules

If Payoneer is also used for other marketplaces (eBay, Etsy, etc.): Make the rule more specific using the exact payout amount range or memo field text to distinguish Walmart Payoneer deposits from others.

Step 6 — Reconciling the Accounts

Reconcile Walmart Bank Account

1. QBO → Accounting → Reconcile → Walmart Bank Account

2. Ending Balance: Closing balance from Walmart Payment Statement for the period (typically $0.00 if all payouts received)

3. Ending Date: Last day of the period

4. Check off all Sales Receipts, fee entries, refund/return deductions, adjustments, and Bank Transfers to Checking

5. Difference: $0.00 → Finish Now → save reconciliation PDF

Reconcile Main Bank Account

After the Walmart Bank Account clears, run the standard bank reconciliation. All matched payout Transfers are already cleared.

WFS Sellers: Three-Line P&L Structure

A properly configured Walmart reconciliation produces three distinct expense lines for WFS sellers:

1. Walmart Referral Fees — the commission on each sale

2. Walmart WFS Fees — per-unit fulfillment cost

3. Walmart WFS Storage — monthly carrying cost of inventory in Walmart's warehouses

This separation lets the seller calculate true contribution margin per unit and compare WFS economics to self-fulfillment — a key analysis any ecommerce CPA should run for WFS clients.

Common Scenarios and Fixes

Month-End Checklist: Walmart Marketplace + QBO

• Walmart Seller Center Payment Summary pulled — all settlement periods within the month identified

• Walmart Transaction Report downloaded — all orders, refunds, fees, adjustments confirmed

• All Walmart orders Synced in PayTraQer Walmart Dashboard — Error tab empty

• Tax mapped to Walmart Marketplace-Facilitated Tax — NOT to Sales Tax Payable

• Walmart Marketplace-Facilitated Tax balance on Balance Sheet nets to $0

• Referral fees visible as Walmart Referral Fees on P&L

• WFS fees visible as Walmart WFS Fees and Walmart WFS Storage on P&L (WFS sellers)

• Adjustments in Walmart Adjustments — each reviewed and confirmed categorized correctly

• Each Walmart payout Matched (not Added) in QBO Banking For Review — using payout provider name

• Bank rules for all active payout providers confirmed active

• Walmart Bank Account clearing account reconciled — Ending Balance = Walmart Payment Statement — Difference $0.00

• Main bank account reconciled — all Walmart payout Transfers cleared

• P&L reviewed: Walmart Sales net of discounts; shipping separate; referral fees, WFS fees, WFS storage each on distinct expense lines

• No sales tax filing obligation for Walmart-facilitated states — Walmart Marketplace-Facilitated Tax balance documented and confirmed

• Reconciliation PDFs saved for all reconciled accounts