Upload UN Comtrade Trade Data (JSON)
For each year, upload Reporter JSON and Partner JSON from UN Comtrade. Both PCM+ and PFM+ use the same data. PFM+ price filters are already embedded.
Settings
Default 0.07 (7%). Adjusts CIF→FOB. Used by PCM+.
Include coefficient as editable column per row (Gap formula auto-updates).
HS code depth: AG2 (chapter), AG4 (heading), AG6 (subheading). Choose "All Levels" to compare summaries across all three.
For Partner PFM. Auto-detected if empty.
Default 1%. A gap is immaterial if it is below this % of the sum of both reporter's and partner's declared trade volume for that HS code and partner country.
Default $1,000. Gaps below this amount are always "No action required".
Embedded PFM Filters
Loading embedded data...
No results yet
Upload data and run the calculation.
No results yet
Upload data and run the calculation.
Commodity Price Explorer
Replaces the original price explorer with the full commodity dashboard: quartiles, box plots, reporter detail, regional trends, and import/export comparison.
Search by HS code or commodity name. Prepared price JSON is available for the commodity codes bundled with the commodity dashboard dataset.
Flow
CIF/FOB Adjustment
Adjusts import prices downward to an FOB-equivalent basis. The bar comparison updates immediately.
Tip: the grouped bar chart always shows both imports and exports side by side, while the rest of the dashboard follows the active flow toggle.
No commodity selected
Search for a commodity code and click Explore to load the full price dashboard inside TRIM.
No results yet
Run calculations first to compare PCM+ and PFM+ results.
Explore by HS Code
Enter a 6-digit HS code. Available after running calculations (AG6 level).
PFM Misinvoicing Legend
■ Underinvoiced (price < Q1)
■ Overinvoiced (price > Q3)
■ Within normal bounds (Q1–Q3)
No code selected
Enter an AG6 code and click Explore. Requires PCM+ and/or PFM+ results at AG6 level.
Explore by Partner Country
Enter a country name or 3-letter ISO code. Available after running calculations.
No country selected
Enter a country name or ISO code and click Explore. Requires PCM+ and/or PFM+ results at AG6 level.
Re-upload Estimation Spreadsheets
Select PCM+ or PFM+ and upload generated Excel files to recreate charts and summaries without re-running the calculation.
Export Gaps XLSX
📤
Export Gaps XLSX
Import Gaps XLSX
📥
Import Gaps XLSX
Summary XLSX (optional)
📊
Summary XLSX (optional)
How to use
Value Unit
⚠ Preliminary Estimates — Plus-Element Investigation Required
These results are preliminary first-step estimates, not final figures.
Run PCM+ calculations (or re-upload PCM+ results) first to generate the Potential IFFs summary.
Flow-Code Triage
UN Comtrade JSON
📂
UN Comtrade JSON