Finance reports
You can view key financial information about your business in the finance reports.
On theReportspage, you can filter byCategories>Financesto display a list of financial reports. To access a summary and find more detailed financial reports, click theSummaryreport.
When you open a finance report, the data is up-to-date, give or take about 1 minute. You can reopen or refresh the report to show newer data.
Bills and fees
If you're looking for information about your Shopify account bills and fees, then you can view your account history in theBillssection of theBillingpage in your Shopify admin.
Finances category filter of the Reports page
You can access a list of finances reports on theReportspage by filtering byCategory>Finances. In the list of reports, you can access theSummaryreport page, and other key reports.
TheTotal salesreport shows the number of orders for the time period and organizes the orders into transactions such as sales, returns, and shipping amounts.
ThePaymentsreport shows the number of monetary transactions across all payment providers (Shopify Payments, manual payments, gift cards, and so on), including both payments and refunds. The detailed Payments finance report groups the transactions by payment provider.
Finances summary page
TheFinancessummary page shows an overview of yoursales,payments,liabilities, andgross profitdata for the selected time frame. Each section has links to related reports.
View the Finances summary page
Steps:
- From your Shopify admin, go toAnalytics>Reports.
- ClickCategories.
- SelectFinancesto filter the reports to show only finances reports.
- In theNamecolumn, click theSummaryreport.
- Optional: Select a channel and choose a date range.
If you remove a channel, then it won't appear in the channel list. However, you can still view historical data for the removed channel by selectingAll channels.
Sales overview
TheSalessection shows an overview of your sales finance reports. It also has links to each of the other sales finance reports:
- Gross salesreport
- Discountsreport
- Returnsreport
- Net salesreport
- Shippingreport
- Taxesreport
Each of these other sales finance reports focuses on a specific metric from theSalesreport.
Payments overview
ThePaymentssection shows an overview of your payments finance reports. It also has a link to a separate payments report for each payment method that your customers have used.
Liabilities overview
TheLiabilitiessection shows an overview of your gift card sales and tips for the selected date range.
In this section,Gift card salesshows the total sales of gift cards, which is the face value of sold gift cards minus any discounts that were applied at the time of the sale.
Gift cards outstanding balanceshows the total outstanding balance of gift cards that were sold or issued.
Tipsshows the total value of tips received.
Gross Profit overview
TheGross Profitsection shows an overview of your net sales, costs, and profit. In this section,Net sales without cost recordedshows net sales where cost wasn't recorded at the time of the sale.Net sales with cost recordedshows net sales where cost was recorded at the time of the sale. Together these add up to your totalNet salesfor the selected date range.
OnlyNet sales with cost recordedare included in yourCost of goods soldreport, and count toward yourGross profit.
Sales finance report
TheSalesfinance report includes the values that you'll most likely need when doing your bookkeeping, such as net sales. The report shows each sale and return that your store made during the selected timeframe, organized by date.
If an order contains multiple products, then each product shows in the report as a separate sale or return, as do shipping charges. You can view the details of an order by clicking its order number.
For each sale or return, the finance report shows:
| Definition | |
|---|---|
| Date | The date of the sale or return. |
| Order | The order that the sale or return is associated with. |
| Product | The product that the sale or return is associated with. |
| Gross sales | Equates toproduct selling price x ordered quantity. Gross sales does not include discounts, returns, taxes, or shipping. |
| Discounts | Equates toproduct discount + the product's proportional share of a cart-wide discount. TheDiscountsvalue combines any line-item discounts with the product's share of a cart-wide discount. Discounts appear as a negative value on the date that the order was placed. |
| Returns | The value of goods that the customer returned to the merchant. Returns appear as a negative number on the date that the return occurred. Refunded shipping charges and their taxes do not appear in theReturncolumn. They appear as negative values in theShippingandTaxescolumns. |
| Net sales | Equates togross sales - discounts - returns. Net salesdoes not include shipping charges or taxes. It will be a positive number for a sale on the date that an order was placed, and a negative number for a return on the date that an order was refunded. |
| Taxes | The taxes associated with a sale or return. It will be a positive number for a sale on the date that an order was placed, and a negative number for a return on the date that an order was refunded. |
| Shipping | The shipping charges associated with a sale or return. It will be a positive number for a sale on the date that an order was placed, and a negative number for a return on the date that an order was refunded. |
| Total sales | Equates togross sales - discounts - returns + taxes + shipping charges. Total saleswill be a positive number for a sale on the date that an order was placed, and a negative number for a return on the date that an order was refunded. |
Discounts finance report
This report includes the discounts that customers received by using discount codes during checkout. The report also includes discounts that you applied during checkout in Shopify POS.
The report includes the following information:
| Definition | |
|---|---|
| Line-item discounts | Discounts that were applied to a single product in an order. |
| Order-level discounts | Discounts that were applied to an order as a whole. |
Discounts aren’t related toCompare at prices.
Taxes finance report
TheTaxesreport shows the sales taxes that were applied to your sales in the selected timeframe.
Each row of the report shows a tax type (such as a state tax or a county tax), its rate, and the total amount of tax that was charged in the selected timeframe.
The report determines the country and region based on the destination of sales, so it might show destination information even for origin-based sales tax jurisdictions. To determine the destination, the shipping address is used. If the shipping address cannot be determined, then the billing address is used. If the billing address cannot be determined, then the POS address is used.
| Definition | |
|---|---|
| Channel | The marketplace channel in which sales occurred, if any. |
| Country | The country of the tax rate. For origin-based tax jurisdictions, such as California, the destination is currently shown instead of the country to which the tax applies. |
| Region | The state or province of the tax rate. For origin-based tax jurisdictions, such as California, the destination is currently shown instead of the region to which the tax applies. |
| Name | The tax rate name. |
| Rate | The tax rate as a percentage. |
| Filed by channel | Which taxes have been filed on your behalf by a marketplace channel. There are three possible values for this column:
|
| Amount | The sales taxes that were applied during the selected timeframe. For example, if you had $100 in sales to which a particular 7% sales tax applied, then the amount will show $7.00. |
Payments finance report
ThePaymentsfinance report shows your store's payment transactions for the selected timeframe.
Your customers' payments are grouped by transactions with the following in common:
| Definition | |
|---|---|
| Payment method | The payment method that the customers used. If you mark an order as paid and selectOtheras the payment method, then the report will show the payment method asManual. |
| Accelerated checkout | The accelerated checkout the customers used, if applicable, such asShop PayorApple Pay. |
| Credit card | Type of credit card that the customers used, if applicable. |
| Sales channel | The name of the channel or app that the customer used to place their order, such as欧宝体育官网入口首页orBuy Button. For sales that originated as draft orders, the report showsDraft Orders. If an app that has no name was used, then the report showsOther. |
For each group of transactions, the report shows:
| Definition | |
|---|---|
| Transactions | The number of payment transactions. |
| Gross payments | The amount paid by the transactions before refunds. |
| Refunds | The total amount refunded across the transactions. |
| Net payments | Equates tototal amount paid - the total amount refunded. |
You also have a payments report for each payment method that your customers have used. You canaccess those payment reportsfrom thePaymentssection of the finances summary.
Canceled payments
If a payment has been authorized but is canceled before the payment can be captured, then a positive amount and a corresponding negative amount will appear in the sales reports. The positive amount appears because an order was placed. A refund is shown to balance the reports. However, nothing will appear in the payments finance reports because you didn't receive a payment.
Liabilities finance report
TheLiabilitiesfinance report shows the sales of gift card products and tips for the selected channels and date range.
Liabilities often require special treatment in accounting.
Gift card sales report
TheGift card salesreport shows the following information:
| Definition | |
|---|---|
| Date | The date when the gift card was sold. |
| Order | The order number of the sale. |
| 客户 | Name of the customer. |
| Gift card value | The value of the gift card. |
| Discounts | Discount applied to the sale of the gift card. |
| Total sales | Gift card value − discounts. |
TheGift cards outstanding balancereport shows the daily balance of all gift card transactions, including the following information:
| Definition | |
|---|---|
| Date | The date. |
| Opening balance | The starting balance of gift cards at the start of the day. |
| Issued value | The value of gift cards issued on the day. |
| Sold value | The value of gift cards sold on the day. |
| Disabled value | The value of gift cards that were disabled on the day. |
| Redeemed value | The amount of gift card redemptions during the day. |
| Refunded value | The amount of payments that were originally paid by gift card and were then refunded during the day. This includes the amounts from gift card refunds due to failed transactions. |
| Adjustment value | Available to: Shopify Plus The value of manual adjustments made to gift cards during the day. |
| Closing balance | The closing balance of all issued and sold gift cards at the end of the day. |
| Net change | The difference between the opening balance and the closing balance. |
Gift card amounts in the reports
Gift cards appear in a few places in your reports. There are specific conditions that affect where they get recorded.
When you issue a gift card from your Shopify admin:
- It isn't included as a sale in any report, nor in the total sales number in theHomesidebar.
When you sell a gift card:
- It isn't included in any sales reports, nor the total sales number in theHomesidebar.
- It is included in theGift Cardsfinance report.
- The amount paid for the gift card is included in thePaymentsfinance report under the payment method that the customer used, such asVisaorCash.
当顾客使用礼品卡purchase something from your store:
- It is included in sales reports. The full value of the item is claimed as sales. For example, a $20 t-shirt with $5 of that purchase paid for by a gift card will show up as $20 in sales.
- The amount paid by or refunded to a gift card is included in thePaymentsfinance report as a gift card entry.
- The amount paid by gift card is subtracted from the gift card balance, which is shown in theLiabilitiesfinance report.
When a gift card expires:
- Any remaining outstanding balance on the gift card will continue to count toward your outstanding gift card balance, which is shown in theLiabilitiesfinance report.
When you disable a gift card:
- Any remaining outstanding balance on the gift card is returned to zero and is removed from the outstanding gift card balance in yourLiabilitiesfinance report. This adjustment applies from the date the card is disabled, and doesn't affect historical data.
- It can take up to 24 hours for disabled values to appear in yourGift cards outstanding balancereport.
Tips report
TheTipsreport shows the value of tips earned by staff and the online store sales channel during the time period.
| Column | Definition |
|---|---|
| Sales channel | The channel the customer used to tip. This will either be **Point of Sale** for tips paid in store, or **Online Store** for tips collected online. |
| Staff name | The name of the staff who processed the tip. Tips made through your online store will display as N/A. |
| Tips | The amount of the tip. |
Understanding total sales
Thetotal salesvalue equates togross sales - discounts - returns + taxes + shipping.
The sametotal salesamount that appears in your finance reports also appears in the overview section of yourShopify Home给你的现金流。自从amount for total sales includes returns, it might appear as a negative value. For example, if you have more returns than sales in a day, then the total sales amount for that day will be negative.
Discrepancies between the Sales and Payments finance reports
There are a few reasons why yourSalesandPaymentsfinance reports might show different numbers:
TheSalesfinance report shows you information specific to orders placed, while thePaymentsfinance report shows information about payments that your customers have made. There could be differences between the values displayed on each report, for example if customers have placed orders but payment has not yet been captured.
因为报告显示数据基于时间表,could be that an order was placed in a different timeframe than the payment was made. For example, if your customer placed an order in May and paid for it in June, then the order will appear in theSalesfinance report for May, and the payment will show in thePaymentsfinance report for June.
When customers purchase gift cards, the amount that they paid for the gift card will show in thePaymentsfinance report. At the same time, the gift card amount appears in thePending salefinance report. Gift card sales are treated as pending sales instead of normal sales because it means that you have the data to combine or separate gift card sales in the way that you want in your own bookkeeping.