Before You Start

This guide assumes you have a Walmart Seller account, an A2X subscription, and administrator access to either QuickBooks Online or Xero.

Overview

30 min
Setup Time
Intermediate
Difficulty
Monthly
Maintenance

What You’ll Learn

  • How to set up your accounting system for Walmart Marketplace
  • Connecting A2X to your Walmart Seller account and QuickBooks/Xero
  • Mapping Walmart transaction types to your chart of accounts
  • Automating daily/weekly settlement imports
  • Streamlining reconciliation of Walmart payouts

1. Preparation Steps

To ensure a smooth setup, create these accounts in your accounting software (QuickBooks Online or Xero) before connecting A2X:

Required Accounts

  • Walmart Sales (Income)
  • Walmart Fees (Expense)
  • Walmart Payouts (Bank/Asset)
  • Sales Tax Payable (Liability)

Optional (but recommended)

  • Walmart Refunds (Expense)
  • Walmart Discounts (Income Reduction)
  • Walmart Gift Cards (Liability)

2. Why A2X is Essential

Unlike basic direct integrations, A2X is purpose-built for marketplace accounting.

Pros:
  • Automated settlement reconciliation.
  • Detailed breakdown of all transaction types.
  • Supports multiple currencies.
  • Handles sales tax accurately.
Cons:
  • Subscription cost.
  • Requires initial setup and mapping.

Expert Tip: Walmart Marketplace accounting involves numerous transaction types (sales, fees, shipping, refunds, promotions, etc.) that make manual reconciliation or basic integrations impractical. A2X precisely dissects each settlement, ensuring every cent is accounted for and matches your bank deposits.

3. A2X Workflow for Walmart

A2X streamlines the complex data flow from Walmart to your accounting system. This ensures a complete and accurate ledger entry for every payout, making reconciliation straightforward.

Here is a sample code block to show how a Walmart order data structure might look.

{
  "walmart_order_id": "WM123456789",
  "customer_id": "CUST987",
  "total_amount": 75.50,
  "marketplace_fees": 8.25,
  "items": [
    { "sku": "WM-PRODUCT-A", "quantity": 1, "price": 50.00 },
    { "sku": "WM-PRODUCT-B", "quantity": 1, "price": 25.00 }
  ],
  "settlement_date": "2025-10-28"
}

4. Setting Up A2X for Walmart

  1. 1

    Connect Walmart Marketplace to A2X

    Log into your A2X account and follow the prompts to authorize access to your Walmart Seller Center data.

  2. 2

    Connect A2X to Your Accounting Software

    Link A2X to your QuickBooks Online or Xero account, granting the necessary permissions for data transfer.

  3. 3

    Configure Account Mapping

    Map each Walmart transaction category (sales, shipping, fees, refunds) to the corresponding accounts in your chart of accounts.

Common Error: Unmapped Transaction Types

Ensure every Walmart transaction type is mapped to an account. If a new fee type appears, A2X will flag it, requiring a new mapping to prevent reconciliation issues.

5. Testing & Going Live

Test Import Checklist

  • Import a historical Walmart settlement
  • Verify the sum of transactions in A2X matches the Walmart payout statement
  • Confirm all revenue and expense lines are correctly posted in QBO/Xero
  • Check that the net payout matches the bank deposit for reconciliation

Need Help?

Expert Support for Walmart Accounting

Struggling to get your Walmart Marketplace accounting perfect? Our specialists can provide tailored setup and troubleshooting assistance.

Get Expert Help