PRWIN (Go Green) – Time Card/Clock

About Go Green Time Clock feature is available in PRWIN version 2.0.002 or higher with a Go Green license that can be purchased by contacting Sales at 800-844-0884 or FM Support at 800-372-7398 or [email protected]. Time Card: Time Card refers to a data entry section of PRWIN that allows manual pre-entry of time cards which is later imported into a payroll. Time Clock: Time Clock refers to third-party software that has a time clock option. An employee’s time is entered in the time clock software and a file is created. PRWIN collects the data from the time clock software file, automatically loads it into the Time Card section, and it is later imported into a payroll.

Time Card / Time Clock Setup Pre-Maintenance To begin using the Time Card/Clock feature the Job Titles must be orderly. In some cases, the Job Classifications may also need to be re-organized which can be a lengthy and tedious process. Contact FM Support at 800-372-7398 or [email protected] for assistance. To use the Time Card/Clock feature it is not a requirement to re-organize the Job Titles but it is highly recommended. Disorderly Job Titles can make using this feature cumbersome. 1.

2.

Definitions: o

Job Classification(Class) = The main job, such as Transportation.

o

Job Title = A breakdown of the Job Class according to the job being performed by the employee, such as Trans Regular Route, Trans AM Route, Trans PM Route, Trans PreK Route, Trans Field Trips, or Trans Athletic Trips.

Time Cards Entered by Job Title: The Time Cards are entered using the employee’s Job Title. The thirdparty Time Clock software system also uses the Job Title to enter time.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 1

3.

Creating Job Titles: Previous to PRWIN version 2.0.002, Job Titles were selected from the drop down() or added new by typing in the Job Title field on the Job Class tab of employee maintenance. Now Job Titles can only be selected by clicking the drop down(). If the Job Title does not exist, go to References Æ Job Titles where it can be added.

In PRWIN version 2.0.002 or higher there is a new Reference called Job Titles. Job Titles are added, edited, and deleted in this Reference option. This list will be displayed in the Job Title drop down() on the Job Class tab of employee maintenance.

4.

Job Title Organization/Clean Up: References Æ Job Titles

o

The toolbar is active and all Job Titles can be edited. This edit will change the name in all areas where it can be seen or used.

o

If the name of a Job Title is being changed, keep it the same type.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 2

Example: Change “Aide Elementary” to “Aide GS”. Do not change “Aide Elementary” to “Cafeteria Head Cook.” o

If there are Job Titles that mean the same thing, select one and use it for all. Example: “Cafeteria Help”, “Cafeteria(2), “Café Worker”, and “Lunchroom” all represent the same job. Choose the one used by most, change it to be what is needed, such as “Cafeteria”, and use it for all. It may be helpful to rename those that will not be used to begin with a Z such as “Z Lunchroom” so they sort at the end of the list. Instructions on how to find and change incorrect Job Titles on employees is explained later.

o

A Job Title cannot be deleted if it is used on any record. A warning will be received if an active Job Title has been selected for deletion.

To assist in making these changes, run a Job Class/Title List. 5.

Verify Job Title Changes: Reports Æ Job Class/Title List

Notice how all the Job Titles begin with a form of the Job Class name. This makes them easy to find and identify. Job Titles followed by a number will not be allowed by the time clock software. Example: Cafeteria(2) Use codes that are easy to decipher. Be specific with the Job Title names so it is clear which one to choose.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 3

6.

Assign a Default Job Title: References Æ Job Classifications Now that the Job Titles have been cleaned up, select a default Title for each Job Class. When a Job Class is added to an employee’s record, the Job Title will default to the one selected here. If it is not the right one for this employee, it can be changed in the employee’s record when it is being added.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 4

7.

Change Incorrect Job Titles: Data Entry Æ Employee Go to each time card employee and make sure the Job Class is marked Hourly. Then look at the Job Title and see if it needs to be changed. If so, click Edit , click the Job Title drop down(), and select the proper Job Title.

8.

Search for Incorrect Job Titles: Reports Æ Employee List While making the Job Title changes to the employee records, it may be helpful to Preview an Employee List as shown below to search for Job Titles that need to be changed.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 5

The report can be previewed to the screen to easily find Job Titles that need to be changed as follows:

a. Click the binoculars on the toolbar to search. b. Type the name of a Job Title that needs to be replaced and press the Enter key or click the Find Next button.

c. Write down the name of the employee. d. Press Enter or click the Find Next button repeatedly until a message is displayed that says no more can be found.

e. One by one, in Data Entry Æ Employee, find each employee on the list and replace the Job Title.

Data Entry Preferences for Manual Entry File Æ Preferences/Setup Æ Time Clock tab Manual Entry Date Range – When entering time for an employee, there is a field for Begin Date/Time and End Date/Time. To make entering these fields quick and easy, the End Date can be defaulted to a certain number of days after the Begin Date. Choose the number of days that applies. Be sure to include weekend days in the count. Examples: •

If the hourly time is being entered daily then 0 days should be entered.

•

If the hourly time is being entered weekly then 6 days should be entered.

•

If the hourly time is being entered for a two-week period of time, then 13 days should be entered and so on

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 6

This is only used when time is being imported from third-party time clock software.

Manual Entry Data Entry Æ Time Cards Only Job Titles that are hourly with active job statuses will be in the Time Cards Employee List. See screen below. To include inactive job Statuses, select (;) Include Inactive. Dates: The dates entered are very important. When the Time Cards are imported into a payroll, the dates to import will be selected according to the date range of the payroll. Add time for an employee 1.

Select or search

2.

Add

Chalkable_1017160832

for the employee.

PRWIN (Go Green) – Time Card/Clock • 7

3.

Begin Date/Time: Type or select () the Begin Date, press tab. Type or select

the Begin Time, press tab.

Hints on Entering the Time: o

The actual time does not have to be inserted. If it is not changed to reflect the actual working time, it will default to 12:00 am – 12:00 pm.

o

If the time is being entered daily, the time can be what it really is.

o

If the time is being entered for a date range, the time might be the employee’s regular assigned schedule, such as 8:00 am to 4:30 pm.

4.

End Date/Time: Type or select () the End Date, press tab. Type or select Hints on Entering the Time, step 3 above.

5.

Units: Type the number of Units worked, press tab. If the time is being entered daily with the exact Begin Time and End Time, the Units will be automatically calculated.

6.

Type: If the type of pay is correct, press tab. If it is not correct click the drop down () or the up/down arrow keys to make a selection and then press tab. If the type of pay does not exist in the drop down (), exit Time Cards and go to Data Entry Æ Employees Æ Income tab. Find the type of pay in the Income Type column and enter a rate of pay. This will allow its display in the drop down () in Time Cards.

7.

Rate: The rate of pay for the selected type of pay will default to what is entered on the employee’s Income tab. It can be changed here for this entry only if necessary, but changing it here will not change it on the employee’s Income tab. Press tab.

the End Time, press tab. See

8. Pay: The units will be multiplied by the rate and entered in this field. Press tab. 9. Edit Accounts: Press this button to change the employee’s salary account number. This will also change the account number on the employee’s Job Class tab. 10. Comments: Type a comment if needed. Only part of the first line will print on the Time Card report. 11. Save 12. Skip ahead for instructions on importing time cards into a payroll.

Preferences for Time Clock Entry File Æ Preferences/Setup Æ Time Clock tab Time clock needs a way to identify the employee, the job, and the type of pay. The employee and job will be assigned IDs in preferences and the type of pay ID will be manually entered. Electronic files will be created to send to the time clock software company. Select (;) Turn On Time Clock Feature

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 8

Default Time Clock Employee ID Field as: ({) No Default – Enter all employee Time Clock IDs manually. (~) Employee Number – The Time Clock ID will be the same as the Employee ID. This is the option recommended. ({) Auto Generate – A random number will be assigned to the Time Clock ID.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 9

Default Time Clock Job ID Field as: ({) No Default – Enter all Job Title Time Clock IDs manually. ({) Job Title – The Job ID will be the same as the Job Title. (~) Auto Generate – A random number will be assigned to the Job ID. This is the option recommended. After making these two selections, press the OK button. The Time Clock IDs for employees and job titles have now been assigned. References Æ Income Types Click Add to add Unpaid as a new type of pay. Assign it a number in sequence.

the

The Time Clock software needs a way to identify the type of pay. Using the list below, manually type the three-letter Time Clock ID which represents the type of pay. Enter only the types of pay needed. The Description and Sequence No. are whatever the user prefers. Enter the “leave” types of pay as listed below so the employee can also enter the hours to be received for these days. This will only make sure they are paid, it does not automatically update attendance. Auto Generated Pay is the type of pay automatically entered by the system when the Update Contract Amounts utility is used. Do not enter a Time Clock Id for this type of pay. Regular Pay .................................... REG Overtime Regular Pay .................... OTR Overtime Double Pay ..................... OTD Extra Pay ........................................ EXT Substitute Pay ................................. SUB Unpaid ............................................ UNP Sick Pay.......................................... SIC Personal Pay ................................... PER Professional Pay ............................. PRO Vacation Pay................................... VAC Holiday Pay .................................... HOL Bereavement Pay ............................ BER Jury Duty Pay ................................. JUR When finished, click Close.

Chalkable_1017160832

If you have a type of pay used by hourly employees that is not listed here, please contact FM Support at 309-372-7398 or [email protected].

PRWIN (Go Green) – Time Card/Clock • 10

Payroll Æ Magnetic Media Æ Time Clock Codes 1. Create a folder called TimeClockCodesNameOfYourSchool on a selected drive. 2. Export File Path: Click the ellipses(…) button to select the folder just created. 3. Select (~) Job Titles and click OK. 4. Select (~) Employees and click OK. 5. Select (~) Income types and click OK.

6. Three files will be created. Zip the folder in which they are contained and according to the instructions of the third-party software company, send the zipped file.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 11

Time Clock Data Collection Instructions for Use The time clock software company will send a file containing the data needed to load Data Entry Æ Time Cards. Please contact the time clock company for details. Create a folder called TimeCards on a selected drive in which to store the file received from the time clock company. Data Entry Æ Time Cards Æ Collect Time Clock Data 1. Select Time Clock File Path & Name to Import– Click the ellipses(…) to search for and select the time clock file.

2. Click OK. 3. View Time Cards – The time clock data to be imported can be viewed. This grid can be printed by selecting the Print button.

4. Click Continue. If no exceptions or errors were received, skip to Import Time Cards into Payroll. All exceptions and errors must be fixed before continuing. See Possible Exceptions and Errors on page 181 for a list of possible exceptions and errors and how they can be fixed.

View Collected Time Clock Data Data Entry Æ Time Cards Æ Time Card Maintenance

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 12

The information showing in Employee Detail reflects the data from the highlighted line in the Employee History grid.

•

Clock Data: This shows that the information from the highlighted line in the grid was collected from the time clock. Each line entry has a unique time clock ID number. In the example above, the number is 1560422174. If Clock Data is blank, the record was manually entered.

•

Valid column: A check indicates the record has no exceptions or errors.

•

Clock column: A check indicates the record was collected from the time clock.

•

Imp column: A check indicates the record has been imported into a payroll.

•

Paid column: A check indicates the record has been included in a payroll and the check has been printed.

Remove Time Clock Data Collected data can be removed for any reason as long as it has not been imported into a payroll. If it has been imported into the payroll, it must first be un-imported from payroll and then it can be removed from Time Card Maintenance. A time clock file can be collected and removed repeatedly as necessary.

Â

If there are items that need to be fixed on the time clock side, that should be done first. Contact the time clock company for assistance. A new file will be sent so the bad data must be removed as follows: Data Entry Æ Time Cards Æ Remove Time Clock Data tab Click the drop down () to select the Purged Time Clock Data. Click OK.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 13

Exceptions and Errors See Possible Exceptions and Errors on page 19 for a list of possible exceptions and errors and how they can be fixed.

Exceptions example – All Exceptions have something to do with the Job Title and all must be fixed. Data Entry ÆTime Cards Æ Time Clock Exceptions tab

Highlight an exception and click

.

Search for the employee and select the correct Job Title. The correct Job Title cannot be selected here because it does not exist.

In this example, go to Data Entry Æ Employees and on the Job Class tab, select the correct Job Title, Custodial.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 14

Go back to Time Clock Exceptions and select

Continue in this manner until all exceptions are removed from the list.

Errors example – All Errors must fixed. See Possible Exceptions and Errors on page 19 for a list of possible exceptions and errors and how they can be fixed. To see the errors in this example go to Reports Æ Time Card Report Group by:

Employee

Report Options: (;)Invalid (;)Show Time Clock Data

Rate of Pay is Invalid – The Time Clock Data shows that in the time clock software a pay type of SUB was used for the job title, Custodial Substitute. It should have been REG. In the example data, Tremont Training School, only teacher substitutes use the Substitute type of pay. Go back to Time Card Maintenance and select the employee.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 15

Type: Click the drop down() and select Regular Pay.

Continue in this manner until all errors are removed.

Verify all Exceptions and Errors have been Eliminated Go to Data Entry Æ Time Cards Æ Time Clock Exceptions

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 16

Click Validate

to make sure all exceptions and errors have been corrected.

If the message says “Validation Complete”, continue to next page. If there are more exceptions and errors continue to fix them until all invalid records have been eliminated. See Possible Exceptions and Errors on page 19 for a list of possible exceptions and errors and how to fix them. 5. Data Entry Æ Time Cards Æ Time Clock Exceptions tab Æ -ORReports Æ Time Card Report Run the Unimported Time Card Report as shown below and verify all records are correct.

Import Time Cards into Payroll End of Payroll Wizard Æ Payroll Information

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 17

Click Import Time Cards to Import all records from Time Card Maintenance that are on or before the end date of the date range of the payroll.

Click Yes.

Click OK.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 18

Payroll Information after import of time cards. Imported time card entries are gray lines. Selected lines are blue. Green lines represent Job Titles that are paid from a contract entered in the system.

If changes need to be made, all time cards must first be unimported.

6. Continue with payroll as usual.

Possible Exceptions and Errors Exceptions – All Exceptions will appear on the Time Clock Exceptions tab and will be listed in the grid. All Exceptions will be a problem with the Job Title. Examples: ¾

436,Michael Jones,Custodian,34,06/01/2013,09:00,06/01/2013,09:30,0.00,UNP,1610210546 436 – Employee ID Michael Jones – Employee Custodian – PRWIN Job Title 34 – Job Title ID 06/01/2013 – Begin Date 09:00 – Begin Time 06/01/2013 – End Date 09:30 – End Time 0.00 – Units UNP – Type of Pay ID 1610210546 – Time Clock Record ID In this example, Michael Jones does not have a Custodian job title, but does have Summer Custodian. Either click Correct and select Summer Custodian or enter a Custodian job title in his record so it can be selected.

¾

107,Marla Bennet,Custodian,34,06/01/2013,5:30,06/01/2013,10:30,5:00,REG,1609046793 For this exception, everything seems to be ok. Click Correct and select the employee and the job title so an association can be made between the exception and the employee. After validating the exception will be cleared, but an error will be displayed on the Time Card Report showing Invalid Emp ID.

Chalkable_1017160832

PRWIN (Go Green) – Time Card/Clock • 19

¾

504,Robert Orr,Custodian,00,06/01/2013,04:45,06/01/2013,11:15,06.50,REG,1601142350 The 00 shows the Job Title ID is missing. Click Correct and select the correct job title.

¾

637,Sara Kramer,Cafeteria,21,06/01/2013,07:30,06/01/2013,12:30,5.00REG,1596491832 The Job Title ID, 21, is not the same as the Job Title ID in PRWIN. Go to References Æ Job Titles and change the Time Clock ID.

When all exceptions have been addressed, go back to the Time Clock Exceptions tab and Validate

Errors:

.

To see the errors, run a Time Card Report.

Examples: •

Job Class is Inactive: Go to Data Entry Æ Employees and one by one activate all inactive Job Classes.

•

Income Type ID is Invalid: An employee used an Income Type in the Time Clock that was either not in PRWIN or did not have a Time Clock Code. Go to References Æ Income Types and add the Income Type and/or ID so it matches the Time Clock. - OR The Time Card is missing the Pay Type. Go to Time Cards Æ Time Card Maintenance and find the records with this error. Click Edit and select the correct Type of pay.

•

Job Class is Salary: All job classes used with the Time Clock must be Hourly not Salaried. Go to Data Entry Æ Employees Æ Job Class tab and change the job class to Hourly.

•

Units are Invalid: Go to Time Cards Æ Time Card Maintenance tab. Highlight the employee with the error and the records will show in the grid. Fix the Units or delete the record if they are not to be paid.

All records marked UNP (unpaid) should be deleted so $0.00 amounts will not be imported into payroll. When all errors have been addressed, go back to the Time Clock Exceptions tab and Validate

Chalkable_1017160832

.

PRWIN (Go Green) – Time Card/Clock • 20