Reports
The Reconciliation Report
The Reconciliation Report provides a comprehensive detail of all your sales. It is generated automatically once a week and continually monitored by the Global-e finance team.
The Reconciliation Report is sent to you by email each week.
The Reconciliation Report is presented in your local currency, and the information is aligned with the rules and regulations of your specific country.
A detailed Reconciliation Report contains:
A breakdown of each order by product, including a breakdown of cart and product discounts.
A summary of all orders dispatched during the period.
A summary of all related shipping and Duties and Taxes costs and subsidies.
A summary of refunds issued within the period, and a breakdown of these refunds by product.
A summary of all returns costs and subsidies for returns that took place during the period.
A summary of service fees.
A summary of gift cards.
A summary of invoicing.
A summary of all totals in the report for ease of invoicing.
A separate tab is available near the bottom of the page for each of the above.
Important
With each report:
The Sales Total serves as the basis for the service fee calculation each week.
Orders are included for reconciliation according to the Received In Hub date and refunds by their creation date.
Accessing Your Reconciliation Report
This page tells you how to:
View your Reconciliation Report
View your Reconciliation Report details
Download your Reconciliation Report
Print your Reconciliation report
Navigate to Merchants > Reports > Reconciliation Report from the top menu.
Select a merchant from the Merchant menu.
Select a date period from the Report menu.
The Reconciliation Report page is displayed showing a summary of the latest billing period.
Follow steps 1 - 3 above.
At the bottom of your report, click one of the following tabs to view more activity details for the selected period:
Products
Orders
ShippingPerParcel
Refunds
RefundsComponents
Returns
Service Free
See ??? for more information about the above.
Follow steps 1 - 3 in To view your Reconciliation Report.
In the bottom-left corner of the page, click Download Report.
Follow steps 1 -3 in To view your Reconciliation Report.
In the bottom-right corner of the page, click Print.
Note
You can select the Show all Pro merchants option to show all Pro merchants located below the Print button.
The reconciliation report is presented in your local (merchant) currency, and the information is aligned with the rules and regulations of your specific country.
See Reconciliation Report....-- .
See ... for a description of the fields in the reconciliation report . Simcha add topic with details.
Issuing Reconciliation Reports
From this screen you can view your reconciliation reports.
From the top menu, navigate to Merchants > Reports.
From the Merchant menu, select a merchant.
From the Report menu, select a week range.
The reconciliation report is displayed in the region below the dropdown menu. Note that the reconciliation report has several tabs containing different reconciliation information.
Downloading and Printing Reconciliation Reports
From this screen you can also download or print your reconciliation reports or invoices by doing one or more of the following:
Downloading your report by clicking Download Report.
Printing your report by clicking Print.
Downloading an invoice of your report by clicking Invoice.
Reconciliation Report Breakdown
Below is a sample Reconciliation Report with a breakdown of the services and fees for the selected week.
Amount Excl. VAT | VAT | Amount Incl. VAT | ||
|---|---|---|---|---|
Sales Total | £23528.85 | £4705.77 | £28234.62 | |
Refunds Total | (£2106.68) | (£423.79) | (£2530.47) | |
Amount to Invoice | £21422.17 | £4281.98 | £25704.15 | |
Service Fee | £1899.44 | £379.89 | £2279.33 | 7.50% of Total Order Value |
Shipping Subsidies | £3,649.75 | £0.00 | £3,649.75 | |
Taxes Subsidization | £1114.45 | £0.00 | £1114.45 | |
Handling Fee | £140.00 | £28.00 | £168.00 | |
Returns | £14.97 | £2.99 | £17.96 | |
Services and Fees | £6818.61 | £410.88 | £7229.49 |
Sales Total
The following figures show the Sales total on the order and product levels:
Order Level
Product Level
Refunds Total
The following figure shows the Refunds total, listing all the refunds that were issued through Global-e during the relevant period:
Shipping Subsidies
Shipping prices are based on the actual weight that we received from the shipper or measured at our hub. Shipping costs are reconciled based on the shipment date. The following figure shows the Shipping subsidies:
Returns
Returns includes the details of each returned parcel. The following figure shows the Returns:
To understand the reconciliation report using your own logistics (WYOL) click here.
For a list of all the report fields and their definitions, see Reconciliation Report Fields.
Viewing a Merchant's Dashboard
From this screen you can view a merchant’s dashboard. All of the graphs can be accessed from the main Dashboard or from its submenu located on the left side of the screen. The Dashboard submenu graphs show more detailed information than their main Dashboard counterparts, such as country lists.
In addition, the following commonly used graphs can be accessed from the Sales Report screen as well:
Sales
Orders
Top Countries - Sales
Top Countries - AOV
Note that you can display the information in the above graphs according to day, week, and month.
From the top menu, navigate to Merchants > Dashboard.
From the Merchant menu, select a merchant.
That merchant's dashboard is displayed showing the following reports as graphs:
Sales
Returns
Orders
Local currency
Top countries
Payment methods
Conversion rate
Duties pre payment
AOV (Average Order Value
Apply one of the following date range filters:
Month to Date
Year to Date
Custom
Filter out information belonging to unwanted countries using the country filter located to the right of the date range filters.
Reconciliation Report
The Reconciliation Report Explained
The following video explains the structure of the weekly reconciliation report.
Reports: Dashboard
Overview
Incomplete: The entire doc must be reviewed, pics replaced, and old and new features updated.
The Merchant Portal Merchant Dashboard feature is a useful tool for tracking business performance at a glance or in more detail, by means of a clear and user-friendly interface.
To access the Dashboard:
Go to the Merchant Portal, Merchants > Reports > Dashboard.
The Dashboard opens.
The following sections provide a short guide to the dashboard and the reports that you can generate.
Sales Report
The Sales report shows your revenues from selling your products minus discounts, within the selected period.
The report displays the following business-oriented options (pivots):
Sales
Orders
Top Countries - Sales
Checkout Conversion Rate
Top Countries – AOV
Returns
Local Currency Payment
Payment Methods
Duties Pre-Payment
You can switch the pivot within the main report, while the dashboard displays the views.
The Orders view shows the number of confirmed non-cancelled orders.
The Top Countries –Sales presents the first top ten sales-leading countries.
The Top Countries – AOV presents the same countries along with their average order value.
Checkout Conversion Report
This report shows the ratio of confirmed transactions to checkout sessions, as tracked by Google Analytics, within the selected period.
The data is available as of February 2020 onwards and is updated at 9:00 AM UTC time, the previous day.
Note that the only traffic taken into account in this report is from the checkout page.
Returns Report
This report shows the percentage of the average of refunds that were issued to customers for returned products, within the selected period.
Local Currency Report
This report shows the ratio of confirmed payments in the shopper country‘s currency vs. payments made in any other currency, within the selected period.
Payment Method Report
This report shows the ratio of confirmed payments via credit/debit cards vs. all other means of payment, within the selected period.
Duties Pre-Payment Report
This report shows the ratio of the different duties pre-payment options that were offered to customers during checkout, within the selected period:
D&T pre-paid – Percentage of orders where customers selected to pay duties & taxes at the checkout.
D&T were not paid – Percentage of orders where customers selected not to pay duties & taxes at the checkout.
Hidden D&T – Percentage of orders with duties & taxes included in the product price as per merchant settings.
D&T applicable – Orders that are liable for duties & taxes according to the destination country’s duties regime.
D&T N/A –Orders that are below the duties & taxes threshold of the destination country or orders delivered by shipping services that do not support D&T prepayment.
Report Features
Date and Country Filters
Two pre-defined filters can be used (Month to Date / Year to Date) to set the date range or a customized period can be selected.
Data is always shown up to the previous day.
Through the country filter, specific countries can be selected to be shown in the report.
By default, all countries that contributed at least one order within the selected period, are selected in the list.