ShopClock Exports Time Clock Data To QuickBooks

Use of computer or pc based time clocks greatly increase the speed and accuracy of the first step of payroll processing by performing all the necessary calculations needed to get the raw time card data ready to enter into the payroll package. In the case of QuickBooks, ShopClock also increases the speed and accuracy of the next step in the process by exporting the time clock data in a form that can be easily imported by QuickBooks payroll program.

Import/Exporting is a two way street

This is actually a two way street: employee information is passed from QuickBooks to ShopClock and then time sheet information is passed back to QuickBooks.

The first step is to export the employee list from QuickBooks and import it into ShopClock. This step can be repeated whenever the employee information in QuickBooks is changed or new employees are added. During this process the information about employees who were previously imported to ShopClock is automatically updated while new employees are added. The fact that the employee information only needs to be keyed in once saves time and improves accuracy. Updating the information in QuickBooks also keeps ShopClock current.

In the second step the time clock data is exported from ShopClock and imported by QuickBooks. When ShopClock processes the time clock data for a payroll period it calculates the number of normal hours worked, overtime hours worked, and in California the number of double overtime hours worked. It then adds any sick time, vacation time, holiday time, and bereavement time which has been assigned to the employee for that pay period. This data is of course available on a pay processing report and could be keyed into any payroll package. The data is also written to an iif file (intuit interface file) which can be imported by the QuickBooks payroll package. The iif file exported from ShopClock breaks the data into the day by day time sheet form used by quick books. That is the number of regular hours worked, overtime hours worked, vacation, sick, holiday, and bereavement hours taken each day of the pay period are passed to QuickBooks – not just the totals. That saves a lot of data entry time, and eliminates a lot of potential transcription errors.