Amazon Settlement Report

How do I sync my Amazon Settlement Report to QuickBooks?

Connex will create a single Summary Sales Receipt or Summary Invoice in QuickBooks from your Amazon Settlement Report.  The order in QuickBooks will add the products as line items with the quantity, SKU, unit price, tax, and Amazon fees.



The Amazon Settlement Report summary feature requires the Gold plan or higher.

What are the advantages and disadvantages?

There are many advantages:

  1. You sync one order per settlement report, instead of several hundred individual customer invoices or sales receipts.
  2. Connex adds the Amazon fees.
  3. It's easier to reconcile and it makes QuickBooks cleaner.

Here are the disadvantages:

  1. You cannot track sales by customer, since you only have a single order in QuickBooks.
  2. The sync runs bi-monthly, so you can't see your sales reporting until the next settlement report.

How to I set up the Connex account settings to sync the Amazon Settlement Report to QuickBooks?

The steps to set-up the settlement report are similar to the steps to set-up our regular Amazon integration. You will see a seller ID and MWS token. Read one of these guides:

Next, follow these steps:

  1. Login to Connex.
  2. Click add new connection.
  3. Choose Amazon Settlement Report. If you use Canada or Amazon Europe, choose Amazon Settlement Report Canada or Europe.
  4. Enter your seller ID and MWS token.
  5. Click submit.

Where are sales synced in QuickBooks?

Sales are synced under the Amazon summary customer, which Connex will create:

How do I change the sync dates?

  1. Log in to Connex.
  2. Next to the Amazon settlement report on the Connex dashboard, click manual sync.
  3. Enter the end date of the report from Amazon. In this example, the date is January 13, 2021:
  4. Click save.
  5. For QuickBooks desktop users, run your web connector

How do I add Amazon Fees?

Connex will export the fees by default under an item called Amazon fees. To use a different item, follow these steps:

  1. Login to Connex.
  2. Select Amazon settlement report.
  3. Click manage.
  4. Expand orders.
  5. Expand merchant fees.
  6. Enter the item name for merchant fees.

How does your software locate reports?

Our software uses the end date of the report period. The end date is usually one - two days before the deposit.

How far back can I set the sync dates?

Amazon only allows reports available in the last ninety days, using a date sync. If you require older sales, upload the reports manually.  You can upload reports manually one at time through Connex.

What does a sample order look like?

Here is a settlement report in QuickBooks and its credit memo. Here is a sales receipt and a credit memo:

Here is an example of the credit memo and sales receipt that are merged. This ensures one order matches the deposit exactly.

To enable merge refunds onto summary, follow these steps:

  1. Login to Connex.
  2. Click manage.
  3. Expand advanced summary.
  4. Click merge refunds.
  5. Click save.