Raw time clock inputs

The "before": each store's export exactly as it arrived, in that store's own format. Rows the engine flagged are highlighted and link to the exception.

Store A Northgate Market 15 flagged Store B Riverside Plaza 5 flagged Store C Lakeview Commons

Store A: Northgate Market

Format store_a · file store_a_timeclock.csv · 159 rows · columns as exported: EmpID, Date, Time, Type, Dept

16 rows outside Sep 7 to 20 were skipped (shifts that belong to another pay period).

Row EmpID Date Time Type Dept Flagged by the engine
4 10012026-09-0708:00INFloor
5 10012026-09-0717:00OUTFloor
6 10022026-09-0709:00INCheckout
7 10022026-09-0717:00OUTCheckout
8 10032026-09-0709:00INStockroom
9 10032026-09-0717:00OUTStockroom
10 10042026-09-0709:00INStockroom
11 10042026-09-0717:00OUTStockroom
12 10052026-09-0709:00INCheckout
13 10052026-09-0717:00OUTCheckout
14 10062026-09-0709:00INFloor
15 10062026-09-0717:00OUTFloor
16 10112026-09-0709:00INCheckout
17 10112026-09-0717:00OUTCheckout
18 10012026-09-0808:00INFloor
19 10012026-09-0817:00OUTFloor
20 10022026-09-0809:00INCheckout Handled by rule Duplicate punch
21 10022026-09-0809:01INCheckout Handled by rule Duplicate punch
22 10022026-09-0817:00OUTCheckout
23 10032026-09-0809:00INStockroom
24 10032026-09-0817:00OUTStockroom
25 10042026-09-0809:00INStockroom
26 10042026-09-0817:00OUTStockroom
27 10052026-09-0809:00INCheckout
28 10052026-09-0817:00OUTCheckout
29 10062026-09-0809:00INFloor
30 10062026-09-0817:00OUTFloor
31 10112026-09-0809:00INCheckout
32 10112026-09-0817:00OUTCheckout
33 10012026-09-0908:00INFloor Attendance to discuss Partial day
34 10012026-09-0911:30OUTFloor Attendance to discuss Partial day
35 10022026-09-0909:00INCheckout Needs review Unreadable row
36 10022026-09-0917:00OUTCheckout Needs review Unreadable row
37 10022026-09-099:6OINCheckout malformed row

Time 9:6O can't be read:

  • "O" is a letter, not the digit 0.
  • Minute 60 doesn't exist: minutes run from 00 to 59.

Expected format: HH:MM

Needs review Unreadable row
38 10032026-09-0909:00INStockroom
39 10032026-09-0917:00OUTStockroom
40 10042026-09-0909:00INStockroom
41 10042026-09-0917:00OUTStockroom
42 10052026-09-0909:00INCheckout
43 10052026-09-0917:00OUTCheckout
44 10062026-09-0909:00INFloor
45 10062026-09-0917:00OUTFloor
46 10112026-09-0909:00INCheckout
47 10112026-09-0917:00OUTCheckout
48 10012026-09-1008:00INFloor
49 10012026-09-1017:00OUTFloor
50 10022026-09-1009:00INCheckout
51 10022026-09-1017:00OUTCheckout
52 10032026-09-1009:00INStockroom Needs review Missed clock-out
53 10042026-09-1009:00INStockroom
54 10042026-09-1017:00OUTStockroom
55 10052026-09-1009:00INCheckout
56 10052026-09-1017:00OUTCheckout
57 10062026-09-1009:00INFloor
58 10062026-09-1017:00OUTFloor
59 10112026-09-1009:00INCheckout
60 10112026-09-1017:00OUTCheckout
61 10182026-09-1009:00IN(empty)
62 10182026-09-1017:00OUT(empty)
63 10012026-09-1108:00INFloor
64 10012026-09-1117:00OUTFloor
65 10022026-09-1109:00INCheckout
66 10022026-09-1117:00OUTCheckout
67 10032026-09-1109:00INStockroom
68 10032026-09-1117:00OUTStockroom
69 10042026-09-1122:00INStockroom Handled by rule Overnight shift
70 10052026-09-1109:00INCheckout
71 10052026-09-1117:00OUTCheckout
72 10112026-09-1109:00INCheckout
73 10112026-09-1117:00OUTCheckout
74 10182026-09-1109:03IN(empty)
75 10182026-09-1116:57OUT(empty)
76 10042026-09-1206:00OUTStockroom Handled by rule Overnight shift
77 10052026-09-1322:00INCheckout Handled by rule Overnight shift
78 10012026-09-1408:00INFloor
79 10012026-09-1417:00OUTFloor
80 10022026-09-1409:30INCheckout Attendance to discuss Late arrival
81 10022026-09-1417:00OUTCheckout
82 10032026-09-1409:00INStockroom
83 10032026-09-1417:00OUTStockroom
84 10042026-09-1409:00INStockroom
85 10042026-09-1417:00OUTStockroom
86 10052026-09-1406:00OUTCheckout Handled by rule Overnight shift
87 10052026-09-1409:00INCheckout
88 10052026-09-1417:00OUTCheckout
89 10062026-09-1409:00INFloor
90 10062026-09-1417:00OUTFloor
91 10112026-09-1409:00INCheckout
92 10112026-09-1417:00OUTCheckout
93 10012026-09-1508:00INFloor
94 10012026-09-1517:00OUTFloor
95 10022026-09-1509:00INCheckout
96 10022026-09-1517:00OUTCheckout
97 10032026-09-1509:00INStockroom
98 10032026-09-1517:00OUTStockroom
99 10042026-09-1509:00INStockroom
100 10042026-09-1517:00OUTStockroom
101 10052026-09-1509:06INCheckout
102 10052026-09-1517:00OUTCheckout
103 10062026-09-1509:00INFloor
104 10062026-09-1517:00OUTFloor
105 10112026-09-1509:00INCheckout
106 10112026-09-1517:00OUTCheckout
107 10012026-09-1608:00INFloor
108 10012026-09-1617:00OUTFloor
109 10022026-09-1609:00INCheckout
110 10022026-09-1617:00OUTCheckout
111 10032026-09-1609:00INStockroom
112 10032026-09-1617:00OUTStockroom
113 10042026-09-1609:00INStockroom
114 10042026-09-1617:00OUTStockroom
115 10062026-09-1609:00INFloor
116 10062026-09-1617:00OUTFloor
117 10102026-09-1609:00INFloor Needs review Shift logged at the wrong store
118 10102026-09-1617:00OUTFloor Needs review Shift logged at the wrong store
119 10112026-09-1609:00INCheckout
120 10112026-09-1617:00OUTCheckout
121 10012026-09-1708:00INFloor
122 10012026-09-1717:00OUTFloor
123 10022026-09-1709:00INCheckout
124 10022026-09-1717:00OUTCheckout
125 10032026-09-1709:00INStockroom
126 10032026-09-1717:00OUTStockroom
127 10042026-09-1709:00INStockroom
128 10042026-09-1717:00OUTStockroom
129 10052026-09-1709:00INCheckout
130 10052026-09-1717:00OUTCheckout
131 10062026-09-1709:00INFloor
132 10062026-09-1717:00OUTFloor
133 10112026-09-1709:00INCheckout
134 10112026-09-1717:00OUTCheckout
135 10012026-09-1808:00INFloor
136 10012026-09-1817:00OUTFloor
137 10022026-09-1809:00INCheckout
138 10022026-09-1817:00OUTCheckout
139 10032026-09-1809:00INStockroom
140 10032026-09-1817:00OUTStockroom
141 10042026-09-1809:00INStockroom
142 10042026-09-1817:00OUTStockroom
143 10052026-09-1809:00INCheckout
144 10052026-09-1817:00OUTCheckout
145 10062026-09-1809:00INFloor
146 10062026-09-1817:00OUTFloor

Store B: Riverside Plaza

Format store_b · file store_b_timeclock.csv · 119 rows · columns as exported: employee_code, punch_datetime, department

14 rows outside Sep 7 to 20 were skipped (shifts that belong to another pay period).

Row employee_code punch_datetime department Flagged by the engine
6 RV-20109/07/2026 08:00 AMFloor
7 RV-20209/07/2026 09:00 AMCheckout
8 RV-20409/07/2026 09:00 AMFloor
9 RV-20509/07/2026 09:00 AMStockroom
10 RV-20309/07/2026 09:01 AMStockroom
11 RV-20309/07/2026 04:59 PMStockroom
12 RV-20109/07/2026 05:00 PMFloor
13 RV-20209/07/2026 05:00 PMCheckout
14 RV-20409/07/2026 05:00 PMFloor
15 RV-20509/07/2026 05:00 PMStockroom
16 RV-20109/08/2026 08:00 AMFloor
17 RV-20209/08/2026 09:00 AMCheckout
18 RV-20409/08/2026 09:00 AMFloor
19 RV-20509/08/2026 09:00 AMStockroom
20 RV-20309/08/2026 09:03 AMStockroom
21 RV-20309/08/2026 04:58 PMStockroom
22 RV-20109/08/2026 05:00 PMFloor
23 RV-20209/08/2026 05:00 PMCheckout
24 RV-20409/08/2026 05:00 PMFloor
25 RV-20509/08/2026 05:00 PMStockroom
26 RV-20109/09/2026 08:00 AMFloor
27 RV-20209/09/2026 09:00 AMCheckout Needs review Odd number of punches
28 RV-20409/09/2026 09:00 AMFloor
29 RV-20509/09/2026 09:00 AMStockroom
30 RV-20309/09/2026 09:02 AMStockroom
31 RV-20209/09/2026 01:00 PMCheckout Needs review Odd number of punches
32 RV-20209/09/2026 01:30 PMCheckout Needs review Odd number of punches
33 RV-20309/09/2026 04:56 PMStockroom
34 RV-20109/09/2026 05:00 PMFloor
35 RV-20409/09/2026 05:00 PMFloor
36 RV-20509/09/2026 05:00 PMStockroom
37 RV-20109/10/2026 08:00 AMFloor
38 RV-20209/10/2026 09:00 AMCheckout
39 RV-20409/10/2026 09:00 AMFloor
40 RV-20509/10/2026 09:00 AMStockroom
41 RV-20309/10/2026 09:01 AMStockroom
42 RV-20309/10/2026 04:58 PMStockroom
43 RV-20109/10/2026 05:00 PMFloor
44 RV-20209/10/2026 05:00 PMCheckout
45 RV-20409/10/2026 05:00 PMFloor
46 RV-20509/10/2026 05:00 PMStockroom
47 RV-20109/11/2026 08:00 AMFloor
48 RV-20209/11/2026 09:00 AMCheckout
49 RV-20409/11/2026 09:00 AMFloor
50 RV-20509/11/2026 09:00 AMStockroom
51 RV-20309/11/2026 09:04 AMStockroom
52 RV-20609/11/2026 10:00 AMStockroom
53 RV-20609/11/2026 04:00 PMStockroom
54 RV-20109/11/2026 05:00 PMFloor
55 RV-20209/11/2026 05:00 PMCheckout
56 RV-20309/11/2026 05:00 PMStockroom
57 RV-20409/11/2026 05:00 PMFloor
58 RV-20509/11/2026 05:00 PMStockroom
59 RV-20609/12/2026 10:00 AMStockroom
60 RV-20609/12/2026 04:00 PMStockroom
61 RV-20109/14/2026 08:00 AMFloor
62 RV-20209/14/2026 09:00 AMCheckout
63 RV-20409/14/2026 09:00 AMFloor
64 RV-20509/14/2026 09:00 AMStockroom
65 RV-20109/14/2026 05:00 PMFloor
66 RV-20209/14/2026 05:00 PMCheckout
67 RV-20409/14/2026 05:00 PMFloor
68 RV-20509/14/2026 05:00 PMStockroom
69 RV-20109/15/2026 08:00 AMFloor
70 RV-20209/15/2026 09:00 AMCheckout
71 RV-20409/15/2026 09:00 AMFloor
72 RV-20509/15/2026 09:00 AMStockroom
73 RV-20309/15/2026 09:04 AMStockroom
74 RV-20109/15/2026 05:00 PMFloor
75 RV-20209/15/2026 05:00 PMCheckout
76 RV-20309/15/2026 05:00 PMStockroom
77 RV-20409/15/2026 05:00 PMFloor
78 RV-20509/15/2026 05:00 PMStockroom
79 RV-20109/16/2026 08:00 AMFloor
80 RV-20209/16/2026 09:00 AMCheckout
81 RV-20509/16/2026 09:00 AMStockroom
82 RV-20309/16/2026 09:02 AMStockroom
83 RV-20109/16/2026 05:00 PMFloor
84 RV-20209/16/2026 05:00 PMCheckout
85 RV-20309/16/2026 05:00 PMStockroom
86 RV-20509/16/2026 05:00 PMStockroom
87 RV-20209/17/2026 09:00 AMCheckout
88 RV-20409/17/2026 09:00 AMFloor
89 RV-20509/17/2026 09:00 AMStockroom
90 RV-20309/17/2026 09:02 AMStockroom
91 RV-20309/17/2026 04:57 PMStockroom
92 RV-20209/17/2026 05:00 PMCheckout
93 RV-20409/17/2026 05:00 PMFloor
94 RV-20509/17/2026 05:00 PMStockroom
95 RV-20109/18/2026 08:00 AMFloor
96 RV-20209/18/2026 09:00 AMCheckout
97 RV-20409/18/2026 09:00 AMFloor
98 RV-20509/18/2026 09:00 AMStockroom
99 RV-20309/18/2026 09:02 AMStockroom
100 RV-21109/18/2026 10:00 AMCheckout
101 RV-21109/18/2026 04:00 PMCheckout
102 RV-20109/18/2026 05:00 PMFloor
103 RV-20209/18/2026 05:00 PMCheckout
104 RV-20309/18/2026 05:00 PMStockroom
105 RV-20409/18/2026 05:00 PMFloor
106 RV-20509/18/2026 05:00 PMStockroom
107 RV-21109/19/2026 10:00 AMCheckout
108 RV-21109/19/2026 04:00 PMCheckout
109 RV-20309/20/2026 10:00 PMStockroom Handled by rule Overnight shift
110 RV-20309/21/2026 06:00 AMStockroom Handled by rule Overnight shift

Store C: Lakeview Commons

File note Store C's file has an extra column, "Badge", that we don't use. It was ignored and doesn't affect pay. If the store changed its export settings, it's worth a quick look.

Format store_c · file store_c_timeclock.csv · 56 rows · columns as exported: Name, Date, In, Out, Dept, Badge unknown column, ignored

6 rows outside Sep 7 to 20 were skipped (shifts that belong to another pay period).

Row Name Date In Out Dept Badge unknown Flagged by the engine
3 Parker Dunn2026-09-0708:0017:00FloorB-13
4 Riley Okafor2026-09-0709:0018:00FloorB-15
5 Rowan Pike2026-09-0709:0416:59CheckoutB-18
6 Sage Delgado2026-09-0709:0017:00CheckoutB-16
7 Taylor Voss2026-09-0709:0316:59StockroomB-17
8 Parker Dunn2026-09-0808:0017:00FloorB-13
9 Riley Okafor2026-09-0809:0018:00FloorB-15
10 Rowan Pike2026-09-0809:0116:59CheckoutB-18
11 Sage Delgado2026-09-0809:0017:00CheckoutB-16
12 Taylor Voss2026-09-0809:0417:00StockroomB-17
13 Parker Dunn2026-09-0908:0017:00FloorB-13
14 Quinn Harlow2026-09-0908:0017:00FloorB-14
15 Riley Okafor2026-09-0909:0018:00FloorB-15
16 Rowan Pike2026-09-0909:0217:00CheckoutB-18
17 Sage Delgado2026-09-0909:0017:00CheckoutB-16
18 Taylor Voss2026-09-0909:0216:56StockroomB-17
19 Parker Dunn2026-09-1008:0017:00FloorB-13
20 Quinn Harlow2026-09-1008:0017:00FloorB-14
21 Riley Okafor2026-09-1009:0018:00FloorB-15
22 Sage Delgado2026-09-1009:0017:00CheckoutB-16
23 Taylor Voss2026-09-1009:0017:00StockroomB-17
24 Parker Dunn2026-09-1108:0017:00FloorB-13
25 Quinn Harlow2026-09-1108:0017:00FloorB-14
26 Riley Okafor2026-09-1109:0018:00FloorB-15
27 Sage Delgado2026-09-1109:0017:00CheckoutB-16
28 Taylor Voss2026-09-1109:0117:00StockroomB-17
29 Quinn Harlow2026-09-1408:0017:00FloorB-14
30 Riley Okafor2026-09-1409:0017:00CheckoutB-15
31 Rowan Pike2026-09-1409:0417:00CheckoutB-18
32 Sage Delgado2026-09-1409:0017:00CheckoutB-16
33 Taylor Voss2026-09-1409:0416:58StockroomB-17
34 Quinn Harlow2026-09-1508:0017:00FloorB-14
35 Riley Okafor2026-09-1509:0017:00CheckoutB-15
36 Rowan Pike2026-09-1509:0116:59CheckoutB-18
37 Sage Delgado2026-09-1509:0017:00CheckoutB-16
38 Taylor Voss2026-09-1509:0116:58StockroomB-17
39 Quinn Harlow2026-09-1608:0017:00FloorB-14
40 Riley Okafor2026-09-1609:0017:00CheckoutB-15
41 Rowan Pike2026-09-1609:0217:00CheckoutB-18
42 Sage Delgado2026-09-1609:0017:00CheckoutB-16
43 Quinn Harlow2026-09-1708:0017:00FloorB-14
44 Riley Okafor2026-09-1709:0017:00CheckoutB-15
45 Rowan Pike2026-09-1709:0116:59CheckoutB-18
46 Sage Delgado2026-09-1709:0017:00CheckoutB-16
47 Taylor Voss2026-09-1709:0316:59StockroomB-17
48 Quinn Harlow2026-09-1808:0017:00FloorB-14
49 Riley Okafor2026-09-1809:0017:00CheckoutB-15
50 Rowan Pike2026-09-1809:0416:58CheckoutB-18
51 Sage Delgado2026-09-1809:0017:00CheckoutB-16
52 Taylor Voss2026-09-1809:0416:58StockroomB-17