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 receive a comprehensive framework for evaluating diversified passive income streams, assessing client risk profiles, and recommending portfolio structures that maximize income while maintaining alignment with financial objectives. The skill analyzes income sources (real estate, dividends, bonds, peer lending, digital assets), models cash flow projections, evaluates tax efficiency, and provides data-driven strategy recommendations ranked by performance potential.
by eryet
You can systematically evaluate payment timing decisions across your vendor base by modeling discount capture opportunities against working capital requirements. The skill analyzes vendor payment terms, your cash flow constraints, and strategic vendor priorities to generate prioritized payment schedules that maximize savings while maintaining adequate liquidity and protecting critical supplier relationships.
by eryet
Create comprehensive, personalized wealth strategies that align client assets, goals, and risk tolerance. You can assess complex financial situations, generate multi-faceted investment and tax strategies, and produce professional recommendations that incorporate goal timelines, asset allocation frameworks, and tax efficiency considerations. The skill helps you move beyond generic advice to deliver actionable, client-specific wealth plans backed by structured analysis.
by eryet
You can generate professionally formatted SVG color palettes by providing a theme name, source URL, or specific hex codes. Claude researches color standards, extracts values from web sources, and organizes 4-7 swatches from dark to light with an anchor brand color at center. Each swatch includes click-to-copy hex codes and hover effects for easy reference.
by eryet
You can trace financial transactions across multiple accounts and entities, document complete chain-of-custody for audit evidence, identify fraud indicators and anomaly patterns, and construct defensible audit conclusions that satisfy both forensic rigor and legal admissibility requirements. This skill provides structured protocols for adversarial skepticism, hostile cross-examination preparation, and quantification of losses or damages with transparent methodologies.
by eryet
You can design and implement activity-based cost allocation models tailored to healthcare facility structures, using clinically-relevant cost drivers like patient encounters, bed-days, and procedure minutes. Claude helps you establish allocation methodologies, calculate departmental profitability by service line, and generate cost-to-charge ratios needed for payer contracts and Medicare compliance reporting.
by eryet
You can upload aging data from your accounting system and Claude will systematically categorize invoices by delinquency bucket, identify high-risk accounts with payment pattern analysis, explain why balances are aging, and generate prioritized collection strategies with account-specific context. This transforms static aging reports into actionable recovery plans that help you understand portfolio health and accelerate cash flow.
by eryet
You can systematically process court orders, IRS levies, and child support withholdings by validating order authenticity, calculating accurate deductions accounting for state exemptions and federal limits, sequencing multiple garnishments by legal priority, and generating compliant documentation for courts and creditors. This skill handles the highest-risk payroll functions—reducing legal exposure, audit risk, and manual processing time while ensuring every deduction meets federal and state regulations.
by eryet