Can QuickBooks Online read a Walmart settlement report?

No. QBO sees the Walmart deposit arrive and has no way to interpret it. The settlement report from Seller Center carries a transaction type on every row, and that type column is what turns a deposit into commission, WFS fulfilment, storage, refunds, fee credits, and adjustments. BeanHawk does that grouping and hands QBO one balanced journal entry per settlement period.

Where do Walmart Connect advertising charges belong in QuickBooks Online?

In an advertising expense account, tagged to the Walmart channel with a class if your plan supports class tracking. Because Walmart Connect usually bills separately rather than coming out of the settlement, it lands in QBO as a card or bank charge with no obvious connection to the channel. Left untagged, your Walmart profit and loss carries no ad spend and looks better than Amazon on a comparison that is not fair.

How often does Walmart Marketplace pay out?

On a recurring cycle set for your account, with a settlement report published for each payment cycle in Seller Center. Cadence has varied by seller and by program, so check yours rather than working from a number you read somewhere. What matters for the books is that the cycle rarely matches a calendar month, so any settlement crossing month end needs splitting by transaction date.

Are WFS fees the same as referral fees?

No, and combining them is a common mapping error. The referral fee is a percentage commission Walmart charges for the sale, and it applies whether you ship the order yourself or not. WFS fees pay for Walmart picking, packing, shipping, and storing your inventory. They move with different drivers, so they need separate accounts if you want to compare self-fulfilment against WFS honestly.

Does QuickBooks Online import marketplace settlements natively?

No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.

Should I use a journal entry or individual sales receipts in QuickBooks Online?

Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Integrations

Walmart Marketplace QuickBooks Online integration, reconciled to the penny

BeanHawk turns every Walmart Marketplace payout into a clean, summarized QuickBooks Online journal: sales, fees, refunds, and taxes mapped to the right accounts, reconciled against the deposit that actually hit your bank.

Why Walmart Marketplace books break in QuickBooks Online

•Walmart settlements net referral fees and refunds into periodic payouts that need settlement-level breakdown for clean books.
•Walmart collects marketplace facilitator tax in most states, so exclude it from revenue.
•WFS (Walmart Fulfillment Services) fees parallel FBA fees and deserve the same per-type expense mapping.

How the integration works

1
Connect Walmart Marketplace
Secure, read-only authorization in about 60 seconds. Multiple accounts and marketplaces supported.
2
Connect QuickBooks Online
OAuth connection with professional default account mappings you (or your accountant) can adjust.
3
Review the first journal
BeanHawk parses each payout line by line and builds one summarized journal that must balance to the penny, or it will not post.
4
Reconcile in one click
The net deposit lands in a clearing account that matches your bank feed exactly. Every Walmart Marketplace payout, accounted for.

Where each Walmart Marketplace payout line belongs in QuickBooks Online

On the payout	Account	Why it matters
Gross merchandise sales	Revenue: product sales	The settlement report shows the sale before commission and adjustments. Booking the payout as revenue understates sales by every fee Walmart withheld and leaves those costs nowhere in the profit and loss.
Shipping revenue charged to the customer	Revenue: shipping income	Walmart's shipping expectations are strict and shipping is often priced at or below cost to stay competitive. Separated out, you can see how much of the price advantage you are funding yourself.
Referral (commission) fee	Cost of sales: marketplace commission	Rates vary by category, so a blended overhead number tells you nothing. On the line it belongs on, you can see which categories are worth listing in at all.
WFS fulfilment fee	Cost of sales: fulfilment	It varies with weight and size and it moves with every unit shipped. Treated as fixed overhead, your break-even price per SKU is wrong by the second largest variable cost you carry.
WFS storage fees, including seasonal and long-term storage	Operating expense: inventory storage	Storage is a function of how long stock sits, not how much sold. Mixed with fulfilment it hides aging inventory until a long-term charge makes the problem expensive and obvious.
Customer refunds, with the commission credited back	Contra-revenue: refunds, with the fee credit to marketplace commission	Netting the refund and the fee credit into one number overstates the credit and understates true commission. Return rate also disappears, and on Walmart a rising return rate can put listing performance at risk.
Return shipping and return processing charges	Cost of sales: returns handling	Returns cost money beyond the lost sale. In a general expense bucket you can never answer whether free returns on a given category are affordable.
Adjustments, disputes, and performance-related charges	Operating expense: marketplace adjustments	These often relate to a prior period and arrive without warning. Their own account keeps them from contaminating current-month commission and gives you a running total to dispute from.
Walmart Connect advertising, usually invoiced or charged separately	Operating expense: advertising	Because it is often billed outside the settlement, it shows up as an unrelated card charge and never gets attributed to the channel. Walmart margin then looks stronger than it is.
Marketplace facilitator sales tax collected by Walmart	Pass-through tax account that nets to zero	Walmart collects and remits it. In revenue it overstates income and can create the appearance of a filing obligation you do not have.

How a month actually closes on Walmart Marketplace

Walmart pays on a set cadence tied to your account, and each payment cycle has a settlement report available in Seller Center. Confirm your own cycle rather than assuming, because it has differed by seller and by program over time. The report is transaction-level with a type on every row, which makes it the best closing document of the five channels here if you actually use the type column.

Group the settlement rows by transaction type and post one summarized journal per settlement period: sales, shipping, commission, WFS fulfilment, storage, refunds, fee credits, adjustments, tax withheld. Route the net to a Walmart clearing account, then clear it when the deposit lands. If a settlement period crosses month end, split by transaction date and post two journals that sum back to the settlement total.

Adjustments are the Walmart-specific trap. They post in the current settlement but frequently relate to an order from a previous period, sometimes several periods back. Do not reopen a closed month to move them. Book them in the period received, put the original order reference in the journal memo, and keep them in a separate account so the trend is visible and disputable.

WFS creates the same inventory questions FBA does. Units get lost, damaged, or disposed of, and any credit you receive is not sales revenue. Book the credit as other income and adjust inventory for the units that left. Skipping the inventory side leaves stock on the balance sheet that no longer exists in a Walmart fulfilment center.

Walmart Connect ad spend is the most commonly missed cost on this channel because it typically does not come out of the settlement. It lands as its own charge, on its own schedule, often against a card. Map it to advertising and tag it to the channel, otherwise you will compare a Walmart profit and loss carrying no ad spend against an Amazon one that carries all of it and reach the wrong conclusion.

Close by proving the arithmetic: gross sales, minus commission, minus fulfilment and storage, minus refunds, plus fee credits, plus or minus adjustments, minus tax withheld, equals the deposit. Anything left in the Walmart clearing account should be a settlement period that has not paid yet. A clearing balance that will not clear usually means an adjustment was posted to the wrong month.

What QuickBooks Online does well, and where it needs help

BeanHawk posts into QuickBooks Online as a summarized Journal Entry per settlement period rather than as individual sales receipts. A QBO journal entry carries one date and has to balance to the penny, so we date it at the period end, put the settlement identifier in the memo, and keep SKU-level detail in our own subledger. That keeps QBO fast and keeps an auditor able to trace any number back to a source document.

The step people get wrong is the bank feed. When the marketplace deposit appears in QBO, it must be matched to the entry already sitting in the clearing account, never added. Clicking Add creates a second income transaction and doubles revenue for that deposit. If your revenue looks roughly twice what you expect, this is almost always the cause, and the fix is to find the added transactions and undo them rather than to adjust the journal.

Class and location tracking, which is how most sellers separate channels inside one company file, is available on the higher QuickBooks Online plans rather than every plan, and Intuit has changed plan naming and inclusions over time. Check what your current subscription includes. If classes are not available to you, the workable alternative is a separate set of income and fee accounts per channel: uglier in the chart of accounts, but it works on any plan and it reports cleanly.

QuickBooks Online's built-in inventory uses FIFO and has no native landed cost handling, so freight, duty, and prep costs cannot be pushed into unit cost inside QBO itself. High-volume sellers usually stop fighting this and keep perpetual SKU valuation in a subledger, posting a periodic inventory and cost of goods sold journal instead. That is the approach BeanHawk takes, which is also why our journals stay small enough for QBO to handle at scale.

Automated Sales Tax in QBO is built for tax you collect and owe. Marketplace facilitator tax is neither, so routing it through the sales tax module invites QBO to include it in a liability you do not have. Send facilitator tax to a pass-through account that nets to zero within the same journal, and keep your own nexus tax, if any, in the sales tax module where it belongs.

One reporting quirk worth knowing before you panic: journal entries are accrual transactions, so a cash-basis profit and loss in QBO can present summarized marketplace journals in ways that look wrong at first glance. Run the accrual view when checking a settlement, and reconcile the clearing account rather than reading the bank balance, since the clearing account is where the timing difference is supposed to live.

Frequently asked questions

Can QuickBooks Online read a Walmart settlement report?: No. QBO sees the Walmart deposit arrive and has no way to interpret it. The settlement report from Seller Center carries a transaction type on every row, and that type column is what turns a deposit into commission, WFS fulfilment, storage, refunds, fee credits, and adjustments. BeanHawk does that grouping and hands QBO one balanced journal entry per settlement period.
Where do Walmart Connect advertising charges belong in QuickBooks Online?: In an advertising expense account, tagged to the Walmart channel with a class if your plan supports class tracking. Because Walmart Connect usually bills separately rather than coming out of the settlement, it lands in QBO as a card or bank charge with no obvious connection to the channel. Left untagged, your Walmart profit and loss carries no ad spend and looks better than Amazon on a comparison that is not fair.
How often does Walmart Marketplace pay out?: On a recurring cycle set for your account, with a settlement report published for each payment cycle in Seller Center. Cadence has varied by seller and by program, so check yours rather than working from a number you read somewhere. What matters for the books is that the cycle rarely matches a calendar month, so any settlement crossing month end needs splitting by transaction date.
Are WFS fees the same as referral fees?: No, and combining them is a common mapping error. The referral fee is a percentage commission Walmart charges for the sale, and it applies whether you ship the order yourself or not. WFS fees pay for Walmart picking, packing, shipping, and storing your inventory. They move with different drivers, so they need separate accounts if you want to compare self-fulfilment against WFS honestly.
Does QuickBooks Online import marketplace settlements natively?: No. QBO can pull the deposit in through the bank feed, and there are app-store connectors aimed at smaller sellers, but the bank feed only ever sees one net number. Nothing in QBO itself splits a settlement into commission, fulfilment fees, advertising, refunds, reimbursements, and reserve. That split has to be produced from the settlement file before it reaches the ledger.
Should I use a journal entry or individual sales receipts in QuickBooks Online?: Journal entries, once you are past a few hundred orders a month. Sales receipts per order fill the file with transactions QBO has to scan on every report, and performance degrades in a way you cannot undo without a file rebuild. A summarized journal per settlement period keeps reporting fast, and per-SKU detail belongs in a subledger where you can query it properly anyway.

Connect Walmart Marketplace to QuickBooks Online free

Start with the free reimbursement audit, then flat all-channel pricing from $19/mo. No per-channel fees.

Also see: Amazon + QuickBooks Online · Amazon + Xero · eBay + QuickBooks Online · eBay + Xero · all guides