Complex Financial Reconciliation Pipeline with Error Handling

Design an end-to-end automated reconciliation workflow that can process multiple financial data sources (bank statements, transaction logs, accounting records) with robust error detection and self-healing capabilities. The system should automatically identify discrepancies greater than 0.5% between sources, generate detailed exception reports, and trigger notification workflows to specific financial team members based on error severity and monetary threshold. Include comprehensive logging, retry mechanisms, and the ability to trace individual transaction anomalies through a complete audit trail.