Oh and a little bit of extra information on the 4 systems, 2 of them are point of sale based data and 2 are from post POS settlement/adjustment software. Ideally...

Thank you all for your replies they have been very helpful.

@Koen - Our intention is primarily for auditing but I can see scenarios where it would be useful for...