Gross Revenue Definition
At Conjura, we define Gross Revenue as the total value of your orders, i.e. the money your customers actually parted with.
This accounts for any discounts the customer received, but does not account for refunds.
Formula: Product Revenue Including Tax + Shipping Revenue Including Tax
Your revenue is calculated from the orders present in your connected ERP and eCommerce systems.
This article details how to get the gross revenue figure from your Conjura dashboards matching to what you see on the Shopify UI.
Shopify Reconciliation
To reconcile your Conjura Revenue with a Shopify store, go to:
<yourstorename>.myshopify.com/admin/reports/sales_over_time
Select the same date range that you've selected in Conjura, and make sure to filter out cancelled orders.
It should look something like this:
(Click on the above image to enlarge it)
Then use the following formula to match the Shopify figures to Conjura:
(1 + Tax Rate) x (Shopify Gross Sales + Shopify Discounts + Shopify Shipping)
Notes:
The tax rate should be represented as a decimal. For example, if tax is 20%, 1 + tax rate = 1 + 0.2 = 1.2
Shopify displays discounts as a negative number. Make sure to keep the negative sign when using the above formula; think of this as deducting discounts from the initial gross sales.
You may see a small discrepancy between Conjura and Shopify if you have made manual edits to historic orders.
We also allocate refunds to orders on their order date rather than the refund date as Shopify does. This means you can assess whether a marketing campaign or product ad has performed accurately rather than the refunds being misrepresented in a later month's performance.