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 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
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 systematically prepare, validate, and generate accurate 1099-NEC and 1099-MISC forms while ensuring full IRS compliance. The skill handles vendor categorization based on payment type, tracks filing thresholds automatically, identifies when CORRECTED forms are needed, and verifies Tax ID Numbers—eliminating manual errors and compressing your year-end compliance timeline by 40-60%. You'll streamline the complex distinction between form types and manage exemptions, multiple legal entities, and Form 1096 transmittal requirements effortlessly.
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