--- name: balance-sheet-reconciliation description: Perform balance sheet account reconciliations to ensure GL balances match supporting sub-ledgers, bank statements, and external records. Identify and resolve unreconciled differences, maintain reconciliation documentation for audit compliance, and establish ongoing reconciliation processes. Use when users need to reconcile balance sheet accounts, resolve unreconciled differences, build reconciliation templates, establish reconciliation controls, prepare for audit, or implement reconciliation automation. Triggers on phrases like "balance sheet reconciliation", "BS recon", "reconcile GL", "unreconciled difference", "bank reconciliation", "sub-ledger reconciliation", "reconciliation process", "recon template", "audit reconciliation", "reconciliation automation", or related reconciliation queries. --- # Balance Sheet Reconciliation Systematically reconcile all balance sheet accounts to verify accuracy, identify differences, maintain audit-ready documentation, and establish robust controls over financial reporting integrity. ## Workflow 1. **Classify Balance Sheet Accounts by Reconciliation Type** - Categorize accounts for appropriate reconciliation approach: ``` RECONCILIATION TYPE MATRIX ════════════════════════════════════════ Type A: External Reconciliation (third-party confirmation) → Cash / Bank accounts (match to bank statements) → Lockbox accounts (match to processor statements) → Credit card accounts (match to card issuer statements) → Investment accounts (match to custodian statements) → Lines of credit (match to lender statements) → Derivative positions (match to counterparty confirmations) Type B: Sub-ledger Reconciliation (ERP module tie-out) → Accounts Receivable (match to AR sub-ledger / customer balances) → Accounts Payable (match to AP sub-ledger / vendor balances) → Inventory (match to inventory sub-ledger / perpetual records) → Fixed Assets (match to fixed asset register) → Notes Receivable / Payable (match to loan schedules) → Accrued expenses (match to accrual schedules) → Deferred revenue (match to contract / billing schedules) Type C: Internal Reconciliation (GL-to-GL, calculated) → Intercompany accounts (match to counter-entity GL) → Tax accounts (match to tax provision calculations) → Reserve / allowance accounts (match to reserve analysis) → Accumulated depreciation (match to depreciation schedule) → Share capital / retained earnings (match to equity ledger) → Treasury stock (match to stock transaction ledger) Type D: Manual / Estimated Reconciliation (judgment-based) → Warranty reserves (match to historical claim analysis) → Litigation reserves (match to legal counsel assessment) → Vacation / bonus accruals (match to HR calculations) → Restructuring reserves (match to management estimates) → Valuation allowances (match to recoverability analysis) ``` 2. **Establish Reconciliation Standards and Policies** - Define reconciliation framework: ``` RECONCILIATION POLICY ════════════════════════════════════════ Frequency: → Cash / bank: Monthly (minimum), weekly for high-volume → Sub-ledger accounts: Monthly → Accruals / reserves: Monthly (at period-end) → Equity accounts: Monthly (or quarterly if activity is low) → Intercompany: Monthly Timing: → All reconciliations completed by close day 5 → Peer review by close day 6 → Management review by close day 7 → Controller sign-off by close day 8 Acceptable Differences: → Cash: $0 tolerance (must balance perfectly) → Sub-ledger: $0 tolerance (investigate all differences) → Accruals: Immaterial rounding (<$100) acceptable → Reserves: Variance explained through roll-forward Documentation Requirements: → Source of GL balance (trial balance extraction) → Source of independent balance (statement, sub-ledger, schedule) → Listing of reconciling items with description, amount, and age → Explanation of each reconciling item → Resolution plan for outstanding items → Reconciler name and date → Reviewer name and date → Retention: Minimum 7 years (audit requirement) ``` 3. **Execute Bank / Cash Reconciliation** - Perform detailed cash reconciliation: ``` BANK RECONCILIATION TEMPLATE ════════════════════════════════════════ Account: Chase Operating Account #XXXX Period: December 2024 GL Balance (per trial balance): $523,450 Bank Statement Balance: $587,200 Reconciling Items: Add to Bank Balance: → Deposits in transit: · Customer payment received 12/31, deposited 1/2: $35,000 · Customer payment received 12/31, deposited 1/2: $22,500 Total deposits in transit: $57,500 Less from Bank Balance: → Outstanding checks: · Check #4521 — Vendor A, written 12/20: ($18,000) · Check #4523 — Vendor B, written 12/22: ($12,300) · Check #4525 — Payroll, written 12/27: ($85,000) Total outstanding checks: ($115,300) Bank Errors / Adjustments: → Bank fee not yet recorded in GL: ($250) → Interest earned not yet recorded in GL: $380 → Wire transfer error (bank credited wrong account): ($5,000) · Contacted bank, correction expected 1/5 Reconciliation: Bank balance: $587,200 + Deposits in transit: $57,500 - Outstanding checks: ($115,300) = Adjusted bank balance: $529,400 GL balance: $523,450 + Interest earned: $380 - Bank fees: ($250) - Bank error: ($5,000) = Adjusted GL balance: $518,580 DIFFERENCE: $10,820 ⚠️ Investigation: → Wire transfer of $10,820 recorded in GL 12/27 but shows as pending on bank statement (international wire) → Add as additional reconciling item → Expected to clear by 1/3 FINAL RECONCILED BALANCE: $518,580 ✓ (balanced) ``` 4. **Execute Sub-ledger Reconciliation** - Reconcile GL to sub-ledger modules: ``` SUB-LEDGER RECONCILIATION TEMPLATE ════════════════════════════════════════ Account: Accounts Receivable (GL #1100) Period: December 2024 GL Balance: $1,245,800 AR Sub-ledger Total: $1,243,500 Difference: $2,300 ⚠️ Investigation: → GL has manual journal entry for $2,300 credit memo that was not processed through AR sub-ledger JE #2024-12-187, posted 12/15 Resolution: → Option A: Reverse GL JE, process credit memo through AR sub-ledger → Option B: Create manual customer credit in AR sub-ledger → Recommended: Option A (proper audit trail) After correction: GL Balance: $1,243,500 AR Sub-ledger Total: $1,243,500 Difference: $0 ✓ Additional Validation: → AR Aging Report Total: $1,243,500 ✓ → Open Invoices + Credits: $1,243,500 ✓ → Top 10 customers: $985,000 (79.2% concentration) ``` 5. **Execute Intercompany Reconciliation** - Reconcile intercompany balances across entities: ``` INTERCOMPANY RECONCILIATION TEMPLATE ════════════════════════════════════════ Entity Pair: US Parent ↔ UK Subsidiary US Parent — Intercompany Receivable: $850,000 UK Subsidiary — Intercompany Payable: £675,000 Exchange Rate (period-end): 1 GBP = 1.2700 USD UK Payable in USD: £675,000 × 1.2700 = $857,250 Difference: $857,250 - $850,000 = $7,250 ⚠️ Analysis: → Currency translation difference: UK records in GBP, US translates at spot rate → Timing difference: US recorded invoice 12/28, UK recorded 12/30 Invoice #INT-2024-445: $7,250 Resolution: → Timing difference resolves in January when both entities record same invoice → Currency difference is normal — eliminated at consolidation level → Document both items as reconciling items → No adjustment needed at entity level Status: Reconciled with documented reconciling items ✓ ``` 6. **Age and Resolve Outstanding Reconciling Items** - Manage aged unreconciled items: ``` RECONCILING ITEM AGING REPORT ════════════════════════════════════════ Account | Item Description | Amount | First Noted | Age | Status ────────────────┼───────────────────────┼──────────┼─────────────┼──────┼──────────── Cash | Outstanding check #4102| $12,500 | Oct 2024 | 84d | ⚠️ INVESTIGATE Cash | Deposit in transit | $5,000 | Dec 2024 | 5d | OK AR | Credit memo not posted | $2,300 | Dec 2024 | 5d | RESOLVED AP | Unmatched payment | $8,750 | Nov 2024 | 62d | ⚠️ INVESTIGATE Fixed Assets | Disposed asset not written off| $45K | Sep 2024 | 110d | 🔴 ESCALATE Escalation Rules: → <30 days: Normal — reconciler tracks → 31-60 days: Manager review required → 61-90 days: Controller review + written explanation → 90+ days: CFO review + forced resolution (adjustment or write-off) Resolution Actions: → Outstanding >60 days: Contact payee / reissue check / stop payment → Unmatched items: Research GL detail, contact counterparty → Old errors: Correcting journal entry with approval → Unresolvable: Write-off with documented investigation trail ``` 7. **Implement Reconciliation Automation** - Identify and deploy automation: ``` RECONCILIATION AUTOMATION MAP ════════════════════════════════════════ Fully Automatable: → Bank reconciliations (feed bank statements via API/SWIFT) → Sub-ledger tie-outs (system-generated, no manual intervention) → Fixed asset depreciation (auto-calculated from register) → Accumulated balances (roll-forward from prior period) Semi-Automatable: → Outstanding items matching (AI/ML fuzzy matching) → Intercompany reconciliation (auto-matching by reference number) → Accrual reversals (auto-reversing entries from prior month) Manual / Review: → Exception investigation and resolution → Estimated / judgment-based accounts → New accounts without historical data → Accounts with complex transaction patterns Recommended Tools: → BlackLine Reconciliations → Trintech Reconciliation → Cadency Reconciliation → SAP Financial Closure (built-in) → ERP-native reconciliation modules ``` 8. **Prepare for Audit** - Ensure audit-ready documentation: ``` AUDIT PREPARATION CHECKLIST ════════════════════════════════════════ → All balance sheet accounts reconciled (100% coverage) → Reconciliations signed off by preparer and reviewer → Outstanding items aged and explained → Items >90 days have management escalation documentation → Reconciliation methodology documented (source, process, frequency) → Material accounts reconciled monthly (not quarterly) → Bank confirmations sent/received for audit year-end → Intercompany confirmations exchanged between entities → Supporting schedules attached (accrual calcs, reserve analyses) → Electronic copies stored in audit management system → Access controls: Only authorized personnel can modify reconciliations ``` ## Integration Points - **Reconciliation Software**: BlackLine, Trintech, Cadency, Servebio, AccountRecon - **ERP**: SAP, Oracle, NetSuite, Dynamics (GL, sub-ledger data) - **Bank Feeds**: SWIFT, ACH feeds, bank APIs, statement file uploads - **Bank Statement Processors**: HighGO, D1, Finastra (electronic statement processing) - **Close Management**: FloQast, HotDocs (checklist, task assignment) - **Audit Management**: Workiva, AuditBoard, TeamMate (documentation storage) - **Spreadsheet Tools**: Excel, Google Sheets (manual reconciliation templates) ## Edge Cases & Handling ``` EDGE CASES ═══════════════════════════════════════ 1. Material Unresolved Difference → Assess materiality: >5% of account balance or >$50K absolute → Immediate escalation to controller → Root cause investigation within 48 hours → Adjusting journal entry if error identified → Disclose in audit management letter if not resolved before audit 2. Multi-Currency Reconciliation → Reconcile in transaction currency first → Translation differences at consolidation level → Track spot rate used vs. ERP rate → Flag rate discrepancies >0.1% 3. System Migration Period → Dual reconciliation during transition (old system + new system) → Opening balance reconciliation is critical → Historical reconciling items may carry forward → Extra audit scrutiny during first close in new system 4. Dormant / Zero-Balance Accounts → Still require reconciliation (prove zero is correct) → Minimum: GL balance = $0 confirmed, no activity noted → Annual full review for dormant accounts ``` ## Conversation Examples ### Reconciliation Process Setup ``` User: "We're getting ready for our first SOC 1 audit and our reconciliations are a mess. Where do we start?" AI: "SOC 1 auditors will scrutinize every balance sheet account reconciliation. Here's your remediation plan: Phase 1: Inventory (Week 1) → List every balance sheet account in your GL → Classify each: External, Sub-ledger, Internal, or Manual → Identify which accounts currently have reconciliations vs. none → Flag material accounts (>$50K or >5% of total assets/liabilities) Phase 2: Build Templates (Week 2) → Create standard reconciliation template for each type → Define required documentation: source, reconciliation, sign-off → Set ownership: Each account assigned to a primary and secondary owner → Set deadlines: Complete by close day 5, review by day 6 Phase 3: Retroactive Reconciliations (Week 3-6) → Work backward from current month → Complete reconciliations for the past 12 months (audit period) → Focus on material accounts first → Document all outstanding items with explanation and age Phase 4: Process Lockdown (Week 7-8) → Implement reconciliation review workflow (maker-checker) → Set up aging alerts for outstanding items (>30, >60, >90 days) → Document reconciliation policy (frequency, tolerances, escalation) → Train reconciliation owners on standards Phase 5: Audit Readiness (Ongoing) → Monthly: All BS accounts reconciled and reviewed → Quarterly: Reconciliation quality audit (spot-check) → Annually: Reconciliation process assessment Red flags SOC 1 auditors look for: → Missing reconciliations for material accounts → "Net zero" reconciling items with no explanation → Outstanding items >6 months with no resolution plan → Same person prepares and reviews (lack of segregation) Want me to help you build the reconciliation templates?" ``` ### Unresolved Reconciling Item ``` User: "We have a $45K reconciling item in Fixed Assets that's been sitting for 4 months. The auditor is asking about it." AI: "A 4-month-old, $45K unreconciled item is a SOC 1 deficiency and audit finding waiting to happen. Here's how to resolve it: Immediate Actions (Today): 1. Pull the Fixed Asset register and GL detail for the account 2. Identify what the $45K represents: → Disposed asset not written off? → Capitalization error? → Depreciation calculation error? → Missing asset addition or retirement? 3. Root Cause Investigation: → Check asset disposition log for the past 6 months → Verify depreciation schedule calculations → Cross-reference with procurement records (new additions) → Check capitalization threshold policy compliance 4. Resolution Options: → If it's a disposed asset: Write off asset cost + accumulated depreciation → If it's a depreciation error: Correcting JE + adjust going-forward schedule → If it's a classification error: Reclassify to proper account → If it's truly unidentifiable: Write-off with documented investigation 5. Auditor Response: → Provide investigation documentation → Explain root cause and resolution → Show corrected reconciliation → Explain process improvement to prevent recurrence Prevention: → Monthly fixed asset reconciliation by close day 4 → Asset disposition approval workflow with GL write-off trigger → Quarterly fixed asset review by controller What does the $45K represent when you check the asset register?" ```