How do I track fees and gross profit?


Many companies want to view their total profit per transaction. QuickBooks has no profit report after fees like the one described. In addition, adding fees in QB will subtract from gross sales. Connex will keep the fees and the orders separate, so you can accurately track sales in QB.

Do I need to connect Amazon directly to Connex?

Yes, you must add Amazon as a connection at the my connections page. On the configure page, you can select do not sync sales to ensure no sales enter QB. This is ideal if you paired ShipStation or Ordoro with our software.

How is this report compiled?

Connex pulls the purchase cost from QuickBooks. Connex matches the product SKU from Amazon to the name field in QuickBooks. Connex pulls an Amazon settlement report and adds up all the fees. Connex divides the total profit by the price of the product.

How do I view the report?

Here are the steps:

  1. If you have not already, pair your Amazon account with Connex.
  2. On the Connex my connections page, choose your Amazon connection.
  3. Hover over the gear and click reports.
  4. Click Amazon Profit and Loss.
  5. Enter a begin and end date of an Amazon settlement report.

Here is an example report:

Do you have any charts?

Yes, here are our charts:

  • Total Sales Minus Fees
  • Total Amazon Fees by Date
  • Total Sales

Here is a diagram of the charts.

Have more questions? Submit a request
Powered by Zendesk