Why are my Amazon settlement report orders incorrect?

Common reasons why your Amazon settlement report in QuickBooks does not match the settlement report in Amazon.

Problem

In QuickBooks, your Amazon sales are incorrect. They are higher or lower than expected.

Solutions

Group sales and refunds by month

If your settlement period was 11/22 - 12/8, Connex would sync the sale with a date of 12/8. This means December has November sales in QuickBooks, so your November and December sales are incorrect.

You can instruct Connex to group sales by month. You would have two sales receipts. The first is November and the second is December:

1. In QuickBooks, delete the summary sale.
2. In Connex, click settings.
3. Click order settings.
4. Click sync orders to QuickBooks.
5. Click summary order settings.
6. Under group by, choose order date month: 
7. Uncheck merge refunds with summary order.
8. Resync your summary sale.
9. Using your Amazon report, determine if both sales are correct.

Here is the end result:

Ungroup refunds and sales

Our software combines the sales and refunds into a single order. It's easier to troubleshoot, if it's a refund versus a sales issue:

1. In QuickBooks, delete the summary sale.
2. Click order settings.
3. Click sync orders to QuickBooks.
4. Click summary order settings.
5. As the grouping, choose payment method.
6. Uncheck merge refunds with summary order.
7. Resync your summary sale.
8. Using your Amazon report, determine if both sales are correct.

Run manual sync of one report

Connex will combine multiple reports into one summary. If you uploaded files for the 10/27 and 11/12 deposit, then you would get one sales receipt. You should upload files if you need to sync farther than 60 days back or your account fails to send the report automatically.

Verify you synced the right report

We have seen users upload different reports and compare them to the wrong payout. Click manual sync on our configure page. Use the date, instead of uploading a file. At times, you could upload an XML file for a deposit on 10/27 when you are really seeking a deposit on 11/12. If your deposit happened on 11/12, then enter 11/11 as the date to try.

Grouped Items

You use QuickBooks grouped items. The price of a grouped item is calculated by QuickBooks. If Amazon says $200 and QuickBooks says $100, then our tool will sync $100. Connex can add an amount to the sale to balance it.  To resolve this issue, click manage on our configure page. Expand orders > sync orders to QuickBooks > advanced transaction. Check fix rounding issues.

How do I contact you about discrepancies?

We do not check settlement report totals against spreadsheets for users. If you can tell us what is wrong, then our team can provide assistance. Please send these details:

1. In Connex, what date did you enter to sync the order? If you uploaded an XML file, please attach it to the ticket.
2. PDF copy of QuickBooks order.
3. Flat file report of the period.
4. What is wrong with the sale? Missing items? Wrong or duplicate fees?

You should start our with the settlement report spreadsheet. In Amazon, go to your settlement report. Download the flat file V2 report:

 

Check the sales receipt and fees. Do they match? Are fees missing? If so, which ones? Usually, fees cause syncing issues because Amazon keeps adding new fees. On the spreadsheet, click a column. Click data and filter. You can run reports.