The problem

The client was overwritng data in the HR database ie when people changed addresses.

2 staff were spending a lot of time logging each change made to the database manually and then sending them to the payroll department where the changes were then input manually into the payroll database.

The solution was to create an automatic data checking system that would allow the users to email the changes in excel format showing the previous information together with the changes. This data could then be automatically imported into the payroll database.

The benefit was that all changes however small would be extracted making it 100% accurate. One user could email the results in seconds rather than 2 Users taking days to record the changes, thus freeing them up for more important tasks. They also had an archive in electronic form of only the important changes made to the database.

The changes were split into three parts. Changes since the previous day. Changes since the previous week and changes since the last payroll handoff, (Monthly)

The reports were conditionally formatted to make visual checking easier.