One subcontractor at a time. Type in the blue cells. Anything you do not know yet, leave at 0 or No.
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.
Vetted
Subcontractor
Trade
Insurance /25
Licence /20
References /20
Pricing /15
Past work /20
SCORE /100
Verdict
Bid
What 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.
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.
We'll send this result plus the matching worksheet. No spam, unsubscribe anytime.
Done — you are on the list.
Something went wrong. Please try again.
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.