Merchant Transaction Reports – Glopal Help

This article is intended to provide you with a detailed explanation of how to read our new merchant transaction reports. You will find a useful glossary explaining what each and every fields from these reports mean.

In addition to the existing Payout report, our checkout teams produces 2 NEW transactional reports offering different levels of reconciliation for our merchants. These reports are generated automatically and sent via email. As a reminder, email subscriptions can be managed directly via the Merchant UI (Payments section).

Reports will be sent for the first time on January 22nd 2024

Payment Transaction Report

This report contains all payments and refunds that a merchant processed through Glopal. It is generated every Monday morning automatically for all merchants.

What's included?

All orders which became READY between Monday 00:00:00 to Sunday 23:59:59. The READY order status implies that payment was taken.
All refunds which were COMPLETED between Monday 00:00:00 to Sunday 23:59:59.

NB: This report excludes the merchant's order references (as the order may not have been placed in the merchant's e-commerce system yet).

Ecommerce Reconciliation Report

This report contains all orders and refunds that were booked in the merchant's e-commerce system. Like the report above, it is generated every Monday morning automatically for all merchants.

What's included?

All orders which became ACCEPTED between Monday 00:00:00 to Sunday 23:59:59. The ACCEPTED order status implies that order was booked in the merchant's e-commerce system.
All refunds which were COMPLETED between Monday 00:00:00 to Sunday 23:59:59.

NB: This report includes the merchant's order references, as these are known when the order status becomes ACCEPTED.

Column	Example values	Description
store_id	Dior	Store identifier.
created_at	2023-12-24 21:43:23	Order/refund creation timestamp.
reported_at	2023-12-24 21:52:54	For the Payment Transaction Report, this is when the order status became READY. For the E-commerce reconciliation report, this is when the order status became ACCEPTED.
gateway_type	adyen, paypal	Identifies the payment gateway of the transaction.
transaction_type	payment, refund	Identifies the type of transaction, either payment or refund.
transaction_external_id	87H41441RE7580451	For PayPal payments and refunds, this is the transaction ID visible in your PayPal account. This is blank for Adyen, as Adyen's transaction references are not exposed to merchants.
glopal_order_id	1083119-1000285	Glopal's order ID.
glopal_refund_id	24422	Glopal's refund ID.
merchant_order_id	5802861527376	Merchant's order ID (E-commerce reconciliation report only.)
merchant_order_number	WEU6853	Merchant's order number/reference (E-commerce reconciliation report only.)
payment_method	card:visa, applepay:amex, paypal...	The payment method.
transaction_currency	CHF	The currency of the transaction, sometimes referred to as the buyer currency.
transaction_amount	1200.00	Total amount in transaction/buyer currency.
transaction_glopal_amount	200.00	Glopal's part (credit / debit) in transaction currency.
transaction_merchant_amount	1000.00	Merchant's part (credit / debit) in transaction currency.
glopal_tax_scheme	euvat-ioss	Reason why Glopal is collecting duty and tax (euvat-ioss, euvat-oss, euvat-frvat, pf-ddp)
glopal_duty_amount	0.00	Glopal-collected duty amount.
glopal_tax_amount	100.00	Glopal-collected tax amount.
glopal_shipping_amount_net	100.00	Glopal-collected Parcel Forwarding international shipping amount (net).
payout_currency	EUR	The merchant's payout currency.
payout_amount	1038.38	For payments, this is the amount you will receive in your payout currency. For refunds, this is the equivalent amount which will be deducted from your Adyen or PayPal balance.
payout_mode	batch	"batch" for Adyen, "instant" for PayPal.
order_items_amount_net	990.00	Total amount of line items (net).
order_discount_amount_net	0.00	Total amount of discounts (net).
order_shipping_amount_net	110.00	Total amount of shopping (net).
order_extra_amount_net	0.00	Total amount of extras (net).
order_duty_amount	0.00	Total amount of duty.
order_tax_amount	100.00	Total amount of tax.
order_destination_country	IE	Country of the end-customer's shipping address.
order_incoterms	DDU, DDP	Delivery Duty Unpaid / Paid
order_calculation_type	tcc, estimate	"tcc" if the total cost calculation is done by Glopal Xport service, we support per-product tax rates and can calculate duty & tax on export with DDP incoterm. It's a paid service but worth it. "estimate" if the calculation is done by Glopal checkout estimation, we assume a single standard VAT rate per destination.

Payment Transaction Report

Ecommerce Reconciliation Report

Related articles