If you are using Walmart Fulfillment services (WFS) and Walmart Performance Ads (WPA) your payout will not match with the A2X invoice. This is because Walmart does not currently include these fees in their settlement API that is sent to A2X. Instead, Walmart takes these fees directly out of the payout that you receive without accounting for it in the settlement.

You will need to account for your Walmart fees in Xero or QuickBooks Online.

We recommend setting up a repeating bill entry in Xero.

This way you will end up with an open invoice from A2X (that includes the sales information) and an open bill each month (which can be updated to reflect the WFS and WPA fees). You can then match both of these up against the deposit that comes through from Walmart to reconcile.

To set up a repeating bill, go to Xero > Business > Bills to Pay.

Click on the drop-down arrow next to New Bill and select, New Repeating Bill.

Set up the bill to repeat every two weeks against the account you would usually apply your WFS and WPA fees to.

For more information on Xero’s repeating bills, read the article in Xero Central HERE.

When reconciling the Walmart deposit, you will select both the invoice from A2X and the bill entry for the fees. Make sure you Tick the checkbox "Show Spent Items" in the match screen so that both invoices and bills will appear and can be selected for reconciling.

Hint: For an overview of Negative Settlement Reconciliation in Xero, read the support article available HERE.

For QuickBooks Online users the best method to automate this process is by the use of a clearing account. In A2X, you will map your deposit bank account to a ‘Walmart Clearing’ bank account (Settings->Connections). We only recommend using this option if you know you have WPA and WFS fees.

As your deposits come through from Walmart, you will allocate them to the same clearing account to offset the balance allocated by A2X. This is the reconciliation process. For any settlements that WFS fees have been deducted from, you can easily account for the fees by way of a split allocation in QuickBooks Online.

The deposit we have received in the bank is $15,700, A2X has allocated the full $16,000 to the clearing account so to reconcile the deposit and allocate the fees you can split the allocation as follows.

The full $16,000 gets allocated against the clearing account to clear the A2X balance.

The $300 is added in as a negative amount allocated against your Walmart WFS/WPA fees expense account:

This is an entry in A2X:

And this is the corresponding Walmart settlement for the period:

We’re here and available via chat to help with any questions you have.

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