Bank Reconciliation Variance Analyzer
Systematically identify and resolve bank statement discrepancies with structured variance analysis
What You Can Do
You can transform bank reconciliation from a tedious search into a systematic investigation process. This skill helps you categorize variances by type, conduct targeted root cause analysis, and build comprehensive documentation that satisfies audit requirements. You'll prioritize investigation resources efficiently and resolve reconciling items with confidence.
Features
Classify discrepancies into timing differences, processing delays, GL errors, banking errors, and other root causes for targeted investigation
Apply systematic investigation techniques based on variance type to identify underlying issues quickly
Prioritize reconciling items by age and materiality to focus on high-impact variances first
Generate audit-ready support documentation that tracks investigation steps and resolution evidence
Verify transaction recording accuracy on both sides of the reconciliation systematically
Distinguish normal timing differences from anomalies that require deeper investigation
Create comprehensive records of variances, investigation findings, and resolution actions for auditor review
Example Output
Example 1: Processing Delay Resolution
Variance: $15,000 check recorded in GL on 3/28 but not appearing on bank statement as of 4/5
Investigation Output:
- Category: Timing Difference — Outstanding Check
- Root Cause: Standard mail float (5-7 business days)
- Supporting Evidence: Check #4521 cleared bank on 4/8 (within normal range)
- Resolution: Remove from reconciliation after bank clearance; no GL adjustment needed
Example 2: Reconciliation Error Discovery
Variance: $3,200 deposit shown on bank statement but missing from GL
Investigation Output:
- Category: GL Recording Error
- Root Cause: Deposit recorded to wrong GL account (1200 instead of 1010)
- Supporting Evidence: Bank reference #DEP-0847; GL entry audit trail shows posting to operating account
- Resolution: Reverse incorrect entry; post to correct cash account; update deposit procedures
- Audit Documentation: Date corrected, approver, business reason
What's Included
- SKILL.md instruction file: Complete variance analysis methodology and investigation framework
- Variance categorization matrix: Reference guide mapping discrepancy types to root causes and investigation techniques
- Bank reconciliation worksheet template: Structured format for recording variances, investigation steps, and resolutions
- Aging report checklist: Tool for prioritizing reconciling items by age and materiality
- Audit documentation template: Standard format for recording investigation findings and resolution evidence
Who It's For
- Staff accountants managing month-end bank reconciliations
- Accounting managers overseeing reconciliation processes and quality control
- Internal auditors validating cash control procedures and reconciliation support
- Finance teams supporting audit fieldwork with comprehensive documentation
- Controllers establishing reconciliation standards for multiple bank accounts or entities
Best For
- Resolving reconciling items older than 10 business days
- Investigating variances exceeding materiality thresholds
- Preparing audit-ready reconciliation support documentation
- Conducting root cause analysis on recurring reconciliation issues
- Establishing reconciliation procedures for new accounts or subsidiaries
You might also like
You can systematically prepare tax provisions that survive audit scrutiny by calculating current and deferred tax impacts, reconciling effective tax rates from statutory to reported amounts, and documenting uncertain tax positions with FIN 48 support. The skill guides you through multi-jurisdictional tax exposure analysis and helps you create audit-ready workpapers with clear audit trails for quarterly (10-Q) and annual (10-K) financial statement filings.
by eryet
You can analyze large volumes of transaction data to identify telltale fraud patterns that perpetrators use to obscure illegal activity—including threshold splitting, timing manipulations, circular routing, and gradual escalation tactics. Claude processes multiple detection lenses simultaneously (temporal anomalies, network patterns, statistical outliers, behavioral shifts) and synthesizes findings into coherent fraud narratives with quantified exposure estimates and litigation-ready evidence chains.
by eryet
You can analyze transaction clusters to identify layering, placement, and integration schemes using proven AML methodologies. Claude applies typology frameworks to suspicious fund flows, cross-border movements, and beneficiary ownership chains—transforming raw transaction flags into regulatory-grade narratives that justify SAR escalation and withstand compliance audits.
by eryet
You can execute structured compliance audits that map regulatory requirements to operational controls, test control effectiveness with documented evidence, quantify compliance risk exposure, and track remediation progress with clear accountability. The framework produces audit findings in regulatory-acceptable format, transforming ad-hoc reviews into defensible procedures that satisfy internal audit standards (IIA) and regulatory expectations.
by eryet
You can analyze insurance claim files to uncover fraud indicators by synthesizing evidence from policyholder statements, medical/repair records, financial documents, and prior claims history. This skill helps you reconstruct timelines, identify inconsistencies and impossibilities, recognize suspicious financial patterns, and build defensible fraud conclusions suitable for claims adjustment, litigation support, or settlement negotiations. Transform raw claim data into an evidence hierarchy distinguishing confirmed facts, supported inferences, and investigative leads requiring further development.
by eryet
You can allocate indirect costs (administration, utilities, depreciation, maintenance) across clinical and non-clinical departments using activity-based costing (ABC) and traditional allocation methodologies. This skill helps you calculate precise allocation rates, model reimbursement scenarios, validate cost driver selections, and document allocation methods for compliance—enabling data-driven decisions on service line profitability, pricing strategies, and payer contract negotiations.
by eryet
You can systematically classify and track expenses against specific restricted grants and donations, reconcile fund balances with compliance verification, and generate accurate financial statements that separate restricted and unrestricted funds. This skill prevents audit failures, donor relation damage, and grant non-compliance penalties by ensuring every restricted fund expense is properly documented, allowable under grant terms, and traceable to donor/grantor requirements.
by eryet
You can rapidly design, document, and validate internal control frameworks aligned with COSO 2013, SOX compliance, and audit standards. Claude helps you map business processes to control objectives, create control matrices linking risks to preventive and detective controls, generate control narratives for auditors, and identify control gaps for remediation planning—compressing what typically takes 200+ annual hours into a fraction of that time while improving control design quality.
by eryet