I don't understand what you are doing.
In all the erps I've ever worked with balance is never saved. It's always recalculated on the fly.
If you want to keep it in sync after in update, delete, insert you need to create a trigger that updates the balance after any operations.