Finances Reports
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.
Sales and Paid Amount
Your sales and paid amount may show different figures for the following reasons:
- Different recording logic: Sales reflects information from orders that have been created, while the paid amount in financial reports represents payments that customers have actually completed. As a result, the figures in these reports may differ—for example, when an order has been placed but payment has not yet been completed.
- Different reporting periods: Financial reports are calculated based on selected time ranges, and the order date and payment date may not fall within the same period. For example, if a customer places an order in May but completes the payment in June, the order will appear in the May sales report, while the corresponding payment will appear in the June paid amount report.
- Gift card transactions: When a customer purchases a gift card, the paid amount is recorded in the paid amount financial report. However, in sales–related reports, gift card amounts are recorded separately as gift card sales rather than regular product sales, allowing you to combine or separate them as needed for accounting purposes.
-
Migrated orders: If orders from the original channel do not include payment-related fields such as Paid amount or Payment date, the system cannot retrieve the corresponding information. In this case, the paid amount is calculated based on the migration date rather than the actual payment completion date, which may result in discrepancies between sales and paid amount in financial reports.
Note: If payment information was correct in the original channel but appears incorrect after migration, please contact SHOPLINE Support for assistance.
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. |