Walmart settlements are not harder than Amazon settlements. They are shaped differently, and the difference shows up in three places: the fulfillment fee is calculated per item from weight and dimensions rather than from a flat category rate, storage carries a seasonal surcharge, and returns are split by fault in a way that changes which fees you get back. Map those three correctly in Xero and the rest of the reconciliation is the same clearing account pattern that works everywhere else.
Walmart's Marketplace Learn guide to WFS fees, last updated 27 May 2026 and describing rates effective as of April 2025, lays the structure out plainly. The pieces you will be posting to Xero:
Standard fulfillment base fee, by shipping weight:
Additions to the base fee: apparel adds 0.50, hazardous materials adds 0.50, a retail price under 10.00 adds 1.00, oversize tier 1 adds 3.00, and oversize tier 2 adds 20.00.
Storage: 0.75 per cubic foot per month from January through September. From October through December, items stored 30 days or fewer stay at 0.75, and items stored longer add 1.50 per cubic foot per month on top.
Long term storage, effective 30 June 2026: 2.25 per cubic foot per month at 366 to 450 days, and 7.50 per cubic foot per month beyond 450 days.
Return processing, by shipping weight: 4.70 for 1 lb or less, 6.20 at 2 lb, 6.70 at 3 lb, then 7.00 plus 0.40 per pound over 4.
Prep chargebacks: 0.65 for a missing or incorrect label, 0.80 for a missing or incorrect poly bag.
Shipping weight is the greater of unit weight and dimensional weight, where dimensional weight is length times width times height in inches divided by 139. Cubic feet for storage is the same product divided by 1,728. Both formulas come straight from Walmart's guide.
A cotton tee ships in a poly bag measuring 12 by 9 by 3 inches and weighs 2.4 lb packed. Retail price is 24.99.
Storage on the same unit: 324 divided by 1,728 equals 0.1875 cubic feet. At 0.75 per cubic foot per month, that is 0.14 per unit per month, or 0.42 for a quarter sitting on the shelf. Now take October through December with the unit sitting more than 30 days: the surcharge adds 1.50 per cubic foot, so the monthly cost becomes 0.42 per unit. Three times the off season rate, on inventory you already own.
That number is small and it is the reason aged Walmart inventory quietly erodes margin. Five thousand units of slow moving stock at the peak surcharge rate runs about 2,100 a month, or 6,300 across the quarter, and it lands as an expense with no matching revenue.
Walmart's guide separates two cases.
When Walmart is at fault, Walmart covers the return processing fee. You retain the original sales price and Walmart retains the fulfillment and referral fees. If the item comes back sellable and is restocked, the sale reverses: you are charged the original sales price and credited the fulfillment and referral fees.
When the seller is at fault, you pay the return processing fee, the sale reverses, and you are credited only the referral fee. Walmart retains the fulfillment fee.
In your books that means a seller at fault return costs you the sale, the fulfillment fee, and the return processing fee, while giving back only the commission. Take the tee above. At a 2.4 lb shipping weight it sits in the 3 lb return band, so the return processing fee is 6.70. Add the 5.95 fulfillment fee Walmart retains and the unit has cost 12.65 in fees against a fully refunded 24.99, before you account for what the unit itself cost you. Returns are not a revenue reduction. They are a revenue reduction plus two live fees, and a Xero file that records only the refund understates the cost of that return by 12.65.
Accounts to create before you connect anything:
Direct costs
Operating expenses
Balance sheet
Keeping long term storage in its own account is worth the extra line. When it appears at all, someone needs to look at the Inventory Health Report and decide whether to run a markdown or a removal. Buried inside a general storage account, it never triggers that conversation.
A two week Walmart settlement for a mid sized seller:
The deposit is 33,136.00. Gross activity inside it is 62,100.00 of revenue and 28,964.00 of cost. If that deposit enters Xero as a single revenue line, you have understated revenue by 28,964.00 and erased every cost lever you have.
The clearing pattern fixes it in four moves. Post the settlement detail against Walmart Settlement Clearing. Reconcile the bank deposit against the clearing balance. Confirm clearing returns to zero. Investigate anything left over, which is usually a reserve or a fee type nobody mapped. Automating that loop is what the Walmart and Xero connection handles.
With Sales Channel set up as a Xero tracking category, the settlement above produces a Walmart column in your profit and loss. Apply cost of goods sold at the SKU level and the column becomes a decision tool:
Then compare that against your Amazon and Shopify columns. If Walmart runs 20 points below your own store, the question is not whether to be on Walmart. It is which SKUs earn their place there, and that answer requires the cost side to be right.
Xero will hold the accounts and produce the report. It will not tell you the landed cost of the units that shipped, because Walmart's settlement never contained that information. It will not track the units sitting in a WFS fulfillment center separately from the units at your 3PL and the units at your own warehouse. It will not flag the SKUs crossing 366 days.
Those come from the inventory layer: warehouse level stock, FIFO valuation, landed cost allocated across inbound shipments, and inventory aging by location. That side of the system is covered on the inventory page, and the reporting it feeds sits on the profit reporting page.
Three tests. Walmart Settlement Clearing at zero. Gross product sales in Xero tying to the Walmart Marketplace and WFS report for the same dates. Storage fees reviewed against the Inventory Health Report so aging stock gets a decision rather than a fee.
Pass all three and the Walmart column can be trusted. See the whole flow on the Xero integration page or walk a live settlement on a demo.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
