invoice-po-reconciliation

Reconciles invoice files against purchase orders in SharePoint libraries and writes status to metadata.

128|50|Updated May 4, 2026
One-click install
npx skills add https://github.com/pnp/sharepoint-skills --skill invoice-po-reconciliation-pnp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: invoice-po-reconciliation
Source: https://github.com/pnp/sharepoint-skills/tree/main/Skills/invoice-po-reconciliation/invoice-po-reconciliation
Command: npx skills add https://github.com/pnp/sharepoint-skills --skill invoice-po-reconciliation-pnp

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Manually comparing invoices against purchase orders is slow and error-prone, especially when totals and PO numbers must be checked one file at a time. This Skill automates the matching, comparison, and status write-back directly inside SharePoint. ## Core Features & Use Cases - Automated PO Matching: Locates the corresponding purchase order in the Purchase Order library using metadata filters or semantic search. - Compliance Comparison: Compares invoice totals against PO totals and classifies each invoice as Compliant, Non Compliant, or Unable to Reconcile. - Metadata Write-Back: Writes Reconciliation Status and Reconciliation Details columns back to the invoice item and returns a formatted Markdown summary table. - Use Case: A finance clerk selects five invoice PDFs in a document library and asks Copilot to reconcile them; the agent matches each to its PO, flags one overage of $1,200.00, and updates the invoice metadata automatically. ## Quick Start Select one or more invoice files in your SharePoint document library and ask Copilot to reconcile these invoices against their purchase orders.

Frequently Asked Questions about invoice-po-reconciliation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I reconcile invoices against purchase orders in SharePoint?▼

Select the invoice files in your SharePoint document library, then ask Copilot to reconcile them against their POs. The skill reads invoice metadata, finds the matching PO in the Purchase Order library, compares totals, and writes the reconciliation status back to the invoice item.

How does invoice to PO matching work in Copilot for SharePoint?▼

The skill extracts the PO Number from each invoice, then filters the Purchase Order library for a matching record using list_items, falling back to find_items or semantic search. It compares invoice total to PO total and reports Compliant, Non Compliant, or No Match.

What happens if no matching purchase order is found for an invoice?▼

The invoice is reported as Unable to Reconcile with a No matching PO found status in the summary table. Processing then continues with the next selected invoice rather than stopping the batch.

Does the skill work if invoice metadata columns are empty?▼

Yes. If metadata columns are missing or empty, the skill reads the invoice file content directly with cat_file and extracts the Invoice Number, Invoice Total, and PO Number from the document body.

Why did the reconciliation status not get written back to my invoice?▼

Write-back requires Reconciliation Status and Reconciliation Details columns on the invoice library. If they do not exist, the skill skips the update, informs you, and offers to create the columns.