Restaurant vendor payment tracker (India)

Why vendor payment aging matters

Most Indian restaurant kitchens run on informal credit from vendors — the sabzi mandi supplier, the meat vendor, the distributor. When these balances are not tracked systematically, two problems compound: unexpected demands for settlement at the worst time (month-end, peak season), and loss of negotiating position because you don't know which vendors are being paid on time and which are quietly accumulating overdue interest or quietly shortchanging deliveries in response to late payments.

An aging analysis — breaking outstanding into 0–7 days (current), 8–30 days (should pay soon), 31–60 days (overdue), 60+ days (problematic) — tells you where your cash flow priority should be and which vendor relationships are at risk. A vendor with ₹40,000 outstanding at 45 days is a relationship risk even if the absolute amount feels manageable.

Credit notes and debit notes

Credit note: issued by the vendor when goods are returned, found short, or a pricing error is corrected in your favour. It reduces your outstanding balance. Record it as a "Credit Note" type — it will deduct from your payable to that vendor.

Debit note: issued by you to the vendor when you are raising a claim — for short delivery, poor quality, or a price discrepancy. It increases the vendor's obligation to you. Record it as a "Debit Note" type. In practice, most informal restaurant-vendor relationships resolve these as informal adjustments rather than formal documents, but recording them here maintains the paper trail for your own reconciliation.

GST implications of vendor payments

For restaurants claiming GST input tax credit (ITC), every invoice in this ledger should have a matching entry in GSTR-2B (auto-populated from vendor filings). If a vendor has not filed their GSTR-1, your ITC for that invoice will not appear in GSTR-2B and cannot be claimed. Tracking invoice reference numbers here lets you reconcile with GSTR-2B at month-end and follow up with specific vendors whose invoices are missing.

TDS under Section 194C applies to restaurant "works contracts" (usually catering or event-specific vendors) where a single payment or aggregate payments exceed ₹1 lakh. For regular daily produce and raw material vendors this typically does not apply, but check with your CA for vendors doing >₹1 lakh/month.

Where this fits

• Purchase order template — the PO is the authorisation; this ledger tracks whether the resulting invoice was received and paid; use the PO reference number as the invoice ref here
• Petty cash voucher pad — small vendor payments made in cash should be supported by a petty cash voucher; record the voucher number as the ref # in this ledger
• Inventory count sheet — after each purchase invoice is entered here, verify that the delivered quantity matches the inventory count; discrepancies should become credit notes or debit notes in this ledger
• Monthly P&L statement — total invoices received in a period is your raw COGS input; the payment ledger reconciles cash out vs. accrual; keep both in sync
• P2 — Petty cash & payables pillar — all articles on cash disbursements, vendor credit management and payables reconciliation for Indian restaurant operators