Account Reconciliation Assistant
GL-to-subledger and bank reconciliation with variance identification
Month-end reconciliation means days of matching transactions line by line, chasing down variances, and praying nothing slips through the cracks before the close deadline.
Who it's for: staff accountants, controllers, bookkeepers, finance managers, audit preparers
Example
"Reconcile our Q4 bank statements against the general ledger" → All 1,247 transactions matched, 8 variances identified with root cause categories, and an aging analysis of outstanding items
CLAUDE.md Template
New here? 3-minute setup guide → | Already set up? Copy the template below.
npx ccplaybooks add account-reconciliation-assistant# Account Reconciliation Assistant
**Important**: This workflow assists with reconciliation processes but does not provide financial advice. All reconciliations should be reviewed by qualified financial professionals before sign-off.
Methodology and best practices for account reconciliation, including GL-to-subledger, bank reconciliations, and intercompany. Covers reconciling item categorization, aging analysis, and escalation.
## Reconciliation Types
### GL to Subledger Reconciliation
Compare the general ledger control account balance to the detailed subledger balance.
Get new playbooks like this one
One email a week with new Claude Code workflows. Free, like everything here.
No spam. Unsubscribe anytime.
What This Does
This playbook provides a structured approach to account reconciliation -- comparing GL balances to subledgers, bank statements, or third-party data. It covers GL-to-subledger recs, bank reconciliations, and intercompany reconciliations, with frameworks for categorizing reconciling items, aging analysis, escalation thresholds, and best practices.
Important: This workflow assists with reconciliation processes but does not provide financial advice. All reconciliations should be reviewed by qualified financial professionals before sign-off.
Quick Start
Step 1: Download the Template
Click Download above to get the CLAUDE.md file.
Step 2: Set Up Your Project
Create a project folder and place the template inside:
mkdir -p ~/Documents/Reconciliation
mv ~/Downloads/account-reconciliation-assistant.md ~/Documents/Reconciliation/CLAUDE.md
Step 3: Start Working
cd ~/Documents/Reconciliation
claude
Say: "Reconcile the AR subledger to the GL control account for December"
Supported Reconciliation Types
- GL to Subledger -- Compare control accounts (AR, AP, fixed assets, inventory, prepaids, accrued liabilities) to subledger detail
- Bank Reconciliation -- Compare GL cash balance to bank statement with outstanding checks, deposits in transit, and unrecorded items
- Intercompany -- Reconcile receivable/payable balances between related entities for consolidation
Reconciling Item Categories
| Category | Description | Action |
|---|---|---|
| Timing Differences | Normal processing delays (outstanding checks, deposits in transit) | Monitor -- will clear within 1-5 business days |
| Adjustments Required | Unrecorded charges, errors, missing entries | Prepare adjusting journal entry |
| Requires Investigation | Unidentified variances, disputed items, aged items | Investigate root cause, escalate if unresolved |
Aging Thresholds
| Age | Status | Action |
|---|---|---|
| 0-30 days | Current | Monitor |
| 31-60 days | Aging | Investigate |
| 61-90 days | Overdue | Escalate to supervisor |
| 90+ days | Stale | Escalate to management |
Example Prompts
"Reconcile the AR subledger to the GL control account for December"
"Perform a bank reconciliation for the operating account as of month-end"
"Help me reconcile intercompany balances between Entity A and Entity B"
"Categorize these reconciling items and identify which need journal entries"
"What are the aged outstanding items over 60 days?"