Amazon Settlement Report
      Back to home
      1.  
      2. Connex for QuickBooks Integrations Guide
      3. Amazon Settlement Report

      Does your connector break out the fees on the Amazon settlement report?

      Connex will break out FBA, advertising, discounts, shipping, available, and unavailable balance.

      Is there a demo?

      Here is a demo:

      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

      How is shipping calculated?

      If there is shipping and a shipping chargeback, Connex maps shipping as $0. If there is shipping tax and marketplace facilitator shipping tax, then Connex maps no tax. Here is the flat file settlement report from Amazon:

      If there is a discount on the sale for free shipping, Connex will map no discount. Instead, Connex will map $0 for shipping.

      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:

      Name Notes
      OtherTransaction These fees include: warehouse lost, warehouse damaged, inbound transportation fee, removal complete. If you export the V2 flat file of your settlement report, anything with type other transaction is grouped into this line.
      AmazonFBAFees  Added as a line item. Go to Connex settings. Click order setting > merchant fees. Enter an item name.
      AmazonAdvertisingFees Connex adds this fee as a separate line item.
      AmazonCouponPayment Connex adds this fee as a separate line item.
      AmazonCurrentReserveAmount Go to Connex settings > order setting > summary group by. If you select order date month, then we omit these details. Otherwise, Connex adds this fee as a separate line item.
      AmazonPreviousReserveAmount Go to Connex settings > order setting > summary group by. If you select order date month, then we omit these details. Otherwise, Connex adds this fee as a separate line item.
      RefundDiscount Connex adds this fee as a separate line item.
      Shipping chargeback This means the customer paid Amazon for shipping, but Amazon deducted shipping before paying your business. If there is a shipping chargeback, then our tool reports $0 shipping for a sale.
      Marketplace facilitator tax The customer paid for tax, but Amazon deducted tax from the order before paying you. Our tool will remove the amount Amazon remitted.

      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.