This is the answer for any serious banking/accounting software.

Balance is calculated & stored after the fact from a known correct value.