Blog / Construction Operations
Project Closeout Tracker: O&M Manuals, Warranties, As-Builts
By Keyona Meeks, Founder, ReRev Labs · Oct 31, 2026 · 8 min read
The short answer: Closeout goes wrong when the paperwork is chased from memory. Keep one row per document you owe the owner: each O&M manual, each warranty, each set of as-builts. Give every row a category, a person responsible and a due date. A Status formula shows Received, Waiting, Late or No due date, and a small count per category shows how far along you are. This is a tracking aid. Your contract and specifications decide what you must deliver. I tested the formulas in LibreOffice, not in Google Sheets.
By the end of this post, you'll be able to:
- List the closeout documents a project owes.
- Set up a tracker with a Status column and category counts.
- See at a glance what is late.
- Know what this tracker cannot do.
I sell build work, so weigh this post with that in mind. This is a record-keeping aid, not a statement of what your contract requires. Check with an attorney, insurer or safety professional before you rely on any log for any contract or legal question.
What closeout documents does a project owe?
Your specifications say. I looked for an official, general list and did not find one. The one primary source I could read, a free sample of the AIA A201-2017 general conditions, was returned as excerpts, the first 15 of 38 pages. In that part, section 3.11 mentions documents "delivered to the Architect for submittal to the Owner upon completion of the Work as a record of the Work as constructed" (an excerpt, so the sentence continues). I found no text on operation and maintenance manuals in what I could read, and the sections on substantial completion and final payment were outside the excerpt. I make no claim about what yours requires. Read your own specifications and list every item they name.
How do you set up the tracker?
Row 1 holds headings. Use a tab named Closeout.
| Column | Heading | What goes in it |
|---|---|---|
| A | Item | The document, such as "Pump O&M manual" |
| B | Category | O&M manual, Warranty, As-built or another word you pick |
| C | Responsible | One person or company |
| D | Due | The date, or blank |
| E | Received | The date it arrived, blank until then |
| F | Status | The formula below |
Put this in F2 and fill it down:
=IF(A2="","",IF(E2<>"","Received",IF(D2="","No due date",IF(D2<TODAY(),"Late","Waiting"))))For a count per category, use one formula per category. This one gives "1 of 2" for O&M manuals:
=COUNTIFS($B$2:$B$200,"O&M manual",$F$2:$F$200,"Received")&" of "&COUNTIF($B$2:$B$200,"O&M manual")I tested both in LibreOffice with five made-up rows. The Status column returned Late, Waiting, Received, No due date and Waiting, and the counts read "0 of 2" for O&M manuals and "1 of 2" for warranties. A line due today shows Waiting. I did not run them in Google Sheets, so test with your own rows. The category words must match exactly, including capitals and spaces.
Who decides the due dates?
You do, or your contract does. I do not supply a default. Use the dates from your specifications or your closeout schedule, and leave the cell blank when you do not have one. The Status column will say "No due date," so the gap stays visible.
How do you use it week to week?
- Add a row for every document the specifications name, before closeout starts.
- Each week, read the Late and No due date rows with the person responsible.
- Enter the received date when the document arrives. Do not delete rows.
- Check the category counts before you ask for a walkthrough.
Where does an LLM fit in this?
An LLM can help with the messy input. For example, it can read a long specification section and suggest a draft list of the closeout items it names. A person must check that list against the specification itself, because an LLM can miss an item or add one the spec never asked for, and sound sure. The Status formula, the counts and the dates are plain rules. My stance: AI writes the code, plain automation runs it, and an LLM shows up only where the input is messy and a person checks the result. For where to start with your own automations, see what to automate first.
How do you test it?
- Enter five test lines: one late, one due next week, one received, one with no due date and one due today.
- Check the Status column against your own reading.
- Check the category counts by hand.
- Delete the test lines.
Where this has limits
- It is a tracking aid, not a legal record. I give no legal advice. Check with an attorney, insurer or safety professional before you rely on any log for any contract or legal question.
- I found no official general list of closeout documents. I read only excerpts of one AIA sample.
- The formulas were tested in LibreOffice, not Google Sheets.
- It shows what someone typed. It does not check that a document is complete or correct.
- It does not send reminders. Warranty reminders need a separate tracker.
- No ReRev prices and no promises about results.
If you want help turning this into a closeout system your whole team uses, see our AI operations service or tell us how you track closeout now. Do not send contracts, drawings, passwords or login details.
Frequently asked questions
What is a construction closeout checklist?
A list of the documents and tasks a project owes at the end. Your contract and specifications decide the contents.
Can a Google Sheet track closeout documents?
Yes, as a tracking aid. One row per document and a Status formula are enough to start.
Does the tracker check that a document is correct?
No. It records the date someone says it arrived.
What if a document has no due date?
Leave the cell blank. The Status shows "No due date" so someone decides.
Does this send reminders?
No. You read it each week.
Is this a legal record?
No. Ask an attorney what counts as a record under your contract.
Read next: The punch list tracks the physical work that has to finish before closeout documents are worth chasing, and warranty tracking keeps the expiry dates alive after handover.