Vendor statement vs our ledger: reconciliation in Excel, and by an AI agent

Short answer: To reconcile a vendor statement with your ledger, match the two by invoice number in both directions, list what each side is missing, compare amounts on the bills that match, and turn the differences into a reconciliation that takes your balance to theirs. An AI agent can do the matching and draft the reply to the vendor for you to check.

Vendor reconciliations come round every quarter, before audits and whenever a supplier chases a payment. The method is simple; doing it for twenty vendors is not.

This post takes the vendor reconciliation from a recent Excel tutorial, then gives the same job to an AI agent.

The tutorial this is based on

Top 5 Reconciliation Hacks in Excel | AI + Manual by Accounts Expert, published 19 September 2026 (in Hindi). This post follows Hack 2, the vendor statement against the books. The presenter also reminds viewers to check AI output and keep sensitive data out of public tools.

How do you reconcile a vendor statement with your ledger in Excel?

  1. Put the vendor's statement and your ledger on two sheets, with the invoice number as the key.
  2. Use XLOOKUP (or VLOOKUP) to bring the vendor's amount into your sheet against each invoice. Lock the ranges with F4.
  3. Run the same lookup the other way, from the vendor's sheet into yours, to find what each side is missing.
  4. Show "Record not found" instead of #N/A, using XLOOKUP's if-not-found argument or IFNA.
  5. Add a difference column for invoices on both sides with different amounts.
  6. Turn the differences into a reconciliation statement that starts from your balance and ends at theirs.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent our ledger for a supplier and the supplier's own statement, from April to October, for a made-up garment maker, Bhavani Garments, and its yarn supplier. The two balances were ₹5,16,680 apart. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackBhavani Garments: reconcile Sri Murugan Yarn Traders' statement with our ledger to 31 October. Both files are attached. Explain the difference and draft a reply to the vendor listing what we need from them. Don't send anything.
Slack request to reconcile a vendor statement with our ledger, with both files attached, and the agent's reconciliation from our balance to the vendor's
The request and the reconciliation from our balance to the vendor's.

What the agent did

  1. Matched the two files by invoice number, in both directions.
  2. Listed what is only in the vendor's statement, what is only in our books, and amounts that differ.
  3. Spotted that the vendor has entered one invoice twice.
  4. Built the reconciliation from our balance to the vendor's balance, with no difference left, and saved it as an Excel workbook.
  5. Drafted a reply to the vendor, and did not send it.
The agent's draft email to the vendor listing the bill to send, the payment in transit, the debit note to book and the duplicate invoice
The reply the agent drafted for the vendor. It is not sent until you say so.

What it found

What explained the ₹5,16,680 gap
ItemAmount (₹)SideAction
Bill SMY/26-27/361 not in our books1,42,300.00Vendor onlyGet the bill, LR and delivery proof
Our payment of 31 October not in their statement2,00,000.00Ours onlyGive the UTR, ask them to credit it
Our debit note for rejected yarn not booked by them18,880.00Ours onlyAsk them to book it
Bill SMY/26-27/321: 2,49,210 vs 2,48,0101,200.00BothAsk for a copy of the bill
Bill SMY/26-27/342 entered twice by the vendor1,54,300.00Vendor onlyAsk them to reverse it

What you still check

Questions accountants ask

Should I use XLOOKUP or VLOOKUP?

XLOOKUP is easier: it looks in any direction and has a built-in "not found" value. VLOOKUP works too, with IFNA around it.

Can the agent do all my vendors at once?

Yes. Put each vendor's statement and ledger in a folder and it works through them one by one, with one reconciliation and one draft reply per vendor.

Will it email the vendor?

Only after you approve the exact text. It drafts the reply and asks before it sends anything.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo