Duties Collected

Duties Collected shows the import duties and regulatory fees you charged customers at checkout, period by period. It matters when you sell across borders.

The Duties Collected report, with its summary cards, chart and table

How It’s Calculated

The cards at the top show Duties Collected, Orders with Duties and Share with Duties for the date range. The chart draws Duties Collected and Additional Fees for each period, as bars, lines or areas. The table has one row per period.

The columns are:

Orders: the number of orders placed.
Orders with Duties: the orders where an import duty was charged at checkout.
Share with Duties: Orders with Duties divided by Orders.
Duties Collected: the duties charged on the orders, as they were placed.
Duties (Current): the duties on the same orders as they stand now, after edits and refunds. The gap to Duties Collected is duty that was removed or refunded later.
Avg Duties per Order: Duties Collected divided by Orders with Duties, so it only counts orders that had a duty.
Additional Fees: regulatory charges that aren’t tax, shipping or duties, such as a state delivery fee.

The length of the date range sets how long a period is:

3 days or less: one row per hour
Up to 93 days: one row per day
Longer: one row per month

Duties aren’t included in Total Sales.

What Counts

Orders count on the day they were placed, in your store’s time zone.
Orders that were canceled, or whose payment was voided or expired, don’t count.
Domestic orders have no duties, and neither do cross-border orders shipped duty-unpaid.
Duties are read from Shopify when an order is imported or updated. An order imported before By the Numbers began recording duties shows none until it’s refreshed from Shopify, so early periods can show too little.
Every amount is in your store’s currency.
Sales Channel, Segment and Filters narrow the report. There’s no comparison period.

What Good Looks Like

There’s no right figure. A store that sells mostly at home has little or none. For a store that sells abroad, the useful signals are the share of orders that carry a duty, and whether Duties (Current) stays close to Duties Collected.

A large gap between those 2 means a lot of duty was removed or refunded after the order.

What to Do About It

A high share with duties: a large part of your sales is cross-border. Open Sales by Country to see where.
A large gap between Collected and Current: look at your refunds with Refunds Processed.

Where to Find It

Duties Collected: open Reports and look under Operations.
Sales by Country: sales by billing country.
Reporting Methodology: how By the Numbers counts sales, and what it leaves out.