featured article

Walmart and QuickBooks Desktop Enterprise: WFS Fees Per Item

Colleen Quattlebaum

August 9, 2026

Fee accounting only works per item

Walmart Fulfillment Services charges by weight, by volume, by calendar month, and by how badly you packed the inbound shipment. Roll all of that into one WFS expense account in QuickBooks Desktop Enterprise and you will know what Walmart cost you last month, but you will not know which SKU is losing money. The fees are per item. The accounting has to be per item too, or the general ledger tells you a true number that answers no useful question.

The good news is that Walmart publishes its fee tables openly, so you can compute the per-unit burden before a single unit ships.

What Walmart's published tables say

Walmart's Marketplace Learn guide on WFS fees, last updated May 27, 2026 and describing fees effective as of April 2025, sets out the structure.

Shipping weight. For items under 1 pound, take unit weight, add 0.25 pounds for packaging, and round up. For items between 1 and 150 pounds, use the greater of unit weight or dimensional weight, where dimensional weight is length times width times height in inches divided by 139.

Standard base fulfillment fee:

| Shipping weight | Base fee per unit |

|---|---|

| 1 lb or less | $3.45 |

| 2 lb | $4.95 |

| 3 lb | $5.45 |

| 4 to 20 lb | $5.75 plus $0.40 for each lb over 4 |

| 21 to 30 lb | $15.55 plus $0.40 for each lb over 21 |

| 31 to 50 lb | $14.55 plus $0.40 for each lb over 31 |

| 51 lb or more | $17.55 plus $0.40 for each lb over 51 |

Additional per-unit fees: apparel adds $0.50, hazardous materials adds $0.50, a retail price under $10 adds $1.00, Oversize 1 adds $3.00, and Oversize 2 adds $20.00.

Storage. Unit cubic feet is length times width times height in inches divided by 1,728. From January through September the rate is $0.75 per cubic foot per month. From October through December it is $0.75 per cubic foot per month for items stored up to 30 days, plus an additional $1.50 per cubic foot per month for items stored longer than 30 days.

Long-term storage, effective June 30, 2026. Items stored 366 to 450 days are charged $2.25 per cubic foot per month. Items stored more than 450 days are charged $7.50 per cubic foot per month.

Return processing runs $4.70 for a unit of 1 pound or less, $6.20 at 2 pounds, $6.70 at 3 pounds, and $7.00 plus $0.40 per pound over 4 in the 4 to 20 pound band.

Prep chargebacks apply when inbound units are not bagged and labeled to standard: $0.65 per unit for a missing or incorrect label and $0.80 per unit for a missing or incorrect poly bag.

A worked SKU

Take SKU W-2210. Dimensions 12 by 9 by 4 inches. Unit weight 2.6 pounds. Retail price $18.99. Not apparel, not hazmat.

Shipping weight. Dimensional weight is 12 times 9 times 4, which is 432 cubic inches, divided by 139, which is 3.11 pounds. That exceeds the 2.6 pound unit weight, so the item bills at 4 pounds. Base fulfillment fee: $5.75. No oversize surcharge, since the longest side is 12 inches. No under-$10 surcharge, since it retails above $10.

Storage. Unit cubic feet is 432 divided by 1,728, which is 0.25 cubic feet. At $0.75 per cubic foot per month, that is $0.1875 per unit per month. This seller turns the SKU in about 45 days, so allocate roughly $0.28 per unit sold.

Returns. The category runs a 6 percent return rate. At $7.00 per return in the 4 pound band, that is $0.42 of return processing per unit sold.

Referral fee. On this seller's category, the referral fee on the statement works out to $2.85 on an $18.99 item. Referral rates differ by category, so pull your own from Seller Center rather than assuming.

Landed cost. $5.33 per unit, freight and duty included.

| Line | Per unit |

|---|---|

| Retail price | 18.99 |

| Referral fee | (2.85) |

| WFS fulfillment fee | (5.75) |

| WFS storage, allocated | (0.28) |

| Return processing, allocated | (0.42) |

| Landed product cost | (5.33) |

| Contribution | 4.36 |

Contribution margin: 23.0 percent. Referral plus WFS charges total $9.30, which is 49.0 percent of the retail price before a dollar of product cost.

What Q4 does to it

Hold the same SKU past 30 days during the October to December window and the extra $1.50 per cubic foot per month applies. At 0.25 cubic feet that is $0.375 per unit per month. Two extra months of peak-season aging adds about $0.75 per unit, cutting contribution from $4.36 to $3.61 and margin from 23.0 percent to 19.0 percent.

What aged stock does to it

Now apply the long-term rates taking effect June 30, 2026. A unit sitting beyond 450 days is charged $7.50 per cubic foot per month, which on 0.25 cubic feet is $1.875 per unit per month.

Three months at that rate is $5.63 per unit. The unit's entire contribution when it sells is $4.36. The storage bill has already exceeded the profit, and it keeps running.

That is not a rounding error to book against a generic fulfillment expense. It is a signal to liquidate, and it is only visible if storage is tracked per SKU.

What bad prep does to it

Send 2,000 units inbound in the wrong poly bag and Walmart corrects it at $0.80 per unit. That is $1,600 charged against a shipment whose total contribution, at $4.36 per unit across 2,000 units, is $8,720. One packaging mistake took 18.3 percent of the profit on the entire inbound.

Structuring it in QuickBooks Desktop Enterprise

The chart of accounts needs enough separation to make the above visible:

  • Walmart referral fees
  • WFS fulfillment fees
  • WFS storage fees, with long-term storage broken out
  • WFS return processing fees
  • WFS prep chargebacks
  • WFS disposal and removal fees
  • Walmart refunds, as contra revenue
  • A Walmart clearing account for the gap between earned and paid

Then use Class tracking to carry Walmart as its own class so the profit and loss can be filtered by channel without duplicating the whole chart.

That gets you channel-level. It does not get you SKU-level, because QuickBooks Desktop Enterprise records that a fulfillment fee was paid, not that it was paid on SKU W-2210. Enterprise has no mechanism to attribute a settlement fee line back to an item.

Closing the SKU gap

The per-item analysis above has to happen somewhere outside the general ledger, then feed into it. ConnectBooks reads Walmart settlement data, allocates fees to the SKUs that generated them, carries FIFO landed cost, and posts the reconciled result into QuickBooks Desktop and Enterprise so the entry ties to the actual disbursement.

The output that matters is the profit view: contribution by SKU, by channel, after every fee that Walmart actually charged rather than the fee schedule you estimated in a spreadsheet last spring. For sellers running Walmart alongside other channels, the Walmart accounting overview and the wider QuickBooks integrations set cover how the channels reconcile side by side.

One practical habit regardless of tooling: pull Walmart's Inventory Health Report on a schedule and watch the age buckets. Walmart's own guidance points sellers there to track how long units have been sitting. With the long-term rates now in force, an aged SKU is a bill that compounds monthly. If you want the per-item math run against your own catalog, book a walkthrough.

Take Control of Your E-Commerce Business with ConnectBooks

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