Walmart Marketplace to NetSuite reconciliation
Walmart Marketplace settlement reconciliation to NetSuite
A channel guide for Walmart Marketplace sellers whose settlement-cycle deposit nets commissions, fulfillment fees, and refunds that NetSuite never sees.
The method
How do you reconcile Walmart Marketplace settlements to NetSuite?
Walmart Marketplace settlement reconciliation to NetSuite maps each line of the settlement report (product sales, category referral commissions, Walmart Fulfillment Services fees, refunds, and commission credits) back to the NetSuite orders behind each settlement deposit. The method decomposes the net payout before posting, so finance reviews the exceptions instead of reverse-engineering what Walmart withheld.
Key takeaways
- Start from the Walmart settlement report, not the net deposit that lands in the bank.
- Separate referral commissions, WFS fees, refunds, and adjustments before posting.
- Match each commission credit back to the refund and original order that triggered it.
- Hold unmatched lines for review instead of dropping them into a clearing account.
01 · The pattern
Why does a Walmart settlement not match NetSuite?
A Walmart Marketplace deposit rarely equals a clean sum of NetSuite sales because the payout is net of category referral commissions, Walmart Fulfillment Services fees, refunds, and adjustments, settled on a cycle that does not follow the accounting period. NetSuite records each order, fee, and refund as a separate event, while Walmart compresses them into one net settlement amount.
- Walmart pays on a settlement cycle that may not align with the close.
- Category referral commissions and WFS fulfillment fees are netted out before the deposit.
- A refund reverses part of the original commission, which can split an order's economics across settlements.
- The bank deposit is a single net figure; NetSuite holds the gross order, fee, and refund detail.
02 · The pattern
Which Walmart settlement lines need NetSuite treatment?
Each category in the settlement report needs a known NetSuite destination or an exception reason. The goal is not to make Walmart look like NetSuite; it is to preserve enough source detail that NetSuite carries accurate revenue, commission, fulfillment-cost, and refund treatment instead of a lump-sum deposit.
| Walmart detail | NetSuite treatment | Review gate |
|---|---|---|
| Product sales and shipping revenue | Sales order, invoice, or cash application path | Confirm the order maps to the expected NetSuite customer and channel. |
| Category referral commission | Fee expense or configured clearing treatment | Check commissions are isolated from gross sales by category. |
| Walmart Fulfillment Services (WFS) fees | Fulfillment-cost expense | Separate fulfillment cost from product margin. |
| Refunds and commission credits | Refund, credit, or exception path | Tie the refund and its commission reversal to the original order. |
03 · The pattern
What happens to a Walmart line that won't match?
When a line will not match, the tempting shortcut is to force the remainder into a clearing or “Other Deposits” account so the deposit ties. The cash looks reconciled, but the cause is buried and the variance resurfaces at audit. The safer method assigns every known line-type to its account by lookup and routes only the genuine exception to a person.
- Forcing the remainder into a catch-all clearing line makes the deposit tie but hides the cause.
- A deterministic method assigns each known line-type to its account by lookup, not by guess.
- Genuine exceptions (a missing order, an unexplained deduction) route to a human with the source detail attached.
- Repeat exceptions feed back into the mapping and integration rules so the same line stops recurring.
Shared vocabulary
What terms matter on this page?
These definitions keep the method precise and extractable for answer engines, while giving finance a shared vocabulary for source files, NetSuite treatment, and review gates.
Settlement report
The Walmart Marketplace report that lists the sales, referral commissions, fulfillment fees, refunds, and adjustments behind a settlement deposit.
Referral commission
The category-based fee Walmart deducts from each sale before paying the seller.
Commission credit
The partial commission Walmart returns when an order is refunded, which must be matched back to the original sale.
Where it goes next
When the pattern becomes an operating decision
This pattern sits between the settlement library, productized reconciliation, and the service paths that explain why the mismatch keeps recurring.
If this reconciliation pattern is caused by connector behavior, the operating decision belongs with a Celigo NetSuite integration partner. If the issue comes from a stalled implementation or brittle partner handoff, compare it with NetSuite HealthCheck and recovery. If the same pattern recurs every close, evaluate Vista Recon against the full NetSuite payout reconciliation.
Amazon FBA settlement reconciliation
Apply the same marketplace settlement method to Amazon FBA disbursements.
Open
Fee and adjustment isolation
See the operator pattern for separating commissions and fees before posting.
Open
NetSuite payout reconciliation hub
Read the broader settlement and payout reconciliation method.
Open
Vista Recon
See the Altura product path for governed settlement reconciliation.
Open
Authorship
Who wrote this guide?
Written by Dave Charland, Founder, Altura Innovation. Last updated 2026-06-20.
FAQ
Frequently asked questions
Need this payout source to tie to NetSuite?
Tell us where the source file, NetSuite record, and close process stop agreeing, and we will help scope the safest Vista Recon path.