Walmart Marketplace Referral Fee: Recon Lines to Expense

Your Walmart payout is lower than sales minus the commission you expected. The recon report shows a walmart marketplace referral fee against individual orders, but QuickBooks has only gross sales. There is no Walmart commission expense, and the bank deposit will not match the amount sitting in your books.

The fix is not to shrink sales until the deposit fits. Identify the actual referral charges, separate them from fulfillment and other activity, and record the missing expenses through Walmart clearing. Then match the payout to the bank without creating sales again.

Where the walmart marketplace referral fee appears

Start with the detailed reconciliation report that supports the payout, rather than a dashboard sales total. Locate referral or commission activity using the available transaction descriptions, fee fields, and order references. Exact labels and layouts can vary; confirm field meanings against the report documentation you are using.

A charge may be presented as a separate transaction or as a component associated with an order line. Preserve the order identifier, item reference where available, amount, transaction date, and payout reference. These fields let you trace an expense total back to its supporting activity.

Do not assume every negative line is a referral fee. Establish which fields contain sales and which contain fees, and confirm whether displayed amounts are signed. If a report provides both transaction detail and summary totals, use the summary as a control rather than adding it to the detail again.

The question is not just “What commission was charged?” It is also “Which charges and credits were included in this payout?” An order-date export can cover a different population from the payout report.

Why an assumed commission does not explain the deposit

A search for a walmart commission rate can help you review marketplace terms, but one assumed rate is not a reconciliation method. The applicable terms and the transaction's circumstances need checking against Walmart's current documentation. This guide does not prescribe rates or category schedules.

For bookkeeping, use the posted charges supported by the recon report. Compare unexpected amounts with the underlying order and applicable terms, but do not substitute an estimate for the report merely because the estimate looks familiar.

The phrase walmart marketplace commission describes the referral-fee concept, not every amount withheld from a payout. Even a correct referral total will not explain fulfillment charges, refunds, or balance movements. Build the payout from all supported components instead of treating the remaining difference as additional commission.

Keep referral expense separate from WFS and other fees

Create a clearly named expense account such as Walmart referral and commission expense. Map supported referral charges there consistently. Keep WFS expenses separately identifiable so marketplace selling costs and fulfillment costs remain distinguishable on the profit and loss statement.

Other Walmart charges need their own review. A service charge should not become referral expense just because both reduce cash received. Likewise, a reserve movement is not automatically an expense: determine whether it represents funds still owed to the business and track it accordingly.

Refunds and fee credits also need distinct treatment. A customer refund changes the sales side of the reconciliation; a related referral-fee credit changes the expense side. Do not infer one amount from the other. Record only the credit actually supported by the report, preserving its link to the original activity.

For the broader classification framework, see Walmart seller fees. For fulfillment-specific questions, use the Walmart WFS fees guide. Here, the goal is a clean referral-expense subtotal within a complete payout reconciliation.

Illustrative example: bridge sales to the payout

The following amounts are illustrative examples, not a fee schedule or an implied commission rate. Assume this simplified payout has no refunds, opening balance, reserve movement, or other adjustments beyond the components shown.

The referral lines explain $1,400 of expense. They do not explain the entire $2,000 difference between gross sales and cash. The remaining $600 belongs to the separately supported WFS and service charges.

For a fresh posting where none of this activity has been recorded, the illustrative settlement entry is:

Debits and credits both equal $10,000. The clearing debit represents the supported payout, not additional income. This full entry is an alternative to completing existing sales records, not an extra entry to place on top of them.

Illustrative example: gross sales already exist

Return to the seller's actual problem: QuickBooks already contains gross sales but no commission expense. Inspect that sales posting before making changes.

Suppose, using the same illustrative amounts, the existing entry credits product sales and debits Walmart clearing for $10,000. In that case, record only the missing expenses:

This entry balances at $2,000 and reduces clearing from $10,000 to $8,000. It does not credit product sales again.

If the original sales debit went to accounts receivable, checking, or another account, this example is not a complete correction. Trace that posting and establish the appropriate clearing workflow with your bookkeeper before adding entries. Otherwise, a balanced fee journal can still leave sales or cash overstated.

When the illustrative payout reaches the bank, record its movement:

Match the downloaded deposit to this recorded transfer. Do not categorize the same bank feed item as new sales. The Walmart–QuickBooks integration overview describes the marketplace-to-books workflow.

Steps to reconcile referral fees in QuickBooks

1. 1

   Identify the payout

   Save its reference, amount, and supporting recon report. Compare the same payout population throughout, rather than mixing order-date totals with payment activity.

2. Isolate referral activity: Group supported referral charges and credits. Retain order references and verify signs so credits reduce expense rather than increase it.

3. Separate other components: Classify WFS, service charges, refunds, and balance movements independently. Explain the complete difference between gross activity and the payout.

4. Inspect existing QuickBooks records: Find the gross-sales posting and its offset account. Check for imported fees, manual journals, or a previously recorded deposit before adding anything.

5. Post only missing activity: Use Walmart clearing and consistent expense mappings. Choose either a complete new settlement entry or the missing-components approach, according to what already exists.

6. Match and review: Match the payout transfer to the bank deposit, then review clearing by payout reference. Document any remaining balance rather than forcing it to zero.

The settlement reconciliation walkthrough covers the same clearing-to-bank principle for Amazon. Apply the principle here using Walmart's own report fields and supporting records, not Amazon transaction labels.

Troubleshooting a remaining difference

The referral total looks too large. Check whether you included summary rows alongside transaction detail, imported the same report twice, or reversed the sign of a fee credit. Inspect the selected lines before changing the expense account.

Commission agrees, but cash still differs. Review WFS and other charges, refunds, prior balances, and funds withheld or released. The Walmart payout guide covers the broader bridge. Do not use commission expense as a balancing plug.

Clearing still has a balance. Inspect it by payout and posting reference. Another payout in transit or a supported balance carried forward can explain an open amount. A duplicate sales import can also create one; those situations require different actions.

An order has a later fee credit. Keep the original charge and later credit traceable. Include each in the payout where it actually appears, rather than silently rewriting a prior reconciliation.

Make referral review part of the payout workflow

Keep the recon report, referral subtotal, expense mapping, and bank match together. That support should explain both why the deposit is smaller than sales and why commission expense differs from total Walmart charges.

If you want help making that workflow repeatable, explore ClearPayout's Walmart connection and pricing. The objective is simple: recognize each supported fee once, keep referral expense visible, and match the resulting payout without recording revenue twice.