Per-Grant Point Expiration: 15 Years of Production-Tested Ledger Design

Managing points that expire individually—not as a batch—is far more complex than standard retention-based systems, requiring careful handling of cancellations, accounting reconciliation, and point-in-time balance queries. This article presents a proven three-table ledger design that tracks which grants each spend consumed, enabling exact cancellation and balance verification. The design has delivered zero inconsistencies across 15 years of production use and scales to handle 100k events per day on PostgreSQL.