Back to challenges
Company Tracks: Netflix-style and Stripe-styleQuick Decisionadvanced5 minPro
Stripe double-entry ledger
Choose a double-entry ledger fact over a single signed-balance column.
How this preview works
Preview this problem before signing in. Sign in to save progress and submit work.
Concept
fact-table-grain
The primary modeling idea this problem reinforces.
Requirements
0
Business needs the model must satisfy.
Scenario
A team needs account balances that always reconcile across charges, refunds, payouts, and fees. One proposal keeps a single running-balance column per account; another models a double-entry ledger with balanced debit and credit entries.
Why this matters
A running-balance column drifts and cannot explain itself. A double-entry ledger (balanced debit and credit entries per transaction) reconciles by construction and is auditable.
Requirements
What success looks like
Common pitfalls
Reference approaches
These are valid approaches, not one absolute answer.
Try the question first.
The discussion has other people's approaches and solutions. Give it a real attempt before you read them.