Free sub prequal · Excel

Free Subcontractor Prequalification Form

Collect the same facts from every sub and score them the same way. Questionnaire, EMR and OSHA 300A safety metrics with TRIR/DART formulas, and a weighted scoring tab with pass/fail thresholds you can edit.

  • Company, licenses, bonding (single/aggregate/surety), insurance vs. your minimums
  • Safety program checklist: 16 elements
  • EMR (3 yrs) + OSHA 300A data → TRIR and DART formulas
  • Largest projects, references, financials, litigation, workforce
  • Weighted scoring: 16 criteria, editable targets, limits, and weights
  • Knockout criteria + QUALIFIED / CONDITIONAL / NOT QUALIFIED result
  • Signed certification and approval blocks

Subcontractor Prequalification Form

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

Questionnaire

Sections A–K: company, licenses, bonding, insurance, safety program, experience, references, financials, litigation, workforce, certification.

02

Safety Metrics

EMR for three policy years and OSHA 300A data for three years → TRIR and DART per 200,000 hours, by year and hours-weighted, with BLS benchmark comparison.

03

Scoring

16 weighted criteria pulled automatically, each with an editable target, pass/fail limit, weight, and knockout flag → score out of 100 and an overall result.

04

Instructions

How to send it, verify it, tune the scoring, and keep the process fair.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

What should a subcontractor prequalification form include?

At minimum: company information and years in business, licenses, bonding capacity (single and aggregate, with surety), insurance limits against your requirements, safety performance (EMR and OSHA 300A data), safety program elements, largest recent projects, references, financial information (revenue, backlog, working capital), litigation and default history, and workforce capacity. It should end with a signed certification.

How do you calculate TRIR and DART?

TRIR = total recordable cases × 200,000 ÷ total hours worked. DART = (days-away cases + job transfer/restriction cases) × 200,000 ÷ total hours worked. The 200,000 represents 100 full-time workers for a year. This template takes the case counts from OSHA 300A columns G, H, I, and J plus hours worked and calculates both, per year and hours-weighted over three years.

What is a good EMR for a subcontractor?

An EMR of 1.00 is the average for the sub's industry and payroll size. Below 1.00 is better than average and above 1.00 is worse. Many GCs set a limit at or near 1.00 and require extra review above it, but the right limit depends on your risk tolerance and the work. The Scoring tab lets you set your own target and limit.

How does the weighted scoring work?

Each of 16 criteria pulls the sub's value from the questionnaire. You set whether lower or higher is better, a target that earns full points, a pass/fail limit, a weight, and whether the criterion is a knockout. Scores slide from 10 at the target to 5 at the limit and drop to 0 beyond it. The weighted total is out of 100, and any failed knockout makes the sub not qualified.

How often should subcontractors be prequalified?

Most contractors re-qualify subs annually, and immediately when something material changes: a new EMR, lapsed or reduced insurance, a change in bonding, a serious incident, or new ownership. Track certificate of insurance expirations between reviews.

Qualify on facts before you award

A subcontractor prequalification form collects the information you need to decide whether a sub can safely and financially perform your work: licenses, bonding, insurance, safety record, experience, references, financial strength, and claims history, collected before you invite them to bid or award a contract.

This free Excel template adds what most prequal forms don't have: TRIR and DART calculated from the sub's own OSHA 300A data, and a weighted scoring sheet with thresholds you control. After award, level the qualified bids with the bid leveling matrix and track insurance with the certificate of insurance tracker.

Field PM keeps subcontracts, COIs, sub daily reports, safety forms, and change orders in one place so you can see how each sub performs on the job.

Why prequalify subcontractors?

Most GCs have had a sub go bad mid-job: the crew stops showing up, the supplier liens the project because the sub didn't pay, the sub's safety record gets your site an OSHA visit, or the "bondable" sub turns out to have no capacity left. Prequalification is how you find those problems before you award. It won't guarantee performance, but it does make sure every sub is judged on the same facts. The free subcontractor prequalification form above collects that information in one questionnaire, calculates the safety rates from source data, and scores each sub against thresholds you set.

What the questionnaire covers

SectionWhat you're checking
A. Company informationLegal entity, years in business (calculated), labor affiliation, certifications, trades self-performed.
B. LicensesLicense type, jurisdiction, number, classification, qualifier, expiration. Verify every one on the state board's website.
C. BondingSurety, single-project and aggregate limits, current bonded backlog, calculated available capacity, bond rate, claims history. Ask for a surety letter on the surety's letterhead.
D. InsuranceEach coverage's limit against your required minimum. The sheet flags any shortfall, and there are endorsement questions (additional insured, waiver of subrogation, primary and non-contributory).
E. Safety program16 program elements: written program, orientation, toolbox talks, JHAs, drug testing, fall protection, confined space, LOTO, silica, trenching, incident investigation, and more.
F. ExperienceLargest projects in the last 5 years with value, scope, and reference contact.
G. ReferencesGCs, owners, and suppliers, with a verified-by column and a 1–5 rating that you fill in after the calls.
H. FinancialsThree years of revenue, backlog, current assets and liabilities, with calculated current ratio, working capital, and backlog-to-revenue.
I. Litigation & historyPending suits, judgments, defaults, failure to complete, bankruptcy, willful/repeat OSHA citations, debarment, liquidated damages.
J. WorkforceEmployee counts, supervision, crew available for this project, and peak manpower.
K. CertificationA signed statement that the answers are true, plus authorization to verify them.

Safety metrics: EMR, TRIR, and DART from source data

Don't just ask a sub for "your TRIR." Subs calculate it differently, some round in their own favor, and some report the wrong year. Ask for the OSHA 300A summary for each of the last three years and the EMR rating worksheet for each of the last three policy years, then calculate the rates the same way for every sub.

Experience Modification Rate (EMR)

The EMR compares a company's workers' comp claims to what's expected for its industry and payroll size. 1.00 is average, below 1.00 is better, and above 1.00 means higher premiums, and usually more injuries. EMR is based on a multi-year lookback, so one bad year stays on the record for a while. A new or very small company may not have a rating and will show 1.00 by default. Ask why.

TRIR: total recordable incident rate

TRIR = (G + H + I + J) × 200,000 ÷ hours worked, where G, H, I, and J are the 300A case columns: deaths, days-away cases, job transfer/restriction cases, and other recordable cases. The 200,000 is 100 full-time workers × 40 hours × 50 weeks, so TRIR reads as recordable cases per 100 full-time workers per year.

DART: days away, restricted, or transferred

DART = (H + I) × 200,000 ÷ hours worked. DART counts only the more serious cases, where someone lost time or couldn't do their normal job, so it's a better severity signal than TRIR.

The template calculates both for each year and as a three-year hours-weighted rate (total cases ÷ total hours), not an average of three yearly rates, which would give a small, bad year the same weight as a big, good one. There are also cells to enter the Bureau of Labor Statistics benchmark rates for the sub's NAICS code (from bls.gov/iif) so you compare the sub against its own industry.

Weighted scoring with editable thresholds

The Scoring tab pulls 16 criteria from the questionnaire and safety tabs automatically:

  • Safety: current EMR, 3-year TRIR, 3-year DART, program elements in place, fatalities
  • Bonding: single-project limit and available aggregate capacity
  • Insurance: coverages below your required minimum
  • Experience: largest completed contract and years in business
  • Financial: current ratio, backlog ÷ revenue, and revenue ÷ this subcontract
  • Legal: litigation and default questions answered "Yes"
  • References: average verified rating
  • Workforce: peak field manpower available

For every criterion you control five things: whether lower or higher is better, the target that earns a full 10 points, the pass/fail limit, the weight, and whether it's a knockout. Between target and limit the score slides from 10 to 5, and past the limit it's 0 and marked FAIL. Weights total 100%, so the weighted score is out of 100. A failed knockout (EMR over your limit, no bonding capacity, insurance below minimum, a fatality) makes the sub NOT QUALIFIED regardless of total. Otherwise the result is QUALIFIED or CONDITIONAL based on two minimum scores you set.

Size fit: a good sub on a job that's too big

A lot of sub failures aren't bad companies. They're decent companies that took on more than they could carry. Two ratios on the scoring sheet catch it:

  • Revenue ÷ this subcontract. A $2M subcontract is a big share of a $5M company's year, and a delay or a slow-paying owner hits that company hard. Many GCs want the subcontract to be a small fraction of the sub's annual volume.
  • Backlog ÷ revenue. A sub already sitting on more than a year of backlog will struggle to staff your job, no matter what the bid says.

Also compare available bonding capacity (aggregate minus bonded backlog), not just the headline program limit.

Running a fair, defensible prequalification process

  1. Use the same form, criteria, and weights for every sub bidding the same package.
  2. Verify rather than trust: license lookups, surety letter, COI from the agent, EMR worksheet, signed 300A, and actual reference calls.
  3. Keep the completed scoring sheet in the bid file with the approval signatures.
  4. Use conditional approval deliberately: a lower contract cap, a performance bond, a site-specific safety plan, or tighter pay-app review.
  5. Re-qualify annually and track insurance expirations between reviews with the certificate of insurance tracker.
  6. On public work, follow any owner or agency prequalification rules. They override your own process.

This template is a screening tool, not legal, insurance, or accounting advice. Have your insurance broker set the required limits and endorsements for your contracts.

After the award

Once a sub is qualified and awarded, you still have to manage them on the job. Field PM keeps subcontracts, certificates of insurance, sub daily reports, JSAs and safety forms, and change orders in one place, so you can see how the sub you qualified actually performs. Start a free 30-day trial, no credit card required.

Related free templates

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice