--- name: general-ledger-management description: Manage the general ledger including chart of accounts design, journal entry processing, account reconciliation, trial balance preparation, period-end posting, and GL data integrity. Use when setting up or redesigning chart of accounts, managing journal entry workflows, preparing trial balances, maintaining GL data quality, configuring multi-entity GL structures, or establishing GL controls. Triggers on phrases like "general ledger", "GL management", "chart of accounts", "COA design", "journal entry management", "trial balance", "GL reconciliation", "account structure", "GL cleanup", "master data management". --- # General Ledger Management Design, maintain, and control the general ledger as the foundation of all financial reporting and analysis. ## Workflow ### 1. Chart of Accounts (COA) Design ``` CHART OF ACCOUNTS ARCHITECTURE ═══════════════════════════════════════ DESIGN PRINCIPLES: → Balance between detail and manageability → Support all reporting needs (internal, external, segment, tax) → Allow for scalability and future changes → Consistent numbering conventions → Minimize need for memorandum accounts NUMBERING SYSTEM (5-digit recommended): 10000-19999: Assets 10000-10999: Current Assets 11000-11999: Cash & Cash Equivalents 12000-12999: Accounts Receivable 13000-13999: Inventory 14000-14999: Prepaid Expenses 15000-19999: Non-Current Assets 15000-15999: Fixed Assets (by type) 16000-16999: Accumulated Depreciation 17000-17999: Intangible Assets 20000-29999: Liabilities 20000-20999: Current Liabilities 21000-21999: Accounts Payable 22000-22999: Accrued Liabilities 23000-23999: Deferred Revenue 24000-29999: Non-Current Liabilities 30000-39999: Equity 30000-30999: Common Stock 31000-31999: Retained Earnings 32000-32999: Treasury Stock 40000-49999: Revenue 40000-40999: Product Revenue 41000-41999: Service Revenue 42000-42999: Other Income 50000-59999: Cost of Goods Sold 60000-69999: Operating Expenses 60000-60999: Salaries & Wages 61000-61999: Benefits 62000-62999: Marketing & Advertising 63000-63999: Professional Fees 64000-64999: Rent & Occupancy 65000-65999: Technology & Software 66000-66999: Travel & Entertainment 67000-67999: Office Supplies 68000-68999: Depreciation & Amortization 69000-69999: Other Operating Expenses 70000-79999: Other Income/Expense 70000-70999: Interest Income 71000-71999: Interest Expense 72000-72999: Gain/Loss on Disposal 73000-73999: Foreign Exchange SEGMENTATION DIMENSIONS (use dimensions/tags, NOT separate accounts): → Department/Cost Center: Engineering, Sales, Marketing, Finance, etc. → Location: HQ, Branch 1, Branch 2, Remote → Project: Project Alpha, Project Beta → Product Line: Product A, Product B, Services → Customer Segment: Enterprise, SMB, Government → Revenue Type: Recurring, One-time, License, Support BEST PRACTICE: Keep COA to 150-300 main accounts; use dimensions for granularity. Avoid creating new account for every new department/project. ``` ### 2. Journal Entry Management ``` JOURNAL ENTRY PROCESS ═══════════════════════════════════════ JE CLASSIFICATION: 1. Recurring/Standard JEs (automated or template-based) → Monthly depreciation → Amortization → Accruals (standard, formulaic) → Intercompany eliminations → FX revaluation 2. Adjusting JEs (period-end, require review) → Revenue recognition adjustments → Inventory adjustments → Provision estimates → Foreign currency adjustments 3. Correcting JEs (error corrections) → Misposted transactions → Wrong account coding → Timing corrections → Restatement entries 4. Non-routine/Non-recurring JEs (require approval) → M&A adjustments → Impairment charges → Restructuring costs → Litigation settlements JE APPROVAL MATRIX: Amount Range | Maker | Checker | Approver ─────────────────────┼───────────┼──────────────┼─────────── <$10,000 | Accountant| Senior Acctg | — $10K – $50,000 | Accountant| Controller | — $50K – $250,000 | Controller| Director | CFO >$250,000 | Controller| CFO | CEO/Board JE WORKFLOW: 1. Creation: Maker drafts JE with description, accounts, amounts 2. Documentation: Attach supporting calculations, source documents 3. Self-review: Maker verifies entry accuracy 4. Review: Checker validates accounts, amounts, business logic 5. Approval: Approver signs off (if required by matrix) 6. Posting: Post to GL (immediately or batched) 7. Numbering: Assign unique JE number (auto-generated) 8. Audit trail: System logs creator, reviewer, approver, timestamps RECURRING JE TEMPLATE: ═══════════════════════════════════════ JE Template ID: JE-REC-001 Description: Monthly Depreciation — Fixed Assets Frequency: Monthly Timing: Day 3 of following month Maker: System (auto-generated from FA module) Checker: Senior Accountant Template: Dr Depreciation Expense (68000) $[calculated] Cr Accumulated Depreciation (16000) $[calculated] Supporting: Fixed asset register run from FA system Notes: Verify against FA roll-forward before posting ``` ### 3. Trial Balance & Reconciliation ``` TRIAL BALANCE PROCESS ═══════════════════════════════════════ PRE-CLOSE TRIAL BALANCE (unadjusted): → Pull from ERP after all sub-ledger posting complete → Verify all sub-ledgers posted (AR, AP, FA, Inventory) → Check that TB balances (total debits = total credits) → Review unusual accounts (zero-balance accounts with activity, vice versa) POST-CLOSE TRIAL BALANCE (adjusted): → After all adjusting JEs posted → Final TB used for financial statement generation → Verify TB still balances → Compare to prior period (significant variance review) → Archive for audit trail ACCOUNT RECONCILIATION SCHEDULE: ═══════════════════════════════════════ Account # Account Name Frequency Owner Deadline ───────────────────────────────────────────────────────────────────────── 11000 Cash — Operating Monthly Treasury Day 5 11100 Cash — Restricted Monthly Treasury Day 5 11200 Cash — Foreign Monthly Treasury Day 5 12000 Accounts Receivable Monthly AR Manager Day 4 13000 Inventory Monthly Controller Day 5 13100 Inventory Reserve Monthly Controller Day 5 15000 Fixed Assets Quarterly FA Manager Day 10 16000 Accumulated Depreciation Quarterly FA Manager Day 10 21000 Accounts Payable Monthly AP Manager Day 4 22000 Accrued Liabilities Monthly Controller Day 5 23000 Deferred Revenue Monthly Revenue Acc Day 5 24000 Long-Term Debt Quarterly Treasury Day 10 25000 Income Tax Payable Quarterly Tax Manager Day 8 30000 Common Stock Annual Controller Day 15 31000 Retained Earnings Monthly Controller Day 5 RECONCILIATION TEMPLATE: ═══════════════════════════════════════ Account: 11000 — Cash — Operating Period: March 2024 Reconciled by: [Name] Date reconciled: [Date] GL Balance (per trial balance): $1,245,000 Bank Statement Balance: $1,248,500 Reconciling Items: Deposits in transit: +$12,000 Outstanding checks: ($12,500) Bank service charges: ($300) Interest earned (not yet posted): +$300 Adjusted GL Balance: $1,245,000 Adjusted Bank Balance: $1,245,000 Difference: $0 ✓ Reconciling Items Aging: Items > 30 days: None Items > 60 days: None Items > 90 days: None Action items: None Review/Approval: Reviewed by: [Name] Date: [Date] Approved by: [Name] Date: [Date] ``` ### 4. GL Data Integrity & Controls ``` GL CONTROLS FRAMEWORK ═══════════════════════════════════════ SEGREGATION OF DUTIES: → Maker ≠ Checker ≠ Approver (for JEs) → Sub-ledger management ≠ GL posting → Account reconciliation ≠ account ownership → System administration ≠ financial posting → Period close ≠ period approval ACCESS CONTROLS: → Role-based access to GL system → Only authorized users can create/post JEs → Only authorized users can modify COA → Only authorized users can close periods → MFA required for GL access → Access review quarterly CHANGE MANAGEMENT: → COA changes require Controller approval → New accounts require justification and mapping → Account closures require reconciliation first → All changes logged with reason and approval MONTHLY GL HEALTH CHECK: 1. TB balances (debits = credits) 2. No unposted JEs in pending status >3 days 3. All recurring JEs posted on schedule 4. All account reconciliations completed 5. No suspense/holding account balance >$0 6. Intercompany balances tied out 7. FX revaluation entries current 8. No duplicate JE numbers 9. All JEs have descriptions and documentation 10. Period end-dates locked appropriately ``` ### 5. Multi-Entity GL Architecture ``` MULTI-ENTITY GL STRUCTURE ═══════════════════════════════════════ Entity Hierarchy: Parent Corp (Reporting Currency: USD) ├─ US Operating Co (USD) │ ├─ Division A │ └─ Division B ├─ EU Holding (EUR) │ ├─ UK Subsidiary (GBP) │ ├─ Germany Subsidiary (EUR) │ └─ France Subsidiary (EUR) └─ APAC Holding (SGD) ├─ Singapore Subsidiary (SGD) ├─ Japan Subsidiary (JPY) └─ India Subsidiary (INR) CONSOLIDATION PROCESS: 1. Each entity maintains local currency GL 2. Common COA mapped across all entities 3. FX translation at month-end rates 4. Intercompany transactions auto-identified 5. Elimination entries generated 6. Minority interest calculated 7. Consolidated TB produced INTERCOMPANY TRACKING: → Each entity uses dedicated IC account range → IC transactions tagged at origin → Auto-matching between entities monthly → Variance tolerance: <$100 auto-clear, >$100 flag → IC balance reconciliation: monthly ``` ## Edge Cases - **Legacy system migration**: Map old COA to new COA; run parallel for 2 periods; validate balances match - **Restatements**: Document restatement rationale; create restatement JEs; update comparative periods; notify auditors - **Hypergrowth COA expansion**: Resist creating new accounts for every new product; use dimensions instead; review quarterly - **Regulatory changes**: COA must support new reporting requirements (e.g., ASC 842 lease accounting, ASC 606 revenue) - **Shared services**: Multiple entities share one GL team; clear entity ownership for each transaction; strong controls ## Integration Points - **ERP**: SAP, Oracle, NetSuite, Microsoft Dynamics (primary GL system) - **Sub-ledgers**: AR, AP, Fixed Assets, Inventory modules - **Consolidation tools**: BlackLine, FloQast, Trintech, OneStream - **Reporting**: Power BI, Tableau, Crystal Reports - **Document management**: SharePoint, DocuSign (approval workflows) - **Calendar**: Period-end close schedules, reconciliation deadlines ## Output ### GL Status Report ``` GENERAL LEDGER STATUS — March 2024 Close ═══════════════════════════════════════ CLOSE PROGRESS: Sub-ledger posting: COMPLETE ✓ Recurring JEs posted: COMPLETE ✓ (23/23) Adjusting JEs posted: COMPLETE ✓ (8/8) Account reconciliations: 45/48 (94%) ⚠ Trial balance: BALANCED ✓ Period status: READY FOR CLOSE PENDING ITEMS: ⚠ 3 reconciliations pending (Day 6, target: Day 5): → 24000 LT Debt (Q1 reconciliation, target Day 10 — on track) → 13100 Inventory Reserve (missing physical count sign-off) → 31000 Retained Earnings (waiting on tax provision input) JE ACTIVITY SUMMARY: Total JEs this period: 34 Recurring: 23 Adjusting: 8 Correcting: 1 Non-routine: 2 Total value posted: $4,850,000 DATA QUALITY: Accounts with no activity: 12 (below threshold) Suspense account balance: $0 ✓ JEs without documentation: 0 ✓ Duplicate JEs detected: 0 ✓ ```