Screen 2 — Exceptions

9 items need you

135 punches came across this week from 15 technicians on 18 jobs, 543.175 hours in total. Work down the stack. Nothing below it is waiting on you.

0 of 9 cleared
1Money at risk

Owen Marchetti has two punches running at the same time Wednesday

2.475 hrs
paid and not worked

The second punch opens 2 hours 48 minutes before the first one clocks out, and it never closed. Neither punch carries a job. Sent as exported, the day books 10.475 hours, and 2.475 of them have no hour type at all.

From your file
DateTechnicianJobInOutHours
10/7Owen Marchetti(no job)7:00:00 AM3:00:00 PM8.000
10/7Owen Marchetti(no job)12:12:30 PMnone2.475
Suggested
Drop the punch that never closed
Day as exported
10.475 hrs
Punch that never closed
− 2.475 hrs
Day after review
8.000 hrs
Overtime owed after review
0.000 hrs
2Needs your judgment

33 punches came across with no job on them

159.025 hrs
29.3% of the week, costed to nothing

Blank Job Name and blank Customer Name on 33 punches across 10 of your 15 technicians. Wendell Pruitt has no job on any of his 5 punches — all 40.000 hours of his week.

From your file
DateTechnicianJobInOutHours
10/1Gideon Ashcroft(no job)6:52:10 AM1:22:10 PM6.500
10/1Wendell Pruitt(no job)7:00:26 AM3:00:26 PM8.000
10/1Andres Tolliver(no job)7:00:31 AM10:30:31 AM3.500
10/1Tomas Brennigan(no job)9:30:00 AM1:30:00 PM4.000
10/1Owen Marchetti(no job)10:00:00 AM11:30:00 AM1.500
10/1Petra Lindqvist(no job)12:00:00 PM2:00:00 PM2.000
Suggested
Assign a job to each punch
Punches with no job
33
Hours sitting on no job
159.025 hrs
Technicians affected
10 of 15
Hours costed after review
159.025 hrs
3Money at risk

4 punches ran outside standard hours and none of them got night pay

11.000 hrs
owed the 10% night increase, paid at base

Standard hours are 5:00 AM - 5:30 PM. All 4 of these punches cross the 5:00 AM boundary, so not one of them is cleanly day or cleanly night. Each has to become two payroll lines. Your export has no night column, so nothing in the file could have told QuickBooks this.

From your file
DateTechnicianJobInOutDayNight
10/2Ruben AvilesTidewater - Bayside Clinic TI #TW-22913:30:12 AM11:30:12 AM6.5001.500
10/2Nestor QuillenTidewater - Bayside Clinic TI #TW-22913:30:12 AM11:30:12 AM6.5001.500
10/7Caleb WintersHARBORVIEW - ICU WINDOW RETROFIT PO# HV-408171:00:05 AM7:00:05 AM2.0004.000
10/7Dmitri HollowayHARBORVIEW - ICU WINDOW RETROFIT PO# HV-408171:00:41 AM7:00:41 AM2.0004.000
Suggested
Split each punch at 5:00 AM
Hours inside standard hours
17.000 hrs
Hours outside standard hours
11.000 hrs
Payroll lines out
8 from 4 punches
Night hours routed to night items
11.000 hrs
4Needs your judgment

16 days where two technicians punched an identical card

26 punches
entered twice by hand

Same jobs, same clock-in, same hours, different name on the card. Nestor Quillen + Ruben Aviles did it 5 days this week. One three-way: Caleb Winters, Dmitri Holloway, Tomas Brennigan on 10/6.

From your file
DateTechnicians on the identical cardPunches each
10/1Hector Dalmau + Isaac Fenworth2
10/1Caleb Winters + Dmitri Holloway1
10/1Nestor Quillen + Ruben Aviles1
10/2Hector Dalmau + Isaac Fenworth2
10/2Luca Bramble + Petra Lindqvist2
Suggested
Enter one card and copy it to the crew
Matched days
16
Punches entered twice
26
Punches you actually type
16
5Needs your judgment

High Time and Welding hours have nowhere to land in QuickBooks

$24.00
the extra $1.00 an hour on 24.000 hrs

17.000 hours of High Time and 7.000 hours of Welding this week. No payroll item exists for either one, so today the rate gets hand-edited on the paycheck. Screen 3 has the six items that fix this.

From your file
DateTechnicianJobCost codeInOutHours
10/1Kai RenfrowSUMMIT RIDGE PH2 CURTAINWALL JOB # 26-114High Time5:00:41 AM1:00:41 PM8.000
10/1Marcus OyebanjiIRONWOOD- WAREHOUSE 9 SKYLIGHTSWelding6:30:05 AM10:30:05 AM4.000
10/1Owen MarchettiMeridian Room 814 broken window MH-00551High Time11:30:14 AM2:30:14 PM3.000
10/2Kai RenfrowIRONWOOD- WAREHOUSE 9 SKYLIGHTSWelding10:45:03 AM1:45:03 PM3.000
10/6Kai RenfrowSUMMIT RIDGE PH2 CURTAINWALL JOB # 26-114High Time6:00:45 AM12:00:45 PM6.000
Suggested
Post the premium as a second line
High Time
17.000 hrs
Welding
7.000 hrs
Premium at $1.00 an hour
$24.00
6Needs your judgment

Kai Renfrow corrected his own hours in the note field Monday

0.500 hrs
logged over what he says he worked

He typed the correction into Payroll Note where nothing reads it. The punch still says 4.000 hours and that is what would upload.

From your file
DateTechnicianJobPayroll noteInOutHours
10/5Kai Renfrownorthgate mall store front broken 911 By Rick @ Food CourtSHOULD BE 3.5 FORGOT TO CLOCK OUT BEFORE THE SUPPLY RUN5:00:22 AM9:00:22 AM4.000
Suggested
Take the hours he wrote down
Punch as exported
4.000 hrs
Correction in his note
− 0.500 hrs
Punch after review
3.500 hrs
7Needs your judgment

Gideon Ashcroft never clocked out Wednesday afternoon

1.350 hrs
on a punch with no clock out

In at 1:17:33 PM on NORTHGATE FOOD COURT DOORS. No clock out. The file recorded 1.350 hours against it anyway, with no hour type.

From your file
DateTechnicianJobInOutHours
10/7Gideon AshcroftNORTHGATE FOOD COURT DOORS1:17:33 PMnone1.350
Suggested
Confirm the clock out
Clock in
1:17:33 PM
Clock out
missing
Hours recorded
1.350 hrs
8Needs your judgment

Halverson Builders is spelled two ways in the same week

31.500 hrs
split across two customer names

HALVERSON BUILDERS carries 21.500 hours and Halverson Builders carries 10.000 hours. Either you have two customers in QuickBooks or one of them will fail to match on the way in.

From your file
DateTechnicianJobInOutHours
10/1Caleb WintersHALVERSON - MARINA OFFICES7:30:11 AM1:30:11 PM6.000
10/1Dmitri HollowayHALVERSON - MARINA OFFICES7:30:11 AM1:30:11 PM6.000
10/2Tomas BrenniganHalverson Dock House6:15:22 AM11:15:22 AM5.000
10/5Tomas BrenniganHalverson Dock House6:14:43 AM11:14:43 AM5.000
Suggested
Point both spellings at one customer
HALVERSON BUILDERS
5 punches
Halverson Builders
2 punches
Customers after review
1
9Needs your judgment

4 payroll notes came across and one of them changes the pay

1 of 4
is an actual payroll correction

Kai Renfrow used the field to correct his hours. The other three are "k", "another good day at clearpane 8 hours", "tacos". Same field, nothing separating them.

From your file
DateTechnicianJobPayroll noteInOutHours
10/1Kai RenfrowSUMMIT RIDGE PH2 CURTAINWALL JOB # 26-114k5:00:41 AM1:00:41 PM8.000
10/1Wendell Pruitt(no job)another good day at clearpane 8 hours7:00:26 AM3:00:26 PM8.000
10/5Kai Renfrownorthgate mall store front broken 911 By Rick @ Food CourtSHOULD BE 3.5 FORGOT TO CLOCK OUT BEFORE THE SUPPLY RUN5:00:22 AM9:00:22 AM4.000
10/7Marcus Oyebanji(no job)tacos9:00:00 AM11:00:00 AM2.000
Suggested
Separate the corrections from the rest
Notes in the file
4
Payroll corrections
1
Everything else
3
Checked and cleared
  • Gideon Ashcroft clocked out at 5:26:42 PM on 10/13 minutes 18 seconds inside the 5:30 PM boundary. Thursday. No night pay owed.