DOCS

For Checkout users

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.

Types of reports 

There are several reports available:

ReportDescriptionUse cases
Payout summaryStructured 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 detailStructured 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 summaryStructured 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 detailStructured 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.
OrdersDisplays 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 detailsLists 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 breakdownAudit landed cost calculations with duty, tax, and fee breakdowns.Periodic tax filing, 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
Payout summaryPayout detailOrdersOrders with item detailsLanded cost breakdown
Each order has its own row
Each order charge has its own row
Available information (summarized)
Payout summaryPayout detailOrdersOrders with item detailsLanded 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
All available fields

Below are the available fields in each report:

FieldPayout summaryPayout detailOrdersOrders with item detailsLanded 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
Field definitions

Below are the definitions of each field in the reports:

FieldDefinition
accountNameName of the account with Zonos.
orderAdditionalTarriffLinesCustoms broker fee for the additional work required to manage and declare multiple tariff (HS) codes in the customs entry.
addressLine1First line of the recipient's address.
addressLine2Second line of the recipient's address, if applicable.
advancementFee charged for advancing duties and taxes on behalf of the customer.
amountMonetary value of the line item or charge.
amountDiscountDiscount amount for the order.
amountDutiesTaxesFeesAmount of duties, taxes, and fees applied to the order.
amountItemAmount for a single item.
amountShippingAmount of shipping on an order.
amountTotalAmount for a single item multiplied by the quantity of the item.
arrivalDateDate the payout arrived in the merchant's bank account.
brokerageBrokerage fee associated with customs clearance.
cityCity of the recipient's address.
countryISO 2-letter country code of the destination.
countryOfOriginCountry where the item was manufactured or produced.
countryOfOriginSourceSource of the country of origin information.
currencyCurrency used for the transaction, in ISO 3-letter format.
customerNameName of the customer placing the order.
customsDescriptionDescription of the item used for customs declarations.
descriptionDescription of the product.
detailTypeDetailed reason for the amount on the order (e.g., tax, brokerage fee, currency conversion fee, merchant processing fee, etc.)
dimensionsUnitUnit of measurement (e.g., inches, cm).
discountOrderDiscount applied to the order.
dutyOrderDuty amount applied to the order.
dutyTaxFeeOrderTotal amount of duties, taxes, and fees applied to the order.
fxForeign exchange rate applied to the transaction.
guaranteeAmount guaranteed by Zonos.
heightHeight of the item.
hsCodeHarmonized System (HS) code assigned to the item.
hsCodeSourceSource of the HS code classification.
itemWeightWeight of the item in the order.
itemWeightUnitUnit of measurement for the item's weight (e.g., kg, lb).
itemOrderCost of the items in the order.
landedCostGuaranteeCost for the landed cost guarantee service (includes both $ and % components of pricing).
lengthLength of the item.
merchantAdjustmentAdjustments that the merchant has entered/requested, typically via rules.
merchantSetAny buffers/adjustments set by the merchant.
merchantFeePortion of the Checkout cost attributed to payment processing costs.
memoAdditional notes or details regarding the payout or transaction.
nameName of the product.
orderDateDate the order was placed, in UTC.
orderDutyDuty amount for the order.
orderFeeAdvancementAdvancement fees for the order.
orderFeeBrokerageBrokerage fees for the order.
orderFeeCarrierCarrier fees for the order.
orderFeeShopperFees charged to the shopper.
OrderFxForeign exchange rate applied to the transaction.
orderNumberUnique identifier for the order in Zonos' system.
orderReferenceAdditional reference number associated with the order, typically the order number in the ecommerce platform.
orderStatusCurrent status of the order.
orderTaxTax amount for the order.
orderTotalTotal amount for the order.
otherMiscellaneous charge or adjustment related to the transaction.
otherCarrierFeeAdditional fees charged by the shipping carrier, including prepayment fees (which the carrier sends on the shipping bill).
packageWeightTotal weight of the package.
packageWeightUnitUnit of measurement for the package's weight.
payoutDateDate the payout was issued to the merchant.
payeeEntity receiving the payment.
payorEntity responsible for making the payment.
payoutNumberMatches the Stripe payout id.
payoutTotalTotal amount paid out to the merchant.
postalCodePostal or ZIP code of the recipient's address.
processingExpected method for processing customs payment: either TAX_REMITTANCE (remit via tax ID) or CUSTOMS_BILL (pay a customs bill).
productIdUnique identifier for the product.
quantityNumber of units of the item in the order.
referenceNumberReferences the Payout number (e.g., po_1QcGXkGbPRfOWRJBfaa90A1A) or Invoice number (e.g., 584184EA-0000).
settledThe amount of the transaction that settled to the merchant.
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.
taxOrderTax amount applied to the order.
totalThe order total (the total the shopper paid).
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.
transactionFeeIncludes cost for Checkout services, including fraud protection. Does not include payment processing costs.
transactionIdUnique identifier for the transaction.
transactionTypePossible 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.
weightUnitUnit of measurement for weight values.
widthWidth 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).

  1. Go to Dashboard → Payouts.
  2. Select the payout.
  3. 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.

  1. Go to Dashboard → Reports.
  2. Click Generate next to the Payout summary report.
  3. 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.
  4. Click Generate report.
  5. 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)
1234ORDER105.8080.7658.96-58.96-7.38-9.88169.30
1234ORDER_REFUND (would show ORDER_CANCEL if this order had not shipped)-105.80-80.76-58.9658.967.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 and shippingOrder minus Zonos' fees (transactionFee and merchantFee). This amount, the sum of columns M through T, matches the settled 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 and guarantee cancel each other out (net to 0).
  • When the order was refunded, Zonos refunded the shopper and took back the itemOrder and shippingOrder amounts from the merchant. Zonos also refunded the transactionFee but kept the merchantFee 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:

  1. Go to Dashboard → Reports.
  2. Click Generate next to the Payout detail report.
  3. Select your preferred date range.
  4. 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) to MERCHANT. 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) to ZONOS. 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)
0123ITEMMERCHANTSHOPPER96.85
0123SHIPPINGMERCHANTSHOPPER30.63
0123MERCHANT_PROCESSINGZONOSMERCHANT-6.72
0123TRANSACTION_PERCENTZONOSMERCHANT-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:

  1. Go to Dashboard → Reports.
  2. Click Generate next to the report you want.
  3. Select the date range starting at the beginning of the quarter and ending at the end of the quarter.
  4. 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:

  1. Download the Orders 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

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?