Business

Supplier Scoring Sheet Indian SMBs Run to Cut Risky Vendors

2026-09-22 - ABikram Mondal

The monthly symptom that hits cash flow first

Owners watch orders arrive late or invoices fail GST checks. Suppliers that looked fine on the phone deliver 20 percent of the time with defects or delays. According to the India Digital Procurement Report 2026 by India SME Forum and Amazon Business, 67 percent of MSMEs cite managing multiple suppliers as a top challenge while 56 percent face non-compliant invoices and price volatility.

Finance teams spend 30 to 40 percent of their time on reconciliation and matching transactions, the Bain report released at Global Fintech Fest 2026 found. Rs 8.1 lakh crore stays stuck in delayed payments across the sector. One bad supplier can tie up working capital for weeks.

The visible cost shows up in lost sales when stock runs out or customers cancel. The hidden cost is owner time spent chasing updates instead of new orders. Proactiq State of SMB Operations 2026 puts average manual admin time at 11.4 hours per week for owners.

That time has a direct rupee value. Divide annual profit by 2300 working hours and the owner hour rate appears. Five hours a week on supplier calls equals one full day lost every month that a process coordinator could handle for a fraction of that cost.

Root cause sits in the absence of a shared record

Most teams keep supplier notes in WhatsApp chats or one person's memory. When the owner steps away, the next order repeats the same mistake. The Proactiq report shows 74 percent of SMBs under 50 employees still run primary operations on Excel or Google Sheets, with an average of 12 separate spreadsheets creating silos.

No single sheet tracks delivery performance, invoice compliance, or price consistency across vendors. Decisions stay ad hoc. A supplier who missed once gets another chance because no one logged the score.

The result is repeated purchases from the same risky sources. Digital procurement adoption sits at just 17.6 percent of the Rs 124.9 lakh crore annual spend, the India SME Forum report states. The rest stays manual and opaque.

Step one: list the four scoring criteria

What: create a simple table with columns for on-time rate, quality defects, invoice compliance, and price stability. Who: the process coordinator owns the template. How: pull last six months of purchase records and delivery notes into one sheet. When: finish the draft by end of week one.

The criteria stay fixed for the quarter. On-time rate counts orders received within agreed window. Quality defects counts returns or rework requests. Invoice compliance checks GST format and matching amounts. Price stability tracks variance against quoted rates.

Four columns keep the sheet usable on a phone. Add a fifth column for overall score once data exists. No owner approval needed for the first version.

Step two: assign data collection to one role

What: every purchase order gets logged with delivery date, defect count, and invoice status. Who: the admin executive records entries within 48 hours of receipt. How: use a shared Google Sheet or simple form that feeds the master list. When: start logging from the first new order after the template is ready.

The executive does not decide scores. They only enter facts from delivery challans and invoices. This removes owner interruptions for status checks.

Monthly volume determines effort. A team handling 50 orders a month spends under two hours on entry. That replaces scattered phone calls that previously consumed owner time.

Step three: run the first scoring pass

What: calculate percentages and assign points on the four criteria. Who: the procurement lead tallies scores every month end. How: use basic formulas in the sheet for on-time percentage and defect rate. When: complete the first full scoring by the end of month two.

Rank suppliers A, B, or C. A suppliers stay on the approved list. B suppliers get a review note. C suppliers move to probation or exit. The lead presents the ranked list at the next executive meeting.

Score changes get noted with dates so trends appear over quarters. No subjective overrides from the owner unless new evidence surfaces.

Step four: tie scores to order decisions

What: set rules that route new orders only to A or B suppliers unless no alternative exists. Who: the procurement lead enforces the rule on every purchase requisition. How: add a quick check against the current ranked list before approving any PO. When: apply from the first order after scoring completes.

Exceptions require a one-line note in the sheet and go to the process coordinator for record. The rule cuts repeat business with known problem vendors without daily owner involvement.

Quarterly review happens in the executive meeting. The procurement lead brings updated scores and any C suppliers flagged for removal. Changes get approved by the group, not the owner alone.

Step five: measure the shift in two numbers

What: track average on-time rate and invoice compliance percentage across all suppliers. Who: the process coordinator pulls the two numbers from the sheet at month end. How: compare against the baseline recorded in month one. When: report at the executive meeting starting month three.

Owners who previously spent hours on supplier calls now see the sheet replace those calls. The same 11.4 weekly admin hours shrink because data lives in one place and decisions follow the scores.

ABikram Mondal builds automation for exactly this kind of problem at https://abikrammondal.com/services/automation. The sheet stays the single source of truth even when the owner travels or takes time off.

The short version. A supplier scoring sheet owned by the process coordinator turns repeated bad purchases into a logged, ranked list that runs without owner calls.

Sources

Reported from the sources above on 2026-09-22. Figures are as published at the time of writing. If something here has moved on, the linked source is the one to trust.

From the desk of ABikram Mondal

If you got here because you are actually thinking about building the flow management system, the CRM or the inventory system this article describes, so it exists instead of staying an idea, that is the work I do. I build for founders and small teams who want the thing to exist and work, not a deck about it.

Automation services · everything I do · talk to me