--- name: account-reconciliation description: Manage account reconciliation including bank reconciliations, account balance verification, sub-ledger to general ledger reconciliation, automated reconciliation tools, and reconciliation close management. Use when performing bank reconciliations, reconciling account balances, managing sub-ledger to GL matches, or streamlining reconciliation processes. Triggers on phrases like "bank reconciliation", "account reconciliation", "balance verification", "sub-ledger reconciliation", "GL reconciliation", "reconciliation close", "reconcile accounts", "unreconciled items", "reconciliation tools", "auto-reconciliation". --- # Account Reconciliation Ensure accurate financial reporting through systematic reconciliation of all material accounts. ## Reconciliation Framework ### Reconciliation Master List & Process ``` RECONCILIATION MASTER LIST: ════════════════════════════ TOTAL ACCOUNTS REQUIRING RECONCILIATION: 48 By materiality: HIGH (>$1M or balance sheet key): 12 accounts MEDIUM ($100K-$1M): 22 accounts LOW (<$100K): 14 accounts By frequency: Monthly: 45 accounts (standard) Quarterly: 2 accounts (low-activity) Annual: 1 account (reserve assessment) RECONCILIATION TYPES: ┌────────────────────────────┬──────────────────────────────────────┐ │ Type │ Accounts / Examples │ ├────────────────────────────┼──────────────────────────────────────┤ │ Bank reconciliation │ Operating accounts, savings, restricted│ │ │ cash, foreign currency accounts │ ├────────────────────────────┼──────────────────────────────────────┤ │ Sub-ledger to GL │ AR sub-ledger, AP sub-ledger, fixed │ │ │ assets, inventory, prepaid expense │ ├────────────────────────────┼──────────────────────────────────────┤ │ Intercompany │ IC receivable/payable (per entity) │ ├────────────────────────────┼──────────────────────────────────────┤ │ Balance sheet detail │ Accrued expenses, deferred revenue, │ │ │ other assets/liabilities, reserves │ ├────────────────────────────┼──────────────────────────────────────┤ │ Third-party confirmation │ Investments, loans, escrow accounts │ ├────────────────────────────┼──────────────────────────────────────┤ │ Analytical reconciliation │ Low-balance, low-risk accounts │ └────────────────────────────┴──────────────────────────────────────┘ RECONCILIATION PROCESS: Step 1: Gather supporting evidence - Bank statements (from bank portal) - Sub-ledger detail (from ERP) - Third-party confirmations (investments, loans) - Prior period reconciliation (carry-forward) - Journal entries posted (current period) Step 2: Perform reconciliation - Match GL balance to supporting detail - Identify differences (timing, errors, omissions) - Age differences (current month vs. prior) - Classify items (recurring, one-time, aged) Step 3: Investigate differences - Timing differences: Normal (clear next period) - Errors: Correction entry (with approval) - Omissions: Additional entry (with approval) - Unexplained: Escalate to Controller - Aged items (>3 months): Root cause + action plan Step 4: Document & certify - Reconciliation template (standard format) - Supporting documentation (attached) - Prepared by: Accountant (designated per account) - Reviewed by: Senior accountant / Supervisor - Certified by: Controller (HIGH accounts) / Manager (MEDIUM) Step 5: File & archive - Storage: BlackLine / SharePoint (digital) - Retention: 7 years (compliance) - Audit trail: Version history, approval log - Access: Restricted (Finance only) RECONCILIATION CLOSE CALENDAR: ┌─────────────────────┬────────────┬─────────────────────────────┐ │ Timeline │ Activity │ Owner │ ├─────────────────────┼────────────┼─────────────────────────────┤ │ Day 1 (month-end) │ GL close │ Accounting team │ │ Day 1-2 │ Bank rec │ Treasury / Cash mgmt │ │ Day 2-3 │ Sub-ledger│ AR / AP / Fixed Assets │ │ Day 3-5 │ BS detail │ Balance sheet accountants │ │ Day 5-7 │ Review │ Senior accountant / Manager │ │ Day 7-8 │ Certify │ Controller (HIGH accounts) │ │ Day 8-10 │ Exception │ Controller / CFO │ │ │ resolution│ │ │ Day 10 │ Sign-off │ Controller │ └─────────────────────┴────────────┴─────────────────────────────┘ Target: All reconciliations completed by Day 10 Current performance: Day 8 (average, 2 days ahead) ✓ ``` ## Bank Reconciliation ### Banking Reconciliations ``` BANK RECONCILIATION DETAILS: ════════════════════════════ BANKING STRUCTURE: ┌─────────────────────────┬──────────┬──────────┬───────────┐ │ Account │ Bank │ Currency │ Balance │ ├─────────────────────────┼──────────┼──────────┼───────────┤ │ Operating (primary) │ Bank A │ USD │ $12,800K │ │ Money market │ Bank A │ USD │ $3,200K │ │ Investment (T-bills) │ Bank B │ USD │ $1,500K │ │ UK operating │ Bank C │ GBP │ £420K │ │ Canada operating │ Bank D │ CAD │ $380K │ │ Singapore operating │ Bank E │ SGD │ S$650K │ └─────────────────────────┴──────────┴──────────┴───────────┘ RECONCILIATION RESULTS (January 2025): All 6 accounts reconciled by Day 3 ✓ Operating account (primary): GL balance: $12,800,000 Bank statement: $12,800,000 Difference: $0 ✓ Outstanding items: - Deposits in transit: $0 (same-day ACH) - Outstanding checks: $0 (all electronic) - Bank fees: $0 (matched) - Interest income: $0 (matched) Status: ✓ BALANCED — Day 1 Money market account: GL balance: $3,200,000 Statement: $3,200,000 Difference: $0 ✓ Interest accrued: $4,800 (matched) Status: ✓ BALANCED — Day 2 UK operating (GBP): GL balance (USD): $533,440 Bank balance (GBP): £420,000 FX rate: 1.270 Difference: $0 ✓ Status: ✓ BALANCED — Day 3 All accounts: ZERO differences (perfect reconciliation) Aged items carried forward: $0 (clean) Exception items: $0 RECONCILIATION QUALITY METRICS: On-time completion: 100% (6/6 accounts) Zero-balance reconciliations: 100% (no differences) Aged items (>3 months): $0 (clean) Prior period carry-forward: $0 (resolved) Review/certification: 100% complete Documentation quality: 5/5 (complete, clear) ``` ## Automated Reconciliation ### Technology & Efficiency ``` AUTOMATED RECONCILIATION PLATFORM: ══════════════════════════════════ PLATFORM: BlackLine Reconciliation Coverage: 38 of 48 accounts (79%) Manual reconciliations: 10 accounts (low-activity, low-risk) Automation features: - Auto-import of bank statements (API connectivity) - Auto-import of sub-ledger detail (ERP integration) - Auto-matching (rule-based, configurable thresholds) - Exception alerts (unmatched items, aged items) - Workflow management (prepare → review → certify) - Audit trail (complete history, approvals) - Reporting (dashboard, exception reports) AUTOMATION PERFORMANCE: Auto-match rate: 87% (improving from 82% last quarter) Manual match required: 10% (review + manual match) Exception / investigation: 3% (escalation) Time savings: Before automation: 40 hours/month (manual) With automation: 15 hours/month (review + exception) Time saved: 25 hours/month (62.5% reduction) Annual savings: 300 hours (FTE equivalent: ~0.15) RECONCILIATION RULES (Auto-Match): ┌─────────────────────────────────┬─────────────────────────────┐ │ Rule Type │ Configuration │ ├─────────────────────────────────┼─────────────────────────────┤ │ Exact match │ Same amount + date ± 1 day │ │ Fuzzy match (amount) │ Amount ± $0.50 (rounding) │ │ Fuzzy match (date) │ Date ± 3 days (timing) │ │ Recurring items │ Same description + amount │ │ │ (monthly bank fees, interest)│ │ Threshold match │ Balance difference < $10 │ │ │ (auto-clear as rounding) │ │ Multi-line match │ Multiple transactions = │ │ │ single GL entry (aggregate) │ └─────────────────────────────────┴─────────────────────────────┘ EXCEPTION MANAGEMENT: Current exceptions (January): 1. UK bank: £2,500 difference (investigation — FX timing) Status: Resolved (FX rate difference — adjusting entry) Resolution: Day 4 Root cause: Rate used in ERP vs. bank settlement rate 2. AP sub-ledger: $8,200 difference (investigation) Status: Resolved (invoice posted to wrong period) Resolution: Day 5 Root cause: Month-end cutoff timing — corrected Total exceptions: 2 (both resolved within target) Exception rate: 4.2% (below 5% target) ✓ Avg. resolution time: 4.5 days (target: <5 days) ✓ RECONCILIATION DASHBOARD: Accounts reconciled: 48/48 (100%) Accounts balanced: 46/48 (95.8%) Accounts with exceptions: 2 (both resolved) Aged items: $0 (clean) Completion status: ✓ ALL COMPLETE Next cycle: February close (Day 1-10) ``` ## Reconciliation Quality & Controls ### Governance & Best Practices ``` RECONCILIATION GOVERNANCE: ══════════════════════════ ACCOUNT OWNERSHIP: Each reconciliation has a designated: - Preparer: Accountant responsible for execution - Reviewer: Senior accountant / supervisor - Certifier: Controller (HIGH) / Manager (MEDIUM-LOW) Segregation of duties: - Preparer ≠ Reviewer (mandatory) - Reviewer ≠ Certifier (for HIGH accounts) - Account owner ≠ transaction approver (where possible) QUALITY STANDARDS: Documentation requirements: - Standard template (all reconciliations) - Supporting evidence (attached, indexed) - Narrative explanation (for all differences) - Aging analysis (for outstanding items) - Prior period carry-forward (clear linkage) Review criteria: - Completeness (all accounts reconciled) - Accuracy (GL balances match supporting detail) - Timeliness (completed within close calendar) - Appropriateness (classification of items) - Resolution plan (aged items, exceptions) AGED ITEM MANAGEMENT: Policy: 0-30 days: Normal (no action required) 31-60 days: Review required (action plan) 61-90 days: Escalation to Controller 90+ days: Write-off / adjustment (with CFO approval) Current aged items: $0 (clean — no aged items) Trend: Improving (Q3 had $45K aged → Q4: $8K → Q1: $0) MONTHLY RECONCILIATION CHECKLIST: ┌───────────────────────────────────┬──────┬──────┐ │ Check Item │ Q4 │ Q1 │ ├───────────────────────────────────┼──────┼──────┤ │ All accounts reconciled by Day 10 │ ✓ 100%│ ✓ 100%│ │ Review completed within 2 days │ ✓ 98% │ ✓ 100%│ │ Certification within 1 day │ ✓ 95% │ ✓ 100%│ │ No items aged >90 days │ ✓ │ ✓ │ │ Documentation complete │ ✓ 100%│ ✓ 100%│ │ Exceptions resolved │ ✓ 96% │ ✓ 100%│ │ Audit trail maintained │ ✓ 100%│ ✓ 100%│ │ Prior period items cleared │ ✓ 100%│ ✓ 100%│ └───────────────────────────────────┴──────┴──────┘ Overall quality score: 100% (Q1 2025) — EXCELLENT Trend: Improving (Q3: 98% → Q4: 99% → Q1: 100%) INTERNAL AUDIT REVIEW: Last review: November 2024 (Internal Audit) Scope: Sample of 12 reconciliations (HIGH + MEDIUM) Findings: 0 deficiencies Recommendations: 1 (minor — enhance narrative for recurring items) Status: ✓ Satisfactory — no exceptions CONTINUOUS IMPROVEMENT: Automation expansion: Current: 38/48 accounts automated (79%) Target: 45/48 (94%) — add 7 more accounts Timeline: Q1-Q2 2025 Benefit: Additional 5 hours/month time savings Rule optimization: Auto-match rate: 87% Target: 92% Action: Refine matching rules (quarterly review) Close acceleration: Current: Day 8 average completion Target: Day 6 Action: Parallel processing (additional resources) ``` ## Output ### Reconciliation Dashboard ``` RECONCILIATION DASHBOARD — Jan 2025 ══════════════════════════════════ Overview: Total accounts: 48 Reconciled: 48/48 (100%) Balanced: 46/48 (95.8%) Exceptions: 2 (both resolved) Aged items: $0 (clean) Completion: Day 8 (target: Day 10) ✓ Bank Reconciliations: Accounts: 6 (all balanced, $0 difference) Completion: Day 3 (target: Day 3) ✓ Outstanding items: $0 Automation: Platform: BlackLine (38/48 accounts) Auto-match rate: 87% (target: 92%) Time savings: 25 hours/month Coverage: 79% (target: 94%) Quality: Overall score: 100% (improving trend) Documentation: Complete (all accounts) Review/certification: 100% Internal audit: Satisfactory (Nov 2024) Zero findings: ✓ Close Performance: Timeline: Day 1-8 (avg. 2 days ahead of target) Review: Within 2 days (100%) Certification: Within 1 day (100%) Exception resolution: 4.5 days avg. Actions: 1. February close cycle (Day 1-10) 2. Expand automation (7 accounts — Q1) 3. Rule optimization review (Q1) 4. Close acceleration plan (Q2) 5. Annual reconciliation policy review (Q2) ``` ## Integration Points - ERP/GL (NetSuite, SAP): GL balances, sub-ledger detail, journal entries - Reconciliation platforms (BlackLine, Cadency): Automated matching, workflow - Banking platforms (API): Bank statements, account data, transaction detail - BI platforms: Reconciliation dashboards, exception reports - Document management (SharePoint): Reconciliation storage, evidence - Internal audit platforms: Audit trail, review evidence - Alerting platforms (Slack, email): Exception notifications, workflow reminders - Data analytics tools: Trend analysis, aging analysis, exception detection ## Edge Cases - **Large balance difference**: Root cause investigation; potential error; adjustment entry; management escalation - **Long-standing aged items**: Write-off assessment; management approval; tax implications; root cause elimination - **System migration**: Dual reconciliation; data mapping; period-end cutover; validation - **Bank error**: Bank communication; correction timeline; temporary adjustment; follow-up - **Fraud indicators**: Immediate escalation; forensic investigation; law enforcement; management notification - **Foreign currency timing**: FX rate differences; adjusting entries; documentation; consistency - **High transaction volume**: Processing time; resource allocation; batch processing; automation - **Account restructuring**: New account mapping; historical data; reconciliation redefinition - **Regulatory requirement**: Enhanced documentation; external auditor evidence; compliance timeline - **Force majeure / banking disruption**: Alternative evidence; manual reconciliation; risk assessment