Financial Statement Reconciliation & Audit Preparation
Map GL accounts to financial statements and generate audit-ready reconciliations
What You Can Do
You can automate the reconciliation of general ledger accounts to financial statement line items, enabling Claude to map accounts, identify reconciling items and variances, and generate audit-trail documentation. Claude analyzes GL data to flag anomalies, quantify discrepancies, and create exception reports that accelerate investigation and resolution—turning hours of manual cross-referencing into systematic, documented processes that withstand external audit scrutiny.
Features
Automatically link general ledger accounts to balance sheet and income statement line items using structured hierarchies
Identify reconciling items, quantify variances, and flag accounts requiring investigation with root cause analysis
Generate formatted reconciliation schedules with account codes, balances, adjustments, and sign-offs ready for auditor review
Compare current period GL balances to prior periods to detect anomalies and trend shifts that signal potential errors
Cross-check financial statement disclosures against GL detail to ensure footnotes support reported balances
Reconcile subsidiary GL accounts to parent company financial statements with elimination tracking and intercompany account mapping
Generate supporting schedules that evidence GAAP application and accounting policy alignment for regulatory and audit purposes
Map old chart of accounts structures to new hierarchies with transition reconciliation and balance carryforward verification
Example Output
Example 1: Account Reconciliation Schedule
| GL Account | GL Balance | FS Line Item | FS Balance | Variance | Notes |
|---|---|---|---|---|---|
| 1200 Accounts Receivable | $2,450,000 | Current Assets | $2,425,000 | ($25,000) | Allowance for doubtful accounts |
| 1210 AR—Trade | $2,500,000 | Current Assets | — | — | Component of AR balance |
| 1250 Allowance for Doubtful Accounts | ($50,000) | Contra-Asset | — | — | Netted in AR presentation |
Example 2: Variance Exception Report
- Account 5100 Sales Revenue: GL = $5.2M | Prior Year = $4.8M | Variance = +8.3% — Requires investigation; Q3 new product launch evident in data
- Account 2100 Accounts Payable: GL = $890K | FS = $850K | Variance = $40K — Unmatched invoice on hold; see reconciliation schedule for detail
Example 3: Audit Trail Documentation
Prepared by: Controller | Date: 12/15/2024 | Reviewed by: CFO | Audit Sign-Off: ___
All material accounts reconciled. No exceptions identified. [Supporting detail attached.]
What's Included
- SKILL.md: Core instruction set for reconciliation methodology and Claude prompting patterns
- GL-to-FS Account Mapping Template: Pre-built hierarchy linking common GL account codes to financial statement line items (assets, liabilities, equity, revenue, expenses)
- Variance Analysis Checklist: Step-by-step guidance for identifying reconciling items, quantifying variances, and prioritizing investigation
- Audit-Ready Schedule Format: Excel/markdown templates for generating signed, dated reconciliation schedules with account detail and supporting notes
- Multi-Period Comparison Workbook: Framework for year-over-year or period-over-period variance analysis to detect trends and anomalies
- Disclosure Cross-Reference Guide: Worksheet linking GL accounts to financial statement footnote disclosures for completeness verification
Who It's For
- Controllers preparing monthly/quarterly/annual financial statement closes and audit support documentation
- Financial Reporting Managers responsible for GL reconciliations and variance investigation across multiple business units
- Internal Auditors validating account mappings and testing reconciliation completeness during SOX or compliance audits
- CPAs & Audit Staff responding to external audit inquiries and generating supporting schedules for sign-off
- Finance Directors overseeing consolidation reconciliations and intercompany account elimination processes
Best For
- Month-end, quarter-end, and year-end GL-to-FS reconciliations
- Variance investigation and root cause analysis across GL account hierarchies
- Audit support schedule preparation and auditor response documentation
- Multi-subsidiary consolidation reconciliation and elimination tracking
- Chart of accounts restructuring with balance carryforward verification
- GAAP compliance documentation and accounting policy support schedules
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