How do I sync my Amazon Settlement Report to QuickBooks?

Introduction

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.

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. You can only sync (90) ninety days back.
  3. 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?

Add a new Amazon Settlement Report Connection

1. To add a new Amazon Settlement Connection to your Connex account, start here: Getting Started with Connex Desktop: Add a New Connection.

2. Follow the Getting Started with Connex Desktop: Pair the Web Connector Guide

3. Follow the Install Wizard to set up Amazon Settlement Report Sync Settings

Important Amazon Settlement Summary Sync Settings

  • Choose the QuickBooks transaction type of Summary Sales Receipt or Summary Invoice.
  • Choose the QuickBooks customer match settings as
    • QuickBooks Customer Name: Single Customer 'Web Store'
    • Single Customer Name: Amazon Summary

These settings are controlled in the Connex for QuickBooks account under menu: Customers ->Matching 

single_customer_match_Amazon_Sales.png

Where are sales synced in QuickBooks?

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

mceclip2-2.png

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 end date is 12/12.
  4. Click save.
  5. For QuickBooks desktop users, run your web connector

I do not see any Amazon Settlement Report summaries in QuickBooks.  What am I doing wrong?

The automatic settlement report functionality may not be turned on in your Amazon Seller Central account.  You must ask Amazon to automatically schedule these reports.

  1. Go to this contact form.
  2. Enter the following information into the contact form.

Contact Reason: Please turn on automatic settlement report for my account.
Changes: I would like to request that the following settlement reports be automatically scheduled for my account:

Flat File Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE
XML Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_XML
Flat File V2 Settlement Report: GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2

Here is a screenshot of the form.

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 period. In this example, the end date is January 16th.

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.

Can I manually upload reports?

If a specific report cannot be located, then you can upload the report manually to Connex:

  1. Login to Amazon Seller Central.
  2. On top, click reports and click payments.
  3. Click the all statements tab.
  4. Using the date range, adjust the range until you see the correct report.
  5. Make sure download XML is available next to the report.
  6. Under a report, click download XML and save the report with an extension of .xml: dowload_xml.jpg
  7. Login to Connex.
  8. Next to Amazon settlement, click manage.
  9. On our configure page, a form to upload a file will appear.
  10. In the upload form, select the XML file and click submit.
  11. You are redirected to the complete page. If you use QuickBooks Desktop, run your web connector.

How are shipping and gift wrap fees calculated?

Connex will add line items for shipping and gift wrap, as if you collected sales. If you add Amazon fees, Connex will add the shipping and gift wrap as an expense to cancel it.

What does a sample order look like?

Here is a settlement report from Amazon and here is an order from QuickBooks. In this example, we merged the refunds onto the sales receipt. 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.

Does your connector break out the fees?

Here is a sample order that synced to QuickBooks. Connex will show these amounts:

  • Amazon fees, which are the total from sales minus the total from refunds.
  • FBA fees
  • Cost of advertising
  • Other transactions, such as warehouse lost
  • Discounts on sales
  • Discounts on refunds, which show positive if refunds are merged
  • Unavailable balance
  • Previous unavailable balance

What are the benefits of separating fees?

Here are some benefits:

  1. If your sale is incorrect, it is easier for our support to determine the issue. If we see the discounts fail to match, then our staff will review the discounts.
  2. You can track certain kinds of fees in QuickBooks.
  3. Instead of a generic total Amazon fees, you can now better audit the fees that you see from Amazon.

What items does Connex create to separate fees?

Here is a list:

  1. OtherTransaction
  2. AmazonFBAFees
  3. AmazonAdvertisingFees
  4. AmazonCouponPayment
  5. AmazonCurrentReserveAmount
  6. AmazonPreviousReserveAmount
  7. RefundDiscount

Do you support Amazon Mexico?

Yes, we support Amazon Mexico. To integrate, follow these steps:

  1. On the my connections page of our product, click add a new connection.
  2. Select Amazon settlement report.
  3. In the marketplace ID field, enter A1AM78C64UM0Y8.
  4. In the website field, enter http://www.amazon.com.mx.
  5. Click configure.

If you try to update your credentials, you will see the Amazon US marketplace ID. Please reenter the Amazon marketplace.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.