For the example of an account, moving to double entry accounting is probably the correct move. With an external reconciliation process to take action if they don't match.

But, that "external" part is what trips up a lot of people. Few things are confined to only exist within the database. Such that sometimes you can't do locks that accurately portray what we can order outside of the computer system. Think legal clawbacks and the like.