Match Deposit Tool

Can I match deposits from Walmart to QuickBooks?

Steps to get started with the Walmart match deposits.

How do I perform the match?

You must download your Walmart settlement report from your Walmart seller portal. The spreadsheet has these headers:

  • Transaction Type
  • Commission from Sale
  • Transaction Date Time
  • Order #
  • Gross Sales Revenue

Here is how the fields map:

Walmart QuickBooks Order # Order Number
Transaction Type If refund, then search for a refund receipt. Otherwise, search for a sales receipt or invoice.
Transaction Date Time Order Date
Gross Sales Revenue Used to determine if order is a refund or sale
Commission from Sale Total fees per order. Aggregated at the bottom of the deposit. Walmart usually takes 15% commission.

How do I upload the spreadsheet?

To perform the match, follow these steps:

  1. If you have not already, set up the sync with Connex.
  2. Once complete, log into Connex.
  3. On the left, click orders > match deposits.
  4. Choose Walmart.
  5. Upload the sheet and complete the form.
  6. Click submit.
  7. If you use QuickBooks Desktop, run your web connector. Otherwise, wait a few minutes. Click dashboard on the left to view the results.