Chart of Accounts and Sub-Ledger Modeling

Product events become dimensioned journals that roll up into statements

Chart of Accounts and Sub-Ledger Modeling Product events become dimensioned journals that roll up into statements Ledger service Product event · payout / fee / loan · Architecture component Product event payout / fee / loan Posting engine · event to journal · Ledger service · versioned rules Posting engine event to journal versioned rules Sub-ledger · dimensioned journals · Ledger service Sub-ledger dimensioned journals General ledger · summarized balances · Ledger service General ledger summarized balances Rollup engine · account hierarchy · Ledger service Rollup engine account hierarchy Statements · BS / P&L / cash flow · Architecture component Statements BS / P&L / cash flow Reference data · accounts + dimensions · Architecture component Reference data accounts + dimensions event journal summarize rollup report validate Legend External Backend Database Frontend Security

Sub-ledger

  • • Dimensioned journal per event
  • • Idempotent on event_id

General ledger

  • • Thin, summarized per period
  • • Balances derived and reproducible

Chart of accounts

  • • Segmented account code
  • • Contra accounts roll up net