Skip to content
Bookalyze
Start free

Walmart settlements: bring in, check, post

Walmart's settlement reports come in row by row. Bookalyze adds them up to Walmart's payout, posts only the ones that do, and posts a settlement again when Walmart corrects it.

Bring them in

On a Walmart country's channel page, Bring in from Walmart downloads every settlement report Walmart lists that isn't here yet. The daily job does the same once the country is connected. Each report's rows are kept as Walmart sent them, without buyers' names or addresses.

How Walmart's rows are read

Each row says what an amount is for. Bookalyze groups them: sales, refunds, Walmart's fees, WFS fees (fulfilment, storage, inbound, prep), advertising, shipping labels, tax (collected and withheld cancel out) and other.

Caution: A settlement whose rows don't add up to Walmart's payout, or with an amount that can't be read, shows Needs a look with the reason, and never posts.

Caution: This reading was built from Walmart's published report layout. Check your first settlement against Seller Center before switching on automatic posting.

Post and match

Where in the app: Commerce → Settlements → Walmart

  1. 1

    Choose how Walmart posts

    An account per group and a Walmart balance account; the day posting starts; automatic posting if you want it.

  2. 2

    Post

    Each settlement becomes one entry on its period's last day, in Walmart's currency at that day's rate.

  3. 3

    Match the payout

    Payouts to your bank lists the suggested deposit: Match, Not this one or Unmatch.

A settlement Walmart corrects shows Changed since posted; Post again brings it up to date.

Not yet

  • Uploading Seller Center's report by hand.
  • WFS's inventory ledger (returns and losses).

What you should see

What you should see

  • Each settlement with its sales, fees, WFS fees, advertising, labels and payout
  • Ready to post for ones that add up; Needs a look with a reason for any that don't
  • Walmart in Channel profit, beside Amazon

Read next

  • Connect Walmart: create an API key

    Add your Walmart countries, then create a client ID and secret in Walmart's Developer Portal for each one and paste them on the country's channel page. About 10 minutes.

    Read the guide

  • How payouts post to your books

    Choose an account for each kind of money (sales, refunds, fees, ads, tax, held back) and a clearing or balance account for the payout, pick the day posting starts, then post by hand or automatically. The same idea for Amazon, Walmart, Noon and eBay.

    Read the guide

  • Match each payout to its bank deposit

    Matching pairs a marketplace payout with the deposit in your bank and moves that deposit to the clearing or balance account, so your sales are counted once. Works in any bank account and any currency.

    Read the guide