Bank Statement Import Categorise Reconcile

com.bestremotetools由 bestremotetools.com 发布v0.21.0更新于 Oct 24, 2026

Import a bank CSV, dedupe on re-import, categorise, summarise per currency and find subscriptions.

概览

AI 生成的概览

将银行 CSV 导入本地账本,重复导入自动去重,可分类交易、按币种汇总并识别订阅。

可以做什么
读取银行导出的 CSV 并保存为本地账本,自动识别表头行、日期、金额、币种以及借方/贷方列,并解析文件自身的数字格式和日期顺序。它通过日期、金额、币种和描述的哈希加出现序号实现重复导入去重,按用户规则为交易分类,并按币种报告收入、支出和净额。它还能识别周期性订阅及其频率和年化费用,将银行扣款与另一个记账工具中的收据对账,并把某时间段导出为 CSV 或 JSON。
适用场景
适合想在对话中查看每月银行交易而无需会计软件的场景:导入导出文件、分类支出、发现订阅,以及检查哪些扣款没有对应收据。适用于希望数据留在本机的个人或小企业记账。
运行要求
作为本地进程在用户机器上运行,仅支持桌面端。npm 包尚未发布,需通过 .mcpb 一键安装包或克隆源码并用 Node.js 构建。可选的 Pro 许可证密钥通过环境变量 MCP_LICENSE_KEY 提供,或调用 license_activate 激活。不使用网络访问。
安装前请注意
它处理银行对账单数据,数据以纯 JSON 文件保存在本地数据目录中,删除该目录即可重置。可选的 MCP_LICENSE_KEY 是离线验证的付费 Pro 密钥。导出会写入文件,并可能覆盖已有文件(会给出提示)。分类规则会重新应用到已存交易,设置分类会修改已存数据。对账功能只读取记账账本。

安装

在 SourceWeft 中

  1. 打开 控制台中的 Bank Statement Import Categorise Reconcile,将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Desktop only,通过 STDIO。 STDIO 服务会启动本地进程,因此需要 SourceWeft 桌面宿主。

其他 MCP 客户端

参照 仓库 中的启动说明。

README

mcp-bank-statement

In the official MCP Registry (io.github.theluckystrike/bank-statement-csv-categorize-reconcile-ledger).

[bank-statement demo]

Export the CSV from your bank, say "import this", and the month is readable. This MCP server turns a bank export into a local ledger: it finds the header row under whatever preamble the bank prints above it, works out which column is the date, which is the money and which way the money went, and reads amounts in the file's own locale, so 1 234,56 from mBank and 1,234.56 from a US bank both become the same number. A debit is stored negative and a credit positive, once, at import, so nothing downstream has to guess. Re-importing the same export adds nothing: every line carries a hash of its date, amount, currency and description, with an occurrence index, so two identical coffees on one day stay two transactions while a second import of the same file stays zero. Your rules categorise transactions as they arrive, summaries report money in, money out and the net per currency and never mix currencies, recurring_detect finds the subscriptions and what each costs per year, and reconcile_expenses matches bank debits against the receipts in mcp-expense-tracker so you can see which debits have no receipt and which receipts never reached the bank. Everything is a plain JSON file on your own machine; nothing is uploaded anywhere.

Turn a bank CSV into a categorised, reconciled month in chat, no accounting SaaS required.

Bank profiles: Revolut, Wise, mBank, PKO BP, ING, N26, and a generic reader that works from the headers alone.

File shapes it reads without being asked: UTF-8 and UTF-16 (either byte order, as Excel on Windows saves it), CRLF, LF and CR-only line endings, quoted fields holding commas, quotes and newlines, 1.234,56 and 1,234.56, accounting parentheses (12.50) and a trailing minus 12.50- (both negative), and a mixture of currencies inside one file. A cell holding - or nothing is skipped and named in skipped_lines rather than read as zero. When the date column is ambiguous (03/04/2026 with no value above 12 anywhere), the assumed order is stated in the response instead of silently picking one.

60-second install

npm publish for @theluckystrike/mcp-bank-statement is pending. Until then, the .mcpb one-click bundle or a clone+build is the working path, both are verified below.

One-click (.mcpb): download bank-statement.mcpb from the latest release and double-click it in Claude Desktop: https://github.com/theluckystrike/mcp-servers/releases/latest

(claude_desktop_config.json):

json
{  "mcpServers": {    "bank-statement": {      "command": "npx",      "args": ["-y", "@theluckystrike/mcp-bank-statement"]    }  }}

Claude Code:

sh
claude mcp add bank-statement -- npx -y @theluckystrike/mcp-bank-statement

(.cursor/mcp.json):

json
{  "mcpServers": {    "bank-statement": {      "command": "npx",      "args": ["-y", "@theluckystrike/mcp-bank-statement"]    }  }}

The npx form above starts working the moment the package is published. Until then, use the .mcpb bundle above, or build from source with exactly these three commands:

sh
git clone https://github.com/theluckystrike/mcp-servers.git && cd mcp-serversnpm installnpm run build -w packages/mcp-license -w servers/spreadsheet -w servers/bank-statement

Then point your client's command at node with one arg: the absolute path to servers/bank-statement/dist/index.js.

To run in Pro mode set MCP_LICENSE_KEY in the same config block, or call license_activate once with your key.

Tools

ToolWhat it does
statement_importRead a bank CSV into the ledger. Detects the header row under any preamble, the date, description, amount (or debit and credit) and currency columns, the date order and the number locale. Reports what it detected, what it stored, how many lines were duplicates of what is already there, and every line it skipped with the reason
transactions_listList transactions in a date range, filtered by account, category or uncategorized, with totals per currency
transactions_searchFind transactions whose description, counterparty, category or account contains the query. Substring only, never a regex
category_rulesSet or list the rules that categorise transactions. An empty match is refused, because it would stamp one category on the whole ledger. A plain match is a case-insensitive substring; regex: true compiles the pattern only if it cannot backtrack exponentially, and (a+)+ is refused and used as a substring. Setting rules re-applies them to stored transactions
transaction_categorizeSet the category on transactions by id. Nothing changes unless every id exists
statement_summaryMoney in, money out and the net for a range, grouped by category, month, account or counterparty, always per currency
reconcile_expensesMatch bank debits against the receipts in mcp-expense-tracker: same currency, same amount, within a date window. Reports matches, bank lines with no receipt, and receipts that never reached the bank. The expense ledger is only ever read
recurring_detectFind subscriptions and recurring charges: the same counterparty, an amount that barely moves, a steady cadence. Reports the cadence, the typical amount, the next expected date and the annualised cost. Two charges are one interval, so the yearly cost is withheld (cadence_confirmed: false) until a third charge confirms it
statement_exportWrite a range to csv or json and return the path. Written atomically, so a failure never leaves a half file. Replacing an existing file is allowed and reported (overwrote_existing_file)
accounts_listThe imported accounts, with bank, currencies, transaction count, date range and last balance
license_statusShow free or Pro mode
license_activateActivate a Pro key (verified offline)

Resource bank://month returns this month's money in, money out and net, grouped by category, per currency. Prompt monthly_review drives the whole month-end pass: totals, uncategorised lines, subscriptions, reconciliation.

Free vs Pro

FreePro
Accounts2unlimited
History read backlast 12 monthsall of it
Category rules5unlimited
Import, list, search, summariseyesyes
reconcile_expensesyes, 31 days at a timeany date range
recurring_detectyes, last 3 months, 5 chargesfull history, every charge
statement_exportnoyes

Import always stores every row, whatever the tier: silently dropping lines on the way in would make the ledger disagree with the bank. The free limit is on what is read back.

Get Pro: https://mcp.zovo.one/buy/bank-statement, $19 one-time for this server, $39 for every server, lifetime. Keys are verified offline; nothing is sent anywhere.

Pairs with

  • mcp-expense-tracker, log the receipts and the mileage; reconcile_expenses reads that ledger and tells you which bank debits have no receipt behind them.
  • mcp-spreadsheet, this server parses your bank CSV with the spreadsheet server's own RFC 4180 reader and locale number parser, so 1 234,56 means the same thing in both. Use it to slice an exported range.
  • mcp-invoice, the income side: raise the invoice, then watch the payment land in statement_summary grouped by counterparty.

Privacy

Everything stays on your machine. Statements are parsed locally and stored in a plain JSON file under ${XDG_DATA_HOME:-~/.local/share}/mcp-servers/bank-statement/. The server makes no network calls at all, not for licensing, not for parsing, not for anything. Deleting that directory resets it.

Built by theluckystrike. Support: [email protected]

Use these docs as an MCP server

Any MCP client (Claude, Cursor, Windsurf, VS Code) can read this repository's documentation directly via GitMCP - no install:

来源:servers/bank-statement/README.md,提交 1bd9d69

工具

0
SourceWeft 尚未在沙箱中启动过该软件包,因此其工具未知。

版本历史

1
  1. v0.21.0最新Sep 16, 2026

评分

已满足适用检查项的 50%

该评分衡量此收录条目的完整程度,依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价,也不表示服务器安全或当前可用:可连通性是带日期的检查结果,评分也不包含安装量或用户评价。

  • 近 30 天内可连通25 分

    请保持端点能够响应 MCP 握手;SourceWeft 每 30 天探测一次。

  • 已声明认证方式10 分

    请在注册中心条目中声明凭据请求头,或保持端点能够响应探测,以便判定其认证方式。

  • 已列出工具15 分

    请让服务器在无凭据时响应 tools/list,或发布可在沙箱中无凭据启动的软件包。

  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分