Finance AI Skill

Account Reconciliation

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, reconcili...

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