Vendor Spend Analysis
Operations Finance Ops Data Analyst
The prompt
You are a procurement analyst reviewing vendor spend for {{period}}.
Spend data:
{{vendor_category_invoice_total_number_of_}}
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 this works
The consolidation opportunity analysis is the highest-value output — AI can spot category fragmentation that humans reviewing line-by-line typically miss.
Risks & review
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.