
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.
概览
将银行 CSV 导入本地账本,重复导入自动去重,可分类交易、按币种汇总并识别订阅。
- 可以做什么
- 读取银行导出的 CSV 并保存为本地账本,自动识别表头行、日期、金额、币种以及借方/贷方列,并解析文件自身的数字格式和日期顺序。它通过日期、金额、币种和描述的哈希加出现序号实现重复导入去重,按用户规则为交易分类,并按币种报告收入、支出和净额。它还能识别周期性订阅及其频率和年化费用,将银行扣款与另一个记账工具中的收据对账,并把某时间段导出为 CSV 或 JSON。
- 适用场景
- 适合想在对话中查看每月银行交易而无需会计软件的场景:导入导出文件、分类支出、发现订阅,以及检查哪些扣款没有对应收据。适用于希望数据留在本机的个人或小企业记账。
- 运行要求
- 作为本地进程在用户机器上运行,仅支持桌面端。npm 包尚未发布,需通过 .mcpb 一键安装包或克隆源码并用 Node.js 构建。可选的 Pro 许可证密钥通过环境变量 MCP_LICENSE_KEY 提供,或调用 license_activate 激活。不使用网络访问。
安装
在 SourceWeft 中
- 打开 控制台中的 Bank Statement Import Categorise Reconcile,将其添加到工作区。
- 为需要使用其工具的对话启用该服务。
Desktop only,通过 STDIO。 STDIO 服务会启动本地进程,因此需要 SourceWeft 桌面宿主。
其他 MCP 客户端
参照 仓库 中的启动说明。
README
mcp-bank-statement
In the official MCP Registry (io.github.theluckystrike/bank-statement-csv-categorize-reconcile-ledger).
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):
Claude Code:
(.cursor/mcp.json):
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:
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
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
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_expensesreads 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,56means 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_summarygrouped 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:
- Docs MCP URL: https://gitmcp.io/theluckystrike/mcp-bank-statement
来源:servers/bank-statement/README.md,提交 1bd9d69
工具
0版本历史
1- v0.21.0最新Sep 16, 2026
评分
已满足适用检查项的 50%
该评分衡量此收录条目的完整程度,依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价,也不表示服务器安全或当前可用:可连通性是带日期的检查结果,评分也不包含安装量或用户评价。
- 近 30 天内可连通25 分
请保持端点能够响应 MCP 握手;SourceWeft 每 30 天探测一次。
- 已声明认证方式10 分
请在注册中心条目中声明凭据请求头,或保持端点能够响应探测,以便判定其认证方式。
- 已列出工具15 分
请让服务器在无凭据时响应 tools/list,或发布可在沙箱中无凭据启动的软件包。
- 描述必需15 分
- 图标10 分
- 文档15 分
- 许可证10 分