Duplicate Invoice Detection: Clean Keys, Running Counts & Near-Duplicates
This lesson is part of the course
In this lesson
You clean the invoice numbers of 14 Kestrel invoices, mark every repeat of an invoice already in the list, find near-duplicates with ROUND and LEFT and total the value to stop.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Invoice Register & AP Ageing: Due Dates, Days Past Due & Buckets Locked
- Three-Way Match with Price & Quantity Tolerances Locked
- Duplicate Invoice Detection: Clean Keys, Running Counts & Near-Duplicates Locked
- Early-Payment Discounts: 2/10 Net 30, Annualised Cost & Take or Skip Locked
- The Payment Run: Due-Date Window, Discounts, Holds & the Cash Limit Locked
- DPO & AP Turnover: How Long Kestrel Takes to Pay Locked
- Vendor Master Checks: Missing Tax IDs, Bank-Detail Changes & Shared Accounts Locked
- Month-End: Accruing Goods Received Not Invoiced (GRNI) Locked