Key takeaways
- Use the Walmart reconciliation report as the source for the settlement period, payout, and line-level activity.
- Record gross sales separately from referral charges, WFS activity, returns, chargebacks, and other adjustments.
- Use Walmart clearing to connect settlement detail with the net deposit in business checking.
- Illustrative journal entries should balance exactly, but account names and mappings should match your bookkeeping policy.
- Review open clearing balances at month-end and document timing differences rather than erasing them.
A bookkeeper needs a repeatable process for how to record walmart sales in quickbooks when the bank deposit never equals gross order totals. The answer is not to treat the deposit as the sale. Start with the Walmart reconciliation report, record the activity through a Walmart clearing account, and then match the net payout to the bank.
Keep gross revenue visible while separating referral charges, Walmart Fulfillment Services (WFS), returns, chargebacks, and other settlement lines. Explain clearing balances rather than forcing deposits into sales.
Why the Walmart deposit is not the sales total
A Walmart payout is generally the result of several categories combined. Gross order proceeds may be increased or reduced by marketplace charges, fulfillment activity, customer refunds, chargebacks, reserves, reimbursements, and corrections. The bank sees the final amount transferred to you; QuickBooks needs the underlying activity if your records are to explain that transfer.
For example, this illustrative example uses a gross order total of $12,000.00. Assume Walmart reports $1,080.00 of referral charges, $720.00 of WFS activity, $300.00 of customer returns, and $100.00 of chargebacks. The resulting payout is $9,800.00. The deposit is real, but it is not a complete description of the sales activity.
If you post only $9,800.00 to sales, the books do not show the original order revenue or the individual reductions. If you post $12,000.00 to sales and then categorize the bank deposit as another sale, revenue is recorded twice. A clearing workflow avoids both problems.
Build the Walmart clearing workflow
The basic sequence is:
- Walmart reconciliation report: Identify the settlement ID, period, gross orders, adjustments, fees, and net payout.
- Walmart clearing: Post the complete settlement activity so the account reflects what Walmart owes or has applied to the payout.
- Bank deposit: Transfer the net amount from Walmart clearing to checking when the funds arrive.
A clearing account is useful because the settlement and the bank transaction often happen on different dates. It also prevents the bank feed from becoming the primary sales record. The settlement journal explains the activity; the bank transaction confirms that cash arrived.
Create accounts with enough detail to support review. A typical structure might include Walmart Sales, Walmart Referral Charges, WFS Expense, Sales Returns and Allowances, Chargebacks, and Walmart Clearing. Your chart of accounts may use different names. Consistency matters more than a particular naming convention.
Separate the important Walmart settlement lines
Gross order sales
Start with the gross order amount shown for the settlement period. Keep product sales separate from the reductions that follow. This makes sales reporting easier to compare with Walmart's order and reconciliation reports.
Referral charges
Referral charges are marketplace costs associated with eligible orders. Map them to a consistent expense account rather than reducing the sales line. The report description and your established chart-of-accounts policy should guide the mapping.
WFS activity
WFS charges relate to Walmart's fulfillment services and may include multiple kinds of activity. Keep WFS lines separate from referral charges when the report distinguishes them. This helps explain changes in fulfillment-related expense without hiding them in a general marketplace account.
Returns and refunds
Customer returns reduce the amount retained from orders, but they are not the same as a marketplace fee. Record returns using a returns or allowances account, with the report reference preserved. A fee reversal may also appear alongside a customer refund; keep the lines distinct when the source report does.
Chargebacks
A chargeback is a customer-payment or order adjustment that can reduce a payout. Record it separately from ordinary returns when the report provides a separate category. Review the order or case reference before posting an unexplained chargeback amount.
Other adjustments
Reserves, reimbursements, corrections, prior-period items, and payout holds can affect clearing. Do not force an unfamiliar line into sales or a generic expense account just to make the journal balance. Retain the description, investigate the source, and document the mapping decision.
Illustrative journal example: Walmart settlement to clearing
The following is an illustrative example, not a fee schedule. It shows gross order sales and separate settlement reductions. Debits and credits both total $12,000.00.
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Walmart clearing | 9800.00 | |
| Walmart referral charges | 1080.00 | |
| WFS expense | 720.00 | |
| Sales returns and allowances | 300.00 | |
| Chargeback expense | 100.00 | |
| Walmart sales | 12000.00 | |
| Total | 12,000.00 | 12,000.00 |
Clearing represents the expected payout; the sales credit preserves gross revenue. Map any additional report lines by source classification and recalculate clearing.
When the $9,800.00 payout reaches the bank, record the transfer below. This is a second illustrative example and balances at $9,800.00.
| Account | Debit | Credit |
|---|---|---|
| Account | Debit | Credit |
| Business checking | 9800.00 | |
| Walmart clearing | 9800.00 | |
| Total | 9,800.00 | 9,800.00 |
Match the downloaded bank transaction to this transfer. Do not categorize the same deposit as sales, miscellaneous income, or a second Walmart receipt. The settlement journal already recorded the sales and reductions.
Steps for how to record Walmart sales in QuickBooks
- 1
Select the settlement
Locate the Walmart reconciliation report and confirm the settlement ID, date range, payout amount, and marketplace. Use one report period at a time.
Confirm the bank deposit: Find the related deposit or expected payout in the bank register. A settlement may be recorded before the deposit arrives, so do not assume that a nearby deposit belongs to it without checking the amount and reference.
Export the detail: Save the reconciliation report and any order, return, chargeback, or WFS detail needed to support the totals. Keep the original labels and identifiers.
Group the lines: Separate gross sales, referral charges, WFS activity, returns, chargebacks, reserves, reimbursements, and other adjustments. Confirm that the grouped lines agree with the report's net payout.
Check for prior entries: Search QuickBooks for imported sales, an earlier Walmart journal, or a manually entered deposit. Duplicate settlement activity can create a false clearing balance.
Post the settlement journal: Record gross sales and the supported settlement lines through Walmart clearing. Confirm that debits equal credits and that the clearing amount agrees with the payout.
Record the bank transfer: When the money arrives, debit business checking and credit Walmart clearing. Match the bank feed to that transfer.
Document exceptions: Add a note for a missing deposit, reserve, timing difference, unresolved chargeback, or unusual correction. Include the settlement ID and the next review date.
Review the period: Compare the clearing activity with the report and bank register. Resolve old balances before they become difficult to trace.
Month-end Walmart reconciliation checklist
At month-end, first list every Walmart settlement included in the accounting period. Compare the settlement IDs and net payout amounts with bank deposits, including deposits that were initiated in one month and received in the next. This separates a timing issue from a missing entry.
Next, review the Walmart clearing account by settlement. A zero balance is useful, but an open balance is not automatically wrong. It may represent a payout in transit, a reserve, or activity that Walmart will include in a later settlement. Each nonzero balance should have a clear explanation and follow-up owner.
Then compare category totals. Gross sales should tie to the selected report scope. Referral charges, WFS activity, returns, and chargebacks should be supported by the corresponding report lines. Look for a fee line posted to sales, a return omitted from the settlement, or a chargeback entered twice.
Retain the report, journal reference, bank match, exception notes, and supporting order detail so another bookkeeper can retrace the work.
Troubleshooting common mismatches
The bank deposit is smaller than the journal clearing amount. Check whether a reserve, chargeback, return, or additional settlement line was omitted. Also confirm that the report and bank deposit refer to the same settlement period.
The clearing account has a credit balance. Look for a bank transfer posted before the settlement journal, a duplicate deposit, or an entry that credited clearing instead of the correct settlement account. Review the settlement ID before making an adjustment.
The clearing account has a debit balance. The payout may not have arrived, or the journal may be missing a reduction that would lower the amount due. Check for a later deposit, a payout hold, or a report line outside the original export.
The same payout appears twice. Compare the bank reference, settlement ID, and journal date. Remove or reverse the duplicate according to your internal review process, and retain a note explaining the correction.
Keep Walmart records repeatable
Keep the sequence consistent: record gross orders, classify settlement reductions, post through Walmart clearing, and match the bank deposit only once.
If you want help making this workflow more consistent, explore ClearPayout's Walmart QuickBooks integration and review ClearPayout pricing. Choose a process that preserves the detail your bookkeeper needs, then apply the same mapping and reconciliation steps to every Walmart settlement.
Frequently asked questions
Related guides
General bookkeeping information, not tax or legal advice.