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