should we consider using transactions tables in our databases so any errors can be amended with adjustments to transactions so all corrections can be followed as we do in account programs.

This would please the auditors and give a clear picture of what has happened.