Trimtabist

The US Trade Ledger — every US container gateway, every partner country, every month — and what each one actually paid at the border.

What America actually pays at the border

Everyone argues about what the tariff rules say. Every month, US Census publishes the duty dollars collected on every product from every origin. Divide by the value of the goods and you get the rate that really happened — through every exclusion, exemption, court order and reroute. Six pictures; every claim links to the record; any code can be looked up at the end. Latest month: 2026-06.

1 · The rulebook cannot be added up

The statutory rate on an upholstered chair from China (HS 9401.61) is Free. On top of it sit the trade-war overlays in force — several at 100% each — and no honest arithmetic turns that stack into a number. The receipts do: 41.1% of dutiable value, 2026-06. Exclusions, effective dates and scope are the entire difference between the rulebook and the bill, and only the receipt knows them.

Modification: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property an…
measure 9903.91.03 · Federal Register citation
+100%
Modification: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property an…
measure 9903.91.08 · Federal Register citation
+100%
Modification and Proposed Modification of Section 301 Action: China's Targeting of the Maritime, Logistics,…
measure 9903.91.14 · Federal Register citation
+100%
Modification: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property an…
measure 9903.91.02 · Federal Register citation
+50%
Modification: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property an…
measure 9903.91.05 · Federal Register citation
+50%
Modification: China's Acts, Policies and Practices Related to Technology Transfer, Intellectual Property an…
measure 9903.91.07 · Federal Register citation
+50%
Except for goods loaded onto a vessel at the port of loading and in transit on the final mode of transit be…
measure 9903.01.64 · from the current schedule
+35%
Implementation of Additional Duties on Products of the People's Republic of China Pursuant to the President…
measure 9903.01.63 · Federal Register citation
+34%
Action Pursuant to Section 301: China's Acts, Policies, and Practices Related to Technology Transfer, Intel…
measure 9903.88.02 · Federal Register citation
+25%
What was actually collected on the chair 41.1%

Measures in force for Chinese-origin goods, by add-on rate — they do not sum, and which apply to this exact code is defined in Chapter 99 notes (several annexes are PDFs we disclose as unmapped). The accent number is the measured composite. Look up any code with tariff_lookup.

2 · The staircase

Chinese goods paid 2.71% of their value at the border in June 2017. Nine years later the line has three landings and one cliff: 7.37% by December 2018, a long plateau, 47.92% in 2025-05, and 21.69% today.

48 24 2017-01: 3 %2017-02: 3 %2017-03: 2 %2017-04: 3 %2017-05: 3 %2017-06: 3 %2017-07: 3 %2017-08: 3 %2017-09: 3 %2017-10: 3 %2017-11: 2 %2017-12: 2 %2018-01: 3 %2018-02: 3 %2018-03: 2 %2018-04: 2 %2018-05: 3 %2018-06: 3 %2018-07: 4 %2018-08: 4 %2018-09: 4 %2018-10: 6 %2018-11: 6 %2018-12: 7 %2019-01: 7 %2019-02: 7 %2019-03: 6 %2019-04: 7 %2019-05: 7 %2019-06: 9 %2019-07: 10 %2019-08: 9 %2019-09: 12 %2019-10: 11 %2019-11: 11 %2019-12: 12 %2020-01: 13 %2020-02: 13 %2020-03: 10 %2020-04: 9 %2020-05: 9 %2020-06: 9 %2020-07: 9 %2020-08: 10 %2020-09: 10 %2020-10: 9 %2020-11: 9 %2020-12: 9 %2021-01: 11 %2021-02: 11 %2021-03: 12 %2021-04: 11 %2021-05: 12 %2021-06: 12 %2021-07: 12 %2021-08: 12 %2021-09: 11 %2021-10: 11 %2021-11: 10 %2021-12: 10 %2022-01: 11 %2022-02: 11 %2022-03: 11 %2022-04: 12 %2022-05: 12 %2022-06: 10 %2022-07: 11 %2022-08: 11 %2022-09: 10 %2022-10: 10 %2022-11: 11 %2022-12: 11 %2023-01: 11 %2023-02: 12 %2023-03: 10 %2023-04: 11 %2023-05: 11 %2023-06: 11 %2023-07: 11 %2023-08: 10 %2023-09: 10 %2023-10: 10 %2023-11: 10 %2023-12: 11 %2024-01: 11 %2024-02: 11 %2024-03: 11 %2024-04: 11 %2024-05: 11 %2024-06: 11 %2024-07: 11 %2024-08: 11 %2024-09: 10 %2024-10: 10 %2024-11: 11 %2024-12: 11 %2025-01: 11 %2025-02: 13 %2025-03: 26 %2025-04: 39 %2025-05: 48 %2025-06: 40 %2025-07: 40 %2025-08: 40 %2025-09: 38 %2025-10: 38 %2025-11: 32 %2025-12: 31 %2026-01: 32 %2026-02: 30 %2026-03: 23 %2026-04: 22 %2026-05: 22 %2026-06: 22 % 22 2017-012021-092026-06
Duty collected as % of ALL Chinese goods' value, monthly. Peak 47.92% in 2025-05; 21.69% in 2026-06. Convention: includes de-minimis code 999995; excluding it raises recent figures ~1.2 points.

3 · It was never only the rate — it was the coverage

In 2017, more than half of every dollar of Chinese goods entered duty-free. By mid-2025, seven cents did. The 2025 wave raised the rate — and it also ended the exemptions. The second half of that sentence is missing from most accounts.

94 47 2017-01: 44 %2017-02: 45 %2017-03: 40 %2017-04: 42 %2017-05: 43 %2017-06: 42 %2017-07: 43 %2017-08: 43 %2017-09: 41 %2017-10: 40 %2017-11: 37 %2017-12: 38 %2018-01: 43 %2018-02: 44 %2018-03: 39 %2018-04: 41 %2018-05: 42 %2018-06: 44 %2018-07: 45 %2018-08: 45 %2018-09: 44 %2018-10: 56 %2018-11: 57 %2018-12: 64 %2019-01: 61 %2019-02: 64 %2019-03: 57 %2019-04: 60 %2019-05: 59 %2019-06: 57 %2019-07: 57 %2019-08: 57 %2019-09: 60 %2019-10: 56 %2019-11: 56 %2019-12: 59 %2020-01: 65 %2020-02: 68 %2020-03: 58 %2020-04: 59 %2020-05: 61 %2020-06: 59 %2020-07: 59 %2020-08: 60 %2020-09: 59 %2020-10: 54 %2020-11: 52 %2020-12: 53 %2021-01: 63 %2021-02: 64 %2021-03: 64 %2021-04: 63 %2021-05: 65 %2021-06: 64 %2021-07: 64 %2021-08: 67 %2021-09: 60 %2021-10: 60 %2021-11: 58 %2021-12: 57 %2022-01: 64 %2022-02: 63 %2022-03: 62 %2022-04: 66 %2022-05: 66 %2022-06: 59 %2022-07: 64 %2022-08: 62 %2022-09: 54 %2022-10: 58 %2022-11: 60 %2022-12: 61 %2023-01: 63 %2023-02: 66 %2023-03: 59 %2023-04: 65 %2023-05: 65 %2023-06: 62 %2023-07: 62 %2023-08: 61 %2023-09: 56 %2023-10: 56 %2023-11: 58 %2023-12: 64 %2024-01: 66 %2024-02: 67 %2024-03: 66 %2024-04: 66 %2024-05: 64 %2024-06: 66 %2024-07: 65 %2024-08: 65 %2024-09: 59 %2024-10: 56 %2024-11: 62 %2024-12: 66 %2025-01: 65 %2025-02: 76 %2025-03: 92 %2025-04: 93 %2025-05: 91 %2025-06: 93 %2025-07: 94 %2025-08: 94 %2025-09: 94 %2025-10: 94 %2025-11: 93 %2025-12: 92 %2026-01: 92 %2026-02: 89 %2026-03: 83 %2026-04: 82 %2026-05: 81 %2026-06: 81 % 81 2017-012021-092026-06
Share of Chinese import value that was dutiable at all: 41.8% (2017-06) → 92.6% (2025-06) → 80.9% (2026-06).

4 · The wall was always there — it pointed at the poor

Before a single trade-war tariff, Cambodia's goods paid 13.7% at the US border. Germany's paid 1.5%. The old schedule taxed apparel-and-footwear origins at roughly ten times the rate it taxed machinery-and-car origins — and the trade war is the first thing in decades to narrow that gap, by raising the top. The ruled study →

Cambodia 13.6% → 21%
Vietnam 7.4% → 6.4%
China 2.7% → 21.7%
India 2.3% → 9.1%
Japan 1.7% → 9.9%
Germany 1.5% → 8.9%
Thailand 1.3% → 5.4%
Canada 0.1% → 2.9%
Mexico 0.1% → 3.4%

Effective burden by origin, June 2017 → 2026-06, sorted by 2017. The ranking partially inverts at the top.

5 · The rerouting prize, priced

In June 2017 Chinese goods paid 4.7 points less at the border than Vietnamese goods. By June 2025 they paid 31 points more. That swing is what a Vietnamese label became worth — the price tag on the diversion this ledger has measured in tonnes.

48 24 2017-01: 3 %2017-02: 3 %2017-03: 2 %2017-04: 3 %2017-05: 3 %2017-06: 3 %2017-07: 3 %2017-08: 3 %2017-09: 3 %2017-10: 3 %2017-11: 2 %2017-12: 2 %2018-01: 3 %2018-02: 3 %2018-03: 2 %2018-04: 2 %2018-05: 3 %2018-06: 3 %2018-07: 4 %2018-08: 4 %2018-09: 4 %2018-10: 6 %2018-11: 6 %2018-12: 7 %2019-01: 7 %2019-02: 7 %2019-03: 6 %2019-04: 7 %2019-05: 7 %2019-06: 9 %2019-07: 10 %2019-08: 9 %2019-09: 12 %2019-10: 11 %2019-11: 11 %2019-12: 12 %2020-01: 13 %2020-02: 13 %2020-03: 10 %2020-04: 9 %2020-05: 9 %2020-06: 9 %2020-07: 9 %2020-08: 10 %2020-09: 10 %2020-10: 9 %2020-11: 9 %2020-12: 9 %2021-01: 11 %2021-02: 11 %2021-03: 12 %2021-04: 11 %2021-05: 12 %2021-06: 12 %2021-07: 12 %2021-08: 12 %2021-09: 11 %2021-10: 11 %2021-11: 10 %2021-12: 10 %2022-01: 11 %2022-02: 11 %2022-03: 11 %2022-04: 12 %2022-05: 12 %2022-06: 10 %2022-07: 11 %2022-08: 11 %2022-09: 10 %2022-10: 10 %2022-11: 11 %2022-12: 11 %2023-01: 11 %2023-02: 12 %2023-03: 10 %2023-04: 11 %2023-05: 11 %2023-06: 11 %2023-07: 11 %2023-08: 10 %2023-09: 10 %2023-10: 10 %2023-11: 10 %2023-12: 11 %2024-01: 11 %2024-02: 11 %2024-03: 11 %2024-04: 11 %2024-05: 11 %2024-06: 11 %2024-07: 11 %2024-08: 11 %2024-09: 10 %2024-10: 10 %2024-11: 11 %2024-12: 11 %2025-01: 11 %2025-02: 13 %2025-03: 26 %2025-04: 39 %2025-05: 48 %2025-06: 40 %2025-07: 40 %2025-08: 40 %2025-09: 38 %2025-10: 38 %2025-11: 32 %2025-12: 31 %2026-01: 32 %2026-02: 30 %2026-03: 23 %2026-04: 22 %2026-05: 22 %2026-06: 22 % 22 2017-012021-092026-06
China, burden on all goods.
13 7 2017-01: 8 %2017-02: 8 %2017-03: 7 %2017-04: 6 %2017-05: 6 %2017-06: 7 %2017-07: 8 %2017-08: 8 %2017-09: 7 %2017-10: 7 %2017-11: 7 %2017-12: 7 %2018-01: 8 %2018-02: 8 %2018-03: 6 %2018-04: 8 %2018-05: 8 %2018-06: 8 %2018-07: 9 %2018-08: 7 %2018-09: 7 %2018-10: 8 %2018-11: 7 %2018-12: 7 %2019-01: 8 %2019-02: 7 %2019-03: 6 %2019-04: 7 %2019-05: 7 %2019-06: 7 %2019-07: 8 %2019-08: 6 %2019-09: 7 %2019-10: 7 %2019-11: 6 %2019-12: 6 %2020-01: 7 %2020-02: 6 %2020-03: 6 %2020-04: 5 %2020-05: 5 %2020-06: 5 %2020-07: 5 %2020-08: 5 %2020-09: 5 %2020-10: 5 %2020-11: 5 %2020-12: 5 %2021-01: 5 %2021-02: 5 %2021-03: 5 %2021-04: 5 %2021-05: 5 %2021-06: 5 %2021-07: 5 %2021-08: 5 %2021-09: 5 %2021-10: 5 %2021-11: 4 %2021-12: 4 %2022-01: 5 %2022-02: 5 %2022-03: 5 %2022-04: 5 %2022-05: 5 %2022-06: 4 %2022-07: 5 %2022-08: 5 %2022-09: 5 %2022-10: 5 %2022-11: 4 %2022-12: 5 %2023-01: 5 %2023-02: 5 %2023-03: 4 %2023-04: 4 %2023-05: 4 %2023-06: 4 %2023-07: 4 %2023-08: 5 %2023-09: 4 %2023-10: 4 %2023-11: 3 %2023-12: 4 %2024-01: 4 %2024-02: 4 %2024-03: 4 %2024-04: 4 %2024-05: 3 %2024-06: 4 %2024-07: 4 %2024-08: 4 %2024-09: 4 %2024-10: 4 %2024-11: 3 %2024-12: 4 %2025-01: 4 %2025-02: 3 %2025-03: 3 %2025-04: 5 %2025-05: 7 %2025-06: 9 %2025-07: 9 %2025-08: 10 %2025-09: 13 %2025-10: 12 %2025-11: 12 %2025-12: 13 %2026-01: 12 %2026-02: 12 %2026-03: 7 %2026-04: 7 %2026-05: 7 %2026-06: 6 % 6 2017-012021-092026-06
Vietnam, same measure, same scale question — the gap between these two charts is the prize for rerouting. See the cargo side: /atlas/list3-tariff-diversion, and the label question ruled at /asked/vietnamese-labels.

6 · The national bill, and the retreat

$2.8B a month in 2017-01. $29.7B at the 2025-10 peak. $21.3B in 2026-06 — the bill has fallen a quarter from its top, and the fall is the least-reported part of the whole episode. Why the retreat sorted by legal authority: the ruled study →

30 15 2017-01: 3 $B/mo2017-02: 2 $B/mo2017-03: 2 $B/mo2017-04: 3 $B/mo2017-05: 3 $B/mo2017-06: 3 $B/mo2017-07: 3 $B/mo2017-08: 3 $B/mo2017-09: 3 $B/mo2017-10: 3 $B/mo2017-11: 3 $B/mo2017-12: 3 $B/mo2018-01: 3 $B/mo2018-02: 3 $B/mo2018-03: 3 $B/mo2018-04: 3 $B/mo2018-05: 3 $B/mo2018-06: 3 $B/mo2018-07: 4 $B/mo2018-08: 4 $B/mo2018-09: 4 $B/mo2018-10: 6 $B/mo2018-11: 5 $B/mo2018-12: 5 $B/mo2019-01: 5 $B/mo2019-02: 4 $B/mo2019-03: 4 $B/mo2019-04: 5 $B/mo2019-05: 5 $B/mo2019-06: 6 $B/mo2019-07: 6 $B/mo2019-08: 6 $B/mo2019-09: 7 $B/mo2019-10: 7 $B/mo2019-11: 6 $B/mo2019-12: 6 $B/mo2020-01: 6 $B/mo2020-02: 5 $B/mo2020-03: 4 $B/mo2020-04: 4 $B/mo2020-05: 5 $B/mo2020-06: 5 $B/mo2020-07: 6 $B/mo2020-08: 6 $B/mo2020-09: 6 $B/mo2020-10: 6 $B/mo2020-11: 6 $B/mo2020-12: 6 $B/mo2021-01: 6 $B/mo2021-02: 6 $B/mo2021-03: 7 $B/mo2021-04: 6 $B/mo2021-05: 7 $B/mo2021-06: 7 $B/mo2021-07: 7 $B/mo2021-08: 8 $B/mo2021-09: 8 $B/mo2021-10: 8 $B/mo2021-11: 7 $B/mo2021-12: 8 $B/mo2022-01: 8 $B/mo2022-02: 7 $B/mo2022-03: 8 $B/mo2022-04: 8 $B/mo2022-05: 8 $B/mo2022-06: 8 $B/mo2022-07: 8 $B/mo2022-08: 8 $B/mo2022-09: 8 $B/mo2022-10: 7 $B/mo2022-11: 6 $B/mo2022-12: 6 $B/mo2023-01: 7 $B/mo2023-02: 6 $B/mo2023-03: 6 $B/mo2023-04: 6 $B/mo2023-05: 6 $B/mo2023-06: 6 $B/mo2023-07: 6 $B/mo2023-08: 6 $B/mo2023-09: 6 $B/mo2023-10: 6 $B/mo2023-11: 6 $B/mo2023-12: 6 $B/mo2024-01: 6 $B/mo2024-02: 6 $B/mo2024-03: 6 $B/mo2024-04: 6 $B/mo2024-05: 6 $B/mo2024-06: 6 $B/mo2024-07: 7 $B/mo2024-08: 7 $B/mo2024-09: 7 $B/mo2024-10: 7 $B/mo2024-11: 6 $B/mo2024-12: 7 $B/mo2025-01: 7 $B/mo2025-02: 7 $B/mo2025-03: 13 $B/mo2025-04: 20 $B/mo2025-05: 25 $B/mo2025-06: 24 $B/mo2025-07: 28 $B/mo2025-08: 27 $B/mo2025-09: 29 $B/mo2025-10: 30 $B/mo2025-11: 25 $B/mo2025-12: 26 $B/mo2026-01: 26 $B/mo2026-02: 21 $B/mo2026-03: 21 $B/mo2026-04: 20 $B/mo2026-05: 21 $B/mo2026-06: 21 $B/mo 21 2017-012021-092026-06
Regular duties collected on all US imports, monthly. Excludes AD/CVD and fees; assessed at entry, refunds not netted.

7 · The rate, chapter by chapter

Tariffs are set on products, so the honest map is by HS chapter. Duty collected in the latest month, and the burden now against June 2017 — click any chapter for its full story.

Vehicles & parts ch 87 1.1% → 12.5% $3.6B/mo duty Machinery & mechanical appliances ch 84 0.5% → 4.1% $3.1B/mo duty Electronics & electrical equipment ch 85 0.6% → 5% $2.7B/mo duty Articles of iron & steel ch 73 1% → 41.4% $1.3B/mo duty Aluminium ch 76 1% → 41.1% $1.1B/mo duty Knit apparel ch 61 13.8% → 22% $787M/mo duty Optical, medical & precision instruments ch 90 0.4% → 6.4% $690M/mo duty Plastics ch 39 2.7% → 10.5% $665M/mo duty Furniture & bedding ch 94 1% → 13.1% $642M/mo duty Woven apparel ch 62 13% → 22.3% $622M/mo duty Iron & steel ch 72 0.1% → 27.6% $604M/mo duty Footwear ch 64 11.8% → 21.4% $497M/mo duty Rubber & tires ch 40 1.5% → 13.2% $377M/mo duty Toys, games & sports equipment ch 95 0.8% → 10.6% $284M/mo duty Leather articles & handbags ch 42 11.5% → 23.5% $255M/mo duty Copper ch 74 0.4% → 9.8% $235M/mo duty Organic chemicals ch 29 1.5% → 6.7% $211M/mo duty Miscellaneous metal articles ch 83 1.9% → 16.5% $207M/mo duty

Top chapters by duty collected, 2026-06. Burden = duty as % of all import value for the chapter, all origins. Every chapter is queryable: tariff_burden(commodity: "62").

How this is checked

Summed against the US Treasury's own monthly customs receipts across all 114 months: yearly agreement 0.89–1.03, with the two divergences both explainable and disclosed (2025 payment timing; 2026 court-ordered IEEPA refunds, which Treasury nets and we — measuring assessment at entry — do not). Twelve statutory spot checks passed, including German and Japanese cars at exactly their 2.5% MFN rate (one HS line — Germany's overall burden is higher because not everything is a car). Internal reconciliation against Census world-total rows: 0.000% worst deviation, 114/114 months.

Honest limits

Duty figures are regular tariffs as calculated at entry (US Census); they EXCLUDE anti-dumping/countervailing duties and processing fees, and do not reflect later refunds (e.g. the 2026 court-ordered IEEPA refunds).
Two different rates: rate_on_dutiable = duty / dutiable value (the rate actually charged on the portion that paid); burden_pct = duty / total consumption value (what the origin’s goods paid overall). Duty-free entries have dutiable value 0.
Sub-$800 de minimis shipments filed no entries and are invisible before the 2025 rule change for China — a bookkeeping regime break, not a trade event.
HS codes were revised in 2022; long within-code series can break at the boundary.
Scope: imports for consumption, all modes, national level — a different (broader) base than the containerised port-level series elsewhere on this site. The two are never divided into each other.
De minimis convention: special code 999995 (low-value e-commerce entries, duty recorded as zero here because it is collected outside this series) is INCLUDED in burden figures; excluding it raises recent China figures by roughly 1.2 points. State the convention when quoting.

Look up any code

With the ledger connected to your AI: hs_search("your product") finds the code; tariff_lookup(hs, origin) returns the rulebook, the measures with citations, and the collected rate side by side; tariff_burden gives the paid-rate history behind beats 2, 4 and 6; and rulings_search finds how CBP has actually classified a product like yours — the case law behind the code. Raw: /api/tariff · /api/hs-search · the daily paper trail. Series with CSVs: tt010.china.burden · tt010.national.duty. Not customs or legal advice.

In print: “What America actually pays at the border” — Trimtab US Trade Ledger (TT-010 Duty receipts), from US Census imports-for-consumption records, cross-checked against US Treasury receipts — trimtabist.com/tariffs