Independent editorial resource
Anexo 24 vs. Pedimento (Data Stage) Reconciliation Tool
Compare two CSV, TSV, or pipe-delimited extracts (Anexo 24 inventory ledger vs. customs broker pedimentos or SAT Data Stage Tables 501/551) locally in your browser to spot missing pedimentos and value variances.
Load two CSV, TSV, or pipe-delimited (|) files—such as your Anexo 24 Temporary Entries extract and your Customs Broker Pedimento log or SAT Data Stage Table 501 / 551—select the matching key column(s) and numeric column, and this tool immediately separates records that exist only in File A, only in File B, or differ in value or UMT quantity.
100% Client-Side Privacy: All parsing and reconciliation happen locally inside your web browser. Your files are never uploaded to any server, never stored, and never leave your computer.
1. Load or Paste Your Two Extracts
2. Map Key Columns & Value/Quantity Column
The Primary Key identifies the same record across both files (typically the 7-digit Pedimento Number, or Pedimento + 8-Digit Tariff Fraction). The Value Column is the numeric field you want to reconcile (Commercial Value in MXN, Customs Value, or UMT Quantity).
How to Diagnose Common Variances
| Observed Variance | Most Common Root Cause in US-Mexico Operations |
|---|---|
| Key exists ONLY in File B (Data Stage / Broker) | Orphan air/courier import cleared at Monterrey, Guadalajara, or AICM airport without notifying the border compliance team, or month-end consolidated pedimento cutoff gap. |
| Key exists ONLY in File A (Anexo 24 / ERP) | Warehouse recorded a goods receipt in SAP/Oracle before the customs broker actually modulated and paid the pedimento at the border, or a superseded pedimento that was replaced by an R1 rectification. |
| Value or Quantity differs on the same Pedimento + Fraction | UMC-to-UMT conversion mismatch, broker gross-weight pallet proration, exchange rate timing difference, or comparing Total Customs Value (Valor Aduana) on one side against Commercial Value (Valor Comercial MXN) on the other. |
Next Step
Found unexplained gaps between Data Stage, ERP, and Anexo 24?
Read our step-by-step protocol for auditing SAT Data Stage Tables 501, 551, and 557, or contact our editorial desk to discuss how to structure a historical reconstruction.
Browser tool output is for internal diagnostic screening and does not replace official SAT records.
Write to us about the content
If the result does not match what you expected, or your case does not fit any of the findings, write to us.
This form does not send your file. What you loaded stays on your machine and never leaves your browser.
Educational & Pre-Audit Screening Tool
This browser-based utility compares two files that you supply and highlights arithmetic or population differences. It does not constitute legal, tax, customs, or accounting advice, does not connect to SAT servers, and does not certify compliance. Always verify findings with your licensed Mexican customs broker or trade compliance advisor.