Bank reconciliation redaction is the removal of banking and personal data from a recon worksheet kept as SOX §404 evidence. The rule asks issuers to test internal control over reporting. anonym.plus marks each identifier on your device, so the matched items stay while the numbers go.
When this applies
A recon worksheet pairs a statement with the ledger, listing full deposit numbers and signers. You strip those before a reviewer opens the workbook.
How anonym.plus handles it
- Open the worksheet in anonym.plus on your device.
- Local OCR reads a scanned statement page.
- The tool flags deposit, routing, and signer data.
- Apply Mask to keep only the last four digits.
- Keep the matched and outstanding-item rows.
- Save the clean workbook locally.
What you need to provide
- The worksheet plus statement (XLSX, PDF, scan).
- An operator: Mask keeps the last four digits.
- Optional allow-list for cleared-item references.
PII & financial identifiers detected
| Category | anonym.plus entity type | Example |
|---|---|---|
| Financial | US_BANK_NUMBER | acct 4412 9087 → ****9087 |
| Names | PERSON | signer Tom Wu → [SIGNER] |
| Identifiers | US_SSN | linked SSN → [SSN] |
| Money | MONEY | balance $52,110 → [AMOUNT] |
| Dates | DATE_TIME | as of 03/31/2026 → [DATE] |
| Org | ORGANIZATION | First Trust → [BANK] |
Compliance achieved
- Supports the control testing named in SOX §404.
- Masks deposit and routing numbers to the last four digits.
- Offline work keeps the workbook off any server.
Anonymize bank reconciliations offline — see plans & start free →
Limitations & cautions
A spaced number on a faint scan can confuse OCR. Verify masked figures on image pages so no full value remains. The tool masks what it detects; check the result.
Frequently asked questions
How much of a bank number may stay?
Usually only the last four digits. The Mask operator keeps those and hides the rest across the workbook.
Will my matched-item rows survive?
Yes. Allow-list cleared-item references. Only banking numbers and signer data are marked.
Is the workbook uploaded?
No. The app runs locally, so the recon stays on your machine.