Reconciliation Report - Global-e Docs

The Reconciliation Report is a structured financial data file provided by Global-e to merchants. It offers comprehensive details of all your sales. The report is generated automatically once a week and the Global-e Finance team is available for any questions regarding the files or data. To access the Reconciliation Report, see Reports. Starting in 2026, an updated layout of the report was introduced. This documentation covers both the original and the updated layouts. To receive the updated report layout instead of the original layout, please contact your CSM. The Reconciliation Report includes the following sections, which you can view by selecting the relevant tab:

The Reconciliation Report is presented in your local currency, and all information is aligned with your country’s specific rules and regulations.
Orders are included in the reconciliation according to their Received in Hub date, while refunds are included based on their Creation date.
Verify that you review the status of your orders on a regular basis, to ensure that all orders dispatched have progressed to Received In Hub. Orders not received in the hub may delay payment of said orders.
For guidance regarding the current status of any order, or to progress orders dispatched which have not yet progressed toReceived In Hub, contact your CSM.

For more information, see the original layout video. For more information about the Reconciliation process, see The Reconciliation Process (Finance).

Summary

This section is an overview of all the fields displayed in the Summary tab. It describes both the original and updated layouts, and includes important details of each. Original Layout The following image shows the original layout:

Section	Field Name	Description
Invoice	Sales Total	Total of all sales from the period.
Refunds Total	Refunds processed during the period.
Amount to Invoice	The total of all sales from the period, including discounts (Sales Total), minus the refunds processed during the period (Refunds Total).
Services and Fees	Service Fee	A fee based on the percentage per contract.
Base for Reconciliation Fee	A calculation based on the Total Order Value paid by the customer
Reconciliation Fee Percentage	The fee percentage noted in the contract.
Reconciliation Fee	Percentage per contract of the base for Reconciliation Fee noted above
Shipping Subsidies	The difference between the total cost of shipping and the fixed price paid by the customer. This is also according to your configuration.
Taxes Recoup	Duties & Taxes that you have chosen to subsidise for the client.
Handling Fee	The handling fees for each order which are processed through the Global-e Merchant hub.
Minimum Service Fee Completion	Refers to the monthly minimum amount defined in the contract. At the end of each month, if the total service fee and reconciliation fee collected do not reach the contractual minimum, we charge the merchant the difference to complete the minimum fee. The amount is calculated as: the contractual minimum fee minus the service fee for the month, minus the reconciliation fee for the month. The breakdown will appear at the bottom of the Summary Tab.
Returns	The shipping cost for each return shipped back during the period.
Amount Paid in Gift Cards	Total amount of all orders paid by Gift Card upon purchase.
Minimum Service Fee Completion	Minimum Fee Amount	Refers to the monthly minimum amount defined in the contract.
Service Fee Charged	Total Service Fee charged over the course of the calendar month.
Reconciliation Fee Charged	Total Reconciliation Fee charged over the course of the calendar month.

Updated Layout The following figure shows the updated layout:

Section	Field Name	Description
Date	Date Period	The report period is always from the initial date up to midnight of the cutoff date (UTC). For example, a report for the 01.01.2025-08.01.2025 includes all orders from the 1st up to and including the 7th; the final date is just the cutoff.
Net Sales	Total Product Price Before Refunds	Total product for orders marked received in hub (dispatch date when orders are shipped direct; date received in Global-e’s hub when shipped via Global-e hub) during the period.
Refunds	Total Refunds	Total of refunds and adjustments issued against the account within the period.
Fees	Service Fee	The amount paid for Global-e’s Service Fee according to your contract (noted as Platform Fee in the contract).
Reconciliation Fee	The amount paid for Global-e’s Reconciliation Fee according to your contract.
Service Fee Adjustment	Adjustment of Service and Reconciliation Fees upon purchase of a product using a gift card which was itself purchased through Global-e.
Minimum Fee Completion	“Minimum fee completion” refers to the monthly minimum amount defined in the contract. At the end of each month, if the total service fee and reconciliation fee collected do not reach the contractual minimum, we charge the merchant the difference to complete the minimum fee. The amount is calculated as: the contractual minimum fee minus the service fee for the month, minus the reconciliation fee for the month. The breakdown will appear at the bottom of the Summary Tab.
Total Fees	Total of the above fees, including Service Fee, Reconciliation Fee, Service Fee Adjustment, Minimum Fee Completion and Borderfree.com Affiliation, as applicable.
Gift Cards	Total Amount Paid In Gift Cards	Total amount of all orders paid by Gift Card upon purchase.
Transactional Costs	Shipping Charges To Merchant	Includes (for breakdown of the below, see Shipping Per Parcel tab for 1 and 2, see Returns tab for 3):
Shipping Charges to Merchant: the difference between the shipping fee paid by the Customer on the outbound sale and the actual cost of outbound shipping. Handling Fee: the crossdock fee for orders shipped via Global-e hubs. Return Shipping costs: the difference between the shipping fee paid by the Customer for the return of goods and the actual cost of shipping for the inbound return.
D&Ts Charges To Merchant	Deduction of Duties & Taxes built into the product price as part of the business proposition - refer to models: Hidden Forced DDP and Partial Forced DDP.
Total Transactional Costs	Total of Shipping Charges To Merchant and D&Ts Charges To Merchant
Margin	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.
Total Transactional Costs with margin deduction	Total value of Total Transactional Costs less Estimated Additional Margin From International Pricing
Invoicing Totals	Merchant Invoice (Net Sales Less Refunds)	Total amount to be invoiced for sales and refunds either by the merchant or on their behalf by Global-e (Self-Billing Invoicing).
Global-e Invoice (Fees, Gift Cards And Transactional Costs)	Total amount to be invoiced by Global-e for Total Fees, Total Transactional Costs and Total Gift Cards.
Net Amount Due	The final amount due after deducting the Global-e Invoice from the Merchant invoice.
Minimum Service Fee Completion	Minimum Fee Amount	Refers to the monthly minimum amount defined in the contract.
Service Fee Charged (for 01//20 - 01//20)	Total Service Fee charged over the course of the calendar month.
Reconciliation Fee Charged (for 01//20 - 01//20)	Total Reconciliation Fee charged over the course of the calendar month.
Total Minimum Fee Completion	Refers to the final fee due after deducting Service Fee and Reconciliation Fee Charged from the Minimum Fee Amount.

Products and Orders

This section provides an overview of all the fields displayed in the Products and Orders tabs: The following figure shows the Productstab layout:

The following figure shows the Orderstab layout:

#	Field Name	Description
1	GE Order#	This is a unique Global-e ID which is created for each order in the our system - for example, GE7733229GB
2	Date Created	The date on which the order is created in Global-e’s system.
3	Date Received In Hub	This date can have two meanings. If you are you shipping through Global-e’s hub, this will be the day the order is scanned into our hub.If you are shipping directly to the end customer, this will be the same as the date of shipment.
4	Merchant Order#	Your ID number for the order, normally taken from your platform.
5	Destination Country	The destination country to which the order was shipped.
6	EU / Non EU	For “EU” merchants: This flag is to indicate whether the destination country is in the EU.For “NON-EU” merchants: not applicable
7	Delivery Method	The shipping method selected by the customer at checkout.
8	Product, SKU, Product Reference and Quantity	These columns contain all of the identification numbers, descriptions, and also quantities of each product.
9	Gross Item Price/Gross Item Price Ex VAT	The price of each product excluding merchant VAT and before the deduction of discounts.
10	Total Product Discount	The discount value against each product or order excluding merchant VAT.
11	Net Item Price/Net Item Price Ex VAT	The price of each product or total of the order excluding merchant VAT and after the deduction of discounts.
12	VAT % (Merchant)	The percentage of VAT which applies on the product price or order total.
13	VAT Amount (Merchant)	The VAT amount which applies on the product price or order total.
14	Net Item Price Incl VAT	The product price or order total, including merchant VAT.
15	Extra Margin Amount	Will appear only in the “orders” tab.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.

Shipping per Parcel

The following figure shows the ShippingPerParcel table:

This section provides an overview of all the fields displayed in the ShippingPerParcel tab.

#	Field Name	Description
1	GE Order#	GE Order# This is a unique Global-e ID which is created for each order in the our system - for example, GE7733229GB
2	Parcel Codes	An unique identifier for each parcel - it is possible that there will be more than one parcel per order.
3	Date Created	Date Created The date on which the order is created in Global-e’s system.
4	Date Received In Hub	This date can have two meanings. If you are you shipping through Global-e’s hub, this will be the day the order is scanned into our hub. If you are shipping directly to the end customer, this will be the same as the date of shipment.
5	Merchant Order#	Merchant Order# Your ID number for the order, normally taken from your platform.
6	Destination Country	Destination Country The destination country to which the order was shipped.
7	EU / Non EU	For “EU” merchants: This flag is to indicate whether the destination country is in the EU. For “NON-EU” merchants: not applicable
8	Delivery Method	Delivery Method The shipping method selected by the customer at checkout.
9	Is Replacement Order	Is Replacement Order Is this parcel for a replacement order, yes or no.
10	Tracking Number	Tracking Number Tracking number for each parcel.
11	Count Parcels	Count Parcels The number of parcels attributed to a single line.
12	Weight Kg	Weight Kg The total weight of the parcels attributed to this line.
13	Shipping Paid By Customer	The shipping cost paid by the customer - a fixed rate according to configuration.
14	Shipping Cost	Total actual shipping cost
15	Shipping Subsidies/ Shipping Subsidies -Excl VAT	Subsidisation of shipping cost - the difference between the amount paid by customer and the total shipping cost.
16	Shipping Subsidies - VAT	The VAT of the subsidisation, set according to merchant VAT settings.
17	Shipping Subsidies - Inc VAT	Subsidisation of shipping cost, including VAT.
18	Total Duties and Taxes	Total duties & taxes related to all parcels included in each line.
19	Taxes Recoup/Taxes Subsidization	Subsidisation of duties & taxes, if you have chosen to subsidise duties & taxes, either fully or partially.
20	Duties Paid By Customer	Portion of duties and taxes paid by customer separately to product and shipping.
21	Handling Fee	Handling Fee These are the handling fees for each order which is processed through Global-e’s hub.

Refunds and Refund Components

The following figure shows the RefundsComponents table:

This section provides an overview of all the fields displayed in the Refunds and RefundsComponents tabs.

#	Field Name	Description
1	Refund Id	This is a unique Global-e ID which is created for each refund or adjustment in the our system.
2	Refund Date Created	Creation date of the refund or adjustment in Global-e’s system.
3	GE Order#	This is a unique Global-e ID which is created for each order in the our system - for exmaple, GE7733229GB
4	Order Date Created	The date on which the order is created in Global-e’s system.
5	Merchant Order#	Your ID number for the order, normally taken from your platform.
6	Destination Country	The destination country to which the order was shipped.
7	EU / Non EU	For “EU” merchants: This flag is to indicate whether the destination country is in the EU.For “NON-EU” merchants: not applicable
8	Refund Reason	The reason selected when the refund or adjustment was created in Global-e’s system.
9	Refund Status	The status of the refund or adjustment - for example, completed or manual.
10	Refund Products	All products included in the refund or adjustment.
11	Refund Components, SKU & Product Reference	Refund Components, SKU and Product Reference of products reimbursed or adjusted by line.
12	Refund Quantity	Refund Quantity of each product refunded or included in the adjustment.
13	Refund Notes	Notes added when the refund or adjustment was created in Global-e’s system.
14	Refund Amount/ Refund Amount Ex VAT	Total of the refund or adjustment, excluding VAT.
15	VAT	VAT relevant for the refund or adjustment.
16	Refund Amount Incl VAT	Total of the refund or adjustment, including VAT.

Returns

The following figure shows the Returns table:

This section provides an overview of all the fields displayed in the Returns tab.

#	Field Name	Description
1	GE Order#	This is a unique Global-e ID which is created for each order in the our system - for example, GE7733229GB
2	Date Created	The date on which the order is created in Global-e’s system.
3	RMA Number	Unique ID number created for each return label - RMA.
4	Tracking Number	Tracking number for each parcel.
5	Merchant Order#	Your ID number for the order, normally taken from your platform.
6	Destination Country	The destination country to which the order was shipped.
7	Shipping Method	Delivery method used for the return shipment.
8	Return Weight (gr)	Actual weight of the return in kilos.
9	Customer Payment Merchant Currency	Return shipping costs paid by customer - a fixed rate according to configuration.
10	Total Return Cost Merchant Currency/ Total Return Cost Merchant Currency excl. VAT	The total return costs, excluding VAT.
11	Total Merchant Cost Merchant Currency/ Total Merchant Cost Merchant Currency excl VAT	This is the difference between the amount paid by customer and the total actual return cost.
12	Total Merchant Cost - VAT	VAT relevant to the return subsidy.
13	Total Merchant Cost Merchant Currency incl VAT	The total cost to merchant, including VAT.

Service Fee

This section provides an overview of all the fields displayed in the Service Fee tab, according to your contract.

#	Field Name	Description
1	Product Paid by Customer	Total product paid by customers at checkout
2	Shipping Paid by Customer	Total of the shipping paid by customers at checkout
3	D&T Paid by Customer	Total of all duties and taxes paid separately from the product and shipping amounts at checkout
4	Total Order Value	Total of the previous three fields, being the total order value paid at checkout including product and shipping, as well as duties and taxes
5	Base for Service Fee	The base for the service fee, being the total order value listed under the Total Order Value field
6	Service Fee Percentage	Service fee percentage as agreed in the merchant’s contract
7	Service Fee	A percentage of the total order value paid by customers, calculated as Total Order Value * Service Fee Percentage
8	Base for Reconciliation Fee	The base for the reconciliation fee, being the total order value listed under the Total Order Value field
9	Reconciliation Fee Percentage	Reconciliation fee percentage as agreed in the merchant’s contract
10	Reconciliation Fee	A percentage of the total order value paid by customers, calculated as Total Order Value * Reconciliation Fee Percentage

Gift Cards

The following figure shows the Gift Cards table:

This section provides an overview of all the fields displayed in the GiftCards tab.

#	Field Name	Description
1	GE Order#	This is a unique Global-e ID which is created for each order in Global-e system - for example, GE7733229GB
2	Date Created	The date on which the order is created in Global-e’s system.
3	Date Received In Hub	This date can have two meanings. If you are you shipping through Global-e’s hub, this will be the day the order is scanned into our hub.If you are shipping directly to the end customer, this will be the same as the date of shipment.
4	Merchant Order#	Your ID number for the order, normally taken from your platform.
5	Destination Country	The destination country to which the order was shipped.
6	EU / Non EU	For “EU” merchants: This flag is to indicate whether the destination country is in the EU. For “NON-EU” merchants: not applicable.
7	Delivery Method	The shipping method selected by the customer at checkout.
8	Gift Card Used Value	Total portion of the order value paid by gift card at checkout.

​Summary

​Products and Orders

​Shipping per Parcel

​Refunds and Refund Components

​Returns

​Service Fee

​Gift Cards