Settlement Report
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), contact your CSM.
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 | ||
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:
| 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 |