All Collections
A2X for Walmart
General Setup
A2X for Walmart default account mapping
A2X for Walmart default account mapping
V2. How does A2X create the default accounts for Walmart accounting and what type of accounts are they?
Natalie Flex avatar
Written by Natalie Flex
Updated over a week ago

A2X fetches your settlement data from Walmart and categorizes the transactions into the higher-level transaction types on the left-most column, such as Adjustments or Commissions.

A2X can create generic accounts in your Chart of Accounts

When you first go to set up your Accounts and Taxes mapping, you will see that A2X can create a number of generic default accounts for you to map transactions to.

Click 'Confirm' to allow A2X to create the following list of accounts in your accounting system

Next, bulk update your tax settings in A2X

Step 1: Enable Bulk Actions

Step 2: Choose tax Exempt or No Tax.

(For UK, EU, AU, NZ, or SG sellers follow the instructions HERE for VAT and GST mapping)

The default accounts created by A2X will assign your transactions into the account types that will generate a reasonable set of financial reports without needing to spend a lot of time on the account mapping process.

Click 'Save'

Account Types for generic accounts created by A2X

The names of the account types created in Xero and in QuickBooks are slightly different but, in accounting terms, they are the same.

Expenses and Sales or Revenue or Income accounts will be on your Income Statements (Profit and Loss). Current assets and Current liabilities will be on your Balance Sheets.

The table below shows the basic account types for each accounting solution so you can find them in your reports:

By saving the mappings, the chosen accounts will be created in Xero or QuickBooks Online and also mapped to your settlement transactions after you refresh them. With this setup task complete, you are ready to send your first settlement!

Custom/Manual Mapping

Because A2X is connected to your accounting software, your complete chart of accounts can be detected in A2X.

Instead of our generic default accounts, you can select your own account for any transaction type. Just click on the down arrow to open the list of existing accounts, and then scroll to find and select the account from your Chart of Accounts list.

Please Note: A2X uses account codes that indicate the accounts were created by A2X such as: "a2xwship" and "a2xwtax". This will differentiate them from the default codes used in the accounting systems, which are often numeric sequences such as 400, 401, etc.

Advanced mapping features:

  • Enable VAT or GST tax mapping for UK, EU, AU, NZ or SG Sellers

  • Edit your new mapping page. You can start by allowing A2X to create a list of chart of accounts, or pick your preferred accounts manually.

Well done, you've mapped your Account Types in A2X!

Pro tip:

Add tracking codes or classes by Walmart marketplace in your invoice settings

To generate custom reports by marketplace like this example below:

If you have any questions or need assistance with your account setup, feel free to email our support team at contact@a2xaccounting.com, and we will be happy to help you where we can.

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?