Verifying supplier payment history is crucial for financial stability, risk management, and maintaining strong supplier relationships. Here's a step-by-step guide covering internal and external methods:
- Review Your Records:
- Accounts Payable (AP) Ledger: Access your ERP system (e.g., SAP, Oracle, QuickBooks) to extract payment data for the supplier.
- Payment Reports: Generate reports like:
- Aged Payable Reports (shows overdue payments).
- Payment Transaction Logs (dates, amounts, methods).
- Dispute Records (track unresolved issues).
- Bank Statements: Cross-check cleared payments against supplier invoices.
- Check for Consistency:
- Payment Terms: Compare actual payment dates to agreed terms (e.g., Net 30). Frequent delays signal risk.
- Invoice Matching: Ensure payments align with approved invoices (no duplicates or unauthorized charges).
- Discount Utilization: Track if suppliers offered early-payment discounts (e.g., 2/10 Net 30) and if you used them.
External Verification
- Credit Reports:
- Use services like Dun & Bradstreet (D&B), Experian, or Equifax to access the supplier’s:
- Payment scores (e.g., PAYDEX®).
- Trade payment history (reported by other clients).
- Public records (liens, bankruptcies).
- Use services like Dun & Bradstreet (D&B), Experian, or Equifax to access the supplier’s:
- Trade References:
- Ask the supplier for 2–3 client references. Contact them to ask:
- "How has [Supplier] performed on payments?"
- "Any late payments or disputes?"
- Tip: Request references from non-competing industries.
- Ask the supplier for 2–3 client references. Contact them to ask:
- Supplier Self-Reporting:
- Ask the supplier to provide a payment history certificate (signed by their CFO). Verify with their bank if needed.
Analyze for Red Flags
- Late Payments: Consistent delays may indicate cash flow issues or dissatisfaction with your service.
- Disputes: Frequent invoice disagreements suggest poor communication or quality issues.
- Over/Underpayments: Repeated errors could signal accounting errors or fraud.
- Sudden Changes: Abrupt shifts in payment behavior (e.g., from on-time to delayed) may signal financial distress.
Leverage Technology
- AP Automation Tools: Use platforms like Coupa, Tipalti, or AppZen to:
- Track payment cycles in real-time.
- Flag anomalies (e.g., duplicate payments).
- Data Analytics: Use BI tools (e.g., Tableau, Power BI) to visualize payment trends and predict risks.
On-Site or Virtual Audit
- For high-risk/suppliers, conduct an audit:
- Review their accounts receivable ledger for your transactions.
- Confirm bank statements match their records.
Legal & Compliance Checks
- Contract Review: Ensure payment terms align with agreements.
- Anti-Bribery Checks: Verify payments aren’t linked to corruption (e.g., via the FCPA database).
Key Metrics to Track
| Metric | Formula | Healthy Range |
|---|---|---|
| Days Payable Outstanding (DPO) | (Avg. Payables / COGS) × 365 | Industry-specific |
| Payment Accuracy Rate | (Correct Payments / Total Payments) × 100 | >98% |
| Dispute Resolution Time | Avg. days to resolve disputes | <30 days |
Best Practices
- Regular Reviews: Quarterly audits for key suppliers.
- Supplier Scorecards: Include payment history in performance evaluations.
- Transparency: Share payment data with suppliers to build trust.
- Document Everything: Maintain records for audits/disputes.
Example Workflow
- Extract 12 months of payment data from your ERP.
- Cross-check with bank statements.
- Pull a D&B report for external validation.
- Contact 2 trade references.
- Flag any discrepancies for investigation.
By combining internal records with external validation, you’ll gain a clear, reliable view of supplier payment behavior—enabling better risk management and negotiation power.
Request an On-site Audit / Inquiry