Supplier payment tracker
A supplier payment tracker is a list of the bills you owe your suppliers. For each bill you write the amount, the due date and what you have paid. The sheet shows the balance on each bill, the total unpaid and which bills are overdue.
What you type stays on your device. Nothing is saved or sent, so print it or download the CSV before you close the page. To make a PDF, choose "Save as PDF" in your browser's print window.
What it is for
A supplier payment tracker is a list of the bills you owe your suppliers. For each bill you write the amount, the due date and what you have paid. The sheet shows the balance on each bill, the total unpaid and which bills are overdue.
Read more: Purchase register and supplier bills · Vendor scorecard
How to use it
- Write one line for each supplier bill: supplier, bill number, bill date and amount.
- Write the due date from the bill or from your agreement with the supplier.
- When you pay, write the amount in the Paid box. For a part payment, write what you paid so far.
- Read the Balance column. A bill with money still owed and a due date before today is marked Overdue. The sheet checks the date on your device.
- Look at the total unpaid at the bottom before you plan the week's payments. Print the sheet or download the CSV.
Supplier payment tracker
Zentaro Serve · serve.zentaro.cloud/templates/supplier-payment-trackerExample, not real data. Press "Clear all" to start your own sheet.
| Supplier | Bill no. | Bill date | Amount (₹) | Due date | Paid (₹) | Balance (₹) | Status |
|---|---|---|---|---|---|---|---|
- Total billed
- Total paid
- Total unpaid
- Overdue
Worked example
Four made-up bills, checked as on 18 November 2026. They are not real suppliers. Press "Fill with the example" to see them in the sheet.
- Vegetable supplier A: billed ₹18,400, paid ₹18,400. Balance ₹0. Paid in full.
- Dairy supplier B: billed ₹26,250, paid ₹10,000. Balance ₹16,250. Due 19 November 2026, so not overdue.
- Grain and oil supplier C: billed ₹41,900.50, nothing paid. Balance ₹41,900.50. Due 12 November 2026, so it is 6 days overdue.
- Packaging supplier D: billed ₹7,800, nothing paid. Balance ₹7,800. Due on the same day, so not overdue yet.
- Total billed ₹94,350.50. Total paid ₹28,400. Total unpaid ₹65,950.50. Overdue ₹41,900.50 on 1 bill.
Calculators that go with this
Questions about this sheet
When is a bill marked overdue?
When money is still owed and the due date is before today. A bill due today is not overdue yet. The sheet uses the date on your device.
What if I pay more than the bill?
The Balance shows a minus figure and the line says Paid extra. It is not taken off the total unpaid. Check it with your supplier.
Is what I type saved or sent anywhere?
No. What you type stays on your device. Nothing is saved or sent. Print the sheet or download the CSV before you close the page.
Want this done for you, every day?
Zentaro Serve launches in 2027. It keeps your sales, cash, stock and recipes in one place. Tell us what you run today and we will get in touch.
Last updated: