Tools / Supplier Toolkit
Free tool · Supplier Toolkit

HORECA Khata & Outstanding Tracker

Ask any HORECA supplier their biggest problem and it is never demand, it is the money stuck at thirty buyers on thirty different credit clocks. This khata keeps invoice-wise outstanding per party, flags what has crossed its credit period, and generates a polite WhatsApp reminder with the exact invoices and amounts, chasing money without burning the relationship.

Supplier Toolkit — HORECA Khata & Outstanding Tracker
In short

Track outstanding buyer-wise, not invoice-wise: each party's total due, what portion is past its credit period, and the oldest overdue days. Send itemised WhatsApp reminders listing invoice numbers and amounts, specific reminders get paid, vague ones get promised.

Overdue = unpaid amount on any invoice past invoice date + credit days. Data stays in your browser's local storage, nothing uploads. Update the paid column as money arrives and the ledger stays honest.

Data lives in this browser only, nothing uploads. Update the "paid" column as money arrives; red rows are past their credit period. The reminder message is deliberately polite: in this trade you chase the money and keep the relationship.

How to use the HORECA Khata & Outstanding Tracker

  1. Add each invoice with party, amount, date and the credit period you actually agreed.
  2. Update the paid column as payments arrive.
  3. For any party in red, tap the WhatsApp reminder, it lists their exact pending invoices.

Frequently asked questions

What credit period is normal in HORECA supply?

7-15 days for fresh produce and dairy, 15-30 for groceries, and big accounts routinely push to 30-45. The trap is unstated credit: an invoice with no agreed period defaults, in the buyer's mind, to whenever. Put days on every invoice and this tracker enforces the number you actually agreed.

When should a reminder escalate beyond WhatsApp?

A working rhythm: polite WhatsApp at due date, a call at +7 days, owner-to-owner conversation at +15, and supply-on-advance-only past +30. Suppliers who escalate on a published rhythm get paid before the suppliers who explode randomly once a quarter.

Should I stop supplying a buyer who is overdue?

Stop adding exposure, not necessarily supply: shift them to cash-on-delivery or advance until the old balance clears. Cutting supply outright often converts a slow payer into a never-payer; COD keeps the relationship and stops the hole deepening.

More Supplier Toolkit tools

Want this run for you? Book a free auditExplore the platform →