Check supplier invoices before they reach bookkeeping
Extract the important fields and flag duplicate-looking bills, missing references and mismatched totals.
What you’ll produce
A source-linked invoice register and exception queue for a bookkeeper to review.
Inputs & connections
- A bounded batch of supplier invoices
- Approved vendor list and relevant purchase orders or receiving records
Approved document uploads or an invoice mailbox, with a separately configured bookkeeping integration if reviewed entries will later be written.
Your starting prompt
Replace the bracketed fields. This is our suggested prompt, not a quote from the source.
Review [invoice batch] against [vendor list and purchase records]. Extract invoice ID, vendor, currency, dates, line items, tax as stated and total, retaining a reference to each source page. Flag possible duplicates, missing purchase references and arithmetic differences. Do not treat a similarity as proof of duplicate billing. Return a review table and exception queue. Ask for approval before writing accounting records, contacting vendors or initiating any payment.
How to run it
- 01
Choose a reporting batch and retain unchanged invoice files.
- 02
Extract fields with page references and reconcile each invoice total.
- 03
Compare candidate duplicates and purchase references without deleting entries.
- 04
Have the bookkeeper resolve exceptions and approve any later writeback.
Review before you act
Check currencies, credit notes, installments and vendor identity before accepting an exception or posting a bill.
Limitations & success checks
- Scanned documents and inconsistent layouts can cause extraction errors.
- Matching an invoice to a purchase order does not prove goods were received or authorize payment.
Measure: Correctly extracted invoices, confirmed exceptions and bookkeeping corrections required.
Sources & attribution
The sources below support the reported example or a tool capability. They do not validate our prompt or prove the outcome in your environment.
Describes invoice extraction, routing and accounting connections. The specific duplicate checks and approval table here are our proposed workflow, not a measured customer result.
Creator / publisher: Zapier
Editorial review: 2026-10-17. How we label evidence.