Export both reports from YEPS as CSV for the pay-period Friday (Start & End = 7/17), then drop them below.
You do not need to delete the header rows — this reads the reports as-is.
It runs the same App-ID match Valerie described (a youth in the Status report but not in the Digital Timesheet report = unapproved),
then splits them into who needs hours entered vs approved, by worksite.
Then hit Publish to team worklist so everyone works the same live list on the 🛠 Worklist tab.
1 · Hours Time Sheet Status Report
The full list of every youth & their hours for the week (has the App ID, Hours and Worksite columns).
2 · Hours Digital Timesheet Report
The approved timesheets (has Approved By Worksite / Approved By Provider). Being on this list = already approved.
3 · Contract list (optional — refreshes the YEPS-contract tags)
App ID → contract, so each youth shows the YEPS contract to open (BK-OY, SI-SB-OY, BX-SB-OY, SF-OY, BK-SB-OY, AGVEP-OY). The current list is built in already — upload a fresh pull to update it.
4 · No Show Report (YEPS — official no-shows leave the board)
Drop the YEPS No Show Report (Application ID · Last · First · Status · Initiative · Contract Name · Cycle Name; xls saved as CSV). Every youth on it is treated as 🚫 off-board: excluded from reconcile and auto-cleared from the live worklist on publish with an audit note — the same proven machinery as the triage off-board lane.
Load both CSVs above to reconcile.
Your name
0
✅ Approved
on the Digital report — done
0
🟡 Approve
hours entered, not approved
0
🔴 Enter hours
0 / blank, no reason
0
⚪ No hours / did not report
0h — still needs approving
0
🕳 No timesheet
from the triage CSV — site must review
0 youth-weeks to clear across 0 worksites · 0 hours.
⚠ STAGED — eyeball, then Publish
Worksite ▲
🟡 Approve
🔴 Enter
⚪ DNR
Total
Hours
0 worksites with unapproved hours
No worksites match your search.
🛠 Work the list — call sites, claim, approve & commit
Payroll not committed yet
Work the list below — mark each youth once you've handled them in YEPS.
Youth-weeks cleared
0of 0 to clear
Done Hours entered Not started
🟡 Need approval0
🔴 Need hours entered0
⚪ No hours / did not report0
Worksites0
Your name
Connecting to live worklist…
▾ 📧 Remind sites with unapproved payroll — week ending
Only worksites with timesheets still unapproved are listed — a fully-approved site can never be emailed from here. Contacts load live from each site’s profile (traced through the youths’ placements, no name-guessing); fix or add an address right in the row before sending. Each site gets its own email naming its participants.
Nothing here. Publish a reconciliation on the 📥 Reconcile tab, or clear your filter.
Worksites fully approved
0of 0 worksites
Fully approved Partly approved None approved
Timesheets approved0
Timesheets pending0
Total placements reporting0
⚠️ Needs attention
These worksites have timesheets not yet approved for this week.