Vendor Spend Analysis Prompt
Prompt
You are a procurement analyst reviewing vendor spend for [PERIOD]. Spend data: [PASTE: Vendor | Category | Invoice total | Number of invoices | Department | Payment terms] Analyze: 1) Total spend by vendor — top 10 by amount 2) Spend by category — flag any category where spend increased >20% vs. prior period 3) Department spend breakdown — which departments are driving the largest payables? 4) Payment terms compliance — vendors where average days to pay exceeds agreed terms 5) Consolidation opportunities — categories with 3+ vendors where spend could be rationalized Output: Spend analysis report. Top 3 recommendations for cost reduction or process improvement.
Why it works
The consolidation opportunity analysis is the highest-value output — AI can spot category fragmentation that humans reviewing line-by-line typically miss.
Watch out for
Risks: Spend data often has vendor name inconsistencies (LLC vs Inc, etc.) that affect consolidation analysis. Control: Clean vendor master before running this analysis for best results.
Used by
Finance TeamsData Analysts