Financial Statement Analysis & Reconciliation for Controllers
Analyze financial statements, identify variances, and prepare audit-ready reconciliations
What You Can Do
You can upload financial statements and account data to Claude, which systematically analyzes line items, identifies material variances, and generates detailed reconciliation memos with full audit trails. Claude helps you document variance explanations, test statement consistency across balance sheet and income statement, and prepare controller-ready supporting schedules—while you retain final approval authority over all published numbers and account balances.
Features
Automatically identify material changes (>5% or $X threshold) across periods and drill into root causes with supporting calculations
Generate detailed reconciliation memos explaining balance sheet and account movements with narrative explanations for auditor review
Analyze subsidiary or department statements, identify intercompany eliminations, and document consolidation adjustments
Create supporting schedules and journal entry narratives with complete documentation trails meeting institutional control standards
Cross-check balance sheet, income statement, and cash flow statement ties with flagged discrepancies for investigation
Structured templates for analyzing specific account types (receivables aging, inventory valuation, fixed asset reconciliation, accrual analyses)
Draft narrative explanations of significant financial changes for management discussion and analysis sections
Example Output
Input: Balance sheet showing Cash increased from $2.5M to $3.2M; Accounts Receivable decreased 12%; Debt decreased 8%
Output:
CASH - $700K Increase (28% variance)
• Operating activities: +$450K (improved collections)
• Financing activities: +$250K (debt repayment per note X)
• Investing activities: -$200K (equipment purchases)
→ Conclusion: Favorable variance driven by debt reduction; investigate sustainability of AR collections improvement
ACCOUNTS RECEIVABLE - $185K Decrease (12% variance)
• Reconciliation to aging schedule: ✓ Matches
• DSO improvement: 42 days → 38 days (within normal range)
• Allowance recalculation: $22K (2.2% of AR per historical loss rates)
→ Recommendation: Obtain customer correspondence explaining early payments
What's Included
- SKILL.md instruction file with methodology for controller-level analysis:
- Variance Analysis Template: Standardized format for documenting material changes with threshold settings
- Reconciliation Memo Framework: Controller-ready document structure with audit trail sections
- Account Analysis Checklist: Guidelines for 8+ account types (cash, receivables, inventory, fixed assets, debt, equity)
- Multi-entity Consolidation Worksheet: Structure for subsidiary analysis and intercompany elimination documentation
- Audit Readiness Checklist: Verification steps before finalizing statements
Who It's For
- Controllers — Managing month-end close processes and auditor interactions
- Assistant Controllers — Supporting financial statement preparation and variance investigations
- Accounting Managers — Preparing detailed account reconciliations and supporting schedules
- Financial Reporting Specialists — Documenting MD&A narratives and consolidation adjustments
- Internal Auditors — Reviewing statement consistency and testing account balances
Best For
- Month-end and quarter-end financial close processes with 15+ line item analyses
- Variance investigations explaining balance sheet or income statement changes >5%
- Reconciliation memo preparation for external auditor review and documentation
- Multi-subsidiary consolidation analysis with intercompany elimination calculations
- Account analysis and supporting schedule preparation (receivables aging, inventory valuation, fixed asset reconciliation)
- Management discussion and analysis (MD&A) narrative drafting for significant financial changes
- Statement consistency testing across balance sheet, income statement, and cash flow
You might also like
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 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
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 automatically detect attendance discrepancies across time-tracking data, classify exceptions by root cause (system errors, policy violations, legitimate absences), and generate audit-ready documentation. This skill establishes decision frameworks that handle routine exceptions efficiently while flagging complex cases for human review, reducing payroll processing time by 60-70% while improving accuracy and reducing compliance liability.
by eryet
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