Submittal log template

A free submittal register you can open in Excel, Google Sheets or LibreOffice. It back-schedules every submit-by date from the required-on-site date and lead time, in working days, using your own holiday list.

Download the template

Both files use the same column names, so either one imports straight into SubmittalKit with no column mapping.

Excel version: “Submittal log” sheet with a frozen, filterable header, dropdowns for type, status and stamp, the submit-by formula on 200 rows, a “Holidays” sheet and a “How to use” sheet. CSV version: the same columns and example rows without formulas. Five example rows are marked in the Notes column; delete them before you start.

What each column is for

ColumnWhat to enter
Spec sectionThe specification section that requires the submittal, e.g. 05 12 00. One section usually produces several rows.
DescriptionWhat is being submitted: “Structural steel shop drawings”, “Door hardware schedule and cut sheets”.
TypeProduct data, shop drawings, samples, O&M manual, warranty, certificate or other (dropdown).
SubcontractorThe company responsible for preparing it. Put suppliers here too if they deal with you directly.
ReviewerWho reviews it: architect, structural, mechanical or electrical engineer, or your own office for record-only items.
Required on siteThe date the material or work has to be on site, taken from your schedule.
Lead time (working days)Fabrication and delivery time after approval. Six weeks is about 30 working days.
Review time (working days)The review period in the contract, often 10 working days. Add more for items that go to a consultant.
Buffer (working days)Room for one resubmittal or a slow week. 2 to 5 days is typical; more for long-lead items.
Submit byCalculated. Required on site minus lead + review + buffer working days, skipping weekends and the Holidays sheet.
StatusNot submitted, submitted, in review, returned or closed (dropdown).
Date submitted / Date returnedWhen it went to the reviewer and when it came back.
StampApproved, approved as noted, revise and resubmit, rejected or received for record (dropdown).
NotesAnything that explains a date: “waiting on colour selection”, “resubmit .1 with fire rating”.

How the submit-by formula works

Each row of the Excel version has this formula in the Submit by column (row 2 shown):

=IF(F2="","",WORKDAY(F2,-(G2+H2+I2),Holidays))

WORKDAY counts working days backwards from the required-on-site date, skipping Saturdays, Sundays and every date in the named range Holidays (the Holidays sheet). The total it subtracts is lead time + review time + buffer. If the required date is blank, the cell stays empty.

Worked example from the template: structural steel shop drawings are needed on site on March 1, 2027.

  • Lead time 30 working days (about six weeks of detailing, fabrication and delivery)
  • Review time 10 working days
  • Buffer 3 working days

That is 43 working days before March 1. Counting back through February (with the Family Day / Presidents' Day holiday on February 15) and January (with New Year's Day), the last day to submit is Monday, December 28, 2026. Count 43 calendar days instead and you'd get January 17, nearly three weeks too late for the steel to make March 1.

The example holidays are Christmas Day, New Year's Day, Presidents' Day (US) / Family Day (BC), Good Friday. Replace them with your project's statutory holidays and any planned shutdown days.

Using the log week to week

Building the list from scratch? Our guide on how to build a submittal register from the specs walks through Division 01 and each section's submittal article.

Run it online free

Import this file into SubmittalKit and get sub upload links, architect review links with stamps, an overdue dashboard, PDF transmittals and a closeout package. No accounts and no per-seat fees.