Act as a senior financial data analyst with 10+ years of experience in automating data workflows. Your task is to design a robust AI-powered data cleansing pipeline for [FINANCIAL INSTITUTION] that processes [RAW DATA SOURCE] (e.g., CSV, Excel, APIs) and outputs standardized, error-free datasets. The solution must: 1) Detect and correct [COMMON DATA ISSUES] (missing values, duplicate entries, format inconsistencies) 2) Apply [VALIDATION RULES] specific to [ACCOUNTING STANDARDS] (GAAP/IFRS) 3) Generate [AUDIT TRAILS] documenting all transformations. Include Python pseudocode for key functions and specify how you'd handle edge cases like [CURRENCY CONVERSION ERRORS]. Prioritize accuracy over speed for regulatory compliance.