Identify possible source of calculation error from list of values

Good day

I am in the process of building an excel model that will assist/automate the process of identifying possible errors in calculation that resulted in the out-of -balance amount.

This is specific to cashiers who can spend between 30 mins and 5 hrs trying to indentify the possible error, if the process is performed manually.

There are set of logical mathematical rules that one has to follow during this process and I want to translate these rules into user defined functions that could assist the user.

Attached is a cdocument with the Common Balancing errors as well as the math logic to resolve the errors.

Your assistance is appreciated.

Originally Posted by martindwilson

try the commercial services exchange forum if you want someone to work through all that!
or attempt it yourself then comeback here for help on functions you need assistance with.

Thank you for your reply.