PAYROLL

[gvishal]

I am looking for some details for capturing the information of the time spent by people in my organization.

The way it works is like this:

It’s a manufacturing company with people working in the production , warehouse and other facilities in shifts throughout the day. There are around 150-170 people in the factory.

As of now, we have a system where each shift supervisor records the time of all of its employees in spreadsheet. At the end of the week, the person handling the payroll takes the information from all these sheets and manually puts it in a Access database.

The process of manually entering the hours spent by each employee in the access database is tedious and time consuming. And the biggest drawback is the chance of error which is huge. Moreover, since this is a weekly activity, the process has to be repeated again and again.

Can anyone suggest what could be a better way of doing all this.

Also, is it possible that the information from the excel spreadsheet can be directly sent to the access database.

Suggestions for any other better way will be highly appreciated.

 

[RichUK]

Why can't shift supervisors enter the data directly into Access?

 

[MichaelRed]

I agree with RichUK.

Even a small app in Ms. Access could be easier for the supervisors to use for data entry and include validation functions to asure that info was entered consistiently and properly. A time-keeping app of this nature could a table for a single week, and have the payroll program import the records weekly and clear the records from the time keeping table.

If you have 'new' fashioned time clocks, many of them have an interface which allows an external device to capture each transaction (Log In /Out), so a small program could just capture the info at the "clock" and relieve the supervisors of even the data entry.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over