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. 

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 the same as setting up the Amazon sync:

  1. Log into Connex.
  2. Click settings.
  3. Choose Amazon.
  4. Choose order setting > sync orders to QuickBooks.
  5. Choose summary payout as the transaction mode. 

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 connection on the Connex dashboard, click manual sync.
  3. Enter the end date of the report from Amazon. In this example, the date is May 5, 2022.
  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. Click settings.
  3. Expand order settings.
  4. Click orders to QuickBooks settings.
  5. Click the merchant fees tab.
  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.