NORTHGATE STAFFING - HOW WE CHASE TIMESHEETS EVERY FRIDAY (Made-up agency for a Stepthrough practice lesson. Written by the office manager, in her own words.) We place about 60 temporary workers at 14 client sites. Workers are paid weekly, and we cannot run payroll on Monday unless every timesheet is in and approved. What I do now, by hand: 1. Friday 9:00 AM. I open the Google Sheet called "Timesheets - This Week". Each row is one worker: Worker name, Mobile, Email, Client site, Supervisor name, Supervisor email, Hours submitted (blank until they submit), Approved by supervisor (Yes or blank). 2. Workers submit their hours with a Google Form on their phone. The form writes the hours into the sheet. By Friday morning about 20 of the 60 have not submitted. 3. I sort the sheet to find the blanks and email each of those workers one by one: "Hi, please submit your hours for this week by noon." It takes about an hour. Some of them only read texts, so I also text maybe 8 people from my own phone. 4. At noon I check again. Usually 5 or 6 are still missing. I call them. 5. For everyone who has submitted, the supervisor at the client site has to approve the hours. I email each supervisor a list of their workers and hours and ask them to reply "approved". There are 14 supervisors. About 4 of them do not reply until I email again at 3:00 PM. 6. When a supervisor replies "approved", I type Yes in the Approved column for each of their workers. Sometimes a supervisor replies with a correction, like "Jamal worked 32 hours, not 40." Then I change the hours myself and note who told me. 7. At 4:30 PM I email our payroll person, Dev, a list of anyone still not submitted or not approved, so he knows who will be paid late. What goes wrong: - I miss someone, and they are paid a week late. This happened 3 times last month. - A supervisor approves by replying to an old email thread and I do not see it. - Twice a worker submitted the form two times with different hours and I paid the wrong one. What I must keep doing myself: - Any change to hours after a supervisor's correction. I want to see those before they change. - The phone calls at noon. People answer a person. Tools we already pay for: Google Workspace (Gmail, Sheets, Forms). We do not have a texting service. Nobody here writes code.