✏️Prompts

Purchase Order Variance Report Prompt

Prompt

You are a procurement analyst. Analyze purchase order variances for this period.

PO data:
[Paste: PO number, vendor, original PO amount, final invoiced amount, variance, category]

Analyze:
1) Total PO variance (% of total PO spend that came in over/under)
2) Top 10 variances by $ amount — what happened?
3) Variance by category (which spend categories have the most overruns?)
4) Variance by vendor (which vendors consistently exceed PO amounts?)
5) Change order analysis (how many POs required modifications?)
6) Maverick spend (invoices received without a PO)

Recommendations:
- Vendors that need better SOWs or fixed-price contracts
- Categories that need tighter PO controls
- Process improvements to reduce variance frequency

Format: Executive summary (1 paragraph) + detailed analysis table.

Why it works

PO variance analysis reveals procurement process weaknesses. AI identifies patterns across hundreds of POs; you focus on the structural fixes.

Watch out for

Risks: Not all PO variances are bad — some reflect legitimate scope changes. Context matters. Control: Procurement and Finance jointly review and set variance tolerance policies.

Used by

Data AnalystsFinance Teams