Knowledge Base

Columns

Let’s look at each column on the Stats page, Settled Transactions.

Note, at the top right you can click the Settings Wheel to SHOW certain columns:

The Standard columns are as follows:

Product Charges:  this is the price the item was sold at.   It does not include sales tax and shipping fees, and it also does not take into account coupon code discounts etc.   If your product has a sell price of $15, but the buyer has a $10 discount coupon and only pays $5 plus $0.75 in sales tax, the Product Charge would still be $15.  The Promo Rebate would be $10 and the Sales Tax of $0.75 would be part of Other.

Promo Rebates:  this is all the promo discounts on the sale – it can include coupon code discounts and it can also include shipping credits.

Amazon Fees:  this includes Amazon’s Referral Fee (normally 15% of Product Charges – promo discounts.  It also includes Amazon’s shipping fees (if any) and FBA fees if fulfilled by Amazon – the Pick fee, item fee and weight-based fee.

Other:  this includes Sales Tax (Non-MFT -- if any) and often shipping fee credits.

Qty:  the number of items sold.

Other (Adj.):  this is where Amazon includes any remaining credits or fees or adjustments.

Amazon Payout:  this is the amount that Amazon will pay (or has already paid) to you as a result of these product sales.   Unless you have an Amazon loan or other Amazon debit, this is the exact amount that Amazon pays you.

Cost (Approx.): these are entered by you.  They are discussed more under the section Settings | SKUs.  There are a few options.  You decide what you put in for your Costs, but typically it is the cost of your product from your manufacturer – the Cost of Goods value for that product.

Inbound (Approx.): Inbound Shipping is entered by you, the seller, and is a way to show the cost of shipping product to Amazon, if that cost is not already deducted in other fees.  This gives you more accuracy for the estimated Gross Profit calculations.  As with Costs, these are entered under Settings | SKUs.

Additional Expense: Like Costs and Inbound values, these are expenses that can be added and used to calculate against the profit.  Add Additional Expenses under Statistics | Additional Expenses.

Ads Cost (Approx.): also PPC.  When PPC Ads (Amazon Sponsored Ads) costs are shown, the Gross Profit is calculated using these figures.

These numbers show incurred PPC costs – which is not necessarily what’s been charged by Amazon, as Amazon typically collects payments in chunks of $500 or more.

Sales Tax (Non-MFT): Sales Tax is shown in this column.  If it is Hidden then it is not included in the Gross Profit calculation.  Sales tax figures are simply what Amazon reports it has collected in Sales Tax (Non-MFT) on your behalf, based on the instructions you provided them.  Note: This only shows non-MFT or registered State Sales Tax collected.

Please consult a sales tax professional to ensure your sales tax settings are correct.

We are only reporting to you what Amazon is reporting.  It is your responsibility to ensure your Sales Tax settings are correct.

Gross Profit (Approx.): total of left to right values.

Profit % (Approx.): a percentage representation of Profit.

Gross Profit / (Order Product Charges + Refund Product Charges[negative number]) + (Order Promo Rebates [negative number] + Refund Promo Rebates)

ROI % (Approx.): Return On Investment.  Gross Profit / (Cost + Inbound)

Off Amazon: If Amazon is fulfills sales through an outside channel, such as Shopify, those values can be shown here.

ACOTS: Ads Cost of Total Sales, or ACOTS for short, is your advertising spend divided by your total sales (sales from ads and organic sales)

Those are the columns across the top and apply to each row.

Now let’s take a look at the overall totals.