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 can systematically validate employee payroll records, cross-check tax withholding calculations against current tax brackets, verify regulatory compliance across federal/state/local requirements, and flag anomalies that could trigger penalties—all before executing payment runs. This reduces processing time by 40-60% while catching errors that manual spreadsheet reviews typically miss, working across ADP, Workday, Gusto, and manual payroll systems.
by eryet
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
This skill helps you audit nexus comprehensively by analyzing physical presence rules, economic thresholds, affiliate connections, and marketplace facilitator statutes across all 50 states and relevant localities. You'll document nexus triggers specific to your client's business model—whether they're selling through marketplaces, using drop-shipping, hiring remote employees, or expanding operations. The result is an actionable filing calendar and remediation strategy that minimizes compliance gaps and protects against substantial back-tax assessments, penalties, and interest.
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 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 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