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.
What each column is for
| Column | What to enter |
|---|---|
| Spec section | The specification section that requires the submittal, e.g. 05 12 00. One section usually produces several rows. |
| Description | What is being submitted: “Structural steel shop drawings”, “Door hardware schedule and cut sheets”. |
| Type | Product data, shop drawings, samples, O&M manual, warranty, certificate or other (dropdown). |
| Subcontractor | The company responsible for preparing it. Put suppliers here too if they deal with you directly. |
| Reviewer | Who reviews it: architect, structural, mechanical or electrical engineer, or your own office for record-only items. |
| Required on site | The 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 by | Calculated. Required on site minus lead + review + buffer working days, skipping weekends and the Holidays sheet. |
| Status | Not submitted, submitted, in review, returned or closed (dropdown). |
| Date submitted / Date returned | When it went to the reviewer and when it came back. |
| Stamp | Approved, approved as noted, revise and resubmit, rejected or received for record (dropdown). |
| Notes | Anything 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
- Sort by Submit by every Monday. Any row still “Not submitted” with a date in the past is already late; a row due in the next two weeks needs a phone call today.
- Number submittals by spec section, e.g.
05 12 00-001.0, and add .1, .2 for each resubmittal so the history stays readable. - Keep the original required-on-site date when the schedule moves; update it and let the submit-by date move with it rather than overwriting the result.
- Track the reviewer's clock too. Date submitted + review time tells you when to chase the architect.
- Don't forget closeout items. O&M manuals, warranties and certificates have submit-by dates too; tie them to substantial completion.
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.