Skip to main content

Purchase Overdue

📄 Purchase Overdue Report​

The Purchase Overdue Report tracks supplier invoices and purchase orders whose payment or delivery deadlines have passed. It helps the procurement and accounts payable teams identify overdue obligations, follow up with suppliers, and manage overdue liabilities effectively.

This report is essential for cash flow control, supplier relationship management, and compliance with procurement agreements.

🎯 Purpose of the Report​

  • Identify supplier invoices with overdue payments.

  • Highlight purchase orders where delivery deadlines have passed.

  • Enable timely follow-up with vendors to avoid supply chain disruptions.

  • Assist in prioritizing payments to avoid penalties or strained vendor relations.

📌 Key Data Fields​

FieldDescription
Document TypePurchase Invoice or Purchase Order.
Document NumberUnique identifier for the invoice or order.
Document DateOriginal date of the invoice or PO.
Vendor NameSupplier’s name.
Reference NumberPO number for invoices or related contract reference.
Item Code / NameProduct or service overdue.
QuantityQuantity overdue for delivery or payment.
Total AmountValue of the overdue invoice/order.
Due DateAgreed payment or delivery deadline.
Days OverdueNumber of days past the due date.
StatusPending Delivery, Pending Payment, Partially Delivered, Partially Paid.
Remarks / NotesFollow-up comments or escalation details.

🔍 Filter & Search Options​

  • Overdue type (payment or delivery).

  • Date range for due dates.

  • Vendor name.

  • Document type (Invoice / PO).

  • Overdue days range (e.g., 1–30, 31–60, 60+).

  • Purchase category or department.

📊 Insights Provided​

  • Total value of overdue supplier payments.

  • List of suppliers with the highest overdue amounts.

  • Aging analysis of overdue purchase obligations.

  • Impact on cash flow and procurement timelines.

  • Supplier performance in meeting delivery timelines.

📤 Export & Integration​

  • Exportable to Excel, PDF, or CSV.

  • Integrated with Accounts Payable to manage overdue payments.

  • Linked with Purchase Orders for overdue delivery tracking.

  • Can trigger automated notifications to procurement teams.

✅ Benefits​

  • Improves payment discipline and vendor trust.

  • Reduces the risk of supply chain delays.

  • Helps avoid late payment penalties.

  • Provides actionable insights for vendor negotiations.

📈 Example Layout​

Document TypeDoc No.Vendor NameDue DateDays OverdueAmountStatusRemarks
Purchase Inv.PINV-1025ABC Traders01-08-2025101,200.00Pending PaymentPayment scheduled 12th
Purchase OrderPO-1087XYZ Supplies30-07-202512800.00Pending DeliveryVendor follow-up sent