Settlement Report - Global-e Docs

The Settlement CSV Report is a structured financial data file provided by Global-e to merchants. It is designed to give merchants a transparent and detailed breakdown of all financial transactions related to their orders, refunds, adjustments, and associated costs or fees. This report can be subscribed to and delivered on a recurring basis, and its format enables multi-purpose data analysis. The following figure shows the Settlement CSV report:

To subscribe to the Settlement Report (weekly and/or monthly), go to Merchant Support Portal.

Key Features

Provides a breakdown of all transaction types such as orders, refunds, adjustments, and returns.
Complete Financial Visibility - full breakdown of revenue, costs, fees, and payout amounts.

The following table provides the field-by-field dictionary of the New Settlement CSV 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.

	Field Name	Description	Formula	Example	Mapping Reference
A	GE reference	Global-e Order ID		GE9248739996GB	GE Order#
B	Order number	Merchant order ID, taken from the merchant’s platform		3579632	Merchant Order#
C	Order Date	Order creation date		2025-07-29 00:00:00	Date Created
D	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.		2025-08-04 00:00:00	Date Received In Hub
E	Destination Country	The country to which the order was shipped		Germany	Destination Country
F	Transaction Type	May include the following values: Order Refund Adjustment (financial transaction between GE and merchant) Returns (inbound shipping costs) UIC/Non Doc (shipping costs that are not associated to a specific order)		Order
G	Total Sales/Refunds excl. B2B VAT	Product price for outbound sale / refund transaction		67.79	Amount to Invoice
H	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
I	Total Costs excl. 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
J	Total Fees excl. 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
K	Total Payment excl. 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
L	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
M	Shipping Paid By Customer incl. B2C VAT	The shipping cost paid by the shopper including B2C VAT		5.93
N	Total Duties and Taxes Paid By Customer	The Duties and Taxes paid by the shopper		0
O	Customer Product Price incl. B2C VAT	The products price paid by the shopper including B2C VAT		67.79
P	Net Sales less Refunds excl. 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.		67.79
Q	Amount Paid In Gift Cards excl. VAT	The amount paid by the shopper via gift card		0	Amount Paid In Gift Cards
R	Service Fee excl. VAT	Global-e service/platform fee.		-3.69	Service Fee
S	Reconciliation Fee excl. VAT	Global-e reconciliation fee.		0	Reconciliation Fee
T	Service Fee Adjustments excl. VAT	Credit adjustments applied to service fees previously charged if applicable		0	Service Fee Adjustments
U	Shipping Charges to Merchant excl. VAT	The difference between the total shipping costs and the shipping amount paid by the shopper		1.04	Shipping Subsidies
V	Returns Shipping Charges to Merchant excl. VAT	The difference between the return shipping costs and the return shipping amount paid by the shopper		0	Returns
W	Handling Fee excl. VAT	These are the cross-dock fees for each order which is processed through Global-e’s hub		0	Handling Fee
X	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

​Key Features

Key Features