Rows in red are what the Apps Script highlights: Days Until Expiry reads "<30", which covers expiring and lapsed certs. Complete is the evaluated sheet formula.
Employee Name
Docs Present (folders)
Docs Missing
TABC Expiration
Days Until Expiry
Tax Form
ID on File
SSN on File
Comp Agreement Signed
Complete
Needs Review
Date Scanned
Active
Notes
Avery Blackwood
W4,TABC,ID,SSN,COMP,DD
04/12/2028
>30
W-4
Yes
Yes
Yes
Yes
2026-09-03
Dashiell Pemberton
TABC
ID, Tax (W-4/W-9)
11/03/2025
<30
No
No
No
No
No
TABC EXPIRED 11/03/2025
2026-09-03
Ines Falconer
W4,TABC,ID,COMP,DD
10/04/2026
>30
W-4
Yes
No
Yes
Yes
2026-09-03
Kai Thornbury
W4,TABC,ID,SSN,COMP,DD
10/03/2026
<30
W-4
Yes
Yes
Yes
Yes
2026-09-03
Lucia Marchetti
ID,SSN
TABC, Tax (W-4/W-9)
Not Found
No
Yes
Yes
No
No
2026-09-03
Marisol Arriaga
W4,TABC,ID,SSN
09/18/2026
<30
W-4
Yes
Yes
No
Yes
2026-09-03
Nadia Okonkwo
W4,ID,SSN,DD
TABC
Not Found
W-4
Yes
Yes
No
No
2026-09-03
Cert renewal scheduled
Nico Castellanos
W4,TABC,DD
ID
09/25/2026
<30
W-4
No
No
No
No
2026-09-03
Rowan Whitlock
W4,TABC
ID
REVIEW
W-4
No
No
No
No
TABC scan is blurry; expiration unreadable
2026-09-03
Simone Delacroix
W4,DD
TABC, ID
Not Found
W-4
No
No
No
No
2026-09-03
Theo Vanderbilt
W4,TABC,DD
ID
07/10/2026
<30
W-4
No
No
No
No
TABC EXPIRED 07/10/2026
2026-09-03
-- INACTIVE (Active=No) --
Ezra Holloway
No
Left in July
Run Log
Run Date
Folders Scanned
Rows Written
Exception Count
Roster Changes
Completion Status
2026-09-03
7 (W4, W9, TABC, ID, SSN, COMP, DD)
14 (11 employees + 3 contractors)
5
Baseline
Complete
Exceptions (5)
Employee / Folder
Issue Type
Detail
Source File
Run Date
Dashiell Pemberton
Expired document
TABC certificate expired 11/03/2025; no tax form or ID on file
TABC/pemberton_dashiell TABC.jpg
2026-09-03
Theo Vanderbilt
Expired document
TABC certificate expired 07/10/2026
TABC/theo vanderbilt tabc.png
2026-09-03
Marisol Arriaga
Name variant
W-4 filed as 'Marisol Arriaga-Reyes'; TABC cert prints 'Marisol Arriaga'. Treated as one person.
TABC is a low-resolution phone photo; expiration not legible
TABC/rowan tabc.jpeg
2026-09-03
Moonlight Sound Co.
Business entity
W-9 filed under a business entity, not an individual
W9/moonlight sound co w9.png
2026-09-03
Contractors sheet
Contractor / Entity
Type
W-9 on File
Docs Present (folders)
Needs Review
Date Scanned
Last Verified
Notes
Bram Winterbourne
Individual
Yes
W9
2026-09-03
Moonlight Sound Co. (Felix Abernathy)
Business entity
Yes
W9
W-9 filed under a business entity; verify vendor classification
2026-09-03
Ophelia Starling
Individual
Yes
W9,DD
2026-09-03
TABC alert drafts
urgent tier
Subject: URGENT: TABC certification(s) expired/expiring, immediate action required (Venue A)
Venue A TABC compliance check, run date 2026-09-03.
The following certifications are expired or expire within 15 days:
- Dashiell Pemberton: EXPIRED 11/03/2025 (304 days ago)
- Theo Vanderbilt: EXPIRED 07/10/2026 (55 days ago)
- Marisol Arriaga: expires 09/18/2026 (15 days remaining)
A staff member may not serve alcohol on a lapsed TABC certification. Anyone listed as EXPIRED cannot serve until renewed.
This draft was prepared automatically from the weekly compliance snapshot. Review before sending.
warning tier
Subject: TABC expiration warning: certification(s) expiring within 30 days (Venue A)
Venue A TABC compliance check, run date 2026-09-03.
The following certifications expire within 30 days:
- Nico Castellanos: expires 09/25/2026 (22 days remaining)
- Kai Thornbury: expires 10/03/2026 (30 days remaining)
A staff member may not serve alcohol on a lapsed TABC certification. Anyone listed as EXPIRED cannot serve until renewed.
This draft was prepared automatically from the weekly compliance snapshot. Review before sending.
Recipients are not configured for this venue, so the scheduled task renders these but does not create Gmail drafts until they are.
Rows in red are what the Apps Script highlights: Days Until Expiry reads "<30", which covers expiring and lapsed certs. Complete is the evaluated sheet formula.
TABC is a low-resolution phone photo; expiration not legible
TABC/rowan tabc.jpeg
2026-09-03
Moonlight Sound Co.
Business entity
W-9 filed under a business entity, not an individual
W9/moonlight sound co w9.png
2026-09-03
Contractors sheet
Contractor / Entity
Type
W-9 on File
Docs Present (folders)
Needs Review
Date Scanned
Last Verified
Notes
Bram Winterbourne
Individual
Yes
W9
2026-09-03
Moonlight Sound Co. (Felix Abernathy)
Business entity
Yes
W9
W-9 filed under a business entity; verify vendor classification
2026-09-03
Ophelia Starling
Individual
Yes
W9,DD
2026-09-03
TABC alert drafts
urgent tier
Subject: URGENT: TABC certification(s) expired/expiring, immediate action required (Venue B)
Venue B TABC compliance check, run date 2026-09-03.
The following certifications are expired or expire within 15 days:
- Dashiell Pemberton: EXPIRED 11/03/2025 (304 days ago)
- Theo Vanderbilt: EXPIRED 07/10/2026 (55 days ago)
- Marisol Arriaga: expires 09/18/2026 (15 days remaining)
A staff member may not serve alcohol on a lapsed TABC certification. Anyone listed as EXPIRED cannot serve until renewed.
This draft was prepared automatically from the weekly compliance snapshot. Review before sending.
warning tier
Subject: TABC expiration warning: certification(s) expiring within 30 days (Venue B)
Venue B TABC compliance check, run date 2026-09-03.
The following certifications expire within 30 days:
- Nico Castellanos: expires 09/25/2026 (22 days remaining)
- Kai Thornbury: expires 10/03/2026 (30 days remaining)
A staff member may not serve alcohol on a lapsed TABC certification. Anyone listed as EXPIRED cannot serve until renewed.
This draft was prepared automatically from the weekly compliance snapshot. Review before sending.