Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for bookkeepers

Vendor Statement Reconciliation Agent

A reconciled vendor statement with every difference explained

Vendor Statement Reconciliation Agent: what goes in, what the agent does and what you get

What it does

Vendors send monthly statements listing what they think is owed, and the gaps between their view and the ledger often hide lost invoices or missed credits. This agent compares each statement to the vendor ledger. It reads statement lines into a table and matches invoices, credits and payments by number, amount and date. For anything left over it looks deeper: a payment in transit, an invoice never received, a credit not applied, or a typo in the invoice number. After each explained item it re-runs the match and lists what is truly missing. It drafts a request for missing invoice copies and a note on payments the vendor has not applied. It never enters an invoice from the statement alone. The specialist approves every message and any ledger change. Edge case: a vendor lists one invoice twice with different numbers, so the agent checks amounts and dates before asking.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueApprovedNo 1 STARTS WHEN Vendor statement received 2 USES A TOOL Read statement lines into a table 3 USES A TOOL Pull vendor ledger and payments for the period 4 DOES Match items by number, amount and date 5 CHECKS THE RESULT Are all differences explained? If not: try fuzzy matches on numbers and look forpayments in transit. Back to step 4. 6 DOES Draft requests for missing invoices and unappliedpayments 7 YOU APPROVE Specialist approves messages and any ledger fixes 8 RESULT Reconciliation sheet filed with the vendor record
Read the steps as a list
  1. Vendor statement received
  2. Read statement lines into a table
  3. Pull vendor ledger and payments for the period
  4. Match items by number, amount and date
  5. Are all differences explained?If not: try fuzzy matches on numbers and look for payments in transit. Back to step 4.
  6. Draft requests for missing invoices and unapplied payments
  7. Specialist approves messages and any ledger fixesThe agent waits here for your OK.
  8. Reconciliation sheet filed with the vendor record

How it decides

It matches items by invoice number first, then by amount and date within a few days. Leftover items are sorted into in transit, missing invoice, unapplied credit or unknown.

  • Payment sent within the last 5 days: mark as in transit
  • Invoice on statement but not in ledger: request a copy, do not enter from the statement
  • Credit on statement not applied: flag for review

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Vendors to reconcile monthly
  • Days counted as in transit (default 5)
  • Matching strictness for invoice numbers
  • Output format for the reconciliation sheet

What keeps you in control

It always asks you first

  • Entering any invoice or credit
  • Sending messages to vendors

Hard limits

  • Never enters invoices from a statement alone
  • Never contacts a vendor without approval

It stops when

  • Done: statement and ledger agree or every difference is listed
  • Stop: statement period does not match available ledger data

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensThe April statement from a packaging supplier showed $18,420 owed against $14,900 in the ledger. The first match left $3,520 unexplained. The agent found a $2,100 payment sent April 28, marked it in transit, and re-ran the match. The remaining $1,420 was an invoice the team never received. The specialist approved a request for a copy, and the reconciliation sheet closed with nothing unexplained.

More agents for bookkeepers