Skip Navigation

Spreadsheet

Reference & Vetting Tracker — 120 Reference-Call Questions Across Five Vetting Types, With a License and Insurance Ledger That Checks Cover Against Your Own Dates (Excel & Google Sheets)

120 reference-call questions for contractors, caregivers, landlords, hires and tenants — plus a ledger that catches insurance lapsing before your job ends.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • 120 curated reference-call questions across five vetting types — contractor and trades, care provider, landlord and property manager, key hire, and tenant — each with what it is really testing, what a reassuring answer sounds like, and what should worry you
  • Every reference answers the same six probes, worded identically for every reference and every type, which is the only reason their answers can be compared at all
  • A count of the probes your references DISAGREED on — where one gave a positive answer and another raised a concern. A stack of separate reference forms cannot produce that number, because nothing in it is comparable
  • Wouldn't say is treated as an answer rather than a gap. A reference who confirms the dates without hesitating and then goes quiet on money has told you something, and the sheet counts it
  • A verification ledger that measures every license, certificate and check against the day your work actually FINISHES — so a policy in force the morning you check it and expired two weeks before the roof is done reads LAPSES MID-JOB, in red, with the days of cover you are short
  • 23 catalogued verification items with where to check each one and how to check it properly — the certificate sent by the agent rather than forwarded by the contractor, the license looked up by number rather than by name
  • Completeness that knows who you are checking: seven required items for a contractor, six for a care provider, three for a landlord — so a full bar means the essentials for THIS type of person, not a generic checklist
  • A readiness state, not a score. It reads what you recorded and tells you whether you have enough to decide; it does not rate the person, and the copy says so

Everyone tells you to check references. Nobody tells you what to do with the answers.

You have three names and a phone. You make the calls, and all three say some version of “yeah, they were great.” You hang up knowing roughly what you knew before, and you sign.

That is not because you asked badly. It is because three separate conversations, each drifting wherever it drifted, produce three things that cannot be laid beside each other. The first reference talked about the crew. The second talked about the price. The third talked about how it all ended. Every one of them was useful, and together they told you nothing you could act on, because you have no way of seeing what they would have said about the same question.

This file is built around that one problem.

Six questions, asked the same way, every time

Every reference you reach answers the same six probes. They are worded once, for all five vetting types, and they always point the same direction — Yes is the good answer on all six, so nothing has to be mentally flipped later:

  • Can you confirm roughly when they worked with you, and what they were responsible for?
  • Knowing everything you know now, would you use them again?
  • Did things happen roughly when they said they would?
  • Did the final cost land where you expected, or were there surprises?
  • When something went wrong, how did they handle it?
  • Is there anything you would want to know if you were in my position?

Because the wording never changes, the answers become comparable — and once they are comparable, a spreadsheet can do something no reference form can. It counts the probes where one reference gave you a positive answer and another gave you a concern.

That number is the point. Three references agreeing tells you one thing. Three references disagreeing tells you something far more useful: exactly which question to go back and ask again, of somebody else.

And “Wouldn’t say” is an answer. A reference who confirms the dates without hesitating and then goes quiet — twice — when you ask about money has told you something specific. The sheet counts it as a concern, because it is one.

The check that passes and still leaves you uncovered

Now the other half, and it is the part almost every guide gets wrong.

Everyone tells you to check that the license is active and the insurance is current. So you do. The certificate arrives, the dates are printed on it, everything is in force, and you tick it off.

Nobody tells you to check it against the day your work ends.

A general liability policy that is genuinely valid the morning you check it, and genuinely expires two weeks before the roof is finished, passes every check ever written down. It also leaves you uninsured for the last fortnight of the job — which, if you have ever had a job run long, is precisely when the expensive discoveries happen.

So the Verification Ledger does not compare an expiry date to today. It compares it to the date you entered as your finish date, and reports the answer in words:

  • Covers your dates — verified, and still valid on the day you are done.
  • LAPSES MID-JOB — in force right now, expired before you finish, with the number of days you are short.
  • Already expired, or Not verified yet — no ambiguity about which.
  • No expiry to track — verified, and nothing to lapse: a deed, a degree, a permit already pulled.
  • Set a work-through date — the one it cannot answer, because you have not told it when you finish. It says so rather than guessing.

It is one column. It is also the single most useful thing in the file, and it costs you nothing but writing the expiry date down.

Required for a roofer is not required for a nanny

Twenty-three things are worth verifying about somebody, and no one person needs all of them. A contractor needs a trade license, general liability, workers’ compensation, a business registration and a permit in their own name. A care provider needs identity, right to work, a background check run properly, a driving record if they will be driving, and a CPR certification that is very often quietly out of date. A landlord needs ownership of record — that the person collecting your deposit is actually entitled to.

So the completeness figure counts required items for that type of person, not a generic list. A full bar means you have done the things that matter here, rather than most of a checklist written for someone else’s situation.

Each item comes with where to check it and how to check it properly: the certificate of insurance sent by the agent directly to you rather than a PDF forwarded by the contractor, the license searched by number rather than by name, the employer’s main number you looked up yourself rather than the one written on the application.

What you get

Nine tabs. Everyone you are currently checking on the Subjects tab, computing their own reference agreement, concern count and verification completeness. The 120-question Question Bank, filterable to your type. A Reference Log with the six probes. Answer Notes that look up the question text from its ID, so you are writing against the question you actually asked. The Verification Ledger. A curated Required Items matrix. A Dashboard that takes one subject in depth. And a Glossary for the words on the paperwork — including the three people routinely use to mean the wrong thing: additional insured is not certificate holder, a bond is not insurance, and a reference is not a referral.

Plus 83 pages of printable guides across five PDFs — including four blank call sheets to take to the call — and a sixth, shorter PDF whose only job is the one-click link to the native Google Sheets copy.

It arrives pre-filled with a worked example — three fictional subjects, already called and verified — so you can see every number doing its job before you clear it and start on your own.

Try it free first

There is a free, ungated printable of the contractor questions — the 24 Contractor Reference-Check Questions, with what each one is testing, what a reassuring answer sounds like, and what should worry you, plus a call sheet and a worked example. No email, no signup. It is one vetting type out of five, and a printed list can only hold questions; the workbook is what compares the answers and checks the dates.

What it is not

It is structured verification. It is not legal advice, and it is not a background-check service. It runs no searches, holds no records, and makes no determination about anybody. It gives you the questions and somewhere disciplined to put the answers.

Screening is regulated, and the rules genuinely differ by country, state and city — what you may ask, what you may consider, what consent you need in writing first, and what you must do if you turn someone down because of what a report said. Before you run a background, credit or driving check, use a service that complies with the law where you are, get written consent, and apply the same criteria to everyone. The file says all of this out loud, on the tabs where it matters, because a question bank is read as a script.

And the verdict it gives you is a readiness state, not a rating. It can tell you whether you have enough to decide. It cannot tell you whether they are any good — that part is still yours.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 9-tab workbook (.xlsx): Read Me, Subjects, Question Bank, Reference Log, Answer Notes, Verification Ledger, Required Items, Dashboard, and a Glossary — plus six PDFs: five printable guides and the one-click Sheets link
  • One-click Google Sheets copy — a ready-made native version, built for Sheets rather than imported into it (no import needed)
  • Start Here guide (PDF) — six sections on getting a reference to actually say something, why six identical questions beat six good ones, and the date test almost everybody misses
  • The Reference-Call Question Bank (PDF) — all 120 questions in print, grouped by vetting type and by the stage of the call they belong in
  • Verification Checklists by Type (PDF) — 23 items sorted into what is worth doing for each kind of person, with where and how to check each
  • Print-and-Use Reference Call Sheets (PDF) — four blank sheets with the six probes at the top, ready for a pen
  • Glossary of Vetting Terms (PDF) — 40 terms in plain English, including the ones people routinely use to mean the wrong thing
  • Ships pre-filled with a complete worked example — three fictional subjects, already logged and verified — that you clear and replace with your own

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$14.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.