Vendor Master Cleanup Prompt
Prompt
You are an AP supervisor reviewing the vendor master for data quality issues. Vendor master export: [PASTE: Vendor ID | Vendor name | Address | Tax ID | Bank account | Payment terms | Last invoice date | Status (active/inactive)] Flag: 1) Duplicate vendors — same name (including variations like "Inc" vs. "Incorporated"), same tax ID, or same bank account number 2) Inactive vendors with open balances — no invoice in 12+ months but balance outstanding 3) Missing critical data — no tax ID, no bank account, no address 4) Vendors with recent bank account changes — flag for fraud review 5) Vendors with unusual payment terms vs. your standard (net 30) Output: Cleanup priority list — High priority (fraud risk or compliance issue) / Medium (data quality) / Low (housekeeping). Include recommended action for each.
Why it works
Vendor master quality directly impacts 1099 compliance and payment fraud risk. Combining fraud signals (bank account changes) with compliance gaps (missing Tax IDs) in one prioritized list makes the cleanup actionable.
Watch out for
Risks: Fuzzy name matching will produce false positives for legitimately different entities. Control: AP manager confirms each proposed merge before any vendor records are combined.
Used by
Finance Teams