invoice-po-reconciliation
Skill142 starsChanged 3 months agoMITView on GitHub
Reconciles one or more user-selected invoice files against 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. Trigger phrases: po reconciliation, invoice reconciliation, invoice to po reconciliation, reconcile invoice, reconcile po, match invoice to po, invoice po match, po match, check invoice against po.
In this repository61 other files it gives its agents.
- analyze-document-librarySkill
- broken-link-auditorSkill
- build-sharepoint-business-solutionSkill
- campaign-storySkill
- convert-cowork-skill-to-sharepointSkill
- copilot-toolboxSkill
- custom-image-taggerSkill
- decision-register-builderSkill
- document-browserSkill
- dossierSkill
- exec-reportSkill
- file-classifierSkill
- find-relevant-skillSkill
- flashcards-dashboardSkill
- generate-site-onboarding-guideSkill
- generate-test-contentSkill
- guest-access-reviewerSkill
- intranet-page-lifecycle-reviewSkill
- kb-ai-review-liteSkill
- knowledge-readiness-advisorSkill
- learning-designerSkill
- library-cleanupSkill
- list-stylingSkill
- metadata-completeness-auditorSkill
- narrated-story-animationSkill
- news-governance-reviewSkill
- organize-librarySkill
- permission-reportSkill
- project-health-checkSkill
- project-intelligence-change-event-extractionSkill
- project-intelligence-root-cause-analysisSkill
- project-intelligence-timeline-dashboardSkill
- rename-files-date-prefixSkill
- resume-screening-summarizerSkill
- review-councilSkill
- rfp-response-compliance-reviewSkill
- rfp-response-content-finderSkill
- rfp-response-content-generationSkill
- rfp-response-extractionSkill
- rfp-response-proposal-reviewSkill
- rfp-response-quality-tone-reviewSkill
- rfp-response-strategy-synthesisSkill
- roadmap-timelineSkill
- scorecard-matrixSkill
- sharepoint-safe-htmlSkill
- site-pages-content-calendarSkill
- site-storage-heatmapSkill
- style-bentoSkill
- style-blueprintSkill
- style-figma-cleanSkill
- style-glassmorphismSkill
- style-high-contrastSkill
- style-monochromeSkill
- style-neobrutalismSkill
- style-pastelSkill
- style-retroSkill
- style-terminalSkill
- sync-blocker-auditorSkill
- team-newsletter-publisherSkill
- topic-explainerSkill
- The first 60 shown.
The file
Show its rules and text
We split this skill into the rules it gives an agent
18 rules. About 0 are common, 11 are distinctive, and 7 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈11
Distinctive · estimate
This author's own choices. Worth a look.
7
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Distinctive: line 25
If no files are selected, ask the user to select the invoice file(s) they want to reconcile.
- Very specific: line 30
Use cat_file or list_items (with field projection) to read the selected invoice file's metadata columns.
- Distinctive: line 35
If the library has metadata columns populated, extract the values directly.
- Very specific: line 37
If metadata columns are missing or empty, read the file content with cat_file and extract Invoice Number, Invoice Total, and PO Number from …
- Distinctive: line 40
Search the Purchase Order library (also try "Purchase Orders" or "PO" if not found) for a record whose PO Number column matches the PO …
- Very specific: line 42
Primary method: Use list_items with a filter on the PO Number column.
- Very specific: line 43
Fallback method: If the library doesn't have a clear PO Number column or the filter returns no results, use find_items or semantic_search …
- Distinctive: line 45
If no matching PO is found, report the invoice as Unable to Reconcile — No matching PO found and move to the next invoice.
- Very specific: line 52
If PO Total is not available in metadata, read the PO file content with cat_file to extract the total.
- Distinctive: line 60
If Invoice Total > PO Total → Non Compliant (overage = Invoice Total − PO Total)
- Distinctive: line 61
If Invoice Total ≤ PO Total → Compliant (remaining budget = PO Total − Invoice Total)
- Very specific: line 64
Use update_list_items_v2 to write the following columns on the invoice item.
- Distinctive: line 72
After processing all invoices, return a single formatted Markdown table:
- Distinctive: line 80
Use these status indicators:
- Distinctive: line 101
Never fabricate invoice or PO data.
- Very specific: line 102
If a column name doesn't match exactly (e.g., "Amount" vs "Invoice Total"), adapt by inspecting the list schema with get_list_schema first.
- Distinctive: line 103
If the Purchase Order library can't be found on the site, ask the user which library contains the POs.
- Distinctive: line 104
If write-back columns (Reconciliation Status, Reconciliation Details) don't exist on the invoice library, inform the user and offer to …
≈ “Common” is an estimate: at least 1 in 5 of the 372,429 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
Invoice vs. Purchase Order Reconciliation
Purpose
Reconcile one or more user-selected invoice files against their corresponding purchase orders (POs). Determine compliance by comparing totals, write results back to invoice metadata, and return a clear summary.
Trigger Phrases
Activate this skill when the user says any of the following (or close variations):
- "po reconciliation"
- "invoice reconciliation"
- "reconcile invoice"
- "invoice to po reconciliation"
- "reconcile po"
- "match invoice to po"
- "invoice po match"
- "check invoice against po"
- "po match"
- "compare invoice to po"
Prerequisites
- The user must have one or more invoice files selected in a document library.
- If no files are selected, ask the user to select the invoice file(s) they want to reconcile.
Steps (repeat for each selected invoice)
Step 1 — Read Invoice Metadata
Use cat_file or list_items (with field projection) to read the selected invoice file's metadata columns. Look for:
- Invoice Number
- Invoice Total (or Amount, Total, Invoice Amount — adapt to actual column name)
- PO Number (or Purchase Order Number, Referenced PO — adapt to actual column name)
If the library has metadata columns populated, extract the values directly.
If metadata columns are missing or empty, read the file content with cat_file and extract Invoice Number, Invoice Total, and PO Number from the document body.
Step 2 — Find the Matching Purchase Order
Search the Purchase Order library (also try "Purchase Orders" or "PO" if not found) for a record whose PO Number column matches the PO Number extracted from the invoice.
- Primary method: Use
list_itemswith a filter on the PO Number column. - Fallback method: If the library doesn't have a clear PO Number column or the filter returns no results, use
find_itemsorsemantic_searchto locate the PO by PO number.
If no matching PO is found, report the invoice as Unable to Reconcile — No matching PO found and move to the next invoice.
Step 3 — Extract PO Details
From the matching PO record, extract:
- PO Number
- PO Total (or PO Amount, Total, Order Total — adapt to actual column name)
If PO Total is not available in metadata, read the PO file content with cat_file to extract the total.
Step 4 — Reconcile
Perform two checks:
- PO Number Match: Confirm the PO Number from the invoice exactly matches the PO Number on the PO record. Any mismatch (e.g., trailing characters, prefix differences) = Discrepancy.
- Total Comparison:
- If Invoice Total > PO Total → Non Compliant (overage = Invoice Total − PO Total)
- If Invoice Total ≤ PO Total → Compliant (remaining budget = PO Total − Invoice Total)
Step 5 — Write Back to Invoice Metadata
Use update_list_items_v2 to write the following columns on the invoice item. If the columns don't exist yet, note that to the user and skip the write-back.
| Column | Value |
| Reconciliation Status | Compliant or Non Compliant |
| Reconciliation Details | Plain-English summary, e.g., "Invoice #1042 ($4,800.00) matched to PO #PO-1042 ($5,000.00). Invoice is within PO budget. Remaining: $200.00." or "Invoice #1043 ($6,200.00) exceeds PO #PO-1043 ($5,000.00) by $1,200.00." |
Step 6 — Return Summary to User
After processing all invoices, return a single formatted Markdown table:
| Invoice # | Invoice Total | PO # | PO Total | Status | Details |
| 1042 | $4,800.00 | PO-1042 | $5,000.00 | ✅ Compliant | Remaining budget: $200.00 |
| 1043 | $6,200.00 | PO-1043 | $5,000.00 | ⚠️ Non Compliant | Overage: $1,200.00 |
| 1044 | $3,500.00 | PO-9999 | — | ❌ No Match | No matching PO found |
Use these status indicators:
- ✅ Invoice is Compliant — Invoice total is at or below PO total. Show remaining budget.
- ⚠️ Discrepancy Found — Invoice total exceeds PO total. Show overage amount.
- ❌ Unable to Reconcile — No matching PO found or PO number mismatch.
Example
User: "Reconcile this invoice against its PO" (User has selected: Invoice-1042.pdf)
Agent response after processing:
I read Invoice-1042.pdf and found Invoice #1042 for $4,800.00 referencing PO-1042. I located PO-1042 in the Purchase Order library with a total of $5,000.00.
Invoice # Invoice Total PO # PO Total Status Details 1042 $4,800.00 PO-1042 $5,000.00 ✅ Compliant Remaining budget: $200.00 I updated the invoice metadata with Reconciliation Status = Compliant and the reconciliation details.
Constraints
- Never fabricate invoice or PO data. All values must come from actual file content or metadata.
- If a column name doesn't match exactly (e.g., "Amount" vs "Invoice Total"), adapt by inspecting the list schema with
get_list_schemafirst. - If the Purchase Order library can't be found on the site, ask the user which library contains the POs.
- If write-back columns (Reconciliation Status, Reconciliation Details) don't exist on the invoice library, inform the user and offer to create them.
- Format all currency values with two decimal places and a dollar sign.
- Process invoices in the order they were selected.
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

