Skip to content
Veracy Advisory Platform
← All prompts

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.