
The Solar EPC Closeout Checklist That Runs Itself
A project manager at a 20-person solar EPC told me that closeout was her least favorite phase. Not because the work was hard, but because it was endless. Every project ended with the same hunt: chasing lien waivers from three subcontractors, confirming as-builts matched the field installation, collecting O&M manuals from the inverter vendor, and making sure the AHJ had signed off on the final inspection. The checklist was simple. The execution was not.
The problem is not the checklist itself. It is the intake layer. Documents arrive by email, text, and sometimes fax. Filenames are inconsistent. Subcontractors forget to include project numbers. And the PM is the only person who knows which items are still missing — because she keeps the map in her head.
I built a closeout checklist system that removes the PM from the intake loop. It starts with a simple Google Sheets template and ends with an agent that reads emails, classifies attachments, and updates the tracker automatically.
The template has one row per project and one column per closeout item: lien waivers, as-builts, O&M manuals, inspection sign-offs, PTO documentation, and final photos. Each cell starts as empty. As documents arrive, the Field Agent parses them, determines which project and item they belong to, and writes a timestamp into the correct cell. The PM glances at the sheet and knows exactly what is missing.
How the agent handles intake: When a subcontractor emails a lien waiver to field@ops.opsforenergy.com, the Field Agent wakes on its 4-hour heartbeat, reads the email, classifies the attachment, extracts the project name or address, queries Supabase to confirm the project ID, and updates the checklist. The whole loop takes under 30 seconds. The PM does not touch the email until the agent has already filed it.
The same pattern works for SMS. A foreman texts a photo of the completed array with the project address. The Field Agent parses the message, matches the address to a project, and logs the photo link in the final photos column.
The metric: For a 15-project portfolio, manual closeout intake takes an estimated 6–8 hours per week. The Field Agent reduces that to under 30 minutes of exception handling — emails the agent could not classify or documents missing a project reference.
An honest limitation: This breaks when a subcontractor sends a document with no project reference at all — no address, no project name, no PO number. The agent flags it for human review rather than guessing. Guessing wrong means misfiling, and misfiling is worse than waiting.
The checklist template is available below. You can use it with or without the agent. But if your inbox is the bottleneck, the agent is what makes the checklist actually run itself.
Want to see this in action? Here's the demo →
Solar EPC Closeout Checklist — Google Sheets template with automated item tracking.
Get the template →