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. You may have orders that exist in both systems, and you may have orders that exist in one but not the other.
In the case that an order exists in both platforms, the ERP system is taken as the source of truth for the revenue generated from that order. For orders that exist in one platform only, the source of truth is the platform that the order exists in.
In all cases, we exclude cancelled orders from our calculations.
This article details how to get the gross revenue figure from your Conjura dashboards matching to what you see on the Linnworks UI.
Linnworks Reconciliation
To reconcile your Conjura revenue with your Linnworks instance:
Step 1 – Export from Conjura
In Conjura, go to the Order Table.
Ensure you include the following columns:
Order Key
Order Date
ERP Sales Channel
Order Status
Gross Revenue
Apply the date range you want to reconcile.
Click Export under the table.
Step 2 – Export from Linnworks
In Linnworks, go to the Processed Orders report.
Set the same date period as in Conjura.
Download the report.
Step 3 – Compare the two reports
The Order Key from Conjura should match up with the Order ID from your Linnworks export. This will allow you to do an order-by-order comparison between the two datasets, using the Total column from Linnworks and Gross Revenue from Conjura.
When comparing, watch out for:
Different currencies
Conjura converts all orders into a single reporting currency.
Linnworks exports orders in their original order currency.
To align, apply an average FX rate for the period when converting Linnworks totals.
Non-Linnworks orders in Conjura
If we pull an order from a data source and cannot match it to a Linnworks order, it will flow into Conjura dashboards.
These can be filtered out in Conjura using the ERP Sales Channel column (look for values beginning with
non-ERP).
Open or Cancelled Orders
The Linnworks download will be processed orders only. Additionally some orders may have no processed date - these would be cancelled orders and should be ignored.
In your Conjura download, make sure to exclude any Open orders using the Order Status column.
Step 4 – Explain Differences
Small discrepancies may still occur due to:
FX rate differences: Conjura uses daily/transaction-level FX rates, while your reconciliation may use a period average.
Rounding: penny-level differences can add up across large order volumes.
Legacy Linnworks reports – some reports (e.g. Financial Summary) are no longer supported by Linnworks and may not align with raw processed order data.
If any discrepencies are still present, please contact support@conjura.com.