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:
- One of our native order integrations
- HTTP Post for Orders
- CSV Upload for Orders
- Custom API Integration
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:
- How does Wicked Reports report the breakdown of Gross & Net for Shopify Sales compared to Shopify?
Shopify's Dashboard Formula:-
Gross Revenue = Product Price x Quantity Sold (excluding taxes, discounts, returns, etc...)
-
Net Revenue = Gross Revenue - Discounts - Returns/Refund
- Gross Revenue = Shopify's Gross Revenue + shipping + tax
- Net Revenue = Shopify's Gross Revenue - refunds - discounts + shipping + tax
- Shopify's gross revenue figure is $83.96
- Wicked's gross revenue figure is $83.96 + $6.24 = $90.2
-