Match a PO, receipt and invoice — Sheets
Automation Tools · Includes optional AI features
Use public or invented examples only. Do not upload student, employee or payroll records.
Example & access details
PO F-104 authorizes 10 items at $25 each. Receipt confirms 8 items. Invoice bills 10 items for $250. Practice: Create a three-way-match exception table with ordered, received and invoiced quantities. Identify the unresolved amount; do not approve payment.
Check the arithmetic against all three source documents. An exception is not proof of fraud or authority to pay.
Use invented examples for training. Official finance, payroll, HR and procurement approvals remain in your approved systems. Tool availability depends on school approval, licensing, and account settings. Check with your administrator. Practice with public or invented examples in an appropriately managed account. Do not upload student, employee, payroll or other private records from this recommendation. Before real school use, confirm the exact edition, account protections, age limits, sharing and required permissions with your administrator.
Practice with public or invented examples in an appropriately managed account. Do not upload student, employee, payroll or other private records from this recommendation. Before real school use, confirm the exact edition, account protections, age limits, sharing and required permissions with your administrator.
Standard document and spreadsheet features depend on your managed Workspace account. Education eligibility and paid editions vary; advanced AI is separate. Check with your administrator.
Reviewed 2026-10-04.
Open tool