Shopify Finances Report

The Shopify Finances Report gathers key financial information in one place. You can see a summary of your product sales and payments, as well as your account information including your invoice fees and Shopify Payments payouts.

Financial reports icon

Note

The Finances Report is available to all stores on the Shopify Plus plan. It is also being gradually released to stores on all other plans.

Working with your Finances Report

You can view your Finances Report from your Reports page in the Shopify admin:

  1. From your Shopify admin, click Reports:

    Reports

  2. Click View finances:

    Finances button

  3. From your Finances Report, you can access information about your Sales, Payments, and Pending sales data:

    Finances summary

Did you know?

Net sales, product sales, and gross sales do not include gift cards. Refunds and sales are tied to the date they occurred.

Discrepancies between sales and payments overviews

There are a few reasons why your sales and payments overviews might show different numbers:

  • The Payments report shows information about payments your customers have made, while the Sales report shows you information specific to orders placed. 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.

  • Since reports show data based on a timeframe, it could be the case that an order was placed in a different timeframe than the payment. For example, if your customer placed an order in May and paid for it in June, then the order will appear in the Sales report for May and the payment will show in the Payments report for June.

  • When customers purchase gift cards, the amount they paid for the gift card will show in the Payments overview. At the same time, the gift card amount appears as a Pending Sale. Gift Card sales are treated as Pending Sales instead of Sales because breaking them out as Pending Sales means you have the data to combine or separate Gift Card sales in the way you want in your own bookkeeping.

Filter reports by channel

The drop-down changes the view depending on which channel you choose. By default, you will see the totals for all channels. If you want to see the totals for a specific channel, click All channels and select the one you want to view.

Channels dropdown

Select a date range

All reports show the last 30 days as the default. You can select a specific date range or choose from a preset range. Note that the date ranges for Last x days end on the day before the current day:

Finances overview date range

Sales overview

The Sales overview displays your sales for the selected timeframe based on the day of the sale. Refunds and discounts show as negative numbers on the date of the refund. The Sales overview includes the values you will most likely need when doing your bookkeeping, such as Net sales. You can view the details of an order by clicking the Order name:

Sales overview

Sales overview terms

Dimension/Metric Definition
Gross sales Equates to product price * quantity (before taxes, shipping, discounts, and returns) for a collection of sales.
Discounts Equates to line item discount + order level discount share for a collection of sales.

The total dollar value reduction applied to a sale in the form of discounts on products, collections, or entire orders.

Discounts that are applied to an entire order are proportionally applied to the sales for the order.

All discounts are applied before taxes.
Refunds The value of the tender given back to the customer in exchange for a returned products, excluding any sales tax paid by the customer.
Net sales Equates to gross sales - discounts - returns.
Taxes Equates to product taxes + shipping taxes - returned product taxes.

Taxes levied on product sales and shipping.
Shipping The amount charged to the customer for delivering an order, not including any taxes.
Total sales Equates to Gross Sales - discounts - refunds + taxes + shipping. Learn more

Total sales

The total sales amount equates to Gross Sales - discounts - refunds + taxes + shipping.

The same total sales amount that appears in your Finances report also appears in the overview section of your Shopify Home to show your cash flow at a glance. Since the amount for total sales includes refunds, it might appear as a negative value. For example, if you have more refunds than sales in a day, then the total sales amount for that day will be negative:

Total sales negative

Payments overview

The Payments overview lists your payment methods for the selected timeframe:

Payments overview

Payments terms

Dimension/Metric Definition
Manual Payments you have entered.
Money order Payments received by money order.
Pay in Store Payments captured in your store.
Shopify Payments (or other gateways) Payments received through payment gateways.

Pending sales overview

The Pending sales overview shows you the anticipated total of any Gift cards you have issued:

Pending sales overview

Pending sales terms

Dimension/Metric Definition
Gift cards issued Equates to gift card value issued - gift card value returned.

This value is unrelated to gift card usage by customers.

Export your data

You can export data to a CSV file while viewing your reports.

Report type Sales Payments Taxes
Features See each transaction in a separate row so you can track details specific to each order. Track where and how your store accepts payments. View taxable sales (which line items are being taxed).
Content included when exporting the full report - Sale ID
- Date
- Order name
- Transaction Type
- Sale type
- Sales channel
- POS location
- Product type
- Product vendor
- Product title
- Product variant title
- Product variant SKU
- Net quantity
- Amount (before discount and taxes)
- Order discount
- Amount (after discounts before tax)
- Taxes
- Amount (after discounts and taxes)
- Transaction ID
- Date
- Order name
- Payment method
- Credit card
- Sales channel
- POS location
- Gross payments
- Refunds
- Net payments
- Sale tax ID
- Order ID
- Date
- Transaction type
- Sale type
- Order name
- Product title
- Product variant title
- Product variant SKU
- Product type
- Country
- Region
- Name
- Rate
- Sales channel
- POS location
- Amount

To get a CSV file for the Sales and Payments reports:

  1. From your Shopify admin, click Reports:

    Reports

  2. Click View finances:

    Finances button

  3. Depending upon which data you want to export, click View report for Sales or Payments:

    View report

  4. Click Export:

    Export button

  5. Select Current Page to export the data on the current view of the report, or Full report to export it all:

    Export options

  6. Click Export.

To get a CSV file that contains data from the Taxes report:

  1. Reports
  2. Click View finances:

    Finances button

  3. In the Sales overview, click Taxes:

    Sales overview taxes

  4. Select Current Page to export the data on the current view of the report, or Full report to export it all:

    Export options

  5. Click Export.

Working with your Finances Report

From the Finances screen, you can see summaries for your sales, payments, and pending payouts.

View your Finances screen

To view your Finances screen:

  1. From the Shopify app, tap Store:
    Store button iphone
  2. Tap Finance reports:
    Finance reports button iphone

View your sales, pending sales, or payments report

To see your sales, pending sales, or payments report:

  1. From the Finances screen, swipe down to the Sales, Pending sales, or Payments summary.
  2. Tap View report:
    View report button iphone

Discrepancies between sales and payments overviews

There are a few reasons why your sales and payments overviews might show different numbers:

  • The Payments report shows information about payments your customers have made, while the Sales report shows you information specific to orders placed. 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.

  • Since reports show data based on a timeframe, it could be the case that an order was placed in a different timeframe than the payment. For example, if your customer placed an order in May and paid for it in June, then the order will appear in the Sales report for May and the payment will show in the Payments report for June.

  • When customers purchase gift cards, the amount they paid for the gift card will show in the Payments overview. At the same time, the gift card amount appears as a Pending Sale. Gift Card sales are treated as Pending Sales instead of Sales because breaking them out as Pending Sales means you have the data to combine or separate Gift Card sales in the way you want in your own bookkeeping.

Filter reports by channel

By default, the Finances screen shows the totals for all of your sales channels. If you want to see the totals for a specific channel, then tap All channels, and select the channel that you want to view:

Filter by channel iphone

Select a date range

All reports show the last 30 days as the default. You can choose from a preset date range or enter a specific date range. Note that the date ranges for Last x days do not include the current day.

To select a date range:

  1. From the Finances screen, tap Month to date.
  2. If you want to select a preset, then tap the drop-down menu under Date range, and select the preset that you want to use:
    Date presets iphone
  3. If you want to set your own date range, then use the calendar fields to enter a start date and an end date.

Export a report

To export a report from your Finances screen:

  1. From a Sales, Pending sales, or Payments report screen, tap Export.
  2. Choose whether to export only the current page or the full report, and then tap the relevant option:
    Report export options iphone
  3. Tap Export.

Working with your Finances Report

From the Finances screen, you can see summaries for your sales, payments, and pending payouts.

View your Finances screen

To view your Finances screen:

  1. From the Shopify app, tap Store:
    Store button android
  2. Tap Finance reports:
    Finance reports button android

View your sales, pending sales, or payments report

To see your sales, pending sales, or payments report:

  1. From the Finances screen, swipe down to the Sales, Pending sales, or Payments summary.
  2. Tap View report:
    View report button android

Discrepancies between sales and payments overviews

There are a few reasons why your sales and payments overviews might show different numbers:

  • The Payments report shows information about payments your customers have made, while the Sales report shows you information specific to orders placed. 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.

  • Since reports show data based on a timeframe, it could be the case that an order was placed in a different timeframe than the payment. For example, if your customer placed an order in May and paid for it in June, then the order will appear in the Sales report for May and the payment will show in the Payments report for June.

  • When customers purchase gift cards, the amount they paid for the gift card will show in the Payments overview. At the same time, the gift card amount appears as a Pending Sale. Gift Card sales are treated as Pending Sales instead of Sales because breaking them out as Pending Sales means you have the data to combine or separate Gift Card sales in the way you want in your own bookkeeping.

Filter reports by channel

By default, the Finances screen shows the totals for all of your sales channels. If you want to see the totals for a specific channel, then tap All channels, and select the channel that you want to view:

Filter by channel android

Select a date range

All reports show the last 30 days as the default. You can choose from a preset date range or enter a specific date range. Note that the date ranges for Last x days do not include the current day.

To select a date range:

  1. From the Finances screen, tap Month to date.
  2. If you want to select a preset, then tap the drop-down menu under Date range, and select the preset that you want to use.
  3. If you want to set your own date range, then use the calendar fields to enter a start date and an end date.

Export a report

To export a report from your Finances screen:

  1. From a Sales, Pending sales, or Payments report screen, tap Export.
  2. Choose whether to export only the current page or the full report, and then tap the relevant option:
    Report export options android
  3. Tap Export.

Want to discuss this page?

Visit the Shopify Community

Ready to start selling online with Shopify?

Try it free