| Customer | Invoice # | Amount Due | Paid Amount | Payment Status | Due Date | Days Delayed | Follow-up Required | Customer Rating | Last Contact |
|---|---|---|---|---|---|---|---|---|---|
| ABC Corporation | INV-1001 | $5,000.00 | $5,000.00 | Paid | 2023-11-01 | 0 | None | Good | 2023-11-01 |
| XYZ Ltd. | INV-1002 | $8,000.00 | $4,000.00 | Partial | 2023-11-05 | 15 | Send 2nd reminder | Caution | 2023-11-10 |
| Tech Solutions | INV-1003 | $12,000.00 | $0.00 | Overdue | 2023-10-15 | 45 | Legal action required | Avoid | 2023-10-20 |
| Global Services | INV-1004 | $6,500.00 | $3,250.00 | Partial | 2023-11-10 | 5 | Payment plan agreed | Good | 2023-11-12 |
| Innovate Tech | INV-1005 | $9,800.00 | $0.00 | Overdue | 2023-11-01 | 10 | Send first reminder | New | - |
Good - Timely payments, reliable customer
Caution - Occasional delays, needs monitoring
Avoid - Chronic late payer, consider credit hold
Paid - Full payment received
Partial - Partial payment received
Overdue - Payment past due date