WB WorkbookBarn All workbooks

Free calculator · nothing to download

Subcontractor Vetting Scorecard

One subcontractor at a time. Type in the blue cells. Anything you do not know yet, leave at 0 or No.

WHO YOU ARE VETTING
INSURANCE
LICENCE
REFERENCES
PRICING
PAST PERFORMANCE
WEIGHTS AND PASS MARK

INSURANCE — 25 POINTS

Days until the GL policy expires—
Insurance rating (out of 10)—
Insurance points earned—

LICENCE — 20 POINTS

Days until the licence expires—
Licence rating (out of 10)—
Licence points earned—

REFERENCES — 20 POINTS

Reference calls that got answered—
References rating (out of 10)—
Reference points earned—

PRICING — 15 POINTS

Their bid vs your benchmark—
Pricing rating (out of 10)—
Pricing points earned—

PAST PERFORMANCE — 20 POINTS

Jobs finished on schedule—
Jobs that came back on you—
Past performance rating (out of 10)—
Past performance points earned—

THE VERDICT

SCORE OUT OF 100—
Verdict—
Points above your pass mark—
Deal breakers (any one stops the hire)—
Weakest area — fix this one first—
Weights off by (should be 0)—

Vetting Log

One row per subcontractor. Copy the five section points across from the SCORECARD tab.

VettedSubcontractorTradeInsurance /25Licence /20References /20Pricing /15Past work /20SCORE /100VerdictBidWhat decided it
1——
2——
3——
4——
5——
6——
7——
8——
9——
10——
11——
12——
13——

Where that leaves you

—

Want it as a spreadsheet you own?

The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts, and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.

Get the workbook · $14.99

See what is inside the workbook

Keep it

Subcontractor Vetting Scorecard: the full workbook

Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.

Buy on Etsy · $14.99What is inside →

Email me these results

We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.

Last updated: October 2026

Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.

WorkbookBarn · All free calculators · Workbooks