Finance AI Skill

General Ledger Management

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 entr...

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 ✓