📋 Free Vendor Payment Tracker Template
Below is a complete vendor payment tracker: columns for every supplier invoice, its due date, payment status, and reconciliation. Set it up as a spreadsheet and never miss a due date.
This tracker helps you manage accounts payable — every invoice you owe, when it’s due, and whether it’s been paid. It’s the difference between paying on time (and keeping suppliers happy) and losing track of what you owe. The columns work for any number of vendors and scale from a handful of invoices to hundreds per month.
Invoice Tracking Columns
| Fields | Description |
|---|---|
| Vendor Name* | The supplier who issued the invoice. |
| Invoice Number* | The supplier’s invoice number. |
| Invoice Date* | When the invoice was issued. |
| Amount* | Total payable including VAT. |
| Currency | If you work with multiple currencies. |
| Due Date* | Payment deadline. |
| Payment Status* | Unpaid / Scheduled / Paid / Overdue. |
| Payment Date | When you actually paid. |
| Payment Method | Bank transfer, card, cash, etc. |
| PO Reference | Linked purchase order number, if any. |
| Notes | Disputes, partial payments, early-batch discounts. |
Summary Dashboard
| Fields | Description |
|---|---|
| Total Outstanding* | Sum of all unpaid invoices. |
| Total Overdue* | Sum of invoices past their due date. |
| Due This Week | Invoices due in the next 7 days. |
| Due This Month | Invoices due in the current month. |
| Total Paid (Month) | Sum of payments made this month. |
How to use
- 1Set up a spreadsheet with the Invoice Tracking Columns as headers.
- 2Create a dropdown for Payment Status: Unpaid, Scheduled, Paid, Overdue.
- 3Log every supplier invoice the day it arrives — don’t let them pile up in your inbox.
- 4Sort or filter by Due Date weekly so nothing slips past its deadline.
- 5Use conditional formatting to highlight overdue invoices in red.
- 6Update the Payment Status and Payment Date the moment you make a payment.
Or automate this
Manually tracking dozens of vendor invoices is where due dates get missed and early-payment discounts are lost. Nika can read incoming supplier invoices, log them with due dates, and flag what needs paying this week — from {price} per invoice.
Questions
How do I avoid late payment fees?
Log every invoice with its due date as soon as it arrives, review the tracker weekly sorted by due date, and schedule payments a few days before the deadline. Set up calendar reminders for large or critical payments.
Should I take early-payment discounts?
If a supplier offers a discount for early payment (e.g. 2% for payment within 10 days), calculate whether the saving exceeds what you’d earn by holding the cash until the normal due date. For most small discounts, paying early is worth it.