> ## Documentation Index
> Fetch the complete documentation index at: https://docs-nce.global-e.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Order Level – Reconciliation Data

The **Order Level - Reconciliation Data** report provides a self-service, embedded reporting experience using the same data available in the Settlement Report, but for extended time periods.

The self-service report enables merchants to easily access, filter, download, and subscribe to key financial reports directly within the Admin portal.

To receive access to Order Level - Reconciliation Data report, you should be granted with **Merchant Report User**, with specific access to **Finance**, by your **Merchant Report Admin**.

For more information regarding the Admin roles, see [Global-e Roles and Features](/global-e-roles-and-features).

## Key Features

* **Full breakdown of all transaction types**, such as orders, refunds, adjustments, and returns. A dictionary tab was added for your convenience.
* **Order-level** view for all merchants (including those receiving parcel-based Settlement CSVs). Order amount reflects reconciled parcels within the selected period.
* **Data retention**: Data retained for the last 15 months.
* **Custom periods**: Report (Reconciliation cycle)/Reconciliation Date/ Fulfillment date/ Order creation date
* **Reconciliation currency selection**: For merchants receiving separate reports per currency, data is presented using the same currency structure as the merchant’s weekly reconciliation reports, ensuring consistency and alignment between BI and Finance. Amounts are not converted between currencies.
* **Excluded B2B VAT**
* 100% margin coverage by **Virtual Coefficient Rate**.
* Financial grouping (different brands reconciled together) will be **split by brand**.
* Can be **Downloaded** to Excel and **Subscribe** to PDF or PPT.

## Report Filters

The following table outlines the available report filters and their descriptions.

| No. | Filter name | Description |
| - | - | - |
| 1 | **Report Currency** | This selection shows only orders reconciled in the chosen currency. Amounts are not converted between currencies. |
| 2 | **Report (Date)** | The Reconciliation cycle period |
| 3 | **Reconciliation Date** | Eligible for reconciliation Date |
| 4 | **Fulfillment Date** | Received in Hub Date |
| 5 | **Order Date** | Order creation date |
| 6 | **Destination Country** | The country to which the order was shipped |
| 7 | **Hub Country** | Supports multi-hub merchants receiving separate reports per hub; users can view multiple hubs as long as they share the same reconciliation currency |
| 8 | **GE Reference** | Global-e Order ID |
| 9 | **Order Number** | Merchant order ID, taken from the merchant's platform |
| 10 | **Transaction Type** | Order, Refund, Return, Adjustment, UIC/Non-Doc |

## Reports Available Fields

The following table provides the field-by-field dictionary of report, outlining each column’s name, description, calculation (if applicable), example, and its reconciliation report mapping reference. The mapping reference column indicates how terms in this report correspond with terminology used in other Global-e financial reports.

| No. | Field Name | Description | Formula | Example | Mapping Reference |
| - | - | - | - | - | - |
| 1 | **Report (Date)** | The Reconciliation cycle period | | 10/27/2025-11/03/2025 | |
| 2 | **GE Reference** | Global-e Order ID | | GE9248739996GB | GE Order# |
| 3 | **Order Number** | Merchant order ID, taken from the merchant's platform | | 3579632 | Merchant Order# |
| 4 | **Order Date** | Order creation date | | 10/15/2025 | Date Created |
| 5 | **Fulfillment Date (Received in Hub)** | If you are shipping through Global-e's hub, this will be the day the order is physically received at the hub. If shipping directly to the shopper, this will be the same as the dispatch date. Applies only to Order Transaction Type | | 10/30/2025 | Date Received in Hub |
| 6 | **Destination Country** | The country that the order was shipped to | | Germany | Destination Country |
| 7 | **Transaction Type** | May include the following values:<br />Order<br />Refund<br />Adjustment (financial transaction between GE and merchant)<br />Refund (inbound shipping costs)<br />UIC/Non Doc (shipping costs that are not associated to a specific order) | | Order | |
| 8 | **Hub Country** | Supports multi-hub merchants receiving separate reports per hub; users can view multiple hubs if they share the same reconciliation currency | | | |
| 9 | **Total Sales/Refunds (excluding B2B VAT)** | Product price for outbound sale / refund transaction | | 67.79 | Amount to Invoice |
| 10 | **Estimated Additional Margin from International Pricing (included in the Product Price)** | Dynamic Pricing- Margin built into the product price usually to cover the estimated average duties and taxes and/or shipping costs per destination country/product category.<br />Fixed Pricing- For orders that include countries or products set as Fixed Price, the estimated margin amount is calculated based on a virtual coefficient rate defined per country. | | 12.41 | |
| 11 | **Total Costs (excluding B2B VAT)** | Total amount of all the applicable costs that are related to the order such as: Shipping charges to merchant for outbound/inbound transactions, Handling fee, Duties and Taxes Charges to Merchant (if applicable and according to the merchant's setup) | Shipping Charges to Merchant excl. VAT + Returns Shipping Charges to Merchant excl. VAT + Handling Fee excl. VAT + Duties and Taxes Charges to Merchant | -11.02 | Shipping Subsidies + Taxes Subsidization + Handling Fee + Returns |
| 12 | **Total Fees (excluding B2B VAT)** | Total amount of all the fees that are related to the order such as: Service fee, Reconciliation fee and Service Fee adjustments | Service Fee excl. VAT + Reconciliation Fee excl. VAT + Service Fee Adjustments excl. VAT | -3.69 | Service Fee + Reconciliation Fee + Service Fee Adjustments |
| 13 | **Total Payment (excluding VAT)** | Net amount paid to the merchant after deducting costs and fees | Net Sales less Refunds excl. B2C VAT + Amount Paid in Gift Cards excl. VAT + Service Fee excl. VAT + Reconciliation Fee excl. VAT + Service Fee Adjustments excl. VAT + Shipping Charges to Merchant excl. VAT + Returns Shipping Charges to Merchant excl. VAT + Handling Fee excl. VAT + Duties and Taxes Charges to Merchant | 53.08 | Amount to Invoice - Services and Fees |
| 14 | **Total Order Value (Service Fee Base)** | Total amount paid by the shopper for products, shipping, duties and taxes | Shipping Paid by Customer incl. B2C VAT + Total Duties and Taxes Paid by Customer + Customer Product Price incl. B2C VAT | 73.72 | |
| 15 | **Shipping Paid By Customer incl. B2C VAT** | The shipping cost paid by the shopper including B2C VAT | | 5.93 | |
| 16 | **Total Duties and Taxes Paid By Customer** | The Duties and Taxes paid by the shopper | | 0 | |
| 17 | **Customer Product Price incl. B2C VAT** | The products price paid by the shopper including B2C VAT | | 67.79 | |
| 18 | **Net Sales less Refunds (excluding B2C VAT)** | The value will be reflected according to the transaction type:<br />**Order** - Item Price net of discounts.<br />**Refund** - Refund amount to the shopper.<br />**Adjustment** - The amount charged/ credited to the merchant. | | | |
| 19 | **Amount Paid In Gift Cards (excluding VAT)** | The amount paid by the shopper via gift card | | 0 | Amount Paid In Gift Cards |
| 20 | **Service Fee (excluding VAT)** | Global-e service/platform fee | | -3.69 | Service Fee |
| 21 | **Reconciliation Fee (excluding VAT)** | Global-e reconciliation fee | | 0 | Reconciliation Fee |
| 22 | **Service Fee Adjustments (excluding VAT)** | Credit adjustments applied to service fees previously charged if applicable | | 0 | Service Fee Adjustments |
| 23 | **Shipping Charges to Merchant (excluding VAT)** | The difference between the total shipping costs and the shipping amount paid by the shopper | | 1.04 | Shipping Subsidies |
| 24 | **Returns Shipping Charges to Merchant (excluding VAT)** | The difference between the return shipping costs and the return shipping amount paid by the shopper | | 0 | Returns |
| 25 | **Handling Fee (excluding VAT)** | These are the cross-dock fees for each order which is processed through Global-e's hub | | 0 | Handling Fee |
| 26 | **Duties and Taxes Charges to Merchant** | The difference between the Duties and taxes costs related to the order (built into the product price), and the Duties and Taxes amount paid by the shopper | | -12.06 | Taxes Subsidization |
| 27 | **Reconciliation Date** | The date the order was included in the reconciliation report | | 10/30/2025 | |
| 28 | **Reconciliation Week** | The week in which the order was included in the reconciliation report | | W44 | |
| 29 | **Reconciliation Month** | The month in which the order was included in the reconciliation report | | Oct | |
| 30 | **Reconciliation Year** | The year in which the order was included in the reconciliation report | | 2025 | |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.