General Ledger Account Reconciliation Workflow
Reconcile GL accounts to source docs with structured templates and variance analysis
What You Can Do
You can systematically reconcile general ledger accounts to supporting documentation, sub-ledgers, and bank statements using structured verification protocols. Claude helps you match transactions, identify variances, document discrepancies, and generate audit-ready workpapers that reduce manual review time by 40-50%. This skill works for monthly reconciliations, multi-line item accounts, and year-end periods requiring detailed evidence.
Features
Claude matches GL entries to source documents and sub-ledger items, flagging unmatched items for investigation
Systematically categorizes and explains balance differences, documenting root causes for audit trails
Pre-built reconciliation formats with sign-off sections, preparer/reviewer fields, and audit evidence checklists
Prioritizes unmatched items by risk (duplicate entries, timing differences, data entry errors) to focus review efforts
Handle bank accounts, A/R, A/P, fixed assets, and prepaid expenses using account-specific verification steps
Generates standardized workpapers with sufficient detail and cross-references for external auditor review
Flags and explains common reconciling items (outstanding checks, in-transit deposits, accruals)
Example Output
Bank Reconciliation Example:
- GL Balance: $247,500
- Bank Statement Balance: $249,850
- Outstanding Checks: $2,350 (Check #1047, Check #1049)
- In-Transit Deposit: $0
- Reconciled Balance: $247,500 ✓
- Variance: $0 (fully reconciled)
A/P Reconciliation with Variance:
- GL Balance: $156,000
- Subledger Balance: $154,250
- Variance: $1,750 (1.1%)
- Root Cause: Invoice #INV-2024-088 recorded in GL but not received from vendor — recommended follow-up action documented
- Recommendation: Contact vendor by [date] to confirm invoice status
Fixed Asset Reconciliation Workpaper:
- Cost Balance: $425,000 ✓
- Accumulated Depreciation: $125,000 ✓
- Additions YTD: $15,000 (4 new assets, all documented)
- Disposals: $0
- Net Book Value: $300,000 ✓
- Auditor Sign-Off: [Lines for preparer/reviewer initials and dates]
What's Included
- SKILL.md instruction file with core reconciliation workflow and protocols:
- Reconciliation Template: Bank, A/R, A/P, and Fixed Asset reconciliation formats with variance line items
- Variance Analysis Checklist: Root cause categories (timing, data entry, missing documentation) with investigation steps
- Workpaper Framework: Audit-ready format with preparer/reviewer sections, sign-off lines, and cross-reference fields
- Discrepancy Triage Guide: Risk-based prioritization matrix for unmatched items and recommended follow-up actions
Who It's For
- Staff Accountants — Executing monthly GL reconciliations and preparing audit-ready workpapers
- AP/AR Specialists — Reconciling payables, receivables, and vendor/customer account balances
- Fixed Asset Accountants — Matching asset cost and depreciation ledgers to fixed asset register
- Finance Analysts — Supporting period-end close reconciliations and variance investigation
- Audit Preparation Teams — Creating standardized documentation for external and internal audit reviews
Best For
- Monthly account reconciliations with 50+ transactions requiring systematic matching
- Variance explanations when GL balance differs from sub-ledger by >2%
- Creating standardized, audit-ready reconciliation workpapers
- Multi-account reconciliations (bank, A/R, A/P, fixed assets) during period-end close
- Year-end and audit period reconciliations requiring detailed support documentation
- Identifying and triaging timing differences, duplicate entries, and data entry errors
You might also like
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 upload aging data from your accounting system and Claude will systematically categorize invoices by delinquency bucket, identify high-risk accounts with payment pattern analysis, explain why balances are aging, and generate prioritized collection strategies with account-specific context. This transforms static aging reports into actionable recovery plans that help you understand portfolio health and accelerate cash flow.
by eryet
Run comprehensive portfolio simulations across multiple asset classes and market scenarios to stress-test your investment strategy. You can analyze how your portfolio would perform under different economic conditions, test the impact of market downturns on your wealth trajectory, and validate whether your asset allocation aligns with your financial goals.
by eryet
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