Types of reports
There are several reports available:
Report | Description | Use cases |
---|---|---|
Payout summary | Structured the same way as the Payout summary report available for each payout, but with a date range selection. The legacy version is also available until July 31, 2025 so you can update any mapping that reference this report. | Analyze orders in your payouts at a high level, with each order on its own row. View transaction and merchant fees. |
Payout detail | Structured the same way as the Payout detail report available for each payout, but with a date range selection. The legacy version is also available until July 31, 2025 so you can update any mapping that reference this report. | View the breakdown of your payout, including what was withheld before the payout was sent to your bank account. |
Invoice summary | Structured the same way as the Invoice summary report available for each invoice, but with a date range. | View a summary of of the charges you have been invoiced. |
Invoice detail | Structured the same way as the Invoice detail report available for each invoice, but with a date range. Each individual charge has its own row in the CSV. | View the breakdown of all charges you have been invoiced. |
Orders | Displays all major information about an order, without getting into itemized details. | Analyze orders to forecast sales, uncover geographical trends, and identify seasonal patterns. |
Orders with item details | Lists all items within an order (each item on its own row). Includes item information, such as quantity, sku, dimensions, hs code, etc. | Analyze orders to determine which products sell best in each country. |
Landed Cost breakdown | Audit landed cost calculations with duty, tax, and fee breakdowns. | Periodic tax filing, audit landed cost calculations. |
- Go to Dashboard -> Reports
- Hover over the report you want and click Generate.
- Select your preferred date range.
- Click Generate report.
Payout summary | Payout detail | Orders | Orders with item details | Landed cost breakdown | |
---|---|---|---|---|---|
Each order has its own row | |||||
Each order charge has its own row |
Payout summary | Payout detail | Orders | Orders with item details | Landed Cost breakdown | |
---|---|---|---|---|---|
Customer information and tracking number | |||||
Payout information | |||||
Transaction fees & merchant fees | |||||
Duties, taxes, and fees details | |||||
Item details (Name, SKU, HS code, etc.) | |||||
Order item count and weight |
Below are the available fields in each report:
Field | Payout summary | Payout detail | Orders | Orders with item details | Landed Cost breakdown |
---|---|---|---|---|---|
accountName | |||||
orderAdditionalTariffLines | |||||
addressLine1 | |||||
addressLine2 | |||||
amount | |||||
amountDiscount | |||||
amountDutiesTaxesFees | |||||
amountItem | |||||
amountShipping | |||||
amountTotal | |||||
arrivalDate | |||||
brokerage | |||||
city | |||||
country | |||||
countryCode | |||||
countryOfOrigin | |||||
countryOfOriginSource | |||||
currency | |||||
currencyCode | |||||
customerName | |||||
customsDescription | |||||
description | |||||
detailType | |||||
dimensionsUnit | |||||
discountOrder | |||||
dutyOrder | |||||
dutyTaxFeeOrder | |||||
fx | |||||
guarantee | |||||
height | |||||
hsCode | |||||
hsCodeSource | |||||
itemWeight | |||||
itemWeightUnit | |||||
itemOrder | |||||
landedCostGuarantee | |||||
length | |||||
merchantAdjustment | |||||
merchantSet | |||||
merchantFee | |||||
memo | |||||
name | |||||
orderDate | |||||
orderDuty | |||||
orderFeeAdvancement | |||||
orderFeeBrokerage | |||||
orderFeeCarrier | |||||
orderFeeShopper | |||||
orderFx | |||||
orderNumber | |||||
orderReference | |||||
orderStatus | |||||
orderTax | |||||
orderTotal | |||||
other | |||||
otherCarrierFee | |||||
packageWeight | |||||
packageWeightUnit | |||||
payee | |||||
payor | |||||
payoutDate | |||||
payoutNumber | |||||
payoutTotal | |||||
postalCode | |||||
processing | |||||
productId | |||||
quantity | |||||
referenceNumber | |||||
settled | |||||
shippingOrder | |||||
shippingService | |||||
sku | |||||
state | |||||
taxOrder | |||||
total | |||||
totalItems | |||||
totalItemWeight | |||||
trackingNumber | |||||
transactionDate | |||||
transactionFee | |||||
transactionId | |||||
transactionType | |||||
weightUnit | |||||
width |
Below are the definitions of each field in the reports:
Field | Definition |
---|---|
accountName | Name of the account with Zonos. |
orderAdditionalTarriffLines | Customs broker fee for the additional work required to manage and declare multiple tariff (HS) codes in the customs entry. |
addressLine1 | First line of the recipient's address. |
addressLine2 | Second line of the recipient's address, if applicable. |
advancement | Fee charged for advancing duties and taxes on behalf of the customer. |
amount | Monetary value of the line item or charge. |
amountDiscount | Discount amount for the order. |
amountDutiesTaxesFees | Amount of duties, taxes, and fees applied to the order. |
amountItem | Amount for a single item. |
amountShipping | Amount of shipping on an order. |
amountTotal | Amount for a single item multiplied by the quantity of the item. |
arrivalDate | Date the payout arrived in the merchant's bank account. |
brokerage | Brokerage fee associated with customs clearance. |
city | City of the recipient's address. |
country | ISO 2-letter country code of the destination. |
countryOfOrigin | Country where the item was manufactured or produced. |
countryOfOriginSource | Source of the country of origin information. |
currency | Currency used for the transaction, in ISO 3-letter format. |
customerName | Name of the customer placing the order. |
customsDescription | Description of the item used for customs declarations. |
description | Description of the product. |
detailType | Detailed reason for the amount on the order (e.g., tax, brokerage fee, currency conversion fee, merchant processing fee, etc.) |
dimensionsUnit | Unit of measurement (e.g., inches, cm). |
discountOrder | Discount applied to the order. |
dutyOrder | Duty amount applied to the order. |
dutyTaxFeeOrder | Total amount of duties, taxes, and fees applied to the order. |
fx | Foreign exchange rate applied to the transaction. |
guarantee | Amount guaranteed by Zonos. |
height | Height of the item. |
hsCode | Harmonized System (HS) code assigned to the item. |
hsCodeSource | Source of the HS code classification. |
itemWeight | Weight of the item in the order. |
itemWeightUnit | Unit of measurement for the item's weight (e.g., kg, lb). |
itemOrder | Cost of the items in the order. |
landedCostGuarantee | Cost for the landed cost guarantee service (includes both $ and % components of pricing). |
length | Length of the item. |
merchantAdjustment | Adjustments that the merchant has entered/requested, typically via rules. |
merchantSet | Any buffers/adjustments set by the merchant. |
merchantFee | Portion of the Checkout cost attributed to payment processing costs. |
memo | Additional notes or details regarding the payout or transaction. |
name | Name of the product. |
orderDate | Date the order was placed, in UTC. |
orderDuty | Duty amount for the order. |
orderFeeAdvancement | Advancement fees for the order. |
orderFeeBrokerage | Brokerage fees for the order. |
orderFeeCarrier | Carrier fees for the order. |
orderFeeShopper | Fees charged to the shopper. |
OrderFx | Foreign exchange rate applied to the transaction. |
orderNumber | Unique identifier for the order in Zonos' system. |
orderReference | Additional reference number associated with the order, typically the order number in the ecommerce platform. |
orderStatus | Current status of the order. |
orderTax | Tax amount for the order. |
orderTotal | Total amount for the order. |
other | Miscellaneous charge or adjustment related to the transaction. |
otherCarrierFee | Additional fees charged by the shipping carrier, including prepayment fees (which the carrier sends on the shipping bill). |
packageWeight | Total weight of the package. |
packageWeightUnit | Unit of measurement for the package's weight. |
payoutDate | Date the payout was issued to the merchant. |
payee | Entity receiving the payment. |
payor | Entity responsible for making the payment. |
payoutNumber | Matches the Stripe payout id. |
payoutTotal | Total amount paid out to the merchant. |
postalCode | Postal or ZIP code of the recipient's address. |
processing | Expected method for processing customs payment: either TAX_REMITTANCE (remit via tax ID) or CUSTOMS_BILL (pay a customs bill). |
productId | Unique identifier for the product. |
quantity | Number of units of the item in the order. |
referenceNumber | References the Payout number (e.g., po_1QcGXkGbPRfOWRJBfaa90A1A ) or Invoice number (e.g., 584184EA-0000 ). |
settled | The amount of the transaction that settled to the merchant. |
shippingOrder | Shipping cost for the order. |
shippingService | Shipping method or service used for delivery. |
sku | Stock Keeping Unit (SKU) for the product. |
state | State or region of the recipient's address. |
taxOrder | Tax amount applied to the order. |
total | The order total (the total the shopper paid). |
totalItems | The total number of items in the order. |
totalItemWeight | Total weight of all items in the order. |
trackingNumber | Tracking number for the shipment. |
transactionDate | Date the transaction was recorded, in UTC. |
transactionFee | Includes cost for Checkout services, including fraud protection. Does not include payment processing costs. |
transactionId | Unique identifier for the transaction. |
transactionType | Possible types: ORDER , ORDER_REFUND , ORDER_CANCEL , CHARGE , or CREDIT . Invoices have another type, STRIPE , which is related to subscription costs, platform fees, or CTP credits. |
weightUnit | Unit of measurement for weight values. |
width | Width of the item. |
Reconcile payouts / Match a single payout to your bank statement
Either of the payout reports can be used to reconcile with your bank statement. It's easiest to download these from the Payouts page, so they contain exactly the orders connected to that payout (rather than from the Reports page, which has you select the date range).
- Go to Dashboard → Payouts.
- Select the payout.
- Click Export transactions in the top right corner, then choose either Payout summary or Payout detail from the dropdown.
The sum of the settled
column in the Payout summary and in the Payout detail will match the total payout amount shown in Dashboard.
Review a refunded order
Use the Payout summary report to view your order and its refund.
- Go to Dashboard → Reports.
- Click Generate next to the Payout summary report.
- Select your preferred date range. Be sure the date range includes both the date of the order and the date of the refund to get the complete view.
- Click Generate report.
- Filter the report for the order in question.
Example
Let's look at one order as an example. Here is a snapshot from a CSV download of the Payout summary report, filtered for order 1234, where a full refund was issued.
orderNumber (I) | transactionType (L) | itemOrder (M) | shippingOrder (N) | dutyTaxFeeOrder (P) | guarantee (Q) | transactionFee (R) | merchantFee (S) | settled (U) |
---|---|---|---|---|---|---|---|---|
1234 | ORDER | 105.80 | 80.76 | 58.96 | -58.96 | -7.38 | -9.88 | 169.30 |
1234 | ORDER_REFUND (would show ORDER_CANCEL if this order had not shipped) | -105.80 | -80.76 | -58.96 | 58.96 | 7.37 | -179.20 |
In this example:
- The merchant is using Zonos' Landed Cost guarantee (values in column Q,
guarantee
). - At the time of the order, the merchant received payment for
itemOrder
andshippingOrder
minus Zonos' fees (transactionFee
andmerchantFee
). This amount, the sum of columns M through T, matches thesettled
value in column U.- Duties, taxes, and fees (
dutyTaxFeeOrder
) were collected, but since the merchant opted for Zonos to handle these, Zonos keeps those funds and pays customs directly. As a result,dutyTaxFeeOrder
andguarantee
cancel each other out (net to 0).
- Duties, taxes, and fees (
- When the order was refunded, Zonos refunded the shopper and took back the
itemOrder
andshippingOrder
amounts from the merchant. Zonos also refunded thetransactionFee
but kept themerchantFee
since zonos will still be billed for the merchant fee by the payment provider.- Duties, taxes, and fees are still not the merchant's responsibility, so they don't appear in this report. Zonos refunded those to the shopper based on the merchant's refund request, but since that refund was Zonos → shopper, it's not reflected here.
Find out how much Zonos withheld vs how much you made on the order
The Payout detail report can be used to find out how much you are paying to Zonos, versus how much your shoppers are paying. However, how you interpret the report depends on if you use our Landed Cost guarantee. Choose whether you do or not below.
By default, shoppers pay for the landed cost guarantee, while merchants pay for the cost of the checkout services (such as payment processing and fraud protection). The Payout detail report records who paid for each portion of the order.
To find out how much you and your shopper paid, first download the report:
- Go to Dashboard → Reports.
- Click Generate next to the Payout detail report.
- Select your preferred date range.
- Click Generate report.
In the report, filter according to what you want to know:
- To find how much your shopper paid you for the order, filter the Payor (column O) to
SHOPPER
and the Payee (column N) toMERCHANT
. This will not include passthrough costs like duty and tax. - To find how much you paid to Zonos out of pocket, filter the Payor (column O) to
MERCHANT
and the Payee (column N) toZONOS
. Sum these values. - To find how much you made on the order, sum up every row for the order (this will match the difference of the above two totals).
Example
Let's look at one order as an example. Here is a snapshot from a CSV download of the Payout detail report, looking at all rows pertaining to a single order, 0123.
orderNumber (I) | detailType (M) | payee (N) | payor (O) | amount (P, all in USD) |
---|---|---|---|---|
0123 | ITEM | MERCHANT | SHOPPER | 96.85 |
0123 | SHIPPING | MERCHANT | SHOPPER | 30.63 |
0123 | MERCHANT_PROCESSING | ZONOS | MERCHANT | -6.72 |
0123 | TRANSACTION_PERCENT | ZONOS | MERCHANT | -4.94 |
To make sense of this detail, let's bucket these into gains and fees.
Gains: Zonos collected these costs from the shopper, then paid them to the merchant.
- The item subtotal, in this case, $96.85 (
ITEM
). - The cost of shipping, $30.63 (
SHIPPING
).
Fees: Zonos collects these costs from the merchant—they are not included in the amount the shopper paid at checkout.
- A merchant processing fee of $6.72 (
MERCHANT_PROCESSING
). - A transaction fee of $4.94 (
TRANSACTION_PERCENT
).
View quarterly data (payouts within a certain time frame)
Payout reports are available for each payout; however, you may want to reconcile all payouts within the last quarter, for example. Rather than downloading multiple payout reports, you can easily download one report with the desired date range.
To download the Payout summary or Payout detail CSV reports, for any date range:
- Go to Dashboard → Reports.
- Click Generate next to the report you want.
- Select the date range starting at the beginning of the quarter and ending at the end of the quarter.
- Click Generate report.
Verify the orders in Dashboard match those in ecommerce platform
If you have made a change recently, you may want to confirm that all of the orders in the Zonos Dashboard also appear in your ecommerce platform. To do so:
- Download the Orders CSV report.
- Go to Dashboard → Reports.
- Click Generate next to the Orders report.
- Select the date range that you want to verify.
- Click Generate report.
- Compare these orders to what you see in your ecommerce platform.
Please reach out to our support team if you have any trouble with your orders.
Audit landed cost calculations
Use the Landed Cost Breakdown report to explore the details of our landed cost calculations without dealing with vertical tables. This report shows each individual cost that contributes to the total landed cost for an order, with every component listed in its own column.
To download the Landed cost breakdown report:
- Go to Dashboard → Reports.
- Click Generate next to the Landed cost breakdown report.
- Select the date range that matches that of the carrier bill.
- Click Generate report.
Downloadable reports for Checkout users
Learn how to get the data you need from downloadable reports.
Downloadable reports provide Checkout merchants with the data they need for reconciliation and analysis. These reports, available in USD and customizable by date range, support common use cases like tax filing, verifying orders, analyzing charges, and gaining business insights. The date and time of all reports are in UTC.