Bring the settlement in.
Download the settlement report from Walmart Seller Center and drop it in. Every line item is kept, with a trail back to the source report — fees, adjustments, chargebacks and all.
Walmart to
QuickBooks Online.
Walmart settles after delivery confirmation, bundling sales with referral fees, WFS charges, returns and the occasional chargeback. TidyPayouts reads your Seller Center settlement report, maps every line, and posts one reviewed journal entry that matches the deposit to the penny.
CSV IMPORT✓ Free during beta✓ Review before posting
WalmartSettlement reports
TidyPayoutsBreakdown · mapping · review
QuickBooks OnlineOne journal entry per settlementWHAT’S INSIDE A WALMART SETTLEMENT.Every deduction,
Every deduction,
named and mapped.
Chargebacks shouldn’t hide
inside your deposit.
- ↳SalesItem and shipping revenue per order, ready for your sales accounts.
- ⚖Referral feesCategory commission — roughly 8–15% — as its own mappable line.
- ◫WFS feesWalmart Fulfillment Services pick, pack and storage charges, separate from referrals.
- ↩Refunds & returnsRefunded orders and return-related adjustments, with fees they hand back.
- ✦AdjustmentsCorrections and reconciling charges between periods, flagged for review.
- ◎ChargebacksOperational deductions that stand out on the P&L instead of vanishing.
- %Sales tax collectedMarketplace-collected tax where Walmart remits — pass-through, not income.
- ≋Payout cadenceBiweekly settlements after delivery confirmation, each reconciled to its bank amount.
FOUR STEPS. EVERY SETTLEMENT.From settlement to
From settlement to
journal entry, in order.
Set it up once.
Then it’s just review and post.
Give every line an account.
Map each line type to an account in your QuickBooks chart of accounts — sales, referral fees, WFS, refunds, adjustments, chargebacks, tax. Mappings are reusable: set them once, and every future settlement follows.
Check it against the deposit.
Resolve unmapped lines, look over chargebacks and adjustments, and compare the net against the deposit that actually arrived. Nothing posts until you approve it.
Send it to QuickBooks.
One balanced journal entry, dated the settlement’s deposit date, nets to the penny of your bank feed. Reversible and re-postable if you change a mapping later.
WHAT LANDS IN YOUR BOOKS.One entry.
One entry.
Every dollar explained.
Your P&L shows real Walmart margins —
WFS and chargebacks included.
Example: a $3,952.45 settlement
ILLUSTRATIVE · SAMPLE DATA| Account (as you mapped it) | Debit | Credit |
|---|---|---|
| Checking account the deposit itself | $3,952.45 | |
| Refunds & returns refunded orders | $158.00 | |
| Marketplace fees referral + WFS | $749.55 | |
| Sales — Walmart item and shipping revenue | $4,860.00 | |
| Totals | $4,860.00 | $4,860.00 |
One journal entry per settlement, dated the deposit date. The entry nets to $3,952.45 — the amount that hit the bank — so QuickBooks’ bank feed matches without manual reconciling. Adjustments, chargebacks and marketplace-collected tax, when present, get their own mapped lines. Made a mistake or changed a mapping? Entries can be reversed and re-posted without losing the trail back to the source report.
THE SETUP GUIDE.Set it up in
Set it up in
an afternoon.
Most of this is one-time work.
After that, a settlement takes minutes.
Create your TidyPayouts account
Join the free beta with your email — no credit card, every plan is free while we’re in beta.
Connect QuickBooks Online
In the app, go to
Settings → Account settingsand connect QuickBooks with your Intuit login. Owner access in TidyPayouts is required, and the connection syncs your chart of accounts so mapping uses your real account names. Availability is rolling out during beta; check connection status inside the app.Download your Walmart settlements
In Seller Center, go to
Payments(orInsights → Payouts) and download the settlement report for the period you need. Import it into TidyPayouts; each settlement becomes its own review.Map your line types
Assign each settlement line type — sales, referral fees, WFS, refunds, adjustments, chargebacks, tax — to an account. Sensible defaults get you most of the way; adjust anything to match your chart.
Review the settlement
Compare the net against the actual deposit, look over chargebacks and adjustments, and add product costs if you track COGS. Unmapped lines are held out (and clearly listed) rather than guessed into an account.
Post, then match the deposit
Send the journal entry to QuickBooks, then match the deposit in your bank feed. Done — on to the next settlement, with the whole trail kept for review.
How do I export my Walmart settlements?+
In Walmart Seller Center, go to Payments (or Insights → Payouts) and download the settlement report for the period you need. Import it into TidyPayouts and the settlement is broken down into sales, referral fees, WFS fees, returns, adjustments and chargebacks.
When does Walmart pay out, and how does that affect posting?+
Walmart settles on a biweekly cycle after delivery confirmation, so one settlement can cover many days of orders. TidyPayouts posts one journal entry per settlement, dated the deposit date — the books stay aligned with your bank while order and SKU detail stays in your workspace.
What about Walmart chargebacks and adjustments?+
Operational chargebacks, failures and reconciling adjustments are imported as their own line types, so they land in the accounts you choose and stand out for review instead of vanishing into the deposit.
Is the QuickBooks connection available now?+
The QuickBooks connection is part of the beta and availability is rolling out by account. Walmart settlements use the CSV import workflow today, which works the same way the connection will: download from Seller Center, import, map, review and post.
Can my bookkeeper double-check before anything posts?+
Yes — that’s the point. Summaries, mappings and source records are all reviewable, and nothing posts until someone approves it. If a posted entry needs to change, it’s reversed and re-posted rather than edited behind the scenes.
OTHER CHANNELS, SAME IDEA.More pairs,
More pairs,
same tidy path.
Bring every channel into the same
QuickBooks workflow.
Amazon to QuickBooks
Settlement flat files or the beta connection: referral and FBA fees, storage, advertising, reserves.
Read the Amazon guide →
Shopify to QuickBooks
Payout reports from Shopify Payments: gross sales, refunds, processing fees and reserves.
Read the Shopify guide →
eBay to QuickBooks
Final value fees, Promoted Listings, labels and dispute holds from Seller Hub CSVs.
Read the eBay guide →
Etsy to QuickBooks
Listing, transaction and processing fees, Offsite Ads and the tax Etsy collects.
Read the Etsy guide →Your settlements,
already sorted.
The next settlement doesn’t have to be a mystery deposit.
Start your free beta →Free during beta. No credit card. A little more breathing room.