Audit Certificate
A reproducible, verifiable record of every reconciliation.
What is an Audit Certificate?
An Audit Certificate is a structured document generated at the end of every reconciliation. It contains everything needed to verify and reproduce the results.
The certificate serves as the official record for sign-off, audit trail, and compliance documentation.
Certificate Contents
Dataset Hash
SHA-256 hash of the combined input files. Ensures you can verify the exact files used.
a7f3c9b2e1d8f4567890abcdef123456...Thresholds & Configuration
The exact parameters used for matching.
similarity_threshold: 0.85
date_tolerance_days: 3
semantic_threshold: 0.85Summary Statistics
High-level counts and percentages.
Timestamp
ISO 8601 timestamp of when the audit completed.
2024-01-04T18:30:00.000ZVerification
To verify a certificate:
- Compute the hash of the original input files using SHA-256.
- Compare the hash to the one in the certificate. They must match exactly.
- Re-run the audit with the same files and thresholds.
- Compare results. Match counts and discrepancy lists should be identical.
Reproducibility Promise: If any result differs, either the input files were modified or there's a bug in STET (please report it!).
Why It Matters
Audit Trail
Auditors can verify that reconciliations were performed correctly and with appropriate rigor.
Regulatory Compliance
SOX, MiFID II, and other regulations require documented evidence of reconciliation processes.
Dispute Resolution
If discrepancies arise later, the certificate proves what was known at the time of sign-off.
Process Improvement
Historical certificates help identify patterns and improve reconciliation quality over time.
Boardroom Ready Reporting
STET generates a comprehensive multi-tab Excel workbook designed for immediate presentation to stakeholders.
Tab 1: Certification
Formal cover page.
Contains the cryptographic hash of the audit, the timestamp, and thePASS /ATTENTION REQUIREDstatus.
Tab 2: Executive Summary
High-level dashboard.
Key performance metrics including total transactions processed, accuracy percentages, and discrepancy counts.
Tab 3: Discrepancies
Actionable intelligence.
A detailed, color-coded list of all flagged transactions with their variance amounts and risk categories.
Tab 4: Matched Ledger
Complete audit trail.
The full record of every successfully matched transaction for historical reference.