Walmart Xero Integration: Step-by-Step Setup Guide (2026)

Xero has 4.2 million global subscribers (Xero FY24 Annual Report, 2024) — and a significant share are eCommerce sellers who also list on Walmart Marketplace. The problem every one of them shares: Walmart’s biweekly settlement is a net ACH deposit that combines gross sales, referral fees (6–20% by category), Walmart Fulfillment Services charges, Walmart Connect advertising spend, and refunds into one number. When that deposit lands in Xero’s bank feed, Xero has no built-in way to decode it. You see a deposit. You do not see the $3,600 in referral fees, the $800 in WFS charges, or the $200 in returns that were deducted before the money reached your account. Record the deposit as revenue and your Xero P&L overstates income, hides every cost, and makes gross margin calculation impossible. This guide covers the correct Xero account structure for Walmart sellers, the step-by-step SyncTools integration, and how to reconcile every biweekly payout in Xero with one click.

TL;DR: Walmart Marketplace deposits a net biweekly payout that bundles gross sales, referral fees, WFS fulfillment charges, Walmart Connect ad spend, and refunds into a single ACH transfer. Recording that deposit as Xero revenue misrepresents your income and hides every fee as an invisible deduction. SyncTools connects Walmart to Xero in under 30 minutes, disaggregating each payout component into the correct account automatically — no CSV exports, no manual journals, no reconciliation spreadsheets.

Using QuickBooks Online instead of Xero? See the Walmart QuickBooks integration guide.

Related: Walmart Marketplace accounting guide — chart of accounts setup, payout structure, and sales tax handling before you connect any integration.

Why Walmart Sellers Using Xero Have an Accounting Problem

Xero’s bank reconciliation is excellent — Xero’s bank rules, bank feeds, and matching workflow are some of the best in mid-market accounting software. The problem is that Walmart’s settlement structure defeats Xero’s default reconciliation model from the very first payout.

When a Xero bank feed receives a Walmart deposit, Xero sees one transaction with one amount. It does not see:

• Gross Walmart sales — the full price customers paid across all orders in the period
• Referral fees — 6–20% of the sale price depending on product category, Walmart’s primary revenue mechanism
• WFS pick and pack fees — per-unit fulfillment charges if you use Walmart Fulfillment Services
• WFS storage fees — monthly per-cubic-foot charges for inventory held in Walmart fulfillment centers
• Walmart Connect ad spend — cost-per-click charges from Sponsored Products campaigns, netted against your payout
• Refunds — customer returns processed in the settlement period, reducing your disbursement
• Marketplace facilitator tax — sales tax Walmart collected and remits to state authorities on your behalf (not your income)

Without automation, you need to manually download the Walmart remittance report from Seller Center every two weeks, extract each of these components, convert them into Xero invoices, bills, credit notes, and journal entries, then reconcile the net payout to your bank. For a seller processing 200 Walmart orders per month, that is 5–8 hours of bookkeeping work per month before you account for errors.

Xero’s bank rules are particularly ill-suited to Walmart payouts because the settlement amount varies every two weeks — gross sales fluctuate with order volume, and fee deductions scale with it. You cannot create a Xero bank rule that matches “Walmart payout” and auto-categorizes it correctly, because the gross and net amounts change every cycle. Automation at the transaction level is the only path to clean books.

Related: eCommerce bookkeeping guide — accounting fundamentals every marketplace seller needs before connecting any integration.

Xero Chart of Accounts for Walmart Sellers

Setting up the right account structure in Xero before connecting any integration is the most important step. Changing account mapping mid-year creates reconciliation work that compounds quickly. This setup takes under ten minutes and only needs to happen once.

Xero uses different account type labels than QuickBooks. Here is how Walmart transaction types map to the correct Xero account categories:

Walmart Transaction Type	Xero Account Name	Xero Account Type
Gross Walmart sales	Walmart Gross Sales	Revenue
Refunds / returns	Walmart Refunds	Revenue (contra)
Referral fee (6–20%)	Walmart Referral Fees	Direct Costs
WFS pick & pack fee	Walmart WFS Fulfillment Fees	Direct Costs
WFS storage fee	Walmart WFS Storage Fees	Expense
Walmart Connect ad spend	Advertising — Walmart Connect	Expense
Marketplace facilitator tax	Sales Tax Payable — Walmart	Current Liability
Payout deposit matching	Walmart Clearing	Bank (current asset)

Why Direct Costs for referral and fulfillment fees? In Xero, Direct Costs accounts appear in the gross profit section of your P&L — which is where platform fees and fulfillment costs belong for accurate gross margin calculation. If you place referral fees in the Expense section instead, Xero will show them below the gross profit line, which understates your true cost of selling on Walmart and inflates apparent gross margin.

The Walmart Clearing account is a bank-type account in Xero that acts as a staging account between your Walmart revenue and your operating bank. SyncTools posts gross sales to Walmart Gross Sales and contra-entries to Walmart Clearing. When fees are deducted, they post as Direct Costs and reduce the Walmart Clearing balance. When the biweekly payout arrives, it matches the Clearing balance exactly — one-click reconciliation.

Related: Xero eCommerce accounting guide — how to structure Xero for multi-channel eCommerce selling.

What Data Syncs from Walmart Marketplace to Xero

Understanding exactly what the integration moves between Walmart and Xero is the first step to configuring it correctly.

What syncs automatically with a properly configured integration:

Walmart Data	Xero Transaction Type	Xero Account
Gross sale (per order or period)	Sales invoice	Walmart Gross Sales (Revenue)
Referral fee (6–20%)	Bill or journal line	Direct Costs: Walmart Referral Fees
WFS pick & pack fee	Bill or journal line	Direct Costs: Walmart WFS Fees
WFS storage fee	Bill or journal line	Expense: Inventory Storage
Walmart Connect ad spend	Bill or journal line	Expense: Advertising
Customer refund	Credit note	Walmart Refunds (contra-revenue)
Marketplace facilitator tax	Journal line	Current Liability: Sales Tax Payable
Biweekly payout	Bank transaction match	Walmart Clearing (zeroes out)

What does not sync:

• Customer names, shipping addresses, and email addresses
• Walmart listing data, titles, images, and pricing rules
• Walmart Seller Center analytics (impressions, conversions, search rank)
• WFS inventory levels (unless your integration specifically supports inventory sync)

Sync mode — invoice vs. journal entry. SyncTools supports two posting modes for Walmart in Xero. Order-level sync creates one Xero sales invoice per Walmart order — maximum granularity, useful for P&L by product category. Settlement-period sync creates one summarized journal entry per biweekly settlement — cleaner for sellers with high order volumes who want books that match their bank deposits exactly. Most Walmart sellers at medium volume use settlement-period sync; high-volume sellers with category-level margin reporting needs prefer order-level.

The settlement-period sync mode is particularly valuable for Xero users because it aligns naturally with Xero’s bank reconciliation workflow. Each biweekly journal entry corresponds to exactly one bank transaction — the Walmart ACH deposit — so there is never an unmatched entry in Xero’s reconciliation queue.

Related: multi-channel inventory accounting — managing Walmart alongside Amazon, Shopify, and other channels in one set of books.

Manual Bookkeeping vs. Automated Integration: True Cost Comparison

The assumption most Walmart sellers make is that manual bookkeeping is free because they do it themselves. The math tells a different story.

For a Walmart seller processing 250 orders per month:

Manual Xero bookkeeping approach:

• Download Walmart remittance report from Seller Center: 15 minutes per cycle (twice a month)
• Extract referral fees by product category, WFS fees by type, Walmart Connect charges: 45–60 minutes per cycle
• Create Xero invoices, bills, and credit notes for each component: 45–60 minutes per cycle
• Match payout deposits in Xero bank reconciliation: 30 minutes per month
• Identify and correct data entry errors (average manual error rate: 1–5%): 1 hour per month
• Total: 5–8 hours per month

At a conservative $40/hour opportunity cost (or actual bookkeeper rate), manual Walmart–Xero bookkeeping costs $200–$320 per month for a 250-order seller — before accounting for the compounding errors that often require corrective journal entries across entire reporting periods.

Automated integration approach:

• One-time setup: 20–30 minutes
• Ongoing: 20–30 minutes per month to review sync reports and confirm reconciliation
• SyncTools subscription: usage-based, typically well under $100/month for a 250-order seller
• Total: under 30 minutes per month + subscription cost

Xero automation eliminates 50–70% of eCommerce bookkeeping time overall (Webgility, 2025). For Walmart-specific bookkeeping, the reduction is closer to 90% — because the biweekly settlement disaggregation is the most time-intensive step, and that is exactly what an integration automates completely.

Related: automated reconciliation for eCommerce — how automated reconciliation works and how to set it up in under 30 minutes.

Step-by-Step: Setting Up SyncTools for Walmart → Xero

Xero holds over 75% market share in Australia and New Zealand and more than 30% in the UK (Fifth Person, 2024). It is also the preferred accounting system for many US-based eCommerce sellers who operate across borders or whose accountants are Xero-certified. Here is how to connect Walmart Marketplace to Xero using SyncTools.

Before you start, confirm you have:

• An active Walmart Marketplace seller account (Professional Seller account required)
• A Xero account (Growing or Established plan recommended for Walmart sellers)
• A SyncTools account — start a free trial if you do not have one
• Admin access to your Walmart Seller Center
• Admin access to the Xero organisation you want to sync to

Step 1 — Build Your Walmart Chart of Accounts in Xero

Before connecting anything, set up the dedicated accounts listed in the table above. In Xero: go to Accounting → Chart of Accounts → Add Account.

The accounts that matter most, and where sellers most often make mistakes:

• Walmart Clearing must be a Bank account type in Xero — not an asset or clearing account under Expenses. Xero’s bank reconciliation workflow only works cleanly if the clearing account is bank-type, because that allows direct matching against your actual bank deposits.
• Sales Tax Payable — Walmart must be a Current Liability — never a revenue account. Xero allows you to configure tax rates against account types; confirm your Walmart tax rate maps to this liability account.
• Walmart Referral Fees and Walmart WFS Fulfillment Fees should be Direct Costs — they appear in the gross profit section of your Xero P&L, where they belong for margin analysis.

Step 2 — Connect Walmart Seller Center to SyncTools

Log into SyncTools and navigate to Integrations → Add Source. Select Walmart Marketplace.

SyncTools redirects you to Walmart’s OAuth authorization page. Sign in with your Seller Center credentials and click Authorize. SyncTools receives read access to your transaction data, payout reports, remittance reports, WFS fee statements, and order history. It never writes to your Walmart account or modifies any store settings.

Once authorized, SyncTools loads your transaction history. The default lookback is 90 days; historical backfill up to two years is available on Standard and Plus plans.

Step 3 — Connect Xero to SyncTools

In SyncTools, go to Integrations → Add Accounting System and select Xero. Click Connect.

SyncTools redirects you to Xero’s OAuth authorization page. Sign in to Xero and choose the Xero organisation you want to connect (if you manage multiple organisations, select the correct one carefully — SyncTools connects to exactly one Xero organisation per account). Click Allow Access.

SyncTools requests access to your contacts, invoices, credit notes, accounts, and bank transactions. The authorization takes about 30 seconds. Once connected, SyncTools reads your existing chart of accounts and presents a recommended mapping table for Walmart transaction types.

Step 4 — Map Walmart Transaction Types to Xero Accounts

This is the most consequential step. Every mapping decision here determines where each dollar in your Walmart transaction history lands in Xero.

Review and confirm each row:

Walmart Transaction Type	Recommended Xero Account	Account Type
Gross sale	Walmart Gross Sales	Revenue
Referral fee	Direct Costs: Walmart Referral Fees	Direct Costs
WFS pick & pack fee	Direct Costs: Walmart WFS Fees	Direct Costs
WFS storage fee	Expense: Walmart WFS Storage	Expense
Walmart Connect ad spend	Expense: Advertising — Walmart	Expense
Refund issued	Walmart Refunds	Revenue (contra)
Marketplace facilitator tax	Current Liability: Sales Tax Payable	Current Liability
Payout deposit	Walmart Clearing	Bank

Three mappings to double-check before proceeding:

1. Tax line → Current Liability, not Revenue. Walmart-collected marketplace facilitator tax is not income. Confirm it maps to your Sales Tax Payable account.
2. Referral fees → Direct Costs, not Expense. This controls where fees appear in your Xero P&L — above or below the gross profit line.
3. Clearing account → Bank type. This enables one-click reconciliation when the ACH deposit hits your Xero bank feed.

Step 5 — Configure Tax Rate and Sync Mode

In SyncTools settings, set tax handling to exclude marketplace facilitator tax from income. This posts Walmart-collected sales tax to your Sales Tax Payable liability rather than adding it to gross revenue.

Next, choose your sync mode:

• Order-level sync: SyncTools creates one Xero sales invoice per Walmart order, plus associated bills for fees. Maximum P&L granularity. Best for sellers wanting per-SKU or per-category margin data.
• Settlement-period sync: SyncTools creates one summarized journal entry per biweekly settlement cycle. Cleanest reconciliation against your bank feed. Best for high-volume sellers or those whose accountant prefers period-level posting.

Most Walmart sellers at 100–500 orders per month use settlement-period sync.

Step 6 — Run a Test Sync and Verify in Xero

Click Sync Now. SyncTools pulls your most recent Walmart transactions — 90 days by default — and posts each to the mapped Xero account.

After the sync completes, verify four things in Xero against your Walmart Seller Center remittance report for the same period:

1. Gross sales — your Xero Walmart Gross Sales balance should match Walmart’s gross sales figure before any deductions
2. Fee expenses — each fee category should appear as a separate line in your Xero P&L, not netted against revenue
3. Tax liability — Sales Tax Payable should match Walmart-collected marketplace tax for the period
4. Clearing account — the Walmart Clearing balance should match your next expected Walmart bank deposit

SyncTools provides a per-settlement reconciliation report in the sync log. Any discrepancies are traceable to a specific transaction type and mapping decision.

Related: SyncTools pricing — free trial available, no credit card required.

How Walmart Biweekly Payouts Reconcile in Xero

The clearing account structure is what makes Walmart–Xero reconciliation a one-click operation rather than a monthly spreadsheet exercise. Here is exactly how it works.

Each biweekly Walmart settlement represents:

• Gross Walmart sales from the preceding 14-day period
• Minus referral fees (6–20% of sale price by product category)
• Minus WFS pick and pack fees (per unit, varies by size and weight tier)
• Minus WFS monthly storage fees (prorated to the settlement period)
• Minus Walmart Connect advertising charges incurred in the period
• Minus refunds processed or applied to the settlement
• = Net payout deposited via ACH to your bank account

Here is how SyncTools posts this to Xero and how reconciliation works:

1. Each Walmart sale credits Walmart Gross Sales (Revenue) and debits Walmart Clearing (Bank)
2. Each referral fee debits Direct Costs: Walmart Referral Fees and credits Walmart Clearing
3. Each WFS fee debits the appropriate expense account and credits Walmart Clearing
4. Each refund debits Walmart Refunds (contra-revenue) and credits Walmart Clearing
5. When the biweekly payout arrives in your Xero bank feed, Xero presents the match: debit your operating bank account, credit Walmart Clearing

At the end of each settlement cycle, the Walmart Clearing account should reach zero. If it does not, the gap is a transaction that has not synced correctly — which SyncTools flags in the reconciliation report.

The reconciliation itself in Xero takes less than a minute per settlement cycle: the deposit appears in your Xero bank feed, Xero suggests the match against the Walmart Clearing balance, you confirm, and the books close clean.

One timing nuance worth planning for: WFS monthly storage fees are invoiced at the start of the following month but apply to the prior month’s inventory. SyncTools matches these to the correct expense period by using the service date rather than the invoice date — so your June WFS storage costs appear in June’s P&L, not July’s. This prevents the common error of seeing higher-than-expected expenses in July and lower-than-expected expenses in June when storage fees hit with a one-month lag.

Related: Walmart Marketplace accounting guide — deep dive on Walmart’s biweekly payout structure, referral fee schedule, and chart of accounts for Walmart sellers.

Walmart Sales Tax in Xero: Marketplace Facilitator Handling

Walmart Marketplace acts as a marketplace facilitator in 46 US states plus Washington D.C., collecting and remitting sales tax on behalf of third-party sellers. This is the correct treatment in Xero:

Walmart-collected sales tax is not your income. It passes through your Walmart account, but Walmart settles it with state tax authorities directly. The correct Xero treatment:

• Xero tax rate: create a Walmart-specific tax rate (or use your existing “Tax Exempt” rate) mapped to Sales Tax Payable — Walmart
• Do not use Xero’s standard sales tax rate for Walmart-collected tax — Xero’s standard tax rate will add the tax to your Xero VAT/GST return as output tax you owe, which is incorrect because Walmart already remitted it
• The liability zeroes out at the end of each period when Walmart remits to state authorities; no action required on your end

For UK, Australian, and New Zealand sellers using Xero:

Xero is the dominant accounting platform in all three markets. UK, AU, and NZ sellers who also sell on Walmart Marketplace US should use separate Xero tracking categories or segments to distinguish US Walmart sales from domestic sales. The US marketplace facilitator tax rules apply to Walmart US transactions regardless of your entity’s country of incorporation.

For UK sellers: if your UK entity is VAT-registered and also processing US Walmart transactions, confirm with your accountant whether US Walmart sales are outside the scope of UK VAT. SyncTools applies the correct Xero tax rate code to Walmart US transactions to prevent them from appearing on your UK VAT return incorrectly.

Xero Tracking Categories for Multi-Channel Walmart Sellers

Xero’s tracking categories are the equivalent of QuickBooks classes — they let you tag transactions with a dimension (such as Sales Channel, Marketplace, or Region) for multi-dimensional reporting. For sellers managing Walmart alongside Amazon, Shopify, or other channels in one Xero organisation, tracking categories are the mechanism that makes per-channel P&L possible.

Recommended tracking category setup for Walmart sellers:

Tracking Category	Tracking Option	Applied To
Sales Channel	Walmart Marketplace	All Walmart revenue and expense transactions
Sales Channel	Amazon	All Amazon transactions
Sales Channel	Shopify	All Shopify transactions

With a Sales Channel tracking category applied, Xero’s P&L by Tracking Category report gives you channel-level gross profit without requiring separate Xero organisations for each platform. SyncTools automatically applies the Walmart tracking category to every synced transaction, so no manual tagging is required.

Sellers who merge all marketplace revenue into a single Xero income account — without tracking categories — consistently underestimate how much the reporting gap costs them. When a multi-channel seller’s total margin drops, they cannot tell whether it is Walmart’s referral fee structure, Amazon’s FBA cost increase, or Shopify’s payment processing fee. Channel-level P&L via Xero tracking categories turns a company-wide margin problem into a platform-specific optimization decision.

Related: multi-channel inventory accounting — COGS tracking, channel-level P&L, and inventory valuation across marketplaces.

For sellers who want channel-level reporting in a BI dashboard beyond Xero’s built-in P&L reports — combining Walmart, Amazon, and Shopify data with operational or advertising metrics — see the Xero Power BI connector guide. SyncTools syncs your Xero data to a database so Power BI connects via SQL without API rate limits or gateway dependencies.

Common Setup Mistakes — Xero-Specific

Most Walmart–Xero integration problems trace back to five setup errors. These apply specifically to Xero’s account type structure.

Mistake 1 — Using an Expense-type clearing account instead of Bank-type

Xero’s reconciliation workflow only enables one-click payout matching when the clearing account is a Bank account type. If you create the Walmart Clearing account as an Asset or Expense account, Xero will not offer the matching option in the bank reconciliation screen — you will need to post manual journal entries instead. Create the Walmart Clearing account as Bank type before running your first sync.

Mistake 2 — Placing referral fees in the Expense section instead of Direct Costs

Xero separates your P&L into Gross Profit (Revenue minus Direct Costs) and Net Profit (Gross Profit minus Expenses). Walmart referral fees and WFS fulfillment costs are platform selling costs — they belong in Direct Costs, not Expenses. Putting them in Expenses shows an inflated gross margin that disappears when you scroll past the gross profit line. Your gross profit rate becomes meaningless for benchmarking against industry standards.

Mistake 3 — Mapping sales tax to Xero’s standard tax rate

Xero’s built-in sales tax rates (BAS, VAT, GST, US Sales Tax) are configured to populate tax returns. If you use Xero’s standard US Sales Tax rate for Walmart-collected marketplace facilitator tax, it will add the Walmart-collected tax to your tax return as output tax you owe — a liability you have already had settled by Walmart. Create a dedicated “Walmart MF Tax” rate mapped to your Sales Tax Payable liability, and set it to not appear on tax returns.

Mistake 4 — Selecting the wrong Xero organisation during setup

If you manage multiple Xero organisations — for instance, separate entities for your Amazon business and your Walmart business — confirm you select the correct one in SyncTools. SyncTools connects to one Xero organisation per account. Syncing Walmart transactions into the wrong Xero organisation creates a reconciliation problem that is significantly harder to reverse than it is to prevent.

Mistake 5 — Skipping the first-sync verification

The first sync reveals any account mapping errors before they compound. After the test sync, always compare gross Walmart sales, total fee expenses, tax liability, and net payout in Xero against the corresponding Walmart Seller Center remittance report. Catching a wrong Direct Costs mapping on day one takes five minutes. Discovering it after six months of synced transactions requires corrective journal entries across the entire prior period.

Related: best eCommerce accounting software — comparison of accounting tools for eCommerce sellers at different scale points.

Walmart vs. Amazon: Xero Integration Differences

Sellers who manage both Walmart and Amazon in Xero frequently ask how the integration and accounting differ. The most important differences:

Dimension	Walmart Marketplace	Amazon
Monthly seller fee	None	$39.99/month (Professional)
Payout frequency	Biweekly (14-day cycle)	Biweekly (7 or 14-day disbursement)
Referral fee range	6–20% flat on sale price	8–15% with variable closing fees
Fulfillment option	WFS (optional)	FBA (widely used)
Advertising billing	Netted from payout (Walmart Connect)	Separate billing stream (Amazon Ads)
Tax facilitation	Yes (46 states + DC)	Yes (46 states + DC)
Xero invoice type	Invoice per order or period journal	Invoice per order or settlement journal
Xero reconciliation	One clearing account, biweekly match	One clearing account, biweekly match

The key accounting difference for Xero users: Amazon Advertising is billed separately from your seller account and creates a separate Accounts Payable entry. Walmart Connect advertising charges are netted directly from your Marketplace payout, appearing in the Walmart remittance report. This means your Walmart Seller Center remittance report is a single document covering all Walmart costs — you do not need to reconcile two separate billing streams the way Amazon sellers do.

For multi-channel sellers running both Walmart and Amazon through Xero, SyncTools uses Xero tracking categories to keep each channel’s transactions cleanly separated in one Xero organisation — so you can run a Xero P&L by channel at any time without exporting to a spreadsheet.

Related: Amazon Xero integration — step-by-step setup for sellers managing both Amazon and Walmart in one Xero organisation.

Frequently Asked Questions

Does Walmart have a native Xero integration?

Walmart Marketplace does not offer a built-in Xero integration as of 2026. Seller Center includes transaction reports, remittance reports, and payout summaries — but no direct Xero connection exists. Third-party tools like SyncTools bridge the gap, automatically syncing Walmart orders, referral fees, WFS fees, and biweekly payout settlements into the correct Xero accounts without manual CSV exports or journal entries. Setup takes under 30 minutes.

How do Walmart biweekly payouts reconcile in Xero?

SyncTools posts all Walmart Marketplace transactions — gross sales, referral fees, WFS charges, advertising, and refunds — to a Walmart Clearing account in Xero as they occur. When the biweekly net payout arrives in your Xero bank feed, it matches the Walmart Clearing balance exactly. Xero presents the match in the bank reconciliation screen, you confirm it in one click, and the clearing account zeroes out. No manual journals, no spreadsheet arithmetic.

What Walmart data syncs to Xero automatically?

A properly configured Walmart Xero integration syncs: gross sales by order or by settlement period, referral fees by product category, WFS pick and pack and storage fees, Walmart Connect advertising spend, refunds and returns (as Xero credit notes), marketplace facilitator sales tax (as a current liability), and payout deposits matched to the Walmart Clearing account. Customer contact data, Walmart listing information, Seller Center analytics, and WFS inventory counts do not sync.

How are Walmart referral fees recorded in Xero?

Walmart referral fees — 6 to 20 percent of the sale price depending on product category — should be posted to a Direct Costs account in Xero (not an Expense-type account). Recording them as Direct Costs places them above the gross profit line in your Xero P&L, giving you an accurate gross margin calculation. Never net referral fees against gross revenue, as this understates both your sales and your costs simultaneously.

Which Xero plan do I need for the Walmart integration?

The Xero Growing plan (or higher) is recommended for Walmart sellers. The Starter plan limits the number of invoices and bills per month — a constraint that Walmart sellers hit quickly. Sellers with multi-currency requirements (a UK or Australian entity also selling on Walmart US) need the Established plan for native multi-currency support. SyncTools works on all Xero plans; the invoice limit is Xero’s, not the integration’s.

Can I backfill historical Walmart data into Xero?

Yes. SyncTools supports historical backfill of up to two years of Walmart Marketplace transaction data into Xero on Standard and Plus plans. This covers the case where you have been selling on Walmart for months before setting up Xero or the integration, and need prior-period data to complete your annual P&L or tax return accurately. The same account mapping applies to historical transactions.

How does SyncTools handle Walmart sales tax in Xero?

Walmart acts as a marketplace facilitator in 46 US states plus Washington D.C. SyncTools maps Walmart-collected marketplace facilitator tax to a Current Liability: Sales Tax Payable account in Xero — not a revenue account, and not Xero’s standard sales tax rate. This prevents Walmart-collected tax from appearing on your VAT, GST, or BAS return as output tax you owe, which would create a false tax liability. Your Xero P&L and tax returns are accurate without any manual adjustment.

Does the Walmart Xero integration work for Australian, UK, and New Zealand sellers?

Yes. SyncTools supports Walmart sellers in Australia, the UK, and New Zealand using Xero. For these entities, SyncTools applies the correct Xero tax rate codes to US Walmart transactions and uses Xero tracking categories to separate US Walmart activity from domestic sales. Confirm with your accountant whether US Walmart sales are outside the scope of your domestic VAT or GST return — the SyncTools mapping keeps them in a dedicated account that makes that determination straightforward.

Connect Walmart Marketplace to Xero — and Stop Reconciling Manually

Every biweekly Walmart settlement is a bookkeeping event that manual handling turns into a 2–3 hour task. A 20–30 minute integration setup eliminates that entirely. The math on automation is unambiguous: the time cost of manual Walmart–Xero bookkeeping exceeds any integration subscription cost within the first one or two settlement cycles.

The setup principles are not complex. Build your Xero account structure first — Walmart Clearing as a Bank account, referral fees as Direct Costs, sales tax as a Current Liability. Connect Walmart and Xero via OAuth in SyncTools. Map each transaction type to its Xero account. Choose your sync mode. Validate the first sync against your Seller Center remittance report. After that, SyncTools handles every Walmart settlement automatically — gross sales post to revenue, fees post to Direct Costs, refunds post as credit notes, and each net payout reconciles to your Xero bank feed in one click.

Start your free SyncTools trial — no credit card required. Connect Walmart Marketplace and Xero in under 30 minutes.

Integration landing pages:

• Walmart Marketplace Xero Integration — full setup guide, Xero account mapping, and payout reconciliation walkthrough
• Walmart QuickBooks Online Integration — for Walmart sellers using QuickBooks instead of Xero

Related guides:

• Walmart Marketplace accounting guide — chart of accounts, biweekly payout structure, WFS fee categories, and sales tax handling for Walmart sellers
• Walmart QuickBooks integration — step-by-step setup for Walmart sellers using QuickBooks Online
• Amazon Xero integration — setup guide for multi-channel sellers managing Walmart and Amazon in one Xero organisation
• eBay Xero integration — same clearing-account reconciliation approach for sellers running both Walmart and eBay through Xero
• Xero eCommerce accounting guide — how to structure Xero for multi-channel eCommerce selling
• Xero Power BI connector — sync Xero data to a database and connect Power BI, Tableau, or any BI tool via SQL for cross-channel dashboards
• eCommerce bookkeeping guide — accounting fundamentals every marketplace seller needs before connecting any integration
• automated reconciliation for eCommerce — how to eliminate manual payout reconciliation across all marketplace channels