Almost every operations manager has one: vendors_MASTER_final_v4.xlsx. Last visit: “??”. Rate: “$85 or $95?”. Paid: “check email”. It works until someone forgets to update it, and then nobody knows when the HVAC is due, who approved the plumber, or how much was spent on supplies this quarter.
What goes wrong with vendor spreadsheets
- They are only as current as the last person who updated them.
- Recurring visits get missed, because a spreadsheet cannot remind anyone.
- Approvals happen in email and cannot be found later.
- Contracts renew silently, or lapse without anyone noticing.
- Owners ask for totals and someone spends an afternoon adding them up.
1. Keep one record per vendor
For each vendor, keep the services they provide, their rates, contract dates, contact details, and a simple rating after each job. When a new team member joins, everything they need is in one place.
2. Schedule recurring visits once
Cleaning every Monday, HVAC every three months, pest control twice a year. Set each one up once with its due date, and get reminded before it is due, instead of remembering.
3. Approve costs before work starts
For anything beyond routine work, get a quote and record who approved it before the vendor starts. It prevents surprise bills and answers “who said yes to this?” instantly.
4. Track every job to done
Each job should move through clear steps: requested, approved, scheduled, done. When a client reported the problem, tell them when it is fixed, so they do not have to ask.
5. Count supplies and repairs as you go
Record each vendor bill and supply purchase against a category and a location when it happens. At the end of the month, the totals are already there.
6. Give owners a live view
Instead of sending “the latest version”, give owners a view they can open any time: spending by vendor and category, unpaid bills, and jobs completed.
HOW VERVEOS HANDLES IT
Process flows that replace the spreadsheet.
- Every vendor in one place: services, rates, contracts, ratings and how much you have spent with each.
- Recurring visits with due dates, and reminders before they are due, on your team’s Today screen.
- Requests, approvals and work orders: a client reports a problem with a photo, you approve the cost, the job is scheduled and tracked to done.
- A schedule of every vendor visit and job, with times, so the front desk knows who is coming.
- Spending counted for you: vendor spend, unpaid vendor bills and expenses by category, including supplies, for each location.
Stuck with a glitch or slow support?
Tell us what is going on with your current system. We might be able to help you sort it out. We are just getting started, and every piece of feedback means the world to us.
Get in touch