A vendor list is the least glamorous document a small business owns and the one that answers the most questions. Who do we actually buy from. Who owns that relationship. Is this supplier approved, or did somebody just start paying them. Almost every business has a list somewhere and almost none of them is current, because the list was built once from memory and never had a reason to be updated. This is how to build one that survives the person who built it.
Start from the ledger, not from memory
Export twelve months of payments from your accounting system and dedupe by payee. That list is longer than the one in your head and it is complete, because a supplier you forgot is still a supplier you paid. Memory produces the twenty vendors that come to mind; the ledger produces the hundred and ten you actually have, including the three that were meant to be one-off and are now on a standing order.
Add the three fields the ledger does not hold
Owner, category and status. The owner is the person who would notice if this supplier stopped answering. The category is what you buy from them, which is what makes consolidation visible. The status is approved, in review or offboarded. None of these exist in accounts payable, and between them they turn a payment history into a vendor list you can act on.
Attach the dates, then the list maintains itself
Contract renewal and notice dates, insurance certificate expiry, and when diligence was last done. A list with dates has a reason to be opened; a list without them is a snapshot that decays from the day it is made. This is the whole difference between a spreadsheet somebody built and a record the business runs on, and it is why dates are what Venbix Pro keeps.
Keep the ones you stopped using
A supplier you offboarded is evidence, not clutter. It records that access was revoked, data was returned and the contract was closed within its notice terms. Deleting the row deletes the proof, and the question of what happened to that supplier arrives from an insurer or an auditor long after everyone involved has stopped thinking about it.
Questions people ask about vendor list
Where should the vendor list live?
Anywhere one person can update and everyone can read. A spreadsheet is fine until a date needs to warn somebody or the author leaves, which are the two things a spreadsheet cannot do.
How often should it be reviewed?
Pull a fresh twelve-month payee export once a year and reconcile it against the list. Anything paid that is not on the list is a supplier nobody approved, and that reconciliation is usually the most informative hour of the year.
What is an approved vendor list?
The subset of your vendor list that has passed whatever checks you require before people are allowed to buy. It is the same record with the status field doing the work, not a second document.