Business Compliance Tools
Find a tool

Validate a KYC remediation spreadsheet

Map one local CSV or XLSX, find missing identifiers, dates, owners, statuses and inconsistent records, then export a corrected evidence set.

UKEUUSFinancial crime
Choose a guidance setChoose a guidance set belowAbout 12 minutes4 working filesStart this tool

Launch price verified. Checkout remains closed until the final payment and recovery tests pass. Entries and files stay in this browser. Sources reviewed 31 July 2026.

Inspect a real output

Built from fictional sample information using the same exporter as the tool.

UK KYC remediation report sampleEU KYC remediation report sampleEU corrected KYC workbook sampleUS KYC remediation report sampleUS corrected KYC workbook sample

What’s included

Correct the working queue

Keep accepted browser corrections in an editable workbook.

  • Corrected XLSX workbook

Review validation evidence

Inspect every structural and consistency finding with the cited source basis.

  • Cited validation PDF

Retain the run record

Preserve structured findings, corrections, review decisions and source assumptions.

  • Structured validation JSON
  • Sources and assumptions record
View every output and format
  • Corrected XLSX workbook
  • Cited validation PDF
  • Structured validation JSON
  • Sources and assumptions record

Who this tool is for

KYC operations, remediation teams and compliance leads managing a structured customer-review queue. Turn an existing spreadsheet into a consistent remediation queue with recorded corrections, review decisions and source hashes.

Supported use

  • One CSV or XLSX file using a supported UK, EU or US working route
  • Column mapping, blanks, invalid dates, duplicates and explicit cross-field consistency checks
  • Browser corrections, manual review notes and a source-bounded evidence set

Have ready

  • The applicable UK, EU or US working route
  • One CSV or XLSX remediation spreadsheet
  • Confirmed mapping for the supported core columns
  • Corrections or human review outcomes for findings that cannot be resolved mechanically

Needs separate review

  • Identity verification, sanctions or PEP screening and customer risk decisions
  • Whether remediation is complete or a customer relationship should continue
  • Unsupported files, fields or business rules that are not observable in the supplied spreadsheet

How it works

  1. Open the spreadsheetChoose the guidance route and read one CSV or XLSX locally.
  2. Map the columnsConfirm which source column supplies each supported remediation field.
  3. Validate and resolveReview blanks, invalid dates, duplicates and inconsistencies, then record corrections or review notes.
  4. Export the queueDownload the corrected workbook, validation report, structured result and sources record.

Where does this task apply?

Choose the guidance set this tool should use. The interface and outputs stay in English.

Choose one before you start.

Choose the jurisdiction above to open the correct tool.The fields, clock and source record change with the selected guidance set.

What this tool checks

The scope stays narrow so the result is clear and reproducible.

  • Maps one local CSV or XLSX into the supported UK, EU or US working fields.
  • Finds blanks, invalid dates, duplicates and explicit cross-field inconsistencies without uploading customer rows.
  • Creates a complete remediation queue while leaving identity, sanctions, PEP and risk decisions to people.

From official material to a working record

Official material sets the basis

Official sources describe due-diligence and record-keeping context relevant to the selected route.

The tool prepares the operational record

The validator checks one remediation spreadsheet consistently and creates a corrected queue with a reproducible evidence record.

Official sources stay visible

Each supported check shows its jurisdiction, source title, source version and review date beside the result. Unsupported cases are rejected rather than estimated.

View this product's official sources

Questions before you use the tool

Scope, files, evidence and browser-local handling.

Does this tool perform KYC or sanctions screening?

No. It checks the structure and consistency of the supplied spreadsheet. It does not verify identities, screen lists or assign customer risk.

Can I correct values in the browser?

Yes. Supported findings can be corrected before the evidence set is exported, and the correction record is retained.

Is customer data uploaded?

No. Spreadsheet rows, mappings, corrections and review notes remain in this browser.

Which formats are supported?

The tool reads one CSV or XLSX and exports a corrected XLSX, cited PDF, structured JSON and sources and assumptions record.

Check the remediation queue

Open the spreadsheet, confirm the mapping and resolve observable findings before keeping the corrected evidence set.

Open the KYC validator