For finance and AP teams

US routing and account number CSV validator

Find routing-number checksum errors, missing account numbers, duplicate routing/account pairs and spreadsheet damage. Get a report that identifies the source row, affected field and next action — without guessing lost digits.

Try US CSV preview Check one routing number free

Free five-row US preview

CSV or TSV only. Preview: first five US rows, sample file up to 256 KB. Paid report: every row within your order limit, file up to 5 MB. Checks do not establish account existence, ownership or ACH/Fedwire eligibility.

Download a synthetic US sample CSV

Choosing a file does not upload it. Only use the columns needed for the audit.

Full-file report pricing

No file or row values are saved or sent to AI providers. US checks are deterministic. For CSV exports, import routing/account columns as Text in Excel: opening a CSV directly can strip leading zeros. US account checks use a digits-only CSV input policy and the 17-character ACH field limit, not a bank-specific account format. This is not a NACHA-file validator.

What we check on every row

Routing structure and ABA checksumNine digits, supported prefix and check digit. Missing leading zeros are flagged, never reconstructed.
Spreadsheet damageScientific notation, decimal exports, missing values and non-digit identifiers. Account existence and bank-specific format are not checked.
Duplicate routing/account pairsReview accounts shared across rows and suppliers with multiple pairs. A shared account is a review flag, not proof of fraud.
Actionable CSV reportSource row numbers, issue codes, affected fields, next actions and original selected bank values. Formula-like cells are escaped.

Sample report

Illustrative synthetic US rows. OK means the stated checks passed, not that an account exists.

Source rowRouting NumberAccount NumberStatusFinding
2110000000000123456789OK structureNot an account-existence or ownership check
371124821076841393430FailRouting length: a leading zero may be lost. Re-export the original as text.
41100000007.684139343E+10FailScientific notation: do not guess the original digits.
Up to 1,000 suppliers
$99
  • One file, one-time payment
  • Instant CSV report, up to 3 uploads
  • File checked in memory, not stored
Order audit — $99
Up to 5,000 suppliers
$149
  • One file, one-time payment
  • Instant CSV report, up to 3 uploads
  • File checked in memory, not stored
Order audit — $149

How it works

  1. Pay securely with Stripe.
  2. Choose IBAN or US routing/account mode and upload a CSV with an optional supplier reference.
  3. Download the report right away and fix the flagged rows before the payment run.

How do I validate routing numbers in a CSV file?

Upload a UTF-8 CSV or TSV with routing and account columns. Map custom headers if needed, then preview the first five US rows free. The full-file report checks every row within the paid order limit and identifies source rows, affected fields and next actions.

Is this an ACH or NACHA file validator?

It checks routing/account columns in a spreadsheet export, not native NACHA records, SEC codes, batch totals, addenda or payment authorization. A CSV structure pass does not certify an ACH file or establish ACH/Fedwire eligibility.

Can a routing number be valid while the account number is wrong?

Yes. ABA structure and checksum are separate from account existence and ownership. Account checks here detect missing, non-digit, damaged or oversized CSV values; they do not confirm a bank-specific format, balance or account holder.

Why did Excel remove the leading zero from my routing number?

Excel can interpret identifiers as numbers and strip leading zeros or export scientific notation. Keep routing and account columns as Text. The report flags suspected damage but never guesses replacement digits; recover the original values from your trusted source.

Does a duplicate routing and account pair mean fraud?

No. Duplicate pairs and suppliers with multiple pairs are review flags. Check the supplier record and intended payment destination before changing data; the audit does not make a fraud determination.

Are supplier bank files saved or sent to AI?

No. Uploaded files are checked in memory and are not persisted or sent to AI providers. Send only a supplier reference and the bank fields needed for the audit. Column mapping templates contain column names, not row values.

What is free and what requires payment?

The first-five-row US structure preview is free for sample files up to 256 KB. Existing one-time audit offers provide a full row-by-row CSV report for up to 1000 or 5000 rows, within the 5 MB upload limit. The displayed order allowance applies; it is separate from Pro API quotas.

Testing an integration instead?

Keep supplier-file checks separate from generated test data. Use US QA generation for fixtures or Stripe ACH test accounts and webhook QA for documented test outcomes and an offline checker. For European supplier files, use the IBAN/BIC audit.

The audit checks bank data, not account ownership or balances. A clean report does not guarantee that a payment will be accepted.