How to import Amazon Seller Central Orders into QuickBooks desktop

Overview

Step One: Exporting sales data (Settlement Report) from Amazon Seller Central

1. Login into your Amazon Seller Central Dashboard
2. Select the Reports menu option, select Payments and then click Date Range Reports.
3. Select the report type as Transaction and the Date range you require
4. Download the report and save the Settlements report to your desktop.
5. The report can be saved as a text tab delimited file, and can be opened in Excel

Step Two: Importing the Amazon Settlement Report into QuickBooks Desktop using Zed Axis

• Linking Amazon SKUs to QuickBooks item names - It is important that the name of the Amazon SKU matches the Full Name of the Item in QuickBooks.  If there is a mismatch then Axis will create a new item in QuickBooks, this may lead to items having duplicate names in QuickBooks leading to problems with having an accurate picture of inventory.
• Selling in multiple countries -  Assuming you have multi-currency enabled in your QuickBooks company file you will need to do separate imports, have fees expense accounts for each currency
• Recording fees and deductions - How to record the fees and charges levied by Amazon make sure you have created items as Other Charge types with the same name as the Amazon fees and linked them to corresponding Expense Accounts in QuickBooks. You will need to have items for;
  • FBAPerOrderFulfillmentFee
  • FBAPerUnitFulfillmentFee
  • FBAWeightBasedFee
  • Commission
  • SalesTaxServiceFee
• How to record returns, lost items and storage fees
• Reconciliation with Settlement report
• Settlement report is generated by Amazon every 14 days or so.

Importing the SKU details

1. Open Zed Axis and connect to your QuickBooks desktop file
2. Click on the import tab and browse to the Settlement Report file that you downloaded from Amazon Seller Central in step one above.
3. Select the option to add a new mapping, and select the transaction type as Sales Receipt and map the fields shown below, and save the map with the name AMZN - SR SKU. (on subsequent imports you just need to select this saved mapping)
4. This first phase of the import is going to import the SKU details so we need to exclude any rows that do not have SKU details (In the preview grid filter the Amount column to exclude Blanks) and click Import,

Importing the Fees

1. Now to import the Fees, select the option to Add a new mapping and select Sales receipt and create a mapping as shown below and save the map with the name AMZN - SR Fees
2. Select the option to Append (as we going to be appending the Fees to the Sales Receipts we create previously).
3. Filter out the rows that do not have Fees by setting the Filter for the ItemRefFullName column to is not NULL
4. Click Import and the various fees will be added to the sales receipts.