SharedSamples.org
SharePoint Skill

Invoice to Purchase Order Reconciliation

Reconciles one or more user-selected invoice files against their matching purchase orders in the Purchase Order library. Compares totals, flags discrepancies, writes reconciliation status back to invoice metadata, and returns a formatted summary table.

Invoice to Purchase Order Reconciliation

About this sample

Automates the procure-to-pay reconciliation step that teams normally do by hand or with custom Power Automate flows. For each selected invoice, the skill reads the invoice metadata (or extracts it from the file content), locates the matching PO in the Purchase Order library by PO Number, and compares totals to determine whether the invoice is Compliant or Non Compliant.

Writes Reconciliation Status and Reconciliation Details back to the invoice item, then returns a Markdown summary table showing Invoice #, Invoice Total, PO #, PO Total, Status (Compliant / Non Compliant / No Match), and the remaining budget or overage amount. Trigger phrases include 'reconcile invoice', 'invoice to po reconciliation', 'match invoice to po', and 'check invoice against po'.

Products & metadata

SharePointMicrosoft 365 CopilotSharePoint-AI-SkillDocument Management