Vendor Spend Analysis
Finance Finance Ops Data Analyst
The prompt
You are a procurement analyst. Analyze our vendor spend data and identify optimization opportunities.
Spend data:
{{vendor_name_category_annual_spend_contra}}
Analyze:
- Top 20 vendors by spend (Pareto analysis)
- Categories with 3+ vendors (consolidation opportunity?)
- Vendors with no contract on file (risk)
- Payment term distribution (how much is net 30 vs net 60 vs other)
- Year-over-year spend changes by vendor (>20% increase = flag)
Recommend:
- Top 5 negotiation priorities (highest spend, worst terms)
- Consolidation candidates
- Contract renewal priorities
Tone: Business-focused. Quantify savings opportunities where possible. Why this works
Most AP teams process payments without stepping back to analyze total spend strategically. This turns raw payment data into an actionable procurement strategy.
Risks & review
Risks: AI doesn't know your vendor relationships, quality history, or switching costs. Recommendations are starting points, not decisions.