Supplier payment tracker template for a small business in Nigeria
Track supplier bills, due dates, payments and remaining balances in one simple schedule, with a naira example and checks against duplicate entries.
A supplier payment tracker helps a business see what it has been billed, what it has actually paid and what remains due. It is especially useful when purchases arrive on different dates or the supplier allows payment later.
Tracker fields to include
Use a separate line for each supplier bill or agreed payment milestone:
- Supplier name and bill or delivery reference.
- Date received, due date and description of the goods or service.
- Amount billed in naira.
- Confirmed amount paid and payment date.
- Balance outstanding.
- Transfer, cash or other payment reference.
- Person who checked the bill and approved payment.
Do not overwrite the original bill amount when the supplier corrects it. Keep the revised document or adjustment linked to the earlier reference so the reason for the new balance is visible.
A worked example
A shop receives stock worth ₦180,000 from a wholesaler with an agreed due date. It pays ₦100,000 by transfer and confirms that the money left its bank account. The tracker should show ₦180,000 billed, ₦100,000 paid and ₦80,000 remaining. The bank statement or payment confirmation should match the recorded transfer. A screenshot of an initiated transfer may not prove that the supplier received the funds.
If the shop pays the remaining ₦80,000 later, add a second payment event with its own date and reference. Do not replace the first payment with ₦180,000 or create a second purchase just to record the balance payment.
Avoid mixing purchase, expense and cash movement
A purchase of goods for resale and an operating expense such as rent are not necessarily classified the same way in formal accounts. Keep the supplier's description and supporting document, and let your accounting process assign the proper treatment. A bank transfer to a supplier is a movement of money; it should not be mistaken for a customer sale.
Review the tracker weekly. Sort by due date, contact the supplier when a bill or quantity is unclear and check your available cash before promising a payment date. For daily inflows and outflows, use the cashbook template. For how stock counts relate to records, see how to investigate stock differences.
ReceiptPro helps businesses organise customer invoices, sales and receipts. Use a supplier ledger or accounting tool if you need supplier bill approvals, allocated part-payments or formal accounts payable reports.