A vendor master list is one sheet with one row per supplier, holding everything you need to pay, contact and identify them correctly: legal name, trade name, GSTIN, contact person, payment terms, typical items and, kept carefully, bank details. Build it once, add a vendor before the first payment, and use it as the single place to look up who a supplier really is.
Which columns should the sheet have?
| Column | Why it earns a place | Made-up example |
|---|---|---|
| Vendor ID | A short unique code that never changes | V014 |
| Legal name | The name on invoices and bank account | Shree Ganesh Traders |
| Trade name | What people call them, for matching narrations | Ganesh Stationers |
| Type | Goods, services, freelancer, landlord | Goods |
| GSTIN | Check it against a vendor's invoice; leave blank if unregistered | As printed on the invoice |
| PAN | Useful for your CA when asked | Optional |
| Contact person and phone | Who to call about a delivery or a mismatch | Mr Rao, with number |
| Email and address | Where invoices come from and where they ship from | Optional |
| Payment terms | When you agreed to pay | Within 30 days of invoice |
| Typical items | What you usually buy from them | Paper, files, toner |
| Status | Active, on hold or closed | Active |
| Last checked | Date you last confirmed the details | 12-Nov-2025 |
A GSTIN has 15 characters, so a quick length check catches most typing slips. Beyond that, copy it exactly as printed on the vendor's invoice rather than from memory.
What about bank details?
Account holder name, account number and IFSC are what make a payment land. They are also what a fraudster wants. The safest way is to keep them out of the main sheet altogether: hold them in a separate file or a separate protected tab that only the person who makes payments can open, and store only the last four digits of the account number in the visible list. Keep login details, passwords and card or UPI PINs out of every vendor file.
How do I keep the list tidy as it grows?
- Turn the range into an Excel Table or a filtered range so the headers stay with the data.
- Add a dropdown for Type and Status with Data validation, so people choose a word and do not type a variation.
- Flag repeats with =COUNTIF($B$2:$B$300,B2)>1 in a spare column; TRUE means the legal name is already listed.
- Freeze the header row and sort by Vendor ID so the oldest suppliers stay at the top.
Should I list every one-off shop?
No. Draw a simple line. A vendor goes on the list if you pay them more than once, if you receive a GST invoice from them, or if you owe them money for any length of time. The corner shop where you pay for a packet of tea in cash does not need a row; a monthly courier or a freelancer does. A weekly check of the last payments will tell you which one-offs have quietly become regular.
How do I use the list when paying?
- Before paying a new vendor, add the row and check the legal name against the invoice.
- Match the name and GSTIN on each bill with the master list; a mismatch means asking a question before paying.
- Pay from the details in the list, not from details typed fresh into a message.
- Record the payment in your tracker, with the vendor name written the same way each time.
Say you order stationery from Ganesh Stationers, and a bank narration reads GANESH STN 4471. Because your list shows trade name and legal name, you can see in a moment that both belong to V014. SpendixAI lets you add merchant aliases so odd narrations like that group under one name, but it records what you paid and does not hold a vendor master, so keep this sheet alongside it.
A yearly clean-up
- Mark vendors with no payment in twelve months as inactive, not deleted.
- Re-confirm contact details for your top five suppliers.
- Ask your CA whether they want any extra identifier for a particular type of vendor, since what records you need depends on your own situation.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

