Tax and GST

A vendor master list: the details to store for each supplier

A vendor master list template: the supplier details worth storing, from legal name and GSTIN to payment terms, plus how to keep bank details safe.

Editorial illustration for A vendor master list: the details to store for each supplier

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?

ColumnWhy it earns a placeMade-up example
Vendor IDA short unique code that never changesV014
Legal nameThe name on invoices and bank accountShree Ganesh Traders
Trade nameWhat people call them, for matching narrationsGanesh Stationers
TypeGoods, services, freelancer, landlordGoods
GSTINCheck it against a vendor's invoice; leave blank if unregisteredAs printed on the invoice
PANUseful for your CA when askedOptional
Contact person and phoneWho to call about a delivery or a mismatchMr Rao, with number
Email and addressWhere invoices come from and where they ship fromOptional
Payment termsWhen you agreed to payWithin 30 days of invoice
Typical itemsWhat you usually buy from themPaper, files, toner
StatusActive, on hold or closedActive
Last checkedDate you last confirmed the details12-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?

  1. Before paying a new vendor, add the row and check the legal name against the invoice.
  2. Match the name and GSTIN on each bill with the master list; a mismatch means asking a question before paying.
  3. Pay from the details in the list, not from details typed fresh into a message.
  4. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports