01
Vendor Master Database
Centralised register with company name, GSTIN, PAN, contact person, payment terms, bank details, and category tags. One sheet, every vendor you work with.
Free Vendor Evaluation Template for Indian Businesses (Excel)
Rate, compare, and track your vendors on 8 weighted criteria. Includes a comparison matrix for side-by-side scoring, a monthly performance tracker, and a contract renewal calendar. Pre-filled with Indian vendor examples.
- Score vendors on 8 criteria with weighted averages, not gut feel
- Compare up to 5 vendors per category in one side-by-side view
- Track monthly on-time delivery, defect rates, and invoice accuracy over time
No spam. Instant download link to your
email.
Petpooja presents
Vendor Evaluation Template
6 Sheets, Excel workbook
8
Criteria · Weighted scoring
2025-26
What's Inside
Six sheets covering every part of vendor evaluation.
02
8-Criteria Scorecard
Weighted scoring across quality, pricing, delivery reliability, credit terms, communication, compliance, range, and after-sales support. You set the weights. The sheet calculates the rest.
03
Side-by-Side Comparison
Compare up to 5 vendors per category. The matrix auto-highlights the top scorer in each criterion and shows overall weighted rank. No more mental juggling.
04
Performance Tracker
Monthly log for on-time delivery %, defect/rejection rate, invoice accuracy, and response time. Twelve months of data per vendor with trend indicators.
05
Renewal Calendar
Contract start dates, end dates, review deadlines, and overdue alerts. Colour-coded: green for active, yellow for review due, red for expired. Never miss a renewal again.
06
Pre-Filled Indian Examples
10 sample vendors (packaging, raw materials, dairy, spices, cleaning supplies), 3 complete evaluations, and realistic scores. Customise or delete them, the structure stays.
Why This Matters
The Real Cost of Picking Vendors on Gut Feel
Here's what usually happens. A supplier drops off samples, the price looks decent, someone says "they seem reliable," and you start placing orders. Six months later, half the deliveries are late and invoice errors pile up. Sound familiar?
Most Indian SMEs choose vendors the same way: referrals, relationships, and whatever worked last time. There's nothing wrong with relationships. But when you're managing 15, 20, 50 vendors across packaging, raw materials, equipment, and services, relationships alone can't tell you who's actually performing and who's costing you money. This is especially true when you're trying to control costs and boost profit.
The costs aren't always obvious. A vendor who's 5% cheaper on price but delivers late 30% of the time? That forces you to overstock, ties up working capital, and sometimes kills a production run. For restaurants, unreliable vendors directly inflate food cost through emergency purchases at higher rates. Another vendor sends wrong invoices every other month. Your accounts team spends hours reconciling, and you risk Input Tax Credit rejection under GST Rule 36(4) if their GSTR-1 doesn't match your GSTR-2B.
Then there's the compliance angle. Under GST, your ITC claim depends on your vendor filing their returns correctly. If a vendor's GSTIN is cancelled or suspended and you don't catch it, you lose the credit. For a business spending ₹50,00,000 a year on procurement, that's potentially ₹9,00,000 in GST credit at risk. Our GST Return Filing Checklist covers the reconciliation process in detail.
This template doesn't replace your judgement. It organises it. Score each vendor on 8 criteria with weights you control. Compare them side by side. Track their performance monthly so you can spot problems in March, not December. Businesses using Petpooja Purchase automate this entire process with AI invoice scanning and vendor performance dashboards, but even without software, this spreadsheet puts you ahead of 90% of SMEs still running vendor decisions on memory and WhatsApp messages.
Sample Preview
What you'll find inside the template.
Five rows from five different sheets. This is real data from the pre-filled examples:
Vendor Master: Sharma Packaging Pvt. Ltd. | GSTIN: 24AABCS1234F1Z5 | Payment Terms: Net 30 | Category: Packaging | Annual Volume: ₹8,40,000
Scorecard: Quality (9/10, weight 25%) + Delivery (7/10, weight 20%) + Price (8/10, weight 15%) + ... = Weighted Score: 8.1/10 | Rating: Preferred Vendor
Comparison Matrix: Sharma Packaging (8.1) vs Rajesh Containers (7.4) vs Greenpack India (6.9) | Winner highlighted: Sharma Packaging | Best on: Quality, Credit Terms
Performance Tracker: April 2025: On-time Delivery 94% | Defect Rate 1.2% | Invoice Accuracy 98% | Trend: Improving (up from 88% on-time in January)
Renewal Calendar: Sharma Packaging | Contract End: 30 Sep 2025 | Review Due: 15 Aug 2025 | Status: Yellow (review in 45 days) | Last Renewed: 01 Oct 2024
... plus 9 more sample vendors, instructions sheet, and blank rows ready for your data.
Key Stats
Why vendor evaluation matters.
8
Criteria scored per vendor: quality, pricing, delivery, credit terms, communication, compliance, product range, and after-sales support.
Source: Template specification, based on CIPS procurement best practices90%+
On-time delivery rate is the benchmark for a reliable vendor. Below 85%, your production schedule and customer promises start breaking down.
Source: CIPS Supply Management standards₹20K+/yr
Estimated annual loss for small businesses from poor vendor choices, including late deliveries, quality rejections, and missed ITC claims.
Source: MSME Ministry estimates, directional
Common Mistakes
8 Vendor Selection Mistakes Indian SMEs Make
01
Choosing vendors only on price
The cheapest quote wins. Until deliveries arrive late, quality drops, or you spend hours chasing credit notes. Total cost of doing business with a vendor is far more than the invoice amount.
02
No written evaluation before onboarding
Someone recommended them, so you place the first order. No reference check, no trial order, no scoring against your existing vendors. You're committed before you know what you're getting.
03
Never reviewing performance after the first order
The initial delivery was great. Six months later, on-time rates dropped to 70% and quality slipped below FSSAI compliance standards. But nobody tracked it, so nobody noticed until a big order went wrong.
04
Not verifying vendor GST returns
Under GST Rule 36(4), your Input Tax Credit depends on your vendor filing GSTR-1 correctly. If their returns don't match, your ITC claim gets rejected. That's real money lost.
05
Verbal agreements instead of documented terms
Payment terms, delivery schedules, defect policies. All agreed verbally. When something goes wrong, there's no reference point. Disputes drag on because nothing was written down.
06
Same vendor for everything
Convenience is nice. But using one vendor across unrelated categories means you never benchmark. Are their prices competitive for cleaning supplies if they're primarily a food supplier? Probably not.
07
Ignoring credit terms as a scoring factor
Two vendors quote the same price. One offers Net 15, the other Net 45. That's 30 extra days of working capital in your bank account. Credit terms matter more than most owners realise.
08
No renewal calendar
Contracts auto-renew because nobody remembered the review date. You're locked in for another year with a vendor you wanted to replace. A simple calendar prevents this entirely.
Comparison
Vendor Selection: Gut Feel vs This Template.
| Aspect | Gut-Feel Selection | With This Template |
|---|---|---|
| Selection criteria | Price and personal relationship | 8 weighted criteria with scores |
| Vendor comparison | Mental notes, maybe a WhatsApp group | Side-by-side matrix, auto-ranked |
| Performance tracking | React when something goes wrong | Monthly data on delivery, quality, invoicing |
| GST compliance check | Rarely done | GSTIN and return status tracked per vendor |
| Contract renewals | Auto-renew by default, review by accident | Calendar with colour-coded alerts |
| Onboarding new vendors | "Someone recommended them" | Scored against existing vendors before first order |
| Negotiation leverage | Anecdotal complaints | 6 months of data showing exact performance gaps |
Pick better vendors. Pay less for the same quality.
Download the free Vendor Evaluation Template and start scoring vendors on data, not memory.
FAQ
Frequently asked questions.
Is this template useful for businesses outside restaurants?
Absolutely. The 8 evaluation criteria (quality, pricing, delivery, credit terms, communication, compliance, range, and after-sales support) apply to any business that works with vendors. Retail stores, manufacturing units, construction companies, hospitals, salons. If you're in the food business, pair this with our Food Cost Calculator to see how vendor pricing impacts your dish-level margins, and use our restaurant P&L template to see how vendor costs flow into your overall profit picture. The pre-filled examples use restaurant-style vendors for illustration, but you can replace them with your own supplier names in under 10 minutes.
How do I score vendors on the 8 criteria?
Each criterion is scored on a 1-10 scale. You assign a weight to each criterion based on what matters most to your business. For example, if on-time delivery is critical, you might weight it at 25%. If after-sales support matters less, give it 5%. The scorecard multiplies each score by its weight and gives you a single weighted average. The Instructions sheet walks through this step by step with a worked example.
Can I add more than 5 vendors to the comparison matrix?
The default comparison sheet supports 5 vendors per category, which works well for most purchasing decisions. You can duplicate the sheet for additional comparisons or extend the columns. The formulas are transparent, not locked, so you can modify them freely. For businesses managing 50+ vendors, Petpooja Purchase offers an automated vendor dashboard.
How often should I review vendor performance?
Monthly for your top 10 vendors by spend. Quarterly for the rest. The Performance Tracker sheet is built for monthly input: on-time delivery rate, defect/rejection rate, invoice accuracy, and response time. Annual reviews work for contract renewals, but monthly tracking catches problems early. If a vendor's on-time rate drops below 85% for two consecutive months, that's your signal to start looking at alternatives. Good vendor management is a core part of cost control for any business.
Does this template help with GST vendor compliance?
Yes. The Vendor Master sheet captures GSTIN for every vendor, and the scorecard includes a compliance criterion. While this template doesn't auto-check GST return filing status (you'll need the GST portal or a tool for that), it gives you a structured place to record compliance status and flag vendors whose returns are irregular. Under GST Rule 36(4), your ITC is at risk if your vendor hasn't filed returns. Our GST Return Filing Checklist covers the full reconciliation process.
About Petpooja
Petpooja is India's leading SME business software suite, trusted by 1,50,000+ businesses across restaurants, retail, healthcare, manufacturing, and more. From billing and payroll to task management and procurement, Petpooja helps Indian businesses run better, every day.
Automate vendor management for your entire business
Petpooja Purchase scans invoices with AI (printed, handwritten, or PDF), tracks vendor performance automatically, syncs with Tally and Busy, and gives you a live dashboard of every vendor relationship. No more spreadsheets, no more manual data entry.
Book a Free Demo
Call: +91-63588 71186