What Is a Contractor Insurance Tracking Spreadsheet?
It is one list of your repair pros. It shows their license and their insurance. And it shows when the insurance ends.
That last part is the one that bites. A pro shows you a paper once. It looks fine. A year later the policy ends. Nobody tells you.
The tool above is that list. It works in your browser. It flags dates that have passed. It flags dates that end in 30 days or less. You can save it, print it, and open it again later.
Why Track Your Repair Pros' Insurance?
So you know who is covered before they walk in your rental. Not after something goes wrong.
A pro says, "Yeah, I'm insured." You nod. You move on. Then a pipe bursts mid-job. Or a worker falls off a ladder. Now you want to know if they had a policy. That is a bad time to find out.
Landlords on BiggerPockets say the same thing over and over. The ones who got burned trusted a "yes" and never checked the date. A common rule there: no keys until the insurance paper is on file. (BiggerPockets forum posts, checked Nov 16, 2026.)
What your own risk is depends on your state and your own policy. Ask your insurance agent what they want from the pros you hire.
What Should the Tracker Have?
Seven things per repair pro. Name, trade, phone, license number, insurance company, policy number, and the end date.
- Name. Use the name on their paperwork. "Mike's Plumbing" may be "M. Torres LLC" on the policy.
- Trade. Plumber, electrician, heat and air, roofer. A license for one trade does not cover another.
- Phone. The number you text for jobs.
- License number. Not every trade or state has one. Leave it blank if there is none.
- Insurance company and policy number. Both are on their insurance paper.
- End date. The most important box. It is the one that changes.
How Do You Get a Repair Pro's Insurance Paper?
Ask for a certificate of insurance. People call it a COI. Their insurance agent can send it to you.
Most COIs in the US use the same one-page form. It is called the ACORD 25. It lists the insurance company, the policy number, the kind of cover, the limits, and the start and end dates.
Here is the catch. The form itself says it is for info only. It shows the policy on the day it was made. It does not promise the policy is still active. (The Hartford and other insurers explain the ACORD 25 this way, checked Nov 16, 2026.)
So some landlords get the paper from the agent, not the pro. And some call the insurance company to check. Your call.
How Often Should You Check the Dates?
Look at the list once a month. Ask for a new paper before the old one ends.
Rule of thumb: ask a few weeks early. A new paper can take days to come. Some business guides say to start 45 to 60 days out. This tool flags at 30 days. That still gives you time to ask.
Pros renew all year long. Not all at once. That is why one list beats a pile of emails. Send each job with our work order.
Does This Tool Check a License or a Policy?
No. It is your own record. It shows what you typed. It does not check a license board. It does not call an insurance company.
To check a license, look up the pro on your state or city license site. To check a policy, call the insurance company on the paper.
Then write the date you checked in your notes. That is your proof that you looked.
Mistakes to Skip
- Taking "I'm insured" as an answer. Get the paper.
- Saving the paper and never looking at the end date again.
- Hiring a handyman for wiring or gas work. Those trades often need a license.
- Keeping the list in your head. Or in five places.
- Forgetting to save the CSV. This page does not keep your list.
An Example
Say you have three repair pros. Today is March 1.
- The plumber's policy ends Dec 31. It shows "Over 30 days left".
- The electrician's ends March 20. It shows "Ends in 19 days". Text them for a new paper.
- The roofer's ended Feb 10. It shows "Ended 19 days ago". Don't send them a job until you get a new one.
Save the CSV. Next month, open it here. The flags update to that day.