Skip to content
Veracy Toolbox
← All prompts

Purchase Order Variance Report

Finance Data Analyst Finance Ops

The prompt

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

PO data:
{{po_number_vendor_original_po_amount_fina}}

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

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

Risks & review

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.