Skip to content
Submittal

Submittal log template that holds up on a live job

A submittal log template is only as good as its columns. Below is the layout project engineers keep on commercial jobs, what belongs in each column, and where a spreadsheet version starts to fail once packages are moving between subcontractors, the general contractor and the design team. When you want the rows filled in from your own project manual, Submittal reads the spec book and builds them for you.

Assistant project manager highlighting rows on a printed spreadsheet submittal log in a site office
1.0

The columns of a good submittal log template

Each column answers one question someone asks in the OAC meeting. If a column does not answer a question, it does not belong in the template.

ColumnWhat it holdsWhy it matters
Submittal numberSection, sequence and revision, for example 087100-002-R1One number per package and revision, so nobody reviews a superseded set
Spec sectionMasterFormat number and title, for example 08 71 00 Door HardwareTies the item to the scope a subcontractor bought
ParagraphThe article the requirement comes from, for example 1.4.BSettles the argument about whether the spec asked for it
TypeProduct data, shop drawings, samples, test reports, certificates, warranties, O&M data, mockupsDecides who reviews it and whether it needs a stamp
CategoryAction, informational or closeoutAction items need approval before fabrication, informational items go on record, closeout items wait for turnover
DescriptionThe requirement quoted from the specLets the sub prepare the right documents the first time
ResponsibleThe company that prepares the packageTells you who to chase
Reviewer routeGC reviewer, then architect, then consultantShows how many desks the package has to cross
Ball in courtWho holds the package todayThe column everyone reads first
Date submittedDate the package left the GCStarts the review clock
Review dueDate submitted plus the contract review timeShows when the architect owes an answer
Lead timeFabrication and delivery time after approvalFeeds the submit-by date
Required on siteDate the material has to arriveThe date the schedule depends on
Submit byRequired on site minus lead time minus review timeThe date the package has to leave the sub
Status and stampNot submitted, In review, Approved, Approved as noted, Revise and resubmit, Rejected, For record onlyTells you whether the order can be released
ReturnedDate the stamp came backCloses the cycle and shows real review time
2.1

Numbering that survives resubmittals

Keep the spec section in the number and add the revision as a suffix. The second door hardware package is 087100-002, and when it comes back Revise and resubmit, the new set goes out as 087100-002-R1. The original row stays in the log with its stamp, the revision is a new row linked to it, and the number of cycles is visible on the page instead of buried in an email thread.

2.2

Stamps that mean the same thing to everyone

Use the stamp wording from your contract, usually Approved, Approved as noted, Revise and resubmit, Rejected and For record only. Approved as noted lets the sub order with the noted corrections. Revise and resubmit means nothing is released until a new revision is reviewed. Rejected means the product or approach does not meet the spec. For record only covers informational items such as certificates and test reports that need no action. Each step is described in the construction submittal process guide.

3.0

Why a spreadsheet template breaks down on live jobs

The template works on day one. A few months in, four people edit it and the copy on the shared drive is no longer the one in everyone's inbox.

  • Two copies drift apart, one emailed to the architect and one on the server, and nobody can say which is current.
  • Ball in court is typed by hand, so it shows whoever last remembered to update it, not who holds the package.
  • Submit-by dates are formulas that someone overwrote with a fixed date, and the chain from lead time to submit-by date breaks without anyone noticing.
  • Revisions overwrite the original row, so the reason a package came back disappears.
  • The files live somewhere else, so the log says Approved while the stamped PDF sits in someone's downloads folder.
  • Nobody gets a reminder, and overdue items surface in the OAC meeting instead of the week they slipped.
  • The rows were typed from the spec book by hand, and a missed paragraph in Division 23 stays missed until the item is needed on site.
4.0

The same columns, filled in from your specs

Submittal keeps every column above and fills them for you. Upload the project manual and the AI reads the submittal language in each section, then builds one row per required item with the section, the paragraph it came from, the type, the category and the description quoted from the spec. You review the rows, merge or split them, assign responsible companies and reviewers, and the log is ready to work. The reading step is explained on spec to submittal log.

From there the log stops being a file. Ball in court moves when a package moves, review due dates follow the contract review time, reminders go to whoever holds the package, and every revision keeps its stamp and files. That is the difference between a submittal log on a shared drive and submittal tracking software.

5.0

Get the log as an XLSX file

The demo on the home page builds a register from a spec section you upload or pick. After you create an account, that demo log stays in your account and exports as XLSX with the columns described on this page, so you can lay it next to your current spreadsheet and compare. Paid projects export the full log to Excel, CSV and PDF at any time, with transmittals as PDF.

Already running a spreadsheet log? Import it from Excel or CSV and keep your numbering. Team and higher plans add custom numbering formats and lead-time tracking. Plans start at 24 USD a month per active project billed yearly, or 49 USD month to month, and subcontractors and external reviewers join at no cost on every plan. All plans are on the pricing page.

6.0

Frequently asked questions

Is this submittal log template a spreadsheet I can download?

This page explains the columns so you can check your own log against them. The XLSX file comes from the demo after you create an account, built from a real spec section, and every paid project exports its full log to Excel, CSV and PDF whenever you need it.

Which columns matter most in a submittal log?

Spec section, paragraph, submittal number, ball in court, required on site and status. Those six answer what is missing, who holds it and what it does to the schedule.

Should the template include closeout items from the start?

Yes. O&M manuals, warranties and extra stock belong in the log from buyout, marked as closeout, so they are tracked for months instead of discovered at substantial completion.

Can I import the log I already have?

Yes. Import from Excel or CSV, map your columns to the Submittal fields and keep your existing numbers. You can then run the spec through the register builder and see which requirements your old log never listed.

Build your first submittal log