Skip to content

Bank transactions explained with receipts and VAT on approval

Once a week it finds bank transactions in your books that still need explaining, finds the matching receipt and works out the VAT. You approve each one before anything is written.

OperationsWorks with Claude Code · Claude Desktop with MCPCommunity example

What it does

  • Lists unexplained transactions and ones waiting in the approval queue
  • Finds the invoice or receipt in your inbox or files
  • Matches by billing period, not by amount alone
  • Reads the invoice to decide the VAT treatment
  • Shows one approval box per transaction with what it will write

Your approval boundaries

Approval required

These actions always wait for your yes:

  • Writing any explanation, category or VAT change to the books
  • Attaching a receipt to a transaction
  • Any change to a period already filed

You decide what happens next.

More about this workflow

This setup is for operators and managers who keep the busywork moving. It takes a repeat chore off your plate and hands back something you can check quickly.

First, it lists unexplained transactions and ones waiting in the approval queue. Next, it finds the invoice or receipt in your inbox or files. Then it matches by billing period, not by amount alone. After that, it reads the invoice to decide the VAT treatment. Finally, it shows one approval box per transaction with what it will write. It works with your accounting app, email and bank export, each on its own login with limited access.

You get the prep work done and waiting for you. The agent stops and asks for your yes before writing any explanation, category or VAT change to the books, attaching a receipt to a transaction and any change to a period already filed, and says plainly if a step cannot be undone.

“Nothing is ever written to your live books until you say so.”
dialog-sergio dialog-sergio on GitHub · Nov 2, 2026
Before you startAccounting app · Email accessScoped permissionsClaude Code or Claude Desktop with MCP
Explore required tools and model recommendations

Tools and access

  • QuickBooks

    Handles the accounting app part of this job. Grant accounting data, no payments.

    API required: Yes. Needs an Intuit developer app with OAuth.

  • Gmail

    Handles the email part of this job. Grant read-only plus compose (drafts) scopes.

    API required: Yes. Needs a Google Cloud project with an OAuth app and the Gmail API turned on. The agent signs in through OAuth with only the scopes you pick.

  • Bank export

    Handles the bank export part of this job. Grant a file you export, never your bank login.

    API required: No. A CSV export you download from your bank. No bank login for the agent.

    No sign-up needed

Official links only. Not sponsored, no affiliate links.

Model recommendations

Best pick

GPT-6.1 Sol

Cheap cached input suits jobs that rerun the same instructions each week.

$2 per million input tokens, $10 per million output tokens, for prompts up to 272K tokens. Longer prompts cost $4 in and $15 out.

OpenAI docs as of October 11, 2026

Cheaper backup

Gemini 3.5 Flash-Lite

Low cost for simple data pulls and matching.

$0.30 per million input tokens, $2.50 per million output tokens.

Google docs as of October 11, 2026

Our own picks. Not sponsored, no affiliate links.

Build your prompt

Add your details, then copy the prompt into your tool.

1Your details

Fill these in and the prompt updates as you type.

inbox, folder or both

your country and scheme

marker added to each entry it touches

2Your prompt

4 of 4 still empty
Fill these in before you run it: [ACCOUNTING APP] [WHERE YOUR RECEIPTS LIVE: inbox, folder or both] [VAT RULES: your country and scheme] [AUDIT TAG: marker added to each entry it touches] You are the Bank transactions explained with receipts and VAT on approval agent. Once a week it finds bank transactions in your books that still need explaining, finds the matching receipt and works out the VAT. You approve each one before anything is written. Use only the details filled in above. If any [BRACKETED] item is still blank or unclear, stop and ask for it first. Do not guess. What you do on your own: - Lists unexplained transactions and ones waiting in the approval queue - Finds the invoice or receipt in your inbox or files - Matches by billing period, not by amount alone - Reads the invoice to decide the VAT treatment - Shows one approval box per transaction with what it will write What you must never do without a yes from a person: - Writing any explanation, category or VAT change to the books - Attaching a receipt to a transaction - Any change to a period already filed Rules: - Before any step on the list above, stop and ask. Say in plain words what you want to do, who it affects, and whether it can be undone. - If something cannot be undone, say so first, in one short line. - Write drafts, not final actions. A person sends, pays, posts, or deletes. - Keep a short log of every action you took and every source you read. - If you are unsure, ask instead of guessing.
View run instructionsPaste into: Claude Code, Claude Desktop with MCP

Your answers stay in this browser only.

Run your workflow

Connect your tools with only the access this setup needs, then follow these steps.

Steps

Do these in order. Test on old data before it touches live work.

  1. 1Connect QuickBooks with its own login, not yours. Grant accounting data, no payments.
  2. 2Connect Gmail with its own login, not yours. Grant read-only plus compose (drafts) scopes.
  3. 3Set up Bank export. Keep it to a file you export, never your bank login.
  4. 4Paste the prompt where your harness takes instructions. See the note under the Copy button.
  5. 5Do a dry run on old or test data first. Check every draft and every stop point by hand before you let it near live work.
  6. 6Read its log after the first real run. Only widen access once a week of runs looks clean.

Safeguards and trust score

The score describes this example setup’s access, approval boundaries, ability to undo changes, and scope.

Access18 / 30

Can draft things that send or spend, so it sits close to risky actions.

Human approval30 / 30

Waits for a yes on: writing any explanation, category or vat change to the books, attaching a receipt to a transaction, any change to a period already filed.

Undo and logs14 / 20

Proposes changes to live records, so the setup needs a change log and a way back.

Scope16 / 20

Runs on its own login across 3 tools. Fewer connections means a smaller blast radius.

How to raise it

  • Access: Take away its ability to send, post or spend. Let it only write drafts, and have a person press send or pay from their own account +6
  • Undo and logs: Stop it from editing live records. Have it write the change as a proposal you apply, and keep a log of every change with a way to roll it back +3
  • Scope: Cut it down from 3 connected tools to the 2 it needs most, each with its own limited login instead of your full account +2

Do all of these to reach 89, up from 78.

Want help getting there? Get an AI Trust Audit from Pixeldesigns

Reviewed by Trustcase (example setup). How scoring works

Embed badge

Show this trust score on your site or README. It links back here.

Trustcase trust score badge
Markdown
[![Trustcase trust score for Bank transactions explained with receipts and VAT on approval](https://trustcase.dev/badge/bank-transactions-explained-with-receipts-and-vat-on-approval.svg)](https://trustcase.dev/use-cases/bank-transactions-explained-with-receipts-and-vat-on-approval)
HTML
<a href="https://trustcase.dev/use-cases/bank-transactions-explained-with-receipts-and-vat-on-approval"><img src="https://trustcase.dev/badge/bank-transactions-explained-with-receipts-and-vat-on-approval.svg" alt="Trustcase trust score for Bank transactions explained with receipts and VAT on approval" height="20"></a>

Other workflows that use the same tools

  • Bill and subscription audit

    Personal. Finds what you pay for every month and what you forgot about.

  • Private money check-in

    Personal. Looks over your spending once a month and sends the summary only to you. It is set up so your numbers can never land in a shared channel.

  • Account balance check against your bank export and email

    Personal. Ask how your accounts are and it reads your finance app's database read only, then checks the figures against your bank's own export and the bank emails in your inbox. Any fix goes through the app's own logic after a dry run, and you verify the result.