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 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 |
- Go to Dashboard -> Reports
- Hover over the report you want and click Generate.
- Select your preferred date range.
- Click Generate report.
Invoice summary | Invoice detail | Orders 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 |
Invoice summary | Invoice detail | Orders 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 |
Below are the available fields in each report:
Field | Invoice summary | Invoice detail | Orders 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 | |||||
description 1 | |||||
detailType | |||||
dimensionsUnit | |||||
discountOrder | |||||
dueDate 2 | |||||
dutyTaxFeeOrder | |||||
OrderFx | |||||
guarantee | |||||
height | |||||
hsCode | |||||
hsCodeSource | |||||
itemWeight | |||||
itemWeightUnit | |||||
invoiceDate 3 | |||||
invoiceNumber | |||||
invoiceTotal | |||||
itemOrder | |||||
length | |||||
merchantAdjustment 4 | |||||
merchantFee | |||||
merchantSet | |||||
memo | |||||
name 5 | |||||
orderDate 6 | |||||
orderNumber 7 | |||||
orderStatus | |||||
orderReference 8 | |||||
organizationId | |||||
other | |||||
otherCarrierFee 9 | |||||
packageWeight | |||||
packageWeightUnit | |||||
postalCode | |||||
processing | |||||
productId | |||||
quantity | |||||
referenceNumber | |||||
shippingOrder | |||||
shippingService | |||||
sku | |||||
state | |||||
total | |||||
totalItems | |||||
totalItemWeight | |||||
trackingNumber | |||||
transactionDate 6 | |||||
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).
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. |
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). |
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. |
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. |
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.
- Go to Dashboard → Reports.
- Click Generate next to Invoice summary.
- Select the date range starting at the beginning of the quarter and ending at the end of the quarter.
- 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
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:
- Download the Order 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
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:
- 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 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.