Pay Reporting

[eMJay00]

Looking for someone to provide advice please...

I have enclosed a template (obviously replacing sensitive information with bogus info) to help you see what I am trying to do...

My goal is to promulgate a database whereby;

- Each pay period I extract a report from our system and copy it into the respective pay period tab (refer to P01 for example extract).
- The information is then automatically married against the data in the ‘Report’ tab
- If the data in the Pay Period tab does not marry with the report tab then the cell that contains the incorrect information changes colour (or something to identify a discrepancy)

Ideally I intend on reducing the man hours involved in manually entering the data to conduct a check to ensure that all personnel receive the correct entitlements and are charged against the correct cost centre.

Any advice (even a better way of displaying this info that is easy for me to report to Management) would be much appreciated!