4.5 How to Use Financial Analytics to Check Your Revenue And Expenses?

Feature Overview

This feature presents your store's income and expenses over a specified period. It calculates actual gross profit and gross margin based on your set product costs. In this feature, order sales are calculated by settlement time, which is consistent with the calculation method of payment report of Amazon Seller Central. Differed from the order placement time, settlement time refers to the fee generation time shown in the transaction overview of Amazon Seller central payment report, representing when Amazon records the fee occurrence, directly affecting your account period, payments, and related revenue and fee statistics on Amazon.

Here are some key points about our statistical method:

  1. Sales are calculated based on settlement time.
  2. Refunds are deducted from the sales amount on the refund date. For example, if a customer orders on January 1 and refunds on February 1, the refund amount is deducted from February 1 sales.
  3. We don't estimate or include fees for pending orders until Amazon generates the relevant fee data when the order status changes.
  4. Product-level fees (parent ASIN, child ASIN, SKU) only include order, refund, and storage fees, excluding Amazon store-level fees.

Note: Amazon's gross profit calculation differs from actual gross profit calculation

Amazon Gross Profit = Amazon Revenue - Amazon Fees
Actual Gross Profit = Amazon Revenue - Amazon Fees - Non-Amazon Expenses (including product sourcing costs, shipping cost to Amazon warehouse, and custom costs)

Due to potentially long periods between order placement and settlement on Amazon, you can use the Sales Analysis feature if you want to view real-time store/product profit based on order placement time and estimated pending order data.


Usage Instructions:

1.Select Business Analysis - Financial Analysis to access the feature. It displays the store's sales analysis for the past week by default. For first-time users, please enter your costs in the Cost Center first.


2.1 Income and Expense Breakdown:

Detailed breakdown of income and expense items in pie charts and tables.


Note:

a. Data is sourced from Amazon's Date Range Report. Access path in Amazon Seller Central: Payments - Payments Repository - Report Type - Select Summary- Select Reporting Date Range-Request Report.



b. Hover over the exclamation mark next to each field on the feature page to see which field it corresponds to in the official summary report.

c. Use the " Hide items with a cost of 0" button to conceal items with zero value for easier data verification.

d. View Amazon revenue composition, Amazon fee composition, and non-Amazon expense composition with pie charts for a clear understanding of each item's proportion.

e. Export page data with a single click.

f. Non-Amazon expenses are included. Click the button to customize and input these data in the Cost Center.

 

2.2 Financial Details:

View detailed income and expense tables for a single store with specified period comparisons. Supports YoY / PoP data comparisons.


Note:

a. Data is sourced from Amazon's Date Range Report. Access path in Amazon Seller Central: Payments - Payments Repository - Report Type - Select Transaction- Select Reporting Date Range-Request Report.



b. Use the dropdown menu to switch between viewing options:

i. PoP: Compare current period with the previous period.

ii. YoY: Compare current period with the same period last year.

iii. Do not compare: Display without comparative data.