Skip to content

Account balance check against your bank export and email

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.

PersonalWorks with Claude Code · Claude Desktop with MCPCommunity example

What it does

  • Answers account questions from read only database queries
  • Cross checks balances against the bank export and bank emails
  • Flags known traps such as near duplicate transactions and early payments
  • Proposes a repair as a dry run through the app's own logic
  • Verifies the data after any fix

Your approval boundaries

Creates drafts

These actions always wait for your yes:

  • Applying any data repair

You decide what happens next.

More about this workflow

This setup is for busy people who want their own day to run a little smoother. It takes a repeat chore off your plate and hands back something you can check quickly.

First, it answers account questions from read only database queries. Next, it cross checks balances against the bank export and bank emails. Then it flags known traps such as near duplicate transactions and early payments. After that, it proposes a repair as a dry run through the app's own logic. Finally, it verifies the data after any fix. It works with your database, bank export and email, 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 applying any data repair, and says plainly if a step cannot be undone.

“repairs data only through the app's own logic”
Alejandro Martinez ingamartinez on GitHub · Oct 26, 2026
Before you startDatabase · Bank export accessScoped permissionsClaude Code or Claude Desktop with MCP
Explore required tools and model recommendations

Tools and access

  • Supabase

    Handles the database part of this job. Grant a role limited to one table.

    API required: Yes. Needs a Supabase project and an API key. Give the agent a role limited to one table.

  • 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
  • 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.

Official links only. Not sponsored, no affiliate links.

Model recommendations

Best pick

Claude Sonnet 5.5

Fast and careful with your inbox and calendar.

$2 per million input tokens, $10 per million output tokens.

Anthropic docs as of October 11, 2026

Cheaper backup

Claude Haiku 5.5

Cheapest Claude option for daily sorting.

From $0.10 per million input tokens and from $0.50 per million output tokens.

Anthropic 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.

read only login

csv

bank sender names

duplicates, grace windows

2Your prompt

4 of 4 still empty
Fill these in before you run it: [FINANCE APP DATABASE: read only login] [BANK EXPORT: csv] [EMAIL SEARCH TERMS: bank sender names] [KNOWN TRAPS: duplicates, grace windows] You are the Account balance check against your bank export and email agent. 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. 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: - Answers account questions from read only database queries - Cross checks balances against the bank export and bank emails - Flags known traps such as near duplicate transactions and early payments - Proposes a repair as a dry run through the app's own logic - Verifies the data after any fix What you must never do without a yes from a person: - Applying any data repair 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 Supabase with its own login, not yours. Grant a role limited to one table.
  2. 2Set up Bank export. Keep it to a file you export, never your bank login.
  3. 3Connect Gmail with its own login, not yours. Grant read-only plus compose (drafts) scopes.
  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.

Access24 / 30

Writes drafts and notes inside your tools, nothing leaves on its own.

Human approval27 / 30

Waits for a yes on: applying any data repair.

Undo and logs17 / 20

Leaves drafts you can throw away, with a record of what it made.

Scope16 / 20

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

How to raise it

  • Human approval: Add a second named stop next to "applying any data repair", so every step that leaves your hands waits for a yes, and have the confirm say plainly what cannot be undone +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 84.

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 Account balance check against your bank export and email](https://trustcase.dev/badge/account-balance-check-against-your-bank-export-and-email.svg)](https://trustcase.dev/use-cases/account-balance-check-against-your-bank-export-and-email)
HTML
<a href="https://trustcase.dev/use-cases/account-balance-check-against-your-bank-export-and-email"><img src="https://trustcase.dev/badge/account-balance-check-against-your-bank-export-and-email.svg" alt="Trustcase trust score for Account balance check against your bank export and email" height="20"></a>
  • Recruiter message triage with scored drafts

    Reads new recruiter messages, scores each role against the criteria you keep in one table, logs it and drafts a reply. Every send goes through one path that a hook forces to ask you first.

  • Purchase research checked on the product page

    Give it what you want to buy and a budget. It searches Amazon, eBay and AliExpress for your delivery region, opens each candidate's real product page to confirm price and shipping, and ranks by review count over star rating.

  • Thursday grocery flyer deals digest

    Ask what is cheap this week or which flyer has the ingredients for a dish, and it searches local store flyers by postal code. Save favourites and get a Thursday morning push with which of them are on sale.

  • Monday journal paper digest posted to your notes

    A weekend job queries a citation index for new papers from a set of journals on your topics and commits the candidate list. On Monday morning a cloud routine reads it, writes the digest and posts it as a page under your notes.

Other workflows that use the same tools

  • Weekly CRM health report

    Sales. Every Monday it checks the CRM for duplicates, missing fields and stuck deals, compares with last week and writes a short report. Numbers come from queries, not the model.

  • Closet inventory from purchase and sale emails

    Ecommerce and resale. A weekly run reads your inbox for purchase confirmations and resale item sold notices and drops them in a review tray. Nothing enters or leaves your closet inventory until you confirm it.

  • Weekly KPI summary with number checks

    Operations. Every Monday an agent writes the short management summary on supplier and delivery performance. It only sees data through read only tools, a control chart sets the traffic light, code checks every number and a person approves before it goes out.