Amazon provides a wide range of reports in Seller Central and navigating them or just knowing which report to use can sometimes seem like an impossible feat.
Furthermore, when it comes to attempts to reconcile back to an Amazon 1099K, it can feel like there is an overload of information available, but none of it really tells you what to do, what to use and how to achieve the end result.

For this guide we will reconcile one month only, however, the same principles apply for calculating the complete year.

​PART 1

Reconciling your Amazon Date Range Transaction Report or your Amazon Summary Statement to your Amazon 1099K.

Information required:
1099K Report

Amazon Date Range Transaction Report
Amazon Summary Seller Statement
​
​

Amazon 1099K Report
The Amazon 1099K is generally sent to the Primary Seller Account owner only. You may also be able to access your 1099-K online.  

Here are the steps to access this form:

Sample Report

Amazon Date Range Transaction Report 

To generate a Date Range Report, follow these steps in Amazon seller central: 

Sample Report

​

Amazon Summary Seller Statement

To generate a Date Range Summary Report, follow these steps in Amazon seller central: 

Sample Report - Standard Orders Statement

Sample Report - Invoiced Orders Statement

With the gathered information, you are now ready to commence the reconciliation process. In our example, we are reconciling the month of July.
​

The 'Unadjusted Gross Sales' reported on our sample 1099K report is $107,395.12.

To balance the Date Range Transaction Statement with the 1099K reported number for July, the following information needs to be gathered from the Transaction report:

The total of these amounts should equal the 1099K Unadjusted Gross Sales number.

We advise using Google Sheets or Excel to create a pivot table based on the date range report data and quickly pick out the required numbers. Or, you can apply a filter on the 'Type' column within the report to filter only the 'Orders' and  get the totals of the columns you need.

You can see below a sample showing the column totals added in for the month of July:

And the same for Invoiced Orders (B2B)

Or displayed in the form of a Pivot Table

As outlined in the screenshots above and reported on the Amazon Date Range Transactions Report, our Unadjusted Gross Sales for the month of July is:
​
Product Sales $105,021.13 (Standard Orders + Invoiced Orders)
Shipping Credits $2,086.49
Giftwrap Credits $6.98
Promotional Rebates ($2,346.14)
Sales Tax Collected $2,758.19
Marketplace Facilitator Tax ($265.00)
_______________________________________
TOTAL UNADJUSTED GROSS SALES $107,395.12
​

To balance the Summary Transaction Statement to the 1099K reported number for July, the following information needs to be gathered from the Summary report:

Standard Orders Summary Statement

Invoiced Orders (B2B) Summary Statement

Now, our Amazon Date Range Transaction Report as well as the Amazon Date Range Summary Report are balanced, as outlined below:

PART 2

Reconciling your A2X Settlement Reports to your Amazon 1099K.
​

Information required:
1099K Report
A2X Settlement Statement export

​Amazon 1099K Report
​The Amazon 1099K is generally sent to the Primary Seller Account owner only. You may also be able to access your 1099-K online.  

Here are the steps to access this form:

Sample Report

​A2X Settlement Export
​The A2X Settlement Reports can be exported directly from within your A2X account. 

Here are the steps to export the required data from A2X:

1. Login to your A2X Account

2. Enable 'Bulk Actions' by clicking into the checkbox

3. Select the relevant settlements and click "Export Settlements"

This will download a CSV file to your computer. 

4. Open the CSV file and sort the data by date to include only the month you are reconciling (remove the lines that are not part of the month you are reconciling).
​
5. Create a pivot table to group the transaction lines together in each of their categories.

6. In the pivot table tab, add 'Description' to the Rows category and add 'Amount' to the Values category (Google Sheets).

7. Lastly, you will need to go through and add up all items as highlighted below:

​The end result is the following:

This is also reflected in the table below.

The same method outlined above can be applied to all months of the year, so you can balance back to the full year Amazon 1099K report. It is common to see a small difference in one month, that is taken up the following month with Amazon reporting, so it is recommended that you complete this procedure for each month of the year, if you wish to ensure the full year balances.

Feel free to contact our support team if you have questions regarding the procedures outlined in this guide.

Hint: If you are in chat and wish to view the article outside of the chat window, please click HERE
​