Financial Report provides key information about your business, including the total order amount, sales, refund amount, and paid amount. You can view the most recent data after opening the report in 1 to 2 minutes, or by reopening or refreshing the report. The Finances: Summary page displays a data overview of sales, payments, liabilities, and gross profit within the selected time range.
In This Article
Sales and Paid Amount
Your sales and paid amount may vary due to the following reasons:
- Sales present information specific to orders created, while the paid amount reflects details about payments made by customers. Values shown on each report may differ. For example, if a customer has placed an order but the payment has not yet marked the order as paid.
- As reports display data based on a time range, the time range for placing an order may differ from that of the payment. For example, if a customer places an order in May but pays in June, the order appears in the May sales section of the financial report, while the payment is reflected in the June payments section of the financial report.
- When customers purchase gift cards, the amount they pay for the gift cards is included in the paid amount section of the financial report. Gift card sales are recorded separately in the product sales report as gift card sales rather than regular product sales, which means you can flexibly combine or separate gift card sales in your accounting as required.
Paid Amount and Net Payments
The paid amount records the positive payment made for an order, and when a refund occurs, it is not deducted from the paid amount. However, the net payments reflect the corresponding deduction in the case of a refund.
For example, if Jennie purchases a sweater for 200 USD on January 1, 2023, and on January 2, 2023, she applies for a 50 USD refund due to style issues. The system approves Jennie's request, and the amount is successfully refunded to her. In the financial report, both the paid amount and net payment on January 1, 2023, are recorded as 200 USD. However, on January 2, 2023, the paid amount is 0 USD, and the net payment is -50 USD. Therefore, when reviewing the report from January 1, 2023, to January 2, 2023, you can observe a paid amount of 200 USD and a net payment of 150 USD.
Common Metrics
The following table lists definitions for common metrics in a financial report:
| Metric | Definition |
| Sales | |
| Subtotal | Subtotal = Selling price × Quantity of items. |
| Discounted Amount | Amount deducted after applying a coupon code entered by the customer or any manual discounts created by you. |
| Commodity Tax | Tax calculated based on the order. If you select All prices include tax in the tax settings, the commodity tax is zero as tax is already included in the Subtotal. |
| Shipping | Logistics fees calculated based on the order. |
| Shipping Tax | Tax associated with shipping calculated based on the order. |
| Tip | Tips calculated based on the order. |
| Points Deduction | Amount deducted from the total payment when members use points discount for payment. |
| Total Order Amount | Total order amount = Subtotal - Discounted amount + Commodity tax + Shipping + Shipping tax + Tip - Points deduction. |
| Refund Amount | Amount refunded in the event of order cancellation. |
| Rounding Adjustment Amount | Amount adjusted after performing mathematical operations such as rounding up, rounding down, or rounding to the nearest integer on the original amount. |
| Duty | Duties imposed on products when they are sold to certain countries/regions. |
| Sales |
The difference between positive and negative amounts of an order recorded based on the time of order changes. It appears as a positive amount on the day of order placement and a negative amount on the day of order return. Sales = Subtotal - Discounted amount + Shipping + Commodity tax + Tip + Shipping tax - Points deduction + Rounding adjustment amount + Duty - Refund amount. Specifically, when an order undergoes multiple edits after creation (e.g., returns, refunds due to reduced items), resulting in changes in the positive and negative value of the order, Sales = Increased amount - Returned amount. |
| Payments | |
| Paid Amount | Amount already paid or partially paid for the order. |
| Refund Amount | Amount refunded in the event of order cancellation. |
| Net Payments | Net payments = Paid amount - Refund amount. |
| Profit Margin | |
| Net Sales | Net sales = Subtotal - Discounted amount - Points deduction + Rounding adjustment amount - Refund amount. |
| Distribution Costs | Distribution costs = Product cost price × Quantity of items. |
| Gross Profit | Gross profit = Net sales - Distribution costs. |
| Debt | |
| Gift Card Sales | Sales for gift card products. |
| Gift Card Balance | Balance of gift cards at the end of the period. |
Viewing the Financial Report
The following section briefly introduces the financial report:
- Summary
- Sales
- Payments
- Viewing Payments by Payment Brand Name
- Commodity Tax
- Gift Card Sales
- Gift Card Balance
Summary
It displays sales details, payments, profit margin, and debt for the selected time range and specific sales channels. You can click the metric to go to the details page and export the summary document in PDF format to archive financial data for a specific time.
Sales
It displays daily sales for each order and product within the specified sales channel and time range. You can click the metric for details.
Payments
It displays customer payment, refund amount, and net payments for different payment channels and methods within the selected sales channel and time range. Note that the paid amount for gift cards is not actual revenue, and you do not receive payment for such transactions, nor does it generate billing commissions.
Viewing Payments by Payment Brand Name
It displays paid and refunded amounts for different payment brand names within the selected time range. If there are no corresponding brand names for a payment method, it is shown as N/A.
Commodity Tax
It displays taxes, tax rates, and commodity taxes for various countries/regions within the selected time range and sales channel.
Each row in this report represents a tax type (e.g., state tax or county tax), the corresponding tax rate, and the commodity taxes paid within the selected time range.
The commodity tax report tracks data from October 2022 (UTC+8) and applies the following dimensions:
| Metric | Description |
| Sales Channel | It displays the name of the channel or app customers use to place orders, such as online stores, Message Center, LIVE, and post. |
| Country/Region | The country or region where the order's shipping address is located. |
| Province/State | The province or state where the order's shipping address is located. |
| Tax Name | The name of the commodity tax rate. |
| Tax Rate | The percentage of the commodity tax rate. |
| Commodity Tax | The commodity tax paid in the order. |
Gift Card Sales
It displays cumulative gift card sales, gift card quantity, gift card discount amount, and gift card net sales by order and customer for the specified sales channel within the selected time range. This report uses the following metrics:
| Metric | Definition |
| Gift Card Sales | Sales for gift card products. |
| Gift Card Quantity | Number of gift card products sold. |
| Gift Card Discount Amount | Discounted sales for gift card products. |
| Gift Card Net Sales | Gift card net sales = Subtotal of gift card products - Discounted amount - Points deduction + Rounding adjustment amount. |
Gift Card Balance
It displays information on the face value of gift cards and usage by date within the selected time range. This report uses the following metrics:
| Metric | Definition |
| Opening Balance | The balance of gift cards at the start of the specified time. |
| Distributed Face Values | Face values of the manually issued created gift cards. |
| Face Values for Sale | Face values of created gift cards purchased by customers. |
| Disabled Amount | The value of disabled gift cards. |
| Payment Amount | The payment amount using gift cards as the payment method. |
| Refund Amount | The refund amount using gift cards as the refund method. |
| Adjustment Amount | Value manually adjusted for gift cards. |
| Gift Card Balance | The balance of gift cards at the end of the specified time. |
| Gift Card Net Balance |
Gift card net balance = Gift card balance - Opening balance.
|
Comments