Vendor Due Diligence Scorecard | Excel Third-Party Risk Assessment Template

Assess, score and monitor your third-party vendors in one ready-to-use Excel workbook.

The Vendor Due Diligence Scorecard gives procurement, compliance and risk teams a consistent, documented way to approve suppliers, without expensive software. Score each vendor, catch deal-breakers automatically, track evidence and schedule reviews, all in Excel.

WHAT'S INSIDE

- Vendor Register: up to 50 vendors with criticality, spend, contract dates, owner and assessor

- Assessment: 40 due diligence questions across 8 weighted risk categories, scored 0 to 5 or N/A from a dropdown, with guidance on what evidence to collect for each question

- Knock-out red-flag rules: 6 deal-breaker questions (sanctions, beneficial ownership, insolvency, adverse media, data protection, forced labour). A red flag overrides a good score, so the vendor is escalated automatically

- Document Checklist: 12 evidence documents per vendor (Received, Pending, Expired, N/A) with completion %

- Scorecard: a one-page report for any vendor with scores, gaps, red flags, decision and sign-off block. Print or save as PDF

- Dashboard: KPIs, final rating mix, criticality × rating heat map, category averages and overdue reviews

- Settings: edit category weights, rating bands, review cycles and red-flag rules to match your policy

THE 8 RISK CATEGORIES

Corporate & Legal · Financial Stability · Compliance & Sanctions · Information Security · Data Privacy · Business Continuity · Operational & Service Quality · ESG & Reputation

AUTOMATIC OUTPUTS

- Overall score out of 100 and a final rating (Low, Moderate, High, Critical)

- Recommended decision: Approve, Approve with conditions, Escalate or Reject

- Next review date based on rating and vendor criticality, with Overdue and Due Soon alerts

YOU RECEIVE (ZIP file)

- BLANK workbook, ready for your vendors

- SAMPLE workbook with 6 fictional vendors to show how everything works

DETAILS

- Works in Microsoft Excel 2010 and later, including Microsoft 365

- No macros, no add-ins, no subscription

- Formula sheets are protected without a password to prevent accidental changes, and you can unprotect them to customise

- Instant digital download

WHO IT'S FOR

Procurement teams, compliance officers, third-party risk managers, consultants and small businesses that need a structured supplier onboarding process.

Built by FinGuard Studio™, creator of Excel tools for compliance and risk professionals.

This template supports your organisation's own judgement and policies. It is not legal advice.