Below you can find how each of the metrics are calculated and where we take them from.
Important note: Reports in My Real Profit have predefined layouts.
Users cannot manually add or remove metrics/values/columns in report tables.
On the Advanced plan, advanced report customization is available only via request (handled by our team), not via self-service UI.
Sales / Total Sales
⤷ Definition: Total revenue generated from customers, including the item price and shipping price for non-FBA orders. For FBA orders, this includes only the item price.
Total Sales includes orders that are in Pending and Shipped status. MCF (Multi-Channel Fulfillment) orders are not included.
If an order transitions from Pending to Canceled status, My Real Profit software will exclude this order from the Total Sales calculation.
Data Source: Amazon’s "All Orders Report."
Calculation: Sum of the item_price row.
Units
⤷ Definition: Total number of units sold within a selected time period. The Units Sold metric uses the same logic as described in Total Sales.
Data Source: Pulled from Amazon’s "All Orders Report."
Calculation: Sum of the quantity row.
Cost of Goods (COGS)
⤷ Definition: The total value of the inventory sold during the selected time period. This cost must be manually added by the user on the Products and COGS page. Please refer to the video guide on how to enter COGS correctly.
Data Source: My Real Profit – Products and COGS page.
Calculation: COGS value x Units.
Fulfillment Fees
⤷ Definition: The cost of delivering the products. This is the total amount of fulfillment fees for the selected time period.
When an order is in Pending status, the FBA fulfillment fee cost is not yet available and is usually delayed by Amazon (the delay can range from 1 to 7 days after the order is placed).
My Real Profit uses the estimated FBA fee provided by Amazon (downloaded daily) until the actual cost becomes available. Once the actual FBA fee is posted on Amazon, My Real Profit will replace the estimation with the actual cost. All FBA fees are allocated by purchase date so the cost aligns with the order's placement date.
Data Source: "Get my FBA fees" for estimation and "Reports Repository" for the actual number.
Referral Fees
⤷ Definition: Revenue-based commission paid to Amazon for using the Amazon marketplace. This cost is a percentage-based commission, and the percentage varies by category. Referral fee calculations follow the same estimation logic as fulfillment fees. Once the order is posted, the estimation is replaced with the actual cost.
Data Source: "Get my FBA fees" for estimation and "Reports Repository" for the actual number.
Calculation:
For FBA: Amazon commission % x (item price – discounts)
For FBM: Amazon commission % x (item price + shipping price – discounts)
Advertising Spend / PPC Cost
⤷ Definition: The cost of using Amazon’s pay-per-click (PPC) service to place your products in Sponsored placements. This cost should match your Amazon Campaign Manager, though there might be a 1-2% difference due to API data variations.
My Real Profit uses Advertised Product reports for Sponsored Products and Sponsored Display ads to accurately break down spending by ASIN.
For Sponsored Brands ads, the system divides the spend equally among all advertised ASINs (e.g., if there are three ASINs, the cost will be divided by three and allocated across those ASINs).
Data Source: Campaign Manager
Refunds
⤷ Definition: When a customer requests a refund on the Amazon platform, the seller will be charged. My Real Profit’s “Refunds” section provides the final cost of customer refunds, which includes multiple transactions:
Refunds: Includes the sales price paid back to the customer, reimbursement of the referral fee to you, and the fee for refund processing (20% of the referral fee or $5 max).
Refund Administration Fee: If your refund rate exceeds the category average, you may be charged an administration fee.
Sellable Returns COGS: The value of inventory returned to FBA fulfillment centers in sellable condition. This amount increases your profit since the product can be sold again.
Data Source:
"Reports Repository" for refund amounts and refund administration fees.
"FBA Customer Returns" report for sellable returns COGS.
Other Fees
⤷ Definition: This section contains general expenses at the account level. These costs cannot be broken down to the product level.
Data Source: "Reports Repository" report
Storage Fee
⤷ Definition: The Amazon FBA (Fulfillment by Amazon) storage fee is the cost Amazon charges sellers for storing their inventory in its fulfillment centers. These fees are part of Amazon's FBA program and are based on the volume of your stored products, measured in cubic feet.
This cost is estimated in My Real Profit because there is a delay before it becomes visible to sellers on Amazon. Amazon storage fees have a 1.5-month delay.
Example: For October storage, you will be charged between November 8th and 15th. Using My Real Profit's estimation method, you can track these costs in real-time.
The estimation is calculated by tracking your daily FBA inventory stock combined with your product measurements. This allows us to calculate how much space you occupy in Amazon's fulfillment centers and estimate the storage cost.
Once the actual cost is available, the estimation will be replaced with the actual cost (in development. not ready yet).
Data Source:
For estimation: "Manage FBA Inventory" and Listings report
For actual cost: "Manage Storage Fees" report
Discounts
⤷ Definition: The total amount spent on discounts within a selected time period. Discount costs follow the same logic as described in Total Sales. It includes all types of promotions, such as coupons, brand-tailored promotions, subscribe and save, etc.
The coupon redemption fee is a fixed cost per redeemed discount per order and varies by marketplace.
Data Source: Pulled from Amazon’s "All Orders Report."
Calculation:
Discounts: Sum of "item promotion discount" but exclude coupons.
Discounts: Sum of "item promotion discount" but only include coupons.
Coupon Redemption Fee: Unique orders with coupons used x coupon redemption cost.
Adjustments
⤷ Definition: Refers to corrections or payments Amazon makes to your seller account for various reasons. Adjustments are changes Amazon applies to your account balance, typically related to inventory or order discrepancies. Reimbursements are payments Amazon provides to compensate for losses or errors for which it is responsible.
Data Source: "Reports Repository" report
Manual Expenses
⤷ Definition: Costs that can be added by the user in the "Manual Expenses" tab.
Data Source: My Real Profit – Manual Expenses page
At My Real Proifit, we have 2 Profit metrics:
Profit
⤷ Definition: Net income generated from sales, including all fees. This profit metric is used on a Profit dashboard.
Formula:
Profit = Total Sales – (Cost of Goods + FBA Fee + Referral Fee + Refunds + Advertising + Discounts + Storage Fee + Other Fees + Adjustments + Manual Expenses)
Profit from Sales (advanced-only metric):
⤷ Definition: Net income generated from sales, excluding certain fees not directly related to the sales. This metric helps evaluate the performance of marketing activities over a specific period.
This profit metric is available only on advanced reports:
Day-to-day
Profit & Loss
Advertising Analytics
Exclusions: Adjustments, reimbursements, removal fees, subscription fees, long-term storage fees.
Formula:
Profit from Sales = Total Sales – (Cost of Goods + FBA Fee + Referral Fee + Refunds + Total Marketing)