A supermarket does not buy from one wholesaler. It buys from many distributors: one for biscuits and snacks, one for detergents, one for oil, one for the dairy, a few local makers for namkeen and papad, and a wholesale market run for loose dal and spices. Each has its own visit day, its own credit days, its own schemes and its own rule about taking goods back.
Keeping all of that in your head works for the first few months. After that, the gaps show up as a scheme you never got, a return that was never adjusted, or a salesman who says you owe more than you think you do. This guide is a simple system for managing suppliers that any store can run, on paper, in Excel or in software.
If you want the steps for entering a single bill, see purchase bill entry. For the monthly register and the GSTR-2B check, see purchase register format. This guide is about the relationship around those bills.
Step 1: make one supplier sheet
Start with one row per supplier. It takes an evening and saves arguments for years.
| Column | Example (made up) |
|---|---|
| Supplier | Supplier A Distributors |
| GSTIN | 24XXXXXXXXXX1Z5 |
| Brands / lines | Biscuits, snacks |
| Salesman + phone | Ramesh, 98XXXXXX01 |
| Office / accounts phone | 79XXXXXX01 |
| Visit day | Monday |
| Credit days agreed | 15 |
| Scheme terms | Written, month by month |
| Return rule | Damaged: exchange. Near expiry: credit note up to 30 days before date |
| Minimum order | ₹5,000 |
Two columns matter more than they look:
- The office phone. Salesmen change. The distributor's accounts person is who settles a disputed balance.
- The return rule, in writing. "Bring it back, we will see" is not a rule. Ask what they take back, how close to expiry, and whether it comes as an exchange or a credit note.
Step 2: make every scheme reach your cost
Schemes are where most of a supermarket's buying margin hides, and where it leaks.
There are three common kinds:
- Free goods on the bill. Buy 10 cartons, get 1 free. The free carton is on the bill at zero.
- Discount on the bill. A percentage or rupee amount off the bill.
- Later credit. A target scheme or display money that comes back as a credit note weeks later.
The first two are easy if you enter them as they appear on the bill. The third one gets lost. Keep a small scheme log:
| Supplier | Scheme | Promised | Expected by | Received | Note no. |
|---|---|---|---|---|---|
| Supplier A | Monthly target | ₹2,000 | 15th next month | ||
| Supplier B | Display, end cap | ₹1,500 | End of quarter | ₹1,500 | CN-0042 |
Look at the blank "Received" cells once a month and ask the salesman about each one. For working out what a free carton does to your cost per piece, see margin calculation for a retail shop.
Step 3: track credit days and outstanding every week
Every supplier has a credit period, usually agreed by word of mouth. Write it down. Then once a week, ideally the same day, run this check:
- List each supplier's unpaid bills with bill date and amount.
- Mark the bills that are past their credit days.
- Compare your total with what the salesman says you owe. If they differ, find the bill or note that explains it.
- Decide what to pay this week, oldest first.
A made-up example:
| Supplier | Bills unpaid | Oldest bill | Credit days | Overdue | Their figure |
|---|---|---|---|---|---|
| Supplier A | ₹40,000 | 22 days old | 15 | Yes | ₹40,000 |
| Supplier B | ₹25,000 | 10 days old | 21 | No | ₹27,000 |
Supplier B's ₹2,000 gap is the kind that grows if you ignore it. Usually it is a return they never adjusted, a credit note you entered and they did not, or a bill one side never received.
The GST reason to pay on time
There is a tax reason too, not just goodwill. Under GST, if you do not pay a supplier the bill value plus tax within 180 days from the invoice date, the input tax credit you took on the unpaid part has to be reversed, with interest. Once you pay, you can take the credit again. A bill that sits forgotten in a disputed balance can quietly cost you this way. Your accountant handles the return; your job is to make sure no bill is forgotten.
Step 4: returns and the vendor balance
Returns are the step that most often breaks the supplier balance and your stock at the same time.
When goods go back to a distributor, damaged, near expiry, or wrong items:
- Enter the return the day the goods leave the store, not when the credit note arrives. Stock must go down that day, or your shelf and your system stop agreeing (see negative stock).
- Get a signed slip from the salesman listing items, quantities and MRP.
- Note what you expect back: an exchange, or a credit note for a rupee amount.
- Match the credit note when it comes. Under GST, the supplier is the one who issues the credit note. Check its amount against your slip.
- Clear it in the weekly outstanding check. An unmatched return slip is money the supplier still owes you.
Whether a supplier accepts returns is up to them, which is why the return rule belongs in the supplier sheet from day one. For catching near-expiry stock early enough to return it, see expiry date tracking.
Step 5: review your suppliers twice a year
Once every six months, look at each supplier on four things:
| Question | What to look at |
|---|---|
| Do they deliver what was ordered? | Short or wrong items on the bill |
| Do schemes arrive? | Blank cells in the scheme log |
| Do they honour returns? | Unmatched return slips |
| Do their lines sell? | Their items in your dead stock list (see dead stock) |
You may not be able to drop a distributor who has the only rights to a brand in your area. But you can raise the problem with facts, and a calm conversation with a list in hand gets further than a complaint.
From our counter
At Banjara, our own supermarket in Ahmedabad, supplier days have a rhythm every store owner will know: salesmen arrive during counter hours, the order is given in a hurry, and the bill turns up a day or two later with the delivery. Our view after running a store is that the order is not the important moment. The important moment is the receiving desk, when the bill meets the goods. That is where a short item, a missing free carton or a wrong MRP gets caught, or does not. If you can give only fifteen careful minutes a day to suppliers, give them to receiving, not to ordering.
Where software helps
A supplier sheet and a scheme log work fine in a notebook or Excel. What gets hard is keeping the outstanding right while bills, payments, returns and credit notes come in every day from many suppliers. Software that keeps purchase entry and supplier balances in the same place means a return or a payment changes both stock and the balance at once, so the weekly check takes minutes instead of an afternoon.
How MarCat handles it
We have run Banjara since January 2025, and it has billed on MarCat since April 2026. This is what MarCat does for suppliers:
- Purchase entry follows the supplier bill as it actually arrives, with batch, MRP and cost for each line, and every purchase moves stock automatically.
- Vendor records and outstanding balances stay in the same system as purchases, so you see what you owe each supplier without a separate sheet.
- Purchase and margin reports show what you bought and what it left you, and stock movement reports surface lines that stopped moving, which helps in the supplier review.
If you want to see how supplier bills and balances work on a real store, message us on WhatsApp at +91 96787 65518.
