📅 Published: June 10, 2026
Vendor paperwork gets messy when everything lives in inboxes. A simple folder system can make COIs, W-9s, licenses, and contacts easier to find when something breaks.
Quick answer
Create one master vendor folder, one folder per vendor, and a tracker for expiration dates, contact info, services, and approval status.
Create one master vendor folder, one folder per vendor, and a tracker for expiration dates, contact info, services, and approval status.
Folder structure
| Folder | What goes inside |
|---|---|
| Vendor Master Tracker | Spreadsheet with all vendors and dates |
| 01-Approved-Vendors | Active vendors ready to use |
| 02-Pending-Documents | Vendors missing paperwork |
| 03-Expired-COIs | Vendors needing updated insurance |
| 04-Archived-Vendors | Old or inactive vendors |
| Vendor Name Folder | W-9, COI, license, contacts, notes |
Tracker columns
- vendor name
- service type
- main contact
- phone
- COI expiration
- W-9 received
- license required
- approval status
- last follow-up
- notes
- file link
Weekly workflow
- Filter COIs expiring within 30 days.
- Send renewal requests.
- Move expired vendors to the expired list.
- Update file links after new documents arrive.
- Archive old documents instead of deleting everything.
Email template
COI renewal request
Hi [Vendor], our records show your COI expires on [date]. Please send an updated certificate when available so we can keep your vendor file current. Thank you.
Hi [Vendor], our records show your COI expires on [date]. Please send an updated certificate when available so we can keep your vendor file current. Thank you.
Final thought
Vendor organization is not glamorous, but it saves time when maintenance gets urgent and everyone needs answers fast.
Need vendor paperwork cleaned up?
If COIs, W-9s, licenses, expiration dates, and vendor folders are scattered everywhere, DamnJobs can help organize the mess.