DOCS

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:

ReportDescriptionUse cases
Invoice summaryStructured 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 detailStructured 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

COMING SOON

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

COMING SOON

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

COMING SOON

Displays components of landed cost grouped into buckets.Audit landed cost calculations
Export a report
  1. Go to Dashboard -> Reports
  2. Hover over the report you want and click Generate.
  3. Select your preferred date range.
  4. Click Generate report.
Structure
Invoice summaryInvoice detailOrders

COMING SOON

Orders with item details

COMING SOON

Landed cost breakdown

COMING SOON

Each order has its own row
Each order charge has its own row
Available information (summarized)
Invoice summaryInvoice detailOrders

COMING SOON

Orders with item details

COMING SOON

Landed cost breakdown

COMING SOON

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:

FieldInvoice summaryInvoice detailOrders

COMING SOON

Orders with item details

COMING SOON

Landed cost breakdown

COMING SOON

accountName
orderAdditionalTarriffLines
addressLine1
addressLine2
amount
amountItem
amountTotal
brokerage
city
country
countryCode
countryOfOrigin
countryOfOriginSource
currency
customerName
customsDescription
description1
detailType
dimensionsUnit
discountOrder
dueDate2
dutyTaxFeeOrder
OrderFx
guarantee
height
hsCode
hsCodeSource
itemWeight
itemWeightUnit
invoiceDate3
invoiceNumber
invoiceTotal
itemOrder
length
merchantAdjustment4
merchantFee
merchantSet
memo
name5
orderDate6
orderNumber7
orderStatus
orderReference8
organizationId
other
otherCarrierFee9
packageWeight
packageWeightUnit
postalCode
processing
productId
quantity
referenceNumber
shippingOrder
shippingService
sku
state
total
totalItems
totalItemWeight
trackingNumber
transactionDate6
transactionFee
transactionId
transactionType
weightUnit
width

1Description of product 2Date the invoice payment is due. Date and time is based on UTC. 3Date the invoice was created. Date and time is based on UTC. 4Includes buffers that the merchant added. 5Product name. 6Date and time is based on UTC. 7Order number in Zonos' system. 8Order number in merchant's platform. 9Additional 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:

FieldDefinition
accountNameName of the account.
additionalTarriffLinesCustoms broker fee for managing multiple tariff (HS) codes in the customs entry.
addressLine1First line of the recipient's address.
addressLine2Second line of the recipient's address, if applicable.
amountMonetary value of the line item or charge.
amountDiscountDiscount amount for the order.
amountDutiesTaxesFeesTotal amount of duties, taxes, and fees for the order.
amountShippingShipping amount for the order.
cityCity of the recipient's address.
countryISO 2-letter country code of the destination.
countryCodeISO 2-letter country code of the destination.
countryOfOriginCountry where the item was manufactured or produced.
countryOfOriginSourceSource of the country of origin information.
currencyCurrency code for the transaction.
customerNameName of the customer.
customsDescriptionDescription of the item used for customs declarations.
descriptionDescription of the product.
detailTypeSpecific type of transaction detail.
destinationCountryCountry code of the destination.
dimensionsUnitUnit of measurement (e.g., inches, cm).
discountOrderDiscount amount applied to the order.
dueDateDate the invoice payment is due. Date and time is based on UTC.
dutyTaxFeeOrderTotal amount of duties, taxes, and fees for the order.
OrderFxForeign exchange rate applied to the transaction.
guaranteeThe total landed cost amount Zonos calculated and will guarantee.
heightHeight of the item.
hsCodeHarmonized System (HS) code assigned to the item.
hsCodeSourceSource of the HS code classification.
invoiceDateDate the invoice was created. Date and time is based on UTC.
invoiceNumberUnique identifier for the invoice.
invoiceTotalTotal amount of the invoice.
itemOrderItem cost for the order.
itemWeightWeight of the item in the order.
itemWeightUnitUnit of measurement for the item's weight (e.g., kg, lb).
lengthLength of the item.
memoAdditional notes or information about the order.
merchantFeeFee amount charged to the merchant.
nameName of the product.
orderDateDate the order was placed. Date and time is based on UTC.
orderDutyDuty amount for the order.
orderFeeCarrierCarrier fees for the order.
orderFeeShopperFees charged to the shopper.
orderNumberOrder number in Zonos' system.
orderReferenceOrder number in merchant's platform.
orderStatusCurrent status of the order.
orderTaxTax amount for the order.
orderTotalTotal amount for the order.
otherAdditional charges or fees not categorized elsewhere.
packageWeightTotal weight of the package.
packageWeightUnitUnit of measurement for package weight.
postalCodePostal or ZIP code of the recipient's address.
processingExpected method for processing customs payment: either TAX_REMITTANCE or CUSTOMS_BILL.
productIdUnique identifier for the product.
quantityNumber of units of the item in the order.
shippingOrderShipping cost for the order.
shippingServiceShipping method or service used for delivery.
skuStock Keeping Unit (SKU) for the product.
stateState or region of the recipient's address.
totalTotal amount for the transaction.
totalItemsThe total number of items in the order.
totalItemWeightTotal weight of all items in the order.
trackingNumberTracking number for the shipment.
transactionDateDate the transaction was recorded, in UTC.
transactionFeeFee amount for processing the transaction.
transactionIdUnique identifier for the transaction.
transactionTypeType of transaction (e.g., ORDER, REFUND, CHARGE).
weightUnitUnit of measurement for weight values.
widthWidth of the item.

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.

  1. 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.
  2. 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:

  1. Go to Dashboard → Reports
  2. Click Generate next to the Invoice summary report
  3. Select your preferred date range
  4. Click Generate report

Key fields explained

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

FieldDefinition
dutyTaxFeeOrderThe amount quoted to customers at checkout for duties and taxes. This amount can be subsidized or buffered by you.
guaranteeThe original amount that Zonos calculated and guarantees to pay for duties and taxes on your behalf. This is what Zonos will invoice you for.
totalThe 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:

  1. Go to Dashboard → Invoices.
  2. Click on the invoice.
  3. Click Export transactions in the top right of the page.
  4. 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

COMING SOON

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:

  1. 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.
  2. 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

COMING SOON

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:

  1. Go to Dashboard → Reports.
  2. Click Generate next to the Landed cost breakdown report.
  3. Select the date range that matches that of the carrier bill.
  4. Click Generate report.

Was this page helpful?