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, Jennie buys a sweater for 200 USD on January 1, 2023. On January 2, she requests a 50 USD refund because the style doesn't suit her, and the refund is approved and sent back to her. Here's what the report shows:

• January 1, 2023: Paid amount is 200 USD, and net payments are 200 USD.
• January 2, 2023: Paid amount is 0 USD, and net payments are −50 USD.
• January 1–2, 2023: Paid amount is 200 USD, and net payments are 150 USD.

Total Order Amount and Sales

In most cases, you can reconcile sales from the total order amount with this formula:

Sales = Total order amount + Rounding adjustment amount + Duty − Refund amount

However, this formula doesn't work for orders that were refunded and then canceled. When an order is canceled, the system updates its total order amount and sales to 0, but any refund issued before the cancellation stays in the refund amount and isn't reset to 0.

Example: A customer orders 100 USD worth of products. You refund 30 USD, and the order is canceled later. For a time range that covers these dates, the figures for this order in the financial report are updated as follows:

After the cancellation, calculating total order amount − refund amount gives −30 USD, which doesn't match the 0 USD in sales shown in the report. If your time range includes orders that were refunded and then canceled, rely on the sales figure in the report.

Common Metrics

The following table lists definitions for common metrics in a financial report:

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:

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:

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: