All Collections
A2X for Walmart
General Setup
Getting started with A2X for Walmart
Getting started with A2X for Walmart

How to import your Walmart settlements to Xero and QuickBooks with A2X for Walmart

Amy Crooymans avatar
Written by Amy Crooymans
Updated over a week ago

About A2X for Walmart

A2X for Walmart imports your Walmart settlements and posts them to your accounting system in a way that makes it easy to reconcile the sales, refunds, discounts taxes and shipping against the cash receipts.

A2X for Walmart has several benefits for accounting:

  • Reconciles Walmart settlements perfectly

  • Automatically imports accurate Walmart data

  • Scales to support 1000's of daily orders without sending 1000's of individual invoices to the accounting system

  • A2X also supports Amazon and Shopify, you can connect all of your marketplaces to a single accounting system for multi-channel sellers

  • Supports multi-currency sellers and multiple tax rates

Does A2X for Walmart support Walmart.ca marketplace?

Currently A2X does not support Walmart.ca. The team at A2X are working on bringing this functionality to our Canadian Walmart Sellers.

1/ Creating an A2X for Walmart account

Create a new A2X for Walmart account from the Walmart sign-up page.

If you already have an existing A2X account, you will be asked to confirm that you wish to create a new account. So, this is where you need to choose 'Continue with New Account'.

In the next window, choose 'Continue to Your New Account'.

Once your account is created it should look like this:

Now you are ready to set up your new A2X for Walmart account.


2/ Connecting an A2X for Walmart account to your Walmart Seller Center

You'll have two options to connect A2X to your Walmart Seller account.

If you are the Walmart seller, choose option 1. Follow the instructions to generate your credentials and input your Client ID and Client Secret, then click 'Connect':

If you are an accountant or bookkeeper, choose option 2 and send your client an email with instructions to authorize the A2X to Walmart integration

For more detailed instructions on how to find your Walmart Client ID & Client Secret, click HERE.

Once connected you'll be redirected back to A2X and your first settlements will begin to import into A2X. The process usually takes 10-20 minutes and for larger Walmart Accounts, it can take several hours to complete.

Once imported you should see the settlements like shown below:

3/ Connecting to your accounting system

Click the Connect button for your accounting system and proceed with the connection process. You will be redirected to your accounting system to grant A2X permission.

If you are connecting A2X for Walmart to the same accounting system that you are already connected to with a different A2X account (either with Amazon, Shopify or a different Walmart Seller Center Account), you should choose to share the existing connection, rather than create a new connection.

4/ Configuring the accounts and taxes for your Walmart Settlements

You need to configure A2X for Walmart to map your Walmart transactions into your accounting system.
โ€‹
A2X will offer to create several generic default accounts, or you can select your own individual mappings. We recommend working with your accountant on this initial setup as it will impact how the Walmart transactions appear in your financial reporting.

You can also customize how the A2X transactions are created, such as grouping the sales by province in the Settings > Invoice section of A2X. This can help if you have specific tax handling requirements for some states.

You can disable, configure and preview these settlements in Settings > Connections.

Please Note: For more information about these mappings or if you have specific requirements that are not handled by the current mapping, please contact the A2X support team.

5/ Posting your Settlements and reconciling them in your accounting system

Once you have connected and configured your account, you can send your Settlements to your accounting system. To do that, click the Send link.

You will then see the settlement in your accounting system and be able to match or reconcile it to the corresponding deposit. For example, below is Xero's bank reconciliation screen showing the matching payouts.

Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE.

Did this answer your question?