How can we help?

Help & FAQs
- Role - Finance
- BigSeller Report -- To realize full data monitoring of goods, stores and shipment
- Introduction to Live Sales Monitor
- Introduction to WMS Monitor
- Introduction to Store Report
- Introduction to Order Report
- Introduction to Sales Report
- Introduction to Profit Report
- Introduction to Shopee Order Profit Report
- Introduction of Store Profit Report
- Introduction of Order Profit Report - General Template
- Introduction of Merchant SKU Profit Report
- Introduction to Invoicing Report
- Introduction to Merchant SKU Report
- Introduction to Task Report
- How to use Payment Reconciliation (Shopee and TikTok Shop)?
- Profit Analysis for Shopee
- Profit Analysis for Lazada
- Profit Analysis for TikTok
- How to update cost of merchant SKU in profit report list?
- How to check Shopee Ads data?
- How to use Payment Reconciliation (Lazada)?
- How to edit other fees for store profit report?
- Introduction to Shopee Store Health (Account Health)
- Introduction to Lazada Store Health (Account Health)
- Introduction to Multi-Currency Exchange Rate Settings

Introduction of Store Profit Report

Copy link & title

Update Time: 19 Aug 2025 05:15

The system will summarize profit data by store, and you can view the profit status of each order.

1. Supported marketplaces: Shopee, Lazada, Tiktok Shop, Facebook, manual orders, POS retail orders, messenger orders.
2. Profit report only counts shipped, completed and canceled orders.

BigSeller's order profit only displays orders released by the platform.
Canceled orders may still incur adjustment fees, so orders with a canceled status (and non-zero settlement data) will also be included in the profit report.

3. Orders not processed in BigSeller also support profit analysis, but you must set a reference price first. If not, Merchant SKU Cost = 0.
4. If you want to add ads, rents, packaging material fees in this table, please check How to add other fees for store profit analysis?

Note: From now, BigSeller will automatically fetch historical ads fee for your TikTok and Shopee stores. To avoid duplication, please do not manually add Shopee ads expenses under Other Fees.

For Shopee ads expenses, data or will be synchronized and updated on a dalily basis. The data of the current day will be visible on the next day.

Field Introduction

1. Store Revenue

Store Revenue = Product Sales + Platform Subsidy + Platform Charges + Other Fee

Note: The Store Revenue shown in the Store Profit Report is not equal to the Order Revenue in the Order Profit Report. This is because Store Revenue also includes certain store-level fees, while Order Revenue only reflects revenue at the order level.

2. Cost of Merchant SKU

Take the cost of goods based on the contents maintained in Order Setting＜Profit Setting＜Cost of Goods Value Setting.

If the Stock-Out Price is greater than 0, the system will quote it as the cost by default;
If the Stock-Out Price is equal to 0, the system will quote the Reference Price of the Merchant SKU as the cost;
However, if the Stock-Out Price and Reference Price are all equal to 0, the cost will be 0

💡Notes for Return Orders

No returns: Merchant SKU Cost = Stock-Out Price × Qty.
With returns: Merchant SKU Cost = Total Stock-Out Price – Cost of Returned SKU (Stock-in Price).
You can go to Inventory > Stock Movement Record to view Stock-Out/In Cost of the order.

4. Profit/Loss

Profit = Store Revenue-Cost of Merchant SKU
Profit Rate = Profit / (Product SKU Sales + Platform Subsidy) x 100%

5. Order Value: the amount actually paid by the buyer for this order

Order Value =Product Sales + Shipping Fee paid by buyer

Product Sales: Product sales after discounts and promotions, where Shopee corresponds to "Product Price" in platform statements and TikTok corresponds to "Subtotal after seller discounts" in platform statements.
Shipping Fee Paid By Buyer: Actual shipping fee paid by buyer (Tokopedia shipping fee paid by buyer is paid to platform directly and is not calculated to the order value, so all are displayed as 0)

6. Platform Subsidy

Subsidy for Discount & Promotion: Support Shopee, Tiktok, and Tokopedia, the subsidy amount to sellers after the discounts and promotions provided to buyer by platform

7. Platform Charges

Commission Fee: commission fee charged by the platform in proportion (commission fee for influencer marketing is not included);
Transaction Fee: transaction fee for platform fund settlement;
Service Charge: only support Shopee, special service fees charged by the platform to sellers;
Shipping Fee Paid By Seller: actual shipping fee paid by seller;
Merketing Fees: only support Lazada, including Free Shipping Max Fee and Sponsored Affiliates;
Refund Value: the fee refunded to the buyer when the order return or refund is completed.
Other Store Fees: Including platform fee adjustments, compensation and all other fees

8. Other Fee ( How to add other fees for store profit analysis?)

You can manually record offline expenses, including advertising, packaging, rent, and other expenses, for easy calculation of complete profits.

Packing Material
Ads
Rent
Others

9. Definition of Time Fields

Order Time: Based on order creation time; matches the platform's "Order Create Time". Manual orders also use this as the order time.

Confirm Time:

Online orders: Prepaid uses payment time; COD uses order creation time.
Offline orders: Manual orders use order time; POS/messenger orders use order creation time.

Release Time:

Non-platform orders: Use shipped time.
Shopee/TikTok: Use settlement time.
Lazada: Use transaction time.

Platform Completion Time in BigSeller:

Shopee/TikTok: When status changes to Completed.
Lazada: When status changes to Delivered / Confirmed / Return or Refund / Lost & Damaged.
Manual orders: When moved to [Shipped > Shipped].

Introduction of Store Profit Report

Field Introduction

Is this content helpful?