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
This skill automates the complex work of calculating material price, quantity, and usage variances; labor rate and efficiency variances; and overhead variances across products, departments, and time periods. You input production data and standard cost tables, and Claude processes the variance calculations, organizes findings by significance, and generates detailed narratives explaining root causes of deviations. This transforms hours of spreadsheet manipulation into a structured analysis package ready for management review and variance committee meetings.
by eryet
You can rapidly cross-reference transaction patterns, revenue data, and economic activity against state-specific nexus thresholds to identify which states trigger filing obligations. The skill flags compliance gaps across physical presence, economic nexus, click-through, and affiliate nexus types, helping you determine filing requirements, quantify retroactive exposure risk, and prioritize registration in new states as clients expand.
by eryet
You can upload aging reports and AR subledger data to Claude, which analyzes bucket distributions, reconciles balances to the general ledger, flags anomalies and aging pattern irregularities, and generates documented collection strategies. Claude produces prioritized customer lists, DSO benchmarking analysis, allowance adequacy assessments, and compliance-ready audit schedules—transforming raw AR data into actionable cash flow optimization strategies.
by eryet
You can systematically validate employee payroll records, cross-check tax withholding calculations against current tax brackets, verify regulatory compliance across federal/state/local requirements, and flag anomalies that could trigger penalties—all before executing payment runs. This reduces processing time by 40-60% while catching errors that manual spreadsheet reviews typically miss, working across ADP, Workday, Gusto, and manual payroll systems.
by eryet
You systematically extract financial red flags from claim submissions, construct causal narratives linking evidence to fraud conclusions, and quantify potential loss exposure. This skill helps you distinguish between legitimate claim variations and fraud indicators, enabling you to generate investigation summaries defensible in litigation, settlement negotiations, or Special Investigation Unit (SIU) presentations.
by eryet
This skill helps you audit nexus comprehensively by analyzing physical presence rules, economic thresholds, affiliate connections, and marketplace facilitator statutes across all 50 states and relevant localities. You'll document nexus triggers specific to your client's business model—whether they're selling through marketplaces, using drop-shipping, hiring remote employees, or expanding operations. The result is an actionable filing calendar and remediation strategy that minimizes compliance gaps and protects against substantial back-tax assessments, penalties, and interest.
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 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