Contact and Order Research
      Back to home
      1. Wicked Help Center
      2. 3. REPORTS
      3. Contact and Order Research

      How are Gross and Net Revenue Calculated

      Revenue reporting in Wicked Reports is based on the combined value of order records within the platform.

      Order records can be created in several ways, including:

      Using the HTTP Post or CSV upload method of sending order details into Wicked Reports, you are able to specify whether the order is a refund or not.

      When orders are pulled in from your order sources or shopping cart via one of our native integrations or a custom API you've developed the Order Status is provided by the source system.

      Gross Revenue is the sum of the value of all individual orders, regardless of status.

      Net Revenue is the sum of the value of individual orders after the following Order Statuses have been filtered out:

      • Refunded
      • Partially Refunded (the refunded amount is not included in Net Revenue)
      • Voided
      • Declined
      • Failed
      • Chargeback
      • Chargebacks
      • Error
      • Written

      NOTE: If you are using our Infusionsoft native integration, you can read here to learn about the impact of the Use Infusionsoft Payment records for revenue reporting setting.

      FAQ:

      1. How does Wicked Reports report the breakdown of Gross & Net for Shopify Sales compared to Shopify? 
        Shopify's Dashboard Formula:

        1. Gross Revenue = Product Price x Quantity Sold (excluding taxes, discounts, returns, etc...)

        2. Net Revenue = Gross Revenue - Discounts - Returns/Refund

        Wicked's Dashboard Formula for Shopify
        1. Gross Revenue = Shopify's Gross Revenue + shipping + tax 
        2. Net Revenue  = Shopify's Gross Revenue - refunds - discounts + shipping + tax
        Example Order from Shopify:
        1. Shopify's gross revenue figure is $83.96
        2. Wicked's gross revenue figure is $83.96 + $6.24 = $90.2