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.

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: Order Refund Adjustment (financial transaction between GE and merchant) Refund (inbound shipping costs) 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. 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: Order - Item Price net of discounts. Refund - Refund amount to the shopper. 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

​Key Features

​Report Filters

​Reports Available Fields

Key Features

Report Filters

Reports Available Fields