This template is a register of suppliers for a small business or team. The Vendors tab holds one row per supplier, with its category, contact, payment terms, rating, contract end date, status and spend for the year.

The Dashboard counts the vendors and the active ones, totals the spend, and counts contracts ending by the end of the year. It also shows spend by category and by status, with charts. Rows turn amber when an active contract is coming up for renewal.

It comes with sample data. Make a copy, then replace the sample rows with your own suppliers. Formulas, dropdowns and charts update on their own.