Just based on what I am reading about building such systems, it seems like the common advice is to not have a single balance column such as `running_balance`, b

Just based on what I am reading about building such systems, it seems like the common advice is to not have a single balance column such as `running_balance`, but instead calculate this value on the go every time it is needed. That's fine. What else?