Does this skill provide SQL schemas for accounting?

Yes, it includes reference schemas for journal entries, journal lines, and chart of accounts structures (1000-7999 numbering conventions).

Can I use this for high-scale event sourcing?

Absolutely. It provides patterns for the ledger-as-event-log model, including SHA-256 hash chaining to ensure the integrity of the event stream.

What is the core philosophy of this ledger design skill?

It follows the golden rule that debits must always equal credits and that financial history is sacred, meaning no journal entries should ever be updated or deleted.

How does it handle transaction corrections?

The skill implements a reversal pattern where mistakes are corrected via new offsetting entries rather than modifying original records, maintaining a perfect audit trail.

Does it support sub-ledger reconciliation?

Yes, it guides the design of AR (Accounts Receivable) and AP (Accounts Payable) sub-ledgers and their reconciliation to the General Ledger control accounts.

Financial Ledger Architecture

Name: Financial Ledger Architecture
Author: rnavarych

byrnavarych

•

Database Management

Architects robust double-entry accounting systems with immutable audit trails and rigorous financial reconciliation patterns.

The Ledger Design skill empowers developers to build production-grade fintech systems by providing standardized guidance on double-entry bookkeeping, chart of accounts organization, and sub-ledger reconciliation. It enforces critical financial principles such as debit-credit parity, append-only journaling, and hash-chained tamper detection. Whether you are implementing a General Ledger from scratch or moving toward a ledger-as-event-log pattern, this skill provides the schemas, validation rules, and architectural patterns necessary to ensure financial data integrity and auditability.

Key Features

01Standardized double-entry bookkeeping schema and validation rules

0211 GitHub stars

03Hash-chained integrity patterns for unauthorized edit detection

04Immutable append-only audit trails with reversal pattern implementation

05Hybrid balance strategy guidance (Running vs. Computed balances)

06Chart of accounts numbering conventions and sub-ledger reconciliation logic

Use Cases

01Building a custom payment processing platform or digital wallet

02Implementing internal financial record-keeping for e-commerce systems

03Refactoring legacy financial databases into event-sourced architectures

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer ledger-design

For use in Claude.ai and ChatGPT

Key Features

01Standardized double-entry bookkeeping schema and validation rules

0211 GitHub stars

03Hash-chained integrity patterns for unauthorized edit detection

04Immutable append-only audit trails with reversal pattern implementation

05Hybrid balance strategy guidance (Running vs. Computed balances)

06Chart of accounts numbering conventions and sub-ledger reconciliation logic

Use Cases

01Building a custom payment processing platform or digital wallet

02Implementing internal financial record-keeping for e-commerce systems

03Refactoring legacy financial databases into event-sourced architectures

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer ledger-design

For use in Claude.ai and ChatGPT