@Akintola_steve Best approach is a hybrid Balance System.
Ledger records every transaction but isn't used for balance reads. Keep a balance column + Redis cache for fast retrieval. Update all three on every successful transaction. Run a scheduler for reconciliation and consistency checks.