The Scenario
You are a compliance officer at a financial institution. The KYC review deadline is Friday. You have an Excel workbook with 400 passport series and numbers on the KYC Intake tab from customer applications this month.
Regulation requires each passport to be checked against the FMS invalid document registry before an account is opened. Your team has been doing this manually — one at a time on the MVD website — and it is taking three days per batch.
The bad version of this week:
- Open the FMS registry check website
- Type the series and number from row 1
- Read the result, go back to the workbook, type "Valid" or "Invalid" in column C
- Repeat 400 times
- Make a typo at row 183 and validate the wrong passport number
- Approve an application that should have been flagged.
The fast version is one prompt and the validation column is filled before your first meeting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the passport columns on the KYC Intake tab, calls DaData's FMS validation endpoint for every row, and writes a clear status back.
Open the SheetXAI sidebar and type:
For each row in the KYC Intake tab, use DaData to validate the passport using the series in column A and the number in column B. Write "Valid" into column C if the passport is valid according to the FMS registry, and "Invalid" if it is listed as invalid. Write "ERROR" in column C if DaData cannot process the record.
SheetXAI reads both columns, calls DaData for each row, and writes the validation status back. All 400 passports, checked against the official FMS registry, in one pass.
What You Get
Column C filled with a validation status for every application on the KYC Intake tab:
- "Valid" — passport is in good standing in the FMS registry
- "Invalid" — passport is listed as invalid or revoked
- "ERROR" — the series/number combination could not be checked
Invalid rows are explicit and filterable. A single filter on column C shows every application that needs escalation.
What If the Data Is Not Quite Ready
KYC intake data from manual forms has inconsistencies. SheetXAI handles them in the same prompt.
When passport series and numbers are combined in one column
Some intake forms captured them together in column A, like "4512 123456."
For each row in the KYC Intake tab, parse column A to extract the 4-digit series and 6-digit number. Use DaData to validate the passport and write "Valid" or "Invalid" into column B. Write "PARSE ERROR" if the format cannot be split correctly.
When you need the check date recorded for the audit trail
Compliance requires that the date of each validation is recorded alongside the result.
For each row in the KYC Intake tab, validate the passport using DaData (series in column A, number in column B) and write the validation status into column C. Write today's date into column D for every row processed successfully.
When some rows were already validated in a prior run
A previous batch covered the first 200 rows. You only need to process the new ones.
Skip any row in the KYC Intake tab where column C already contains "Valid" or "Invalid." For all other rows, use DaData to validate the passport using columns A and B and write the result into column C.
When you need the validation results plus a compliance committee summary
The committee wants pass/fail counts for the monthly compliance report.
Validate all 400 passports in the KYC Intake tab using DaData and write "Valid," "Invalid," or "ERROR" into column C. Then create a new sheet called "Compliance Summary" with: total validated, count of Valid results, count of Invalid results, count of ERRORS, and the percentage of applications cleared for account opening.
The pattern: the validation run and the compliance summary come from the same prompt.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Russian passport data, then ask it to run DaData validation on the series and number columns. The DaData integration is included in every SheetXAI plan. For related workflows, see how to enrich supplier INNs in Excel or the DaData in Excel overview.