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 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