---
schema_version: "1"
id: a0253f54b5cc603ea1d67045f911815e38a5c0252baa7ee5051b313723218db1
title: Create and Download a GMV Report
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_running_a_gmv_report.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_running_a_gmv_report.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 0aee78fb5b0ce896528d31bbdc196339d49e4f18faae65012de8ef0b75561537
description: "Create a Gross Merchandise Value (GMV) report for B2C Commerce in Business Manager. Select from four report types: Order Journal, GMV Report per Month, GMV Report per Day, and GMV per Order. B2C Commerce also automatically generates daily and monthly GMV reports on production instances. You can download a report you create or an auto-generated report to a comma-separated values (CSV) file that you can import into a spreadsheet."
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# Create and Download a GMV Report

Create a Gross Merchandise Value (GMV) report for B2C Commerce in Business Manager. Select from four report types: Order Journal, GMV Report per Month, GMV Report per Day, and GMV per Order. B2C Commerce also automatically generates daily and monthly GMV reports on production instances. You can download a report you create or an auto-generated report to a comma-separated values (CSV) file that you can import into a spreadsheet.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_note.png)

Note GMV reports are available for all instance types, but they're intended for production instances to reflect real revenue. B2C Commerce auto-generates reports for GMV data on production instances only. The auto-generated report job is disabled on Development and Sandbox instances.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_note.png)

Note See [Taxation (Net and Gross) Impact on Subscription Fees](https://help.salesforce.com/s/articleView?id=cc.b2c_taxation_impacton_subscription_fees.htm&release=264.0.0&type=5 "For proper calculation of GMV and resulting B2C Commerce subscription fees, it's critical that all orders have proper tax handling.") to understand how tax calculations can significantly impact the subscription fees that you pay.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/images/icon_note.png)

Note Set the brand and geographical location for the site so that they appear in GMV reports. See [Site Brand and Billing Entity in B2C Commerce](https://help.salesforce.com/s/articleView?id=cc.b2c_site_brand_and_billing_entity.htm&release=264.0.0&type=5 "Use Business Manager to set the site brand and billing entity, so you can analyze GMV reports.").

1. Click App Launcher ![App Launcher](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/cc/b2c_merchandiser_administrator/images/appLauncher.png), and then select **Administration** | **Operations** | **GMV Reports**.
    
    Report status appears in the Status section. Click **Refresh** to refresh your view as reports run.
2. To create a custom report, on the GMV Reports page click **Create**.
    1. Enter the report start date or select it with the calendar widget.
    2. Enter the report end date or select it with the calendar widget.
    3. Select the report type.
        
         
        | Report Type | Description |
        | --- | --- |
        | Order Journal | One row per line item in the order. |
        | GMV Report per Month | One row for each site, month, order source, action, and item type included within the specified time range. B2C Commerce automatically generates this report on the first day of each month. |
        | GMV Report per Day | One row for each unique combination of site, day, order source, action, and item type within the specified time range. B2C Commerce automatically generates this report on the first day of each month. |
        | GMV per Order | One row for each unique combination of site, date, order source, action, order, and item type within the specified time range. |
    4. Select the report scope, for example, _All Sites_ or one or more selected sites.
    5. Click **Export**.
3. Download a report.
    1. Click **Download** in the Custom Reports section for reports you created, or in the Auto-Generated Reports section for the reports that B2C Commerce generates on production instances.
    2. Select the report to download.
    3. To compress the report file before you download it, click **Compress**.
    4. Click the report name to start the download.
4. Import a downloaded report into Microsoft Excel or another spreadsheet.
    
    These instructions can differ depending on the spreadsheet software that you use.
    
    1. Open the spreadsheet software.
    2. Click the **Data** tab.
    3. Click the **From Text** button.
    4. Find the downloaded file and click **Import**.
    5. On the Text Import Wizard - Step 1 of 3, keep these settings: Delimited, Start import at Row: 1, File origin: MS-DOS (PC-8).
    6. Click **Next**.
    7. On the Text Import Wizard - Step 2 of 3, select Comma as the delimiter and deselect tab.
    8. On the Text Import Wizard - Step 3 of 3, click **Finish** with no setting changes.
    9. Save the data in an existing or new worksheet.