Walmart Marketplace Settlements

Overview

Walmart Marketplace Settlements refer to the financial transactions and reports that occur between Walmart and its marketplace sellers. These settlements are an essential part of the overall financial management process.

Walmart Marketplace sends Settlement reports with information about order-related fees, commissions, and taxes, approximately every 14 days. With Sellercloud, you can download Walmart Marketplace Settlements automatically or manually. Upon import, the Settlement updates commissions, taxes, and fees on the related orders in Sellercloud. You can seamlessly utilize this data for your reports, analysis, accounting purposes, and other business needs.

Manage Walmart Marketplace Settlements

To generate your Settlement Reports, Walmart Marketplace calculates your account’s earnings for the preceding two weeks. This calculation takes into account your sales, fees, refunds, and other relevant transactions. 

Download Settlements

Sellercloud enables you to download your Walmart Marketplace Settlements both automatically and manually.

Automatically

To enable the automatic download of Walmart Marketplace Settlements into Sellercloud:

1. Navigate to Settings and choose a company.
2. From the Toolbox, select Walmart Marketplace > General Settings.
3. Check Enable Settlement Download and click Save.

Manually

If a Walmart Marketplace Settlement is not in Sellercloud and you know its Settlement ID, you can download it manually:

1. Navigate to Settings and select a company.
2. From the Toolbox, choose Settlement > Import Settlement.
3. Go to the Channel dropdown, and select Walmart Marketplace.
4. Enter the Settlement ID > Click Continue.

A Queued job is created and once completed, the Settlement appears in your list.

Search Settlements

To view all Walmart Marketplace Settlements imported into Sellercloud:

1. Navigate to Settings > Company Settings and choose a company.
2. From the Toolbox, select Settlement > Settlements.
3. In the Filters panel, choose Walmart Marketplace from the Order Source dropdown.
4. Enter your date range and any other desired filters.
5. Click Search.
6. A list of your settlements will load.
7. Select a settlement from the grid and access the Actions menu at the upper right corner to either:
   1. Delete
   2. Export to Excel

   To display orders without settlements, use the action View Orders With No Settlement.

8. To display orders without settlements, click on View UnSettled.
9. To view a specific settlement, click on its hyperlink ID.
10. The chosen settlement data will be displayed on your screen:
    1.  All related fees (e.g. Commissions, SALE amount, TaxCollected, TotalWalmartFundedSavings, REFUNDED, etc.) will be displayed in a Fee grid on the right. 
    2. The complete settlement details appear in a grid, which can be customized with the Select Columns option. 
    3. If you want to refine the list of settlement transactions, check the Enable Filters box, select the desired filters and click on Search.
11. To extract the settlement details in an Excel file, click on Export Summary, or navigate to the Select Action dropdown and click Export. The file can contain the following column headers:
    1. SettlementID1 – Sellercloud settlement ID.    
    2. Settlement ID – Walmart Marketplace Settlement ID  
    3. CompanyID – Sellercloud company ID.        
    4. Company – The name of the company that receives the settlement.       
    5. Trans Type – Usually, this field shows Order, or Non-Order, but depending on the transaction kind, this value could vary.   
    6. Movement Type – Here you’ll find the exact movement type (e.g. Refund, Adjustment, etc.).        
    7. Transaction Date – Each settlement can contain multiple transactions on separate rows. This field displays the specific transaction’s date.       
    8. Order # –  This is the Sellercloud Order ID.      
    9. Order_Item_ID – The ID of an item in the specific order.        
    10. OrderSource – This is the Channel ID (usually 50 for Walmart Marketplace or 79 for WFS)     
    11. Channel Order # – The Walmart Marketplace Order ID.       
    12. SKU – Product’s Stock Keep Unit ID.       
    13. COGS – This field contains the settlement’s Cost Of Goods Sold.
    14. Commission – Walmart Commission Amount.        
    15. Carrier Shipping Cost – Respective Order’s shipping carrier costs.       
    16. Channel Shipping Cost – Order’s Channel shipping costs.      
    17. Tax – Any related tax amount will be displayed here.        
    18. Transaction Fee – Charge for the specific transaction.        
    19. Posting Fee – The cost to list the product.       
    20. Grand Total – Order’s/Transaction’s grand total.        
    21. MiscFees – Additional miscellaneous fees, applied by Walmart Marketplace.       
    22. SCAmount – The associated amount that is already present in Sellercloud.      
    23. Settlement Amount – Settlement total amount in USD.       
    24. Amount Difference – The difference is the amount to be adjusted after the settlement is imported into Sellercloud.       
    25. Currency – Transactions currency.       
    26. CurrencyRate – Applied conversion rate.

Related Reports

Once your Walmart Marketplace Settlements are imported into Sellercloud, the data is reflected in Sellercloud’s Financial Reporting Suite. Navigate to Reports and select: 

• Profit and Loss – To access the Profit and Loss Order Summary report and your general P&L reports.
• Settlements – If you are looking for settlements’ Reconciliation Summary, Reconciliation Details, or Tax Collected by Settlement data.

You can utilize these reports to analyze trends, gain insights into revenue and expenses, and enhance your understanding of the profitability of your listings.