Customs finance / free audit workbook

One import item. One transparent evidence trail.

A credible duty review joins the historical declaration to the goods actually imported and the law that applied at the time. This CSV is a starting point, not a refund claim.

Download the CDS audit CSV

Research reviewed on 12 November 2026 against the linked official guidance. Illustrations are hypothetical, not client outcomes or professional advice.

Request the right HMRC reports

The Customs Declaration Service reporting tool provides up to 31 consecutive days of data per request from within the previous four years. It normally excludes the latest two days, and HMRC says preparation can take up to 72 hours. An importer generally needs CDS subscription, EORI and linked Government Gateway access; outside reviewers need the importer's permission.

Which source tells you what?
HMRC reportUseful fieldsControl to perform
Import item reportCommodity code, customs value, duty amountGroup comparable items; check for inconsistent treatment
Import tax lines reportCustoms duty, VAT and other amountsSeparate duty from tax that follows a different recovery route
Import header reportDeclaration-level invoice, value and transport informationReconcile against invoices and original entry totals
Export item reportExport recordsUse only if a separate export-history question requires it

The reporting window is not the claim window: HMRC's normal overpaid import duty limit is three years, subject to exceptions. Track each MRN and entry date separately. See the claim route guide before considering CDS, C285 or a VAT-return adjustment.

Use the downloadable register at item level

The CSV workbook gives columns for MRN, item number, EORI, import date, description, original code and origin, customs value, duty paid, proposed treatment, source evidence, reviewer and status. It includes one visibly fictional example row. Replace the example with authorised internal records; do not paste sensitive declarations into a public form.

Worked example: when a spreadsheet says £1,000

Hypothetical entry — not a real claim

One imported line has a customs value of £50,000 and 5% duty of £2,500. Someone suggests the correct rate may have been 3%, or £1,500. The £1,000 difference is a hypothesis until dated specifications, code, origin, measures, legal grounds, deadline and original duty actually paid have been verified. It may turn out there is no overpayment.

Three controls a serious review needs

  1. Keep the original entry intact. Proposed values belong in new columns, never overwritten historic fields.
  2. Test a negative example. Find a comparable entry you expect is correct and explain why. This can expose broad spreadsheet errors.
  3. Document the sign-off. Every actionable hypothesis needs an assigned qualified reviewer and a source-supported legal explanation.

Move carefully from data to action

Investigate apparent coding anomalies with our commodity-code guide, origin differences with the trade preference guide, and data access with the CDS reports walkthrough. An importer should authorise any third-party access and establish secure document handling before sharing records.

A specific, documented issue?

Initial enquiries are handled by Pearl Lemon Accountants Ltd. Specialist representation, scope and fees require separate agreement. No saving or repayment is guaranteed.

Request a preliminary assessment