✏️Prompts

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