Let's say I have a business; I do all my transactions in "System A" and then, later re-enter these transactions into "System B". System A has the advantage of being 'live'. If I need information on an individual teller's history, I can have it right away. System B has the advantage of some internal tools that make financial reporting and statements easy to pull and create.

(I have a team in-place that enters the transactions into one or both of the systems)

To reconcile both System 'A' and 'B', I currently download both sets of transactions into an excel spreadsheet and manually highlight/check each one off.

​

One of the systems, (system B) is an outdated version of SAGE 500... is there anything that I can do in SAGE 500 to make the reconciliation easier? Is there any way to treat transactions like a physical object and then update the state of them to "reconciled". The important thing is that everything makes it's way into SAGE. Any and all ideas are welcome. Thanks!