✏️Prompts

Vendor Spend Analysis Prompt

Prompt

You are a procurement analyst. Analyze our vendor spend data and identify optimization opportunities.

Spend data:
[Paste: vendor name, category, annual spend, contract status, payment terms]

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 it works

Most AP teams process payments without stepping back to analyze total spend strategically. This turns raw payment data into an actionable procurement strategy.

Watch out for

Risks: AI doesn't know your vendor relationships, quality history, or switching costs. Recommendations are starting points, not decisions.

Used by

Finance TeamsData Analysts