AI and MCP

Using AI to find unusual transactions in client statements

A practical method for accountants to let AI find unusual transactions in client statements, from duplicates to split payments, with a clear trail for your files.

Editorial illustration for Using AI to find unusual transactions in client statements

For an accountant, the value of an AI assistant on a statement is a faster first pass: it lists duplicates, round-sum payments, split payments and oddities that you then examine against vouchers and the client's explanation. It does not replace testing, and its output is not evidence. Use it to decide where to look, and record what you looked at and what you concluded.

Check permission and scope first

Client statements are the client's data. Check your engagement terms and the client's consent before putting them into any assistant, and use the narrowest access available. SpendixAI lets you choose a scope when connecting Claude or ChatGPT through MCP, lets you start read-only, and lets you disconnect at any time. Pro covers one personal workspace, so it does not give you a shared multi-client environment; each client's records stay in their own workspace.

Patterns worth listing

  • Same amount, same party, within two days. The app's Possible duplicate charges report does exactly this without AI.
  • One payment split into several smaller ones to the same party on the same day.
  • Round-sum transfers with no matching invoice.
  • Weekend or holiday postings that the client does not usually make.
  • Cash withdrawals that never appear against any expense.
  • Payments to a party not in the client's vendor list.

Run the rule-based report first, then ask the assistant for the rest.

A worked example

Say a client's October statement contains these entries (invented).

DatePartyAmountObservation
4 OctPackaging vendor₹42,500First payment
5 OctPackaging vendor₹42,500Same amount next day
11 OctTransporter₹9,000Part of a split
11 OctTransporter₹9,000Part of a split
11 OctTransporter₹9,000Part of a split

The first pair needs the vendor's ledger and the invoices. If only one invoice of ₹42,500 exists, the second payment is an advance or a duplicate; if the vendor confirms a duplicate, ₹42,500 should be recovered or adjusted. The three transporter payments total ₹27,000 (₹9,000 times three). Whether that is three trips or one invoice paid in parts is a question for the client, not for the assistant.

What the assistant gives you and what you must add

  1. It gives you the list. You add the voucher reference for each item.
  2. It gives you a pattern. You add the client's explanation.
  3. It gives you an amount. You add the ledger effect and the adjustment, if any.
  4. It gives you nothing about intent. Do not infer it.

Limits you should say out loud

The assistant reads only what is in the workspace: uploaded statements and typed entries. If a statement was incomplete or a file failed to import (the import history will show failures), your population is incomplete. Reconcile opening and closing balances before you say anything about completeness. Also remember that unusual is not the same as wrong, and that categorisation and GST figures in reports are estimates to confirm against invoices.

How far down the list do you go?

Once you have the flagged list, decide how far to go. A list of eight items can be cleared one by one. A list of two hundred needs sorting by amount, so you chase the largest first and sample the rest. Say the flagged items total ₹3,10,000 and the top five make up ₹2,45,000. By looking at five items you have covered about 79 percent of the value (245,000 divided by 310,000). Record the basis on which you stopped. If anything suggests deliberate concealment, that is a professional matter to handle under your own standards, not something to settle in a chat.

Closing the loop

  1. Reconcile the statement's closing balance first.
  2. Run the duplicate report and the assistant query.
  3. Obtain explanations and documents for each flagged item.
  4. Record adjustments in the books, not in the assistant.
  5. Keep the working notes with the file.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports