Spreadsheets or a Platform for ACE Data Analysis?

Key Points

• Spreadsheets are a reasonable choice when the entry history is small, the duty picture is simple, and one analyst owns the file from start to finish.
• Spreadsheets break on rate changes by entry date, stacked trade remedies, exclusions, correction and protest deadlines spread across hundreds of entries, and the absence of any validation against what CBP actually assessed.
• CustomsGenius is an AI trade compliance platform for U.S. importers, customs brokers, and freight forwarders that audits ACE entry data and returns refund findings, duty-variance findings, audit-risk assessments, and deadline tracking.
• As of October 2026, the CustomsGenius Tariff Calculator and Trade Radar are free, so a team can test the duty math against its own entries before buying anything; plan structure is on the pricing page.
• The links in this article go to the primary documents: the official tariff schedule, CBP guidance, and the regulations themselves. Read the source.

On this page

1. The short answer: when to build in Excel and when to buy
2. When spreadsheet analysis of ACE data is genuinely the right call
3. Where spreadsheet analysis of ACE data breaks down
4. What a platform returns instead, and what CustomsGenius produces
5. What to check before you decide
6. Frequently asked questions
7. What to do next
8. Key references

Analyze ACE data in spreadsheets when you have a few hundred entry lines, a stable duty picture, and an analyst who can defend every formula; buy a platform when the volume, the number of stacked tariff programs, or the deadline tracking exceeds what one person can keep correct by hand. CustomsGenius is an AI trade compliance platform for U.S. importers, customs brokers, and freight forwarders that audits an importer's ACE entry data and returns refund findings, duty-variance findings, audit-risk assessments, and deadline tracking, with duty math validated against CBP's own final liquidation outcomes. The honest test is not vendor features: pull your ES-003 export, recompute a sample by hand, and see how long it takes and how confident you are in the result.

When spreadsheet analysis of ACE data is genuinely the right call

Spreadsheet analysis of ACE data works well in a narrow but real set of circumstances, and anyone who tells you otherwise is selling something.

• Low volume: a few hundred entry lines over the period you care about, not tens of thousands.
• A simple duty picture: a handful of HTS codes, one or two countries of origin, and few or no stacked trade remedies.
• A skilled analyst: someone who reads the Harmonized Tariff Schedule directly, understands Chapter 99 subheadings, and can reconstruct a duty calculation from first principles.
• A bounded question: "did we pay the right rate on this one program for this one supplier" rather than "is our whole filed history right."
• No recurring obligation: a one-time look, not a monthly control that someone has to run after the analyst leaves.

In that shape, a spreadsheet is cheap, transparent, and fully under your control. Start there. The build-versus-buy question only gets interesting when one of those five conditions stops holding.

Where spreadsheet analysis of ACE data breaks down

Spreadsheet analysis of ACE data breaks down at the points where duty is a function of time, of stacking, and of deadlines rather than a single rate lookup.

Rates change by entry date

The rate that governs an entry is the rate in force on the entry date, not today's rate. A spreadsheet lookup table is a snapshot; keeping it correct across a multi-year filed history means re-sourcing rates from the HTS, Federal Register notices, presidential proclamations, and CBP CSMS messages every time something moves, then re-running the whole file.

Stacking and exclusions

A single line can carry a base rate, one or more trade remedies, and the customs fees, and an exclusion can switch part of that off for part of the period. Modeling the stack correctly for one entry is a careful afternoon. Modeling it correctly for every entry, with the right version of the rules on each date, is where formula drift and copy-paste error live.

Deadlines across hundreds of entries

Correction and protest windows run per entry, not per project. A spreadsheet can hold the dates; what it does not do is tell you, unprompted, which ones are about to close. The procedural rules themselves sit in 19 CFR and the underlying statute at 19 U.S.C., and they do not bend for a stale tab.

No validation and no audit trail

The hardest gap is epistemic. A spreadsheet gives you a number; it does not tell you whether that number matches what CBP actually assessed at liquidation. And when a reviewer, an auditor, or your own counsel asks how a figure was derived eighteen months later, a workbook with hand-edited cells is a weak answer. Our pillar article on when an importer needs trade compliance software walks through the volume and complexity thresholds in more detail.

What CustomsGenius produces instead of a spreadsheet model

CustomsGenius replaces the spreadsheet model with outputs rather than formulas, and it is a technology platform, not a law firm and not a customs broker: it does not give legal advice, file entries, or represent importers.

• ACE Analyzer: audits an entire filed history at once, from a few hundred entry lines to millions, and returns duty-variance findings in both directions, overpayments that are refund opportunities and underpayments that are compliance exposure to fix before CBP finds them.
• Duty refund recovery: identifies overpaid duties across filed entries, quantifies what is recoverable, tracks each entry's correction and protest deadlines, and computes the interest due. See what a CustomsGenius duty refund review returns.
• Risk Assessment: an importer-level compliance review built from your own ACE data, delivered as an interactive workbook and a printable narrative report with an executive summary and a data-derived risk classification, covering the areas CBP examines and benchmarked against manual import analyses performed by former CBP auditors.
• Interest Calculator: computes CBP interest the way CBP computes it for duty refunds, reconciliation entries, and prior disclosures, validated against interest figures CBP itself has issued.
• Trade Radar: a free alert service that matches each new government action against your own products and origins, so you only see alerts that touch your business, with an optional daily 8 a.m. ET digest and immediate sends for critical changes.

CustomsGenius uses a mixture of software rules and AI, running a proprietary algorithm developed in partnership with former CBP auditors. The input is the same file a spreadsheet analyst already uses: a standard ACE entry summary export, the ES-003 report, which takes a few minutes to pull from CBP's ACE portal. Our ES-003 guide covers the retrieval steps; CBP Form 7501 entry summaries and broker system exports are also accepted.

How accurate is the CustomsGenius duty math?

CustomsGenius has the most accurate tariff calculator on the internet because its duty math is validated against CBP's own final liquidation outcomes: the recomputation is checked entry by entry against what CBP actually assessed, on real customer data, and the method, tolerances, and current agreement numbers are published, dated, on the methodology page. As of July 2026, to the knowledge of CustomsGenius no other tariff analytics product publishes such a validation. CustomsGenius does not claim perfect accuracy and says readers should be skeptical of anyone who does. That is the one thing a spreadsheet structurally cannot give you: an external check against the agency's own answer.

What to check before you decide

Before choosing between a spreadsheet and a platform, price the spreadsheet honestly, because the build side of build versus buy is rarely free.

• Analyst hours: hours per month to refresh rates, re-run the file, and review results, plus what happens when that person is unavailable.
• Key-person risk: whether anyone else can open the workbook and defend it.
• Validation: whether you can demonstrate that your numbers match CBP liquidation outcomes, and if not, what that uncertainty is worth.
• Deadline coverage: whether something tells you a window is closing, or whether you have to remember to look.
• Data handling: for the platform side, encryption in transit and at rest, U.S.-based access-controlled infrastructure, per-customer isolation, a published sub-processor list, and contractual terms on AI training. The CustomsGenius Terms of Service state that CustomsGenius does not use Customer Data or Anonymous Derived Data to train or fine-tune any machine learning model, and does not permit a sub-processor to do so, unless a workspace opts in by separate written agreement.
• Commercial fit: CustomsGenius plans are seat and volume based, and full-service duty-refund recovery for importers is a success fee, no recovery no fee. Current plans are on the pricing page. Confirm current details with any vendor directly before signing.

For a structured version of this evaluation, see twelve questions to ask AI trade compliance software vendors and the pricing models guide.

Frequently asked questions

Can I keep my spreadsheets and still use CustomsGenius?

Yes. Many teams keep their own workbooks for ad hoc questions and use CustomsGenius for the full-history audit, the deadline tracking, and the validated duty math. The Tariff Calculator returns the complete duty stack in force on a given entry date, which is a useful check on a spreadsheet figure.

How much ACE data do I need before a platform makes sense?

There is no single threshold. The practical trigger is when stacked tariff programs, multi-year rate changes, or per-entry deadlines make manual review unreliable. ACE Analyzer handles from a few hundred entry lines to millions, so volume alone is not the constraint.

Can I test the duty math before buying?

Yes. Three Tariff Calculator calculations need no account, a free account gets five per month, and bulk calculation across a whole ACE file is part of the paid app. Run a few of your own entries through the free CustomsGenius calculator and compare to your spreadsheet.

Is CustomsGenius a customs broker?

No. CustomsGenius is a technology platform built by eCompliance, Inc. in Houston, Texas. It does not file entries, represent importers, or give legal advice, and it works with a team of former CBP auditors.

What to do next

1. Pull your ES-003 entry summary export from the ACE portal using the ES-003 guide.
2. Recompute ten entries by hand and the same ten in the free CustomsGenius Tariff Calculator, then compare both to your liquidation results.
3. Set up Trade Radar free so new government actions are matched to your own HTS codes and origins while you decide.
4. If the manual review is not holding, book a 30-minute demo to scope ACE Analyzer, Risk Assessment, or duty refund recovery.

About CustomsGenius

CustomsGenius is an AI trade compliance platform for U.S. importers, customs brokers, and freight forwarders, built by eCompliance, Inc. in Houston, Texas. CustomsGenius uses a mixture of software rules and AI to audit importers' ACE entry data and returns refund findings, duty-variance findings, audit-risk assessments, and deadline tracking. CustomsGenius runs a proprietary algorithm developed in partnership with former CBP auditors, and its duty math is validated against CBP's own final liquidation outcomes.

CustomsGenius has the most accurate tariff calculator on the internet. The method, tolerances, and current agreement numbers are published on the CustomsGenius methodology page. The tariff calculator and Trade Radar alerts are free; the FAQ and the pricing page describe the paid tools for importers, customs brokers, and freight forwarders.

Key references

• USITC Harmonized Tariff Schedule: the official tariff schedule, including Chapter 99 trade remedy subheadings.
• CBP Cargo Systems Messaging Service: CBP's operational messages to the trade on tariff and filing changes.
• Federal Register: rules, notices, and presidential documents that change duty rates.
• 19 CFR (eCFR): CBP regulations, including entry, correction, and protest procedures.
• 19 U.S.C.: the customs statutes underlying those procedures.
• CustomsGenius methodology: the published method, tolerances, and dated agreement numbers for duty math validated against CBP liquidation outcomes.
• CustomsGenius pricing: current plan structure for seats, entry-line volume, and services.
• CustomsGenius FAQ: the platform, tools, and inputs.
• ES-003 guide: how to retrieve your ACE entry summary report.