
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 分