HomeGlobal ecommerce Reporting and analytics For non-Checkout users

Downloadable reports for non-Checkout users

Learn how to get the data you need from downloadable reports.

Downloadable reports provide non-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.

Checkout merchants can use their Payout reports for similar information.

Types of reports

There are five reports:

Report↕	Description↕	Use cases↕
Invoice summary	Structured the same way as the Invoice summary report, but with a date range selection.	High-level view of charges over a custom date range (e.g., quarterly data).
Invoice detail	Structured the same way as the Invoice detail report, but with a date range selection.	Differentiate fees paid to Zonos vs charges paid on your behalf, granular view of itemized fees for any custom date range (e.g., quarterly data).
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.
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.	Audit landed cost calculations

Export a report

Structure

Available information (summarized)

↕	Invoice summary↕	Invoice detail↕	Orders↕	Orders with item details↕	Landed cost breakdown↕
Customer information and tracking number
Charges per order
Duties, taxes, and fees details
Item details (Name, SKU, HS Code, etc.)
Order item count and weight

All available fields

Below are the available fields in each report:

Field↕	Invoice summary↕	Invoice detail↕	Orders↕	Orders with item details↕	Landed cost breakdown↕
`accountName`
`orderAdditionalTariffLines`
`addressLine1`
`addressLine2`
`amount`
`amountDutiesTaxesFees`
`amountItem`
`amountTotal`
`brokerage`
`city`
`country`
`countryCode`
`countryOfOrigin`
`countryOfOriginSource`
`currency`
`currencyCode`
`customerName`
`customsDescription`
`description`¹
`detailType`
`dimensionsUnit`
`discountOrder`
`dueDate`²
`dutyTaxFeeOrder`
`OrderFx`
`guarantee`
`height`
`hsCode`
`hsCodeSource`
`itemWeight`
`itemWeightUnit`
`invoiceDate`³
`invoiceNumber`
`invoiceTotal`
`itemOrder`
`landedCostGuarantee`
`length`
`merchantAdjustment`⁴
`merchantFee`
`merchantSet`
`memo`
`name`⁵
`orderDate`⁶
`orderDuty`
`orderFeeAdvancement`
`orderFeeBrokerage`
`orderFeeCarrier`
`orderFeeShopper`
`orderNumber`⁷
`orderReference`⁸
`orderTax`
`orderTotal`
`orderStatus`
`organizationId`
`other`
`otherCarrierFee`⁹
`packageWeight`
`packageWeightUnit`
`postalCode`
`processing`
`productId`
`quantity`
`referenceNumber`
`shippingOrder`
`shippingService`
`sku`
`state`
`total`
`totalItems`
`totalItemWeight`
`trackingNumber`
`transactionDate`⁶
`transactionFee`
`transactionId`
`transactionType`
`weightUnit`
`width`

¹Description of product ²Date the invoice payment is due. Date and time is based on UTC. ³Date the invoice was created. Date and time is based on UTC. ⁴Includes buffers that the merchant added. ⁵Product name. ⁶Date and time is based on UTC. ⁷Order number in Zonos' system. ⁸Order number in merchant's platform. ⁹Additional carrier fees, including prepayment fees (which the carrier sends on the shipping bill).

Field definitions

Below are the definitions for each field in the reports:

Field↕	Definition↕
`accountName`	Name of the account.
`additionalTarriffLines`	Customs broker fee for managing 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.
`amount`	Monetary value of the line item or charge.
`amountDiscount`	Discount amount for the order.
`amountTotal`	Total amount of the order.
`amountDutiesTaxesFees`	Total amount of duties, taxes, and fees for the order.
`amountShipping`	Shipping amount for the order.
`city`	City of the recipient's address.
`country`	ISO 2-letter country code of the destination.
`countryCode`	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 code for the transaction.
`customerName`	Name of the customer.
`customsDescription`	Description of the item used for customs declarations.
`description`	Description of the product.
`detailType`	Specific type of transaction detail.
`destinationCountry`	Country code of the destination.
`dimensionsUnit`	Unit of measurement (e.g., inches, cm).
`discountOrder`	Discount amount applied to the order.
`dueDate`	Date the invoice payment is due. Date and time is based on UTC.
`dutyTaxFeeOrder`	Total amount of duties, taxes, and fees for the order.
`OrderFx`	Foreign exchange rate applied to the transaction.
`guarantee`	The total landed cost amount Zonos calculated and will guarantee.
`height`	Height of the item.
`hsCode`	Harmonized System (HS) code assigned to the item.
`hsCodeSource`	Source of the HS code classification.
`invoiceDate`	Date the invoice was created. Date and time is based on UTC.
`invoiceNumber`	Unique identifier for the invoice.
`invoiceTotal`	Total amount of the invoice.
`itemOrder`	Item cost for the order.
`itemWeight`	Weight of the item in the order.
`itemWeightUnit`	Unit of measurement for the item's weight (e.g., kg, lb).
`landedCostGuarantee`	Cost for the landed cost guarantee service (includes both $ and % components of pricing).
`length`	Length of the item.
`memo`	Additional notes or information about the order.
`merchantFee`	Fee amount charged to the merchant.
`name`	Name of the product.
`orderDate`	Date the order was placed. Date and time is based on 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.
`orderNumber`	Order number in Zonos' system.
`orderReference`	Order number in merchant's platform.
`orderStatus`	Current status of the order.
`orderTax`	Tax amount for the order.
`orderTotal`	Total amount for the order.
`other`	Additional charges or fees not categorized elsewhere.
`packageWeight`	Total weight of the package.
`packageWeightUnit`	Unit of measurement for package weight.
`postalCode`	Postal or ZIP code of the recipient's address.
`processing`	Expected method for processing customs payment: either `TAX_REMITTANCE` or `CUSTOMS_BILL`.
`productId`	Unique identifier for the product.
`quantity`	Number of units of the item in the order.
`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.
`total`	Total amount for the transaction.
`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`	Fee amount for processing the transaction.
`transactionId`	Unique identifier for the transaction.
`transactionType`	Type of transaction (e.g., ORDER, REFUND, CHARGE).
`weightUnit`	Unit of measurement for weight values.
`width`	Width of the item.

Use cases

View quarterly data (charges within a certain time frame)

Invoices are available for each invoice period; however, you may need to reconcile all charges within the last quarter, for example. Rather than downloading multiple invoice reports, you can easily download one report with the desired date range.

Download the Invoice summary or Invoice detail CSV reports, depending on your preference for granularity.
1. Go to Dashboard → Reports.
2. Click Generate next to Invoice summary.
3. Select the date range starting at the beginning of the quarter and ending at the end of the quarter.
4. Click Generate report.
Sum up total (column U in Invoice summary).

Differentiate fees paid to Zonos vs charges paid on your behalf

The Invoice summary report helps you distinguish between fees paid directly to Zonos and charges that Zonos pays on your behalf (like duties and taxes).

Here's how to access and interpret the report:

Go to Dashboard → Reports
Click Generate next to the Invoice summary report
Select your preferred date range
Click Generate report

Key fields explained

These fields are particularly important for understanding how duties, taxes, and fees are handled:

Field↕	Definition↕
`dutyTaxFeeOrder`	The amount quoted to customers at checkout for duties and taxes. This amount can be subsidized or buffered by you.
`guarantee`	The original amount that Zonos calculated and guarantees to pay for duties and taxes on your behalf. This is what Zonos will invoice you for.
`total`	The total amount charged to you, which includes: - The guaranteed amount for duties and taxes - Zonos transaction fees - Any other applicable fees

Example breakdown of a standard order

Item value: $278.83
Shipping: $38.81
Duties/taxes quoted to customer (dutyTaxFeeOrder): $134.90.
Amount guaranteed by Zonos (guarantee): $134.90
Transaction fee: $8.60
Total charged to you: $143.50

In this example, Zonos is collecting $134.89 from the customer for duties and taxes, guaranteeing to pay $134.90 on your behalf, and charging you an $8.60 transaction fee. The total amount charged to you ($143.50) covers both the guaranteed amount and the transaction fee.

Example 1: 50% Duty/Tax Subsidy

Item value: $278.83
Shipping: $38.81
Actual duties/taxes due: $134.89
Merchant subsidy (50%): -$67.45
Duties/taxes quoted to customer (dutyTaxFeeOrder): $67.44
Amount guaranteed by Zonos (guarantee): $134.89
Transaction fee: $8.60
Total charged to you: $143.49

In this example, the merchant is paying 50% of the duties and taxes. The customer only pays $67.44, while Zonos charges the merchant the full guaranteed amount ($134.89) plus the transaction fee. The merchant absorbs the difference between what the customer paid and what Zonos charges.

Example 2: 10% Duty/Tax Increase

Item value: $278.83
Shipping: $38.81
Actual duties/taxes due: $134.89
Merchant increase (10%): +$13.49
Duties/taxes quoted to customer (dutyTaxFeeOrder): $148.38
Amount guaranteed by Zonos (guarantee): $134.89
Transaction fee: $8.60
Total charged to you: $143.49

In this example, the merchant is charging 10% more for duties and taxes. The customer pays $148.38, while Zonos guarantees $134.89. The merchant keeps the difference ($13.49) and pays the transaction fee.

Reconcile invoices / Match a single invoice to the withdrawal on your bank statement

To reconcile a single invoice:

Go to Dashboard → Invoices.
Click on the invoice.
Click Export transactions in the top right of the page.
Click Invoice summary from the dropdown.

This method ensures accuracy by avoiding potential discrepancies from date-range reports. Using the date range in this scenario could result in an incomplete report, as there could be adjustments outside of the date range that apply to the invoice.

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 Order CSV report.
1. Go to Dashboard → Reports.
2. Click Generate next to the Orders report.
3. Select the date range that you want to verify.
4. 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.

Book a demo