How should WFS fees be recorded in Xero?

As at least two separate accounts posted from the manual journal: fulfilment fees in cost of sales, storage fees in operating expenses. They are driven by different things, units shipped versus days held, and combining them means you cannot see aging inventory until a long-term storage charge makes it expensive. If you also sell self-fulfilled, keep those postage costs in a third account so the two models stay comparable.

Walmart posted an adjustment after I closed the month in Xero. What now?

Leave the closed month alone. Post the adjustment as part of the current period's manual journal, into your marketplace adjustments account, and put the original order or settlement reference in the narration so anyone reviewing it can trace it back. Reopening a closed period to chase a small adjustment costs more than it is worth and breaks the tie-out you already proved.

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.

Can Xero connect to a marketplace and code the fees on its own?

Not on its own. Xero's bank feed brings in the deposit as a single line, and connector apps vary widely in how much of a settlement they break out. Xero has no way to know that a deposit contains commission, advertising, refunds, and a reserve movement. Something has to parse the settlement file and hand Xero a balanced manual journal, then you match the deposit against the clearing account.

Do I actually need tracking categories in Xero for one sales channel?

If you sell on one channel and nothing else, separate accounts are simpler and you can skip tracking entirely. Tracking earns its place the moment you add a second channel or a second region, because it lets you run a profit and loss per channel without duplicating the chart of accounts. Just remember you only get two categories, so spend the first one on the dimension you will report on most.

Integrations

Walmart Marketplace Xero integration, reconciled to the penny

BeanHawk turns every Walmart Marketplace payout into a clean, summarized Xero 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 Xero

•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 Xero
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 Xero

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 Xero does well, and where it needs help

Xero calls the posting mechanism a Manual Journal, and it behaves differently from a QuickBooks journal entry in ways that matter. Manual journals can be saved as drafts for review before posting, they can be set to auto-reverse on a chosen date, and they carry a 'show journal on cash basis reports' option that changes whether the entry appears in cash-basis reporting. BeanHawk posts a summarized manual journal per settlement period with the settlement reference in the narration.

Tracking categories are Xero's answer to segmenting by channel, and the constraint is specific: an organisation gets two tracking categories, each with a capped number of options (Xero has adjusted the option limit over time, so check the current figure). Spend one on Channel and think hard before committing the second, because there is no third. Sellers who use both on channel and marketplace region find they have nothing left for department or brand later.

Bank reconciliation in Xero pushes you toward Find and Match, and that is exactly what a marketplace deposit needs: match it against the clearing account transaction the manual journal created. The danger is bank rules. A rule that auto-codes anything from Amazon or Shopify straight to a sales account will happily book net deposits as revenue forever, understating sales and erasing every fee. If you already have such a rule, delete it before connecting anything.

Xero has no native landed cost function, and its inventory uses average cost rather than FIFO. Tracked inventory items in Xero also come with limits that multi-channel sellers hit quickly. The practical answer is the same one that works in QuickBooks: keep perpetual SKU-level valuation in a subledger, push freight and duty into unit cost there, and post a periodic summarized inventory and cost of goods sold journal into Xero.

Xero's plans cap how many invoices, bills, and in some cases bank transactions you can process per month, and plan names and limits have changed by region and over time. Manual journals are not usually the binding constraint, but if you also invoice wholesale customers out of Xero, the cap can be. Multi-currency is another plan-dependent feature and it matters directly if you sell across marketplaces in more than one currency, so confirm your plan before designing the chart of accounts around it.

For a cross-border seller, set up one clearing account per currency and let Xero handle the revaluation rather than converting everything by hand. Xero will post unrealised gains and losses on foreign currency balances at period end, which means your clearing account balance moves for reasons that have nothing to do with the marketplace. Knowing that in advance saves an afternoon of hunting for a difference that is working exactly as designed.

Frequently asked questions

How should WFS fees be recorded in Xero?: As at least two separate accounts posted from the manual journal: fulfilment fees in cost of sales, storage fees in operating expenses. They are driven by different things, units shipped versus days held, and combining them means you cannot see aging inventory until a long-term storage charge makes it expensive. If you also sell self-fulfilled, keep those postage costs in a third account so the two models stay comparable.
Walmart posted an adjustment after I closed the month in Xero. What now?: Leave the closed month alone. Post the adjustment as part of the current period's manual journal, into your marketplace adjustments account, and put the original order or settlement reference in the narration so anyone reviewing it can trace it back. Reopening a closed period to chase a small adjustment costs more than it is worth and breaks the tie-out you already proved.
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.
Can Xero connect to a marketplace and code the fees on its own?: Not on its own. Xero's bank feed brings in the deposit as a single line, and connector apps vary widely in how much of a settlement they break out. Xero has no way to know that a deposit contains commission, advertising, refunds, and a reserve movement. Something has to parse the settlement file and hand Xero a balanced manual journal, then you match the deposit against the clearing account.
Do I actually need tracking categories in Xero for one sales channel?: If you sell on one channel and nothing else, separate accounts are simpler and you can skip tracking entirely. Tracking earns its place the moment you add a second channel or a second region, because it lets you run a profit and loss per channel without duplicating the chart of accounts. Just remember you only get two categories, so spend the first one on the dimension you will report on most.

Connect Walmart Marketplace to Xero 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