Check supplier invoices against purchase orders
Each invoice matched to its PO and delivery note, with price, quantity and duplicate problems marked.
- You start it: When you start it
What it does
The task
Read the supplier invoices and the delivery notes in the Google Drive folder folder. Match each invoice to its purchase order in the Google Sheet po sheet by the PO number. Compare the items, the quantities, the unit prices and the total, and compare the quantities with the delivery notes. Check Xero for an earlier bill with the same invoice number, or with the same amount from the same supplier. Write a table with the invoice, the PO, the result and each difference. Do not approve or pay anything.
- It works in Google Drive, Google Sheets and Xero, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- It runs once, when you start it.
What you give it
| Blank | What to give | Example |
|---|---|---|
| folder | The Google Drive folder with invoices and delivery notes | Finance/AP/2026-10 |
| po sheet | The Google Sheet with your purchase orders | https://docs.google.com/spreadsheets/d/1PurchaseOrders |
What you get back
An example run with the example values above. Your run uses your own data.
14 invoices checked: 10 match, 4 need a look
| Invoice | PO | Result |
|---|---|---|
| NF-2291, Northport Freight | PO-2198 | Price: 4,200.00 EUR, the PO says 3,900.00 EUR |
| SS-1102, Sparkline Services | PO-2215 | Quantity: 14 cleanings billed, 12 on the delivery notes |
| TB-7731, Talkbox Phones | none | No PO number on the invoice |
| CB-55120, Cloudbase Hosting | PO-2203 | Possible duplicate: same amount as bill CB-55098 in Xero |
| PW-0473, Printwell | PO-2210 | Match |
... 9 more matches
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 2 blanks
Type folder and po sheet. Tab moves to the next blank.
- 03
Run it
Run sends it to the agent. Follow each step in the panel, and stop it at any time.
From the terminal
cuiar exec "Read the supplier invoices and the delivery notes in the Google Drive folder Finance/AP/2026-10. Match each invoice to its purchase order in the Google Sheet https://docs.google.com/spreadsheets/d/1PurchaseOrders by the PO number. Compare the items, the quantities, the unit prices and the total, and compare the quantities with the delivery notes. Check Xero for an earlier bill with the same invoice number, or with the same amount from the same supplier. Write a table with the invoice, the PO, the result and each difference. Do not approve or pay anything."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool run_task to run my "Check supplier invoices against purchase orders" template with folder = Finance/AP/2026-10; po sheet = https://docs.google.com/spreadsheets/d/1PurchaseOrders.Setup for other agents: AI agents.
The tool call
{
"name": "run_task",
"arguments": {
"task": "Read the supplier invoices and the delivery notes in the Google Drive folder Finance/AP/2026-10. Match each invoice to its purchase order in the Google Sheet https://docs.google.com/spreadsheets/d/1PurchaseOrders by the PO number. Compare the items, the quantities, the unit prices and the total, and compare the quantities with the delivery notes. Check Xero for an earlier bill with the same invoice number, or with the same amount from the same supplier. Write a table with the invoice, the PO, the result and each difference. Do not approve or pay anything."
}
}Related templates
All finance templatesFinance
Find card payments that have no receipt
Each card payment matched to a receipt from your inbox or folder, with the missing ones listed first.
You start it: When you start it- Any bank site
- Gmail
- Google Drive
- +1 more: Google Sheets
Finance
Prepare the figures for your VAT return
Sales and input VAT by rate for the period, checked against your sales platforms, with the box values.
You start it: When you start it- Xero
- Shopify
- Stripe
- +1 more: Google Sheets
Finance
Build a 13-week cash flow forecast
Weekly cash in and out from your bank, open invoices and bills, with the weeks below your minimum marked.
You start it: When you start it- Any bank site
- Xero
- Google Sheets
FinanceAsks first
Create client invoices from your tracked hours
One draft invoice per client from your hours sheet, with rates and dates, sent after you approve it.
On a schedule: On the 1st of each month at 10:00- Google Sheets
- Xero
Finance
Compare your budget with actual spending
Budget against actual for each account, the largest differences first, with the transactions behind them.
On a schedule: On the 5th of each month at 9:00- Xero
- Google Sheets
Sales
Answer an RFP or a security questionnaire
A draft answer for each question from your own documents, with the source and the gaps marked.
You start it: When you start it- Google Sheets
- Confluence
- Google Drive